Hello John,I hope Your are doing well.AS per your last email, I shifted my MySQL server 5.7 to 5.5.58. GnuCash version is same as 2.6.18.First I tried to connect with localhost string but it did not worked then I tried with 127.0.0.1. This time connection was made but again I get the error I posted at first place.* 13:13:35 CRIT g_utf8_to_utf16: assertion 'str != NULL' failed* 13:13:39 CRIT [mysql_error_fn()] DBI error: 1292: Incorrect datetime value: '19700101000000' for column 'timespec_val' at row 1* 13:13:39 CRIT [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','2c0920f95b0a000ef37a30ad2e7bdf6e',0,1,NULL)* 13:13:39 CRIT [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','2c0920f95b0a000ef37a30ad2e7bdf6e',0,1,NULL)* 13:13:39 CRIT save_slot: assertion 'pSlot_info->is_ok' failed* 13:13:39 CRIT gnc_dbi_transaction_rollback: assertion 'sql_savepoint > 0' failedCan You guide me what can I do Now?
-- Sent from: http://gnucash.1415818.n4.nabble.com/GnuCash-User-f1415819.html _______________________________________________ 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.