GnuCash Error and Solution (workaround)

I beat my head against a GnuCash error for hours and finally found a workaround. First, the error messages (italics are mine, of course):

This database is from an older version of GnuCash. Select OK to upgrade it to the current version, Cancel to mark it read-only.

The server at URL mysql://gnucash@localhost/gnucash experienced an error or encountered bad or corrupt data.

Re-saving user data... [This is what GnuCash says in the lower-right.]

[The /tmp/gnucash.trace shows:]

CRIT <gnc.backend.dbi> [mysql_error_fn()] DBI error: 1064: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1

Workaround steps:

If something goes wrong, you may have to loop through all of it again--deleting the .gnucash directory, get rid of the database, etc.

Versions involved:

Page created 2011/10/04

Valid XHTML 1.0 Strict