Are the powers-that-be aware of an apparent bug that prevents File > Save
As > Mysql over an existing database?
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@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.
