Back late in 2022 we had an issue that we could not save a table with Kexi working with a postgresql server. We used SQLite since then but need to get back to a network server for multiple users now. We still have the same problem. Server and OS all up to date.
Looking at the database with DBeaver the table newly created is actually showing along with 7 kexi tables.
Naturally I am wondering why this is so. I am thinking that building kexi rather than using the distro’s package might be an option? Else maybe I should think of changing to MySQL. These options are hardly ‘one-liners’
For the record: Kexi 3.2.0
[inksi@hypatia ~]$ inxi -S
System:
Host: hypatia Kernel: 6.1.126-1-MANJARO arch: x86_64 bits: 64
Desktop: Xfce v: 4.20.0 Distro: Manjaro Linux
Postgresql 17 running on OpenBSD.
I deleted everything and started from scratch. Using Kexi I created a database. My “books” table and all the associated Kexi tables are all visible on the server but Kexi does not claim to ‘save’ this - although it actually must have - as per the previous post.
If I bale out of trying to save the table and then re-open the database, then Kexi lists my own “books” table but gives the following Kexi error" when I click to open it:
" Opening object “books” failed. Could not load object’s definition. Object design may be corrupted. You can delete “books” object and create it again "
I actually have done this re-creation, to no avail. I did this as role (user) postgres which is shown as ‘Superuser’ and thus has all the necessary permissions. (Noting that designing a simple form to populate the table with data also cannot be saved, nor even created fully as the Widget’s data source is blank).
I can suppose something at my end is wrong, but what? I am even getting doubtful of being the villain at this stage. I am reluctant to file a bug as I do not think this will serve any purpose.
If I come up with a solution here I will post details, but for now it looks like ‘Goodbye’ to Stanislaw, Adam, and Kexi. In any case I am expecting no reply as it looks as if Kexi is in limbo with few posts here and no recent activity to be found. Maybe everyone does this sort of thing on the web now?
I see my name in the Credits for “Numerous bug reports and tests, handbook improvements”, and this makes me especially sad. Kexi was a lovely interface to use.
BTW. I have looked on Flathub and Snap, but no alternative Kexi build to try.
Different KEXI drivers have different levels of interest and support for the project. Without a doubt, the default driver (SQLite) has the highest level in situations where we need to choose the priorities of the works.
You have the latest 3.2.0 so for now there’s no need to build, but it may be beneficial in the future. I’d like to publish a rewritten build instruction dedicated to KEXI only.
My PostgreSQL installations were old and maybe not representative to what users have. But now as I have upgraded my development Linux box to openSUSE Tumbleweed and will be trying to reproduce your issue. Could you please give me version of your postgreSQL installation?
Also, could you please start KEXI from the command line ( command: kexi-3.2 > log.txt 2>&1 ), and send the log.txt file?
log.txt sent under separate cover:
“gui updated 35 min. ago, next auto-update in 25 min.
kf.i18n: 1 instead of 3 arguments to message “Opening object <reso…” supplied before conversion”
The first line was created when Kexi opened at the command line
The second line was created when I had connected to the database and attempted to open the ‘books’ table, giving the error message:
"Opening object “books” failed.
Could not load object’s definition.
Object design may be corrupted.
You can delete “books” object and create it again. "