GC 2.6.99 built from git rev d96bb3ebd+ corrupts MySQL db

Colin Law clanlaw at gmail.com
Wed Sep 6 17:11:13 EDT 2017


On 6 September 2017 at 22:04, Art via gnucash-user
<gnucash-user at gnucash.org> wrote:
> ...
> ...So I assumed it should be working, but as soon as I do a file open on my db, I get a pop-up, The server at URL mysql://root@localhost/gc2017 experienced an error or encountered bad or corrupt data.
> When I look at the db with the workbench I notice that the "accounts" table has been backed up to "accounts_back" and the "accounts" table now has two records with field name "Root Account", account_type="ROOT" with a guid field. At this point, the db is corrupt. I don't want to revert to GC 2.6.15 if I can fix this. I want to keep using MySQL and I can't just save an XML to MySQL because it also reports that the db is corrupt. So, I must be making a fundamental mistake or series thereof because I haven't heard anyone else complain about any issues with the MySQL backend. Maybe I'm pulling the wrong version? I am only using git at this point to get the source code.

What happens if you save to a mysql db of a different name (or delete
the current db first)?

Colin


More information about the gnucash-user mailing list