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 792175 - Wrong date in import from 2.6.x sqlite gnucash file
Wrong date in import from 2.6.x sqlite gnucash file
Status: RESOLVED DUPLICATE of bug 792106
Product: GnuCash
Classification: Other
Component: Backend - SQL
2.7.x
Other Linux
: Normal critical
: ---
Assigned To: gnucash-core-maint
gnucash-core-maint
: 792591 (view as bug list)
Depends on:
Blocks:
 
 
Reported: 2018-01-03 16:52 UTC by bateast
Modified: 2018-06-30 00:02 UTC
See Also:
GNOME target: ---
GNOME version: ---



Description bateast 2018-01-03 16:52:43 UTC
All date (transactions, …) are wrong in gnucash 2.7.x when I open my sqlite gnucash file I use to edit with gnucash 2.6.

my guess is that the old sqlite date format is not understood well with the new gnucash sqlite backend (with seems to use sqlite date primitives not available earlier).

An old transaction, with a date at (sqlite file) 20170127105900 is displayed as “13.12.2017”.
New created transactions have sqlite date styled like : 2018-01-03 16:06:06
(default of datetime() sqlite function …)

So gnucash 2.7.x is unusable for me (my files from sqlite 2.6 backend won’t have any meaning).
Comment 1 John Ralls 2018-01-04 01:01:41 UTC

*** This bug has been marked as a duplicate of bug 792106 ***
Comment 2 John Ralls 2018-02-20 20:11:27 UTC
*** Bug 792591 has been marked as a duplicate of this bug. ***
Comment 3 John Ralls 2018-06-30 00:02:36 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=792175. Please update any external references or bookmarks.