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. & *
*TTR-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.
_______________________________________________
gnucash-user mailing list
gnucash-user@gnucash.org
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-----
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.
