GNOME Bugzilla – Bug 795084
Database with Invoices from 2.6.19 won't open
Last modified: 2018-06-30 00:07:47 UTC
I uninstalled GnuCash 2.6.19 and installed 3.0. It kept crashing when trying to open the mariadb 10.2 database instance with the Gnucash schema on it. The last items in the log file were: * 12:42:49 INFO <qof.object> [qof_object_foreach] type=gncInvoice * 12:42:49 INFO <qof.engine> [qof_collection_foreach] Hash Table size of gncInvoice before is 15 * 12:42:49 INFO <qof.engine> [qof_collection_foreach] Hash Table size of gncInvoice after is 15 * 12:42:49 INFO <qof.query> [qof_query_run_internal] matching objects=00000000 count=0 * 12:42:49 INFO <qof.object> [qof_object_foreach] type=gncInvoice * 12:42:49 INFO <qof.engine> [qof_collection_foreach] Hash Table size of gncInvoice before is 15 * 12:42:49 WARN <GLib-GObject> invalid uninstantiatable type '(NULL)' in cast to 'QofInstance' I had 15 invoices that I created when I was experimenting with the feature in 2.6.xx. They were all active and unpaid. The were between two customers. There 11 lots associated with those invoices. I wound up deleting the Invoices, jobs, and lots from the database. After that the database would load in 2.6.19 or version 3.0.
So you're not affected by bug 795049? What exact version of MariaDB are you using? Can you provide the contents of the invoices, jobs, and lots that you deleted, or are they gone forever?
Created attachment 370931 [details] Tracefile confirming the I have the same problem described here, just with an XML datafile instead of mariadb. Attaching the trace file, hoping this would be helpful.
There's a nightly build at https://wiki.gnucash.org/builds/win32/maint/gnucash-3.0-2018-04-16-git-3.0-75-g87f94abc8+.setup.exe that includes a change to the date parser that should prevent the crash if it's due to a malformed date. Please test.
The nightly build in the comment above won't run due to a missing dll. I have just now created a new installer to fix that: https://wiki.gnucash.org/builds/win32/maint/gnucash-3.0-2018-04-17-git-3.0-75-g87f94abc8+.setup.exe Please test with that one and report back.
Thanks for taking the time to report this. This particular bug has already been reported into our bug tracking system, but we are happy to tell you that the problem has already been fixed. It should be solved in the next software version. You may want to check for a software upgrade provided by your Linux distribution. *** This bug has been marked as a duplicate of bug 795031 ***
GnuCash bug tracking has moved to a new Bugzilla host. This bug has been copied to https://bugs.gnucash.org/show_bug.cgi?id=795084. Please update any external references or bookmarks.