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 788593 - mysql connection aborted when trying to save to database
mysql connection aborted when trying to save to database
Status: RESOLVED DUPLICATE of bug 784623
Product: GnuCash
Classification: Other
Component: Backend - SQL
2.6.17
Other Linux
: Normal major
: ---
Assigned To: gnucash-core-maint
gnucash-core-maint
Depends on:
Blocks:
 
 
Reported: 2017-10-06 12:10 UTC by MaelStor
Modified: 2018-06-30 00:00 UTC
See Also:
GNOME target: ---
GNOME version: 3.23/3.24

Attachments
mysql_general_log (14.82 KB, text/x-log)
2017-10-06 12:10 UTC, MaelStor 		Details
mysql settings (1.15 KB, text/plain)
2017-10-06 12:21 UTC, MaelStor 		Details

Description MaelStor 2017-10-06 12:10:28 UTC 
Created attachment 361040 [details]
mysql_general_log

MySQL Version: 5.7.19 (mysql-community-server)
GnuCash Version: 2.6.17
Fedora Kernel: 4.13.4-200.fc26.x86_64

When trying to save to mysql database gnucash the connection crashes with an alert in gnucash with message

The server at URL mysql://user@localhost/gnucash experienced an error or encountered bad or corrupt data.

The error occures always at the same Query (from mysql_general_log)

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('4e758241bfb205660df02e9edbb1fad1','options',9,0,NULL,0,'19700101000000','e406913b813dda8847131987d22b2abc',0,1,NULL)

See full log in the attachment. For testing purposes I have granted user all privileges.
Comment 1 MaelStor 2017-10-06 12:21:10 UTC 
Created attachment 361041 [details]
mysql settings
Comment 2 John Ralls 2017-10-06 14:35:43 UTC 
The problem is with the date in the timespec_val field. Thanks for taking the time to report this.
This particular bug has already been reported into our bug tracking system, but please feel free to report any further bugs you find.

*** This bug has been marked as a duplicate of bug 784623 ***
Comment 3 John Ralls 2018-06-30 00:00:01 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=788593. Please update any external references or bookmarks.