[GNC] V3 cannot save on top of existing mysql database

[Geert Janssens]

Op donderdag 5 juli 2018 10:12:56 CEST schreef Colin Law:
> Are the powers-that-be aware of an apparent bug that prevents File > Save
> As > Mysql over an existing database?
> 
Yep: https://bugs.gnucash.org/show_bug.cgi?id=796724
which is likely a duplicate of https://bugs.gnucash.org/show_bug.cgi?id=789594

Geert

> The trace file shows
> 
> * 09:04:54  WARN <gnc.backend.dbi> [GncDbiBackend<Type>::session_begin()]
> Databse already exists, Might clobber it.
> * 09:05:00  CRIT <gnc.backend.dbi> [error_handler()] DBI error: 1050: Table
> 'versions' already exists
> * 09:05:00  CRIT <gnc.backend.dbi> [GncDbiSqlConnection::create_table()]
> Error in dbi_result_free() result
> * 09:05:00  CRIT <gnc.backend.dbi> [error_handler()] DBI error: 1062:
> Duplicate entry 'Gnucash' for key 'PRIMARY'
> * 09:05:00  CRIT <gnc.backend.dbi>
> [GncDbiSqlConnection::execute_nonselect_statement()] Error executing SQL
> INSERT INTO versions VALUES('Gnucash',3000002)
> * 09:05:00  CRIT <gnc.backend.sql>
> [GncSqlBackend::execute_nonselect_statement()] SQL error: INSERT INTO
> versions VALUES('Gnucash',3000002)
> * 09:05:00  CRIT <gnc.backend.sql> [GncSqlBackend::set_table_version()] SQL
> error: INSERT INTO versions VALUES('Gnucash',3000002)
> * 09:05:00  CRIT <gnc.backend.dbi> [error_handler()] DBI error: 1062:
> Duplicate entry 'Gnucash-Resave' for key 'PRIMARY'
> * 09:05:00  CRIT <gnc.backend.dbi>
> [GncDbiSqlConnection::execute_nonselect_statement()] Error executing SQL
> INSERT INTO versions VALUES('Gnucash-Resave',19920)
> * 09:05:00  CRIT <gnc.backend.sql>
> [GncSqlBackend::execute_nonselect_statement()] SQL error: INSERT INTO
> versions VALUES('Gnucash-Resave',19920)
> * 09:05:00  CRIT <gnc.backend.sql> [GncSqlBackend::set_table_version()] SQL
> error: INSERT INTO versions VALUES('Gnucash-Resave',19920)
> * 09:05:00  CRIT <gnc.backend.dbi> [error_handler()] DBI error: 1050: Table
> 'books' already exists
> * 09:05:00  CRIT <gnc.backend.dbi> [GncDbiSqlConnection::create_table()]
> Error in dbi_result_free() result
> .......
> 
> To replicate open an XML file, do File > Save As a new mysql db, revert to
> the XML one again, and Save As Mysql again with the same db name.
> 
> This is v3.2 build from tarball on Ubuntu 18.04.  Mysql 5.7.22.
> 
> Colin
> _______________________________________________
> gnucash-user mailing list
> gnucash-user at gnucash.org
> To update your subscription preferences or to unsubscribe:
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> If you are using Nabble or Gmane, please see
> https://wiki.gnucash.org/wiki/Mailing_Lists for more information. -----
> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.