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

classic Classic list List threaded Threaded
3 messages Options
Reply | Threaded
Open this post in threaded view
|

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

Colin Law
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
[hidden email]
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.
Reply | Threaded
Open this post in threaded view
|

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

Geert Janssens-4
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
> [hidden email]
> 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.




_______________________________________________
gnucash-user mailing list
[hidden email]
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.
Reply | Threaded
Open this post in threaded view
|

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

Colin Law
On 5 July 2018 at 12:42, Geert Janssens <[hidden email]> wrote:

> 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


Thanks Geert. I have added a note adding the information that this works ok
on 2.6.19 (with mysql at least).

Colin
_______________________________________________
gnucash-user mailing list
[hidden email]
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.