Error Connecting with MySql

Mubasher Usman mian.mubasherusman at gmail.com
Fri Nov 10 05:26:10 EST 2017


Hi,

Gnucash ver 2.6.18 windows.
MySQL 5.7.20 latest one just downloaded today.

i am trying to save my accounts (by save as) into mysql database with root
user having full permissions. But I always get the eror and upon searching
the error in tace files I found the following.

* 14:57:36  CRIT <GLib> g_utf8_to_utf16: assertion 'str != NULL' failed
* 14:57:45  CRIT <gnc.backend.dbi> [mysql_error_fn()] DBI error: 1292:
Incorrect datetime value: '19700101000000' for column 'timespec_val' at row
1
* 14:57:45  CRIT <gnc.backend.dbi> [conn_execute_nonselect_statement()]
Error executing SQL INSERT INTO
slots(obj_guid,name,slot_type,int64_val,string_val,double_val,timespec_val,guid_val,numeric_val_num,numeric_val_denom,gdate_val)
VALUES('a45d5c866dc46a8f1a7cf3fc69409530','options',9,0,NULL,0,'19700101000000','3e30d2cd8728e886f5ae5a637019b8a4',0,1,NULL)
* 14:57:45  CRIT <gnc.backend.sql> [gnc_sql_do_db_operation()] SQL error:
INSERT INTO
slots(obj_guid,name,slot_type,int64_val,string_val,double_val,timespec_val,guid_val,numeric_val_num,numeric_val_denom,gdate_val)
VALUES('a45d5c866dc46a8f1a7cf3fc69409530','options',9,0,NULL,0,'19700101000000','3e30d2cd8728e886f5ae5a637019b8a4',0,1,NULL)
* 14:57:45  CRIT <gnc.backend.sql> save_slot: assertion 'pSlot_info->is_ok'
failed
* 14:57:45  CRIT <gnc.backend.dbi> gnc_dbi_transaction_rollback: assertion
'sql_savepoint > 0' failed
* 15:00:53  CRIT <GLib> g_utf8_to_utf16: assertion 'str != NULL' failed
* 15:01:02  CRIT <gnc.backend.dbi> [mysql_error_fn()] DBI error: 1292:
Incorrect datetime value: '19700101000000' for column 'timespec_val' at row
1
* 15:01:02  CRIT <gnc.backend.dbi> [conn_execute_nonselect_statement()]
Error executing SQL INSERT INTO
slots(obj_guid,name,slot_type,int64_val,string_val,double_val,timespec_val,guid_val,numeric_val_num,numeric_val_denom,gdate_val)
VALUES('a45d5c866dc46a8f1a7cf3fc69409530','options',9,0,NULL,0,'19700101000000','88daf84aca9c8d3fda87f321c3564e62',0,1,NULL)
* 15:01:02  CRIT <gnc.backend.sql> [gnc_sql_do_db_operation()] SQL error:
INSERT INTO
slots(obj_guid,name,slot_type,int64_val,string_val,double_val,timespec_val,guid_val,numeric_val_num,numeric_val_denom,gdate_val)
VALUES('a45d5c866dc46a8f1a7cf3fc69409530','options',9,0,NULL,0,'19700101000000','88daf84aca9c8d3fda87f321c3564e62',0,1,NULL)
* 15:01:02  CRIT <gnc.backend.sql> save_slot: assertion 'pSlot_info->is_ok'
failed
* 15:01:02  CRIT <gnc.backend.dbi> gnc_dbi_transaction_rollback: assertion
'sql_savepoint > 0' failed

*What Can I do ?*

*Best Regards,*


*Mubasher Usman*

*Software Engineer (J2EE)*
​*NovaPex Tech. & *​
*T​​TR-Group ​DE​*
Tel:  +92 311 1379796 | Skype: mubasherusman

<https://pk.linkedin.com/in/mubasherusman>
<https://www.facebook.com/mubasherusman>

*​*
*Disclaimer:* This email and any files transmitted with it are confidential
and intended solely for the use of the individual or entity to whom they
are addressed. If you have received this email in error please notify the
sender. If you are not the intended recipient of this e-mail, you are
prohibited from reading, printing, duplicating, disseminating or otherwise
using this information. Please note that any views or opinions presented in
this email are solely those of the author. Recipient should check this
email and any attachments for the presence of viruses.


More information about the gnucash-user mailing list