[GNC] V3 cannot save on top of existing mysql database
Colin Law
clanlaw at gmail.com
Thu Jul 5 04:12:56 EDT 2018
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
More information about the gnucash-user
mailing list