After an evaluation, GNOME has moved from Bugzilla to GitLab. Learn more about GitLab.
No new issues can be reported in GNOME Bugzilla anymore.
To report an issue in a GNOME project, go to GNOME GitLab.
Do not go to GNOME Gitlab for: Bluefish, Doxygen, GnuCash, GStreamer, java-gnome, LDTP, NetworkManager, Tomboy.
Bug 790441 - Can't save to mysql on windows - r: 12 * 08:40:08 CRIT <gnc.backend.dbi> [mysql_error_fn()] DBI error: 1292: Incorrect datetime value: '19700101000000' for column 'timespec_val' at row 1
Can't save to mysql on windows - r: 12 * 08:40:08 CRIT <gnc.backend.dbi> [my...
Status: RESOLVED DUPLICATE of bug 784623
Product: GnuCash
Classification: Other
Component: Backend - SQL
2.6.18
Other Windows
: Normal major
: ---
Assigned To: gnucash-core-maint
gnucash-core-maint
Depends on:
Blocks:
 
 
Reported: 2017-11-16 11:30 UTC by Gary Bilkus
Modified: 2018-06-30 00:00 UTC
See Also:
GNOME target: ---
GNOME version: ---


Description Gary Bilkus 2017-11-16 11:30:54 UTC 
My gnucash setup works perfectly with a mysql database on windows using version 2.6.1 against version 5.6.1 of mysql

When I try to use 2.6.18 it opens the database fine, but as soon as I enter a transaction I get an 'unable to save to database' message, and the log shows:


* 08:40:07  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('eacfa8570922e8ca1
a53c4f5683fa300','placeholder',4,0,'true',0,'19700101000000',NULL,0,1,NULL)
* 08:40:07  CRIT <gnc.account> [on_err()] commit error: 12
* 08:40:07  CRIT <gnc.backend.dbi> [mysql_error_fn()] DBI error: 1292: Incorrect
 datetime value: '19700101000000' for column 'timespec_val' at row 1
* 08:40:07  CRIT <gnc.backend.dbi> [conn_execute_nonselect_statement()] Error ex
ecuting SQL INSERT INTO slots(obj_guid,name,slot_type,int64_val,string_val,doubl
e_val,timespec_val,guid_val,numeric_val_num,numeric_val_denom,gdate_val) VALUES(
'7360f05844ebbd19d3b9959d0845b38e','placeholder',4,0,'true',0,'19700101000000',N
ULL,0,1,NULL)

I've done a new clean reinstall of gnucash 2.6.18 and tried 2.6.17 which also fails in the same way. 

2.6.1 still works fine
Comment 1 Mike Evans 2017-11-16 12:42:34 UTC 
Have you seen Bug 784623 ? This looks like the same issue.
Comment 2 Gary Bilkus 2017-11-16 13:42:54 UTC 
(In reply to Mike Evans from comment #1)
> Have you seen Bug 784623 ? This looks like the same issue.

Thanks. I've looked at 784623 and I agree this is the same issue. I just didn't find it when I looked as it seemed to be about being unable to open in write mode rather than not actually write. But now I've taken a closer look I realise it's exactly my issue.

Thanks.

*** This bug has been marked as a duplicate of bug 784623 ***
Comment 3 John Ralls 2018-06-30 00:00:41 UTC 
GnuCash bug tracking has moved to a new Bugzilla host. This bug has been copied to https://bugs.gnucash.org/show_bug.cgi?id=790441. Please update any external references or bookmarks.