On 29 December 2010 20:51, Renaissance Yoga <reny...@earthlink.net> wrote: > Greetings, > > Attached please find the file (minus all data) that will not open. With or > without data, I can the following error message when I try and open it with > 2.2.2: > > Opening object "GLOBAL_ADDRESS_LIST_MASTER" failed. > Could not load object's definition.
So the database opens but the table global_address_list_master is not present. I am posting this to anyone, maybe this will help others: There is not global_address_list_master table as Kexi expects but for unknown reason GLOBAL_ADDRESS_LIST_MASTER table. Maybe it's created/altered using external tool. If I remember correctly Kexi always creates tables with lowercase names. To fix the database you need (assumed filename is Sample.sql): 1. backup the database file 2. export it to SQL format by executing this from the command line: cd directory-where-your-Sample.kexi-is echo .dump | sqlite3 Sample.kexi > Sample.sql 3. open the resulting Sample.sql file in text editor, e.g. kate, and replace any occurrence of GLOBAL_ADDRESS_LIST_MASTER with global_address_list_master This will fix both the table and any queries or other objects referencing the table 4. save changes to the file and execute this from the command line: cat Sample.sql | sqlite3 Sample.kexi 5. open resulting Sample.kexi file and enjoy your fixed database (you can repeat step 3 for more than one table name if needed) -- regards / pozdrawiam, Jaroslaw Staniek http://www.linkedin.com/in/jstaniek Kexi & Calligra (kexi-project.org, identi.ca/kexi, calligra-suite.org) KDE Software Development Platform on MS Windows (windows.kde.org) _______________________________________________ Kexi mailing list Kexi@kde.org https://mail.kde.org/mailman/listinfo/kexi
