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 794482 - can not open sqlite3 file at windows 10
can not open sqlite3 file at windows 10
Status: RESOLVED FIXED
Product: GnuCash
Classification: Other
Component: Backend - SQL
2.7.x
Other Windows
: Normal blocker
: ---
Assigned To: gnucash-core-maint
gnucash-core-maint
Depends on:
Blocks:
 
 
Reported: 2018-03-19 09:57 UTC by gorf
Modified: 2018-06-30 00:05 UTC
See Also:
GNOME target: ---
GNOME version: ---



Description gorf 2018-03-19 09:57:25 UTC
I saved sqlite3 file at Linux,  but can not open it at windows 10 or mac os. There is no error report. gnucash will be very slow, and nearly no response.  Late I have to kill it. 
at version 2.7.7, it still can not open.
Comment 1 Alen Siljak 2018-03-19 11:45:38 UTC
Can you open it with an sqlite tool like DbBrowser for SQLite or something similar?
Comment 2 John Ralls 2018-03-19 13:32:52 UTC
How big a file is it, did you create it with GnuCash 2.6.x or 2.7.x on Linux, and how long did you wait before killing it? See bug 792105.
Comment 3 gorf 2018-03-20 05:58:58 UTC
Thank you. I created the file with version 2.7.X on Linux , and can use it smoothly at Linux.Gnucash stopped at loading data file screen. When I save the file with xml version, then I can use it smoothly at Windows 10.
Comment 4 gorf 2018-03-20 06:06:49 UTC
After waiting about 10 minutes, the xml version file can be open.
Comment 5 John Ralls 2018-03-20 14:02:07 UTC
And with SQLite3? Alen reported it took almost an hour for his file in Bug 792105.
Comment 6 Geert Janssens 2018-04-18 13:50:54 UTC
Can you install this nightly build
https://code.gnucash.org/builds/win32/maint/gnucash-3.0-2018-04-18-git-3.0-83-gcad6bb427+.setup.exe
And test loading the sqlite3 file again?
The load performance issue should be resolved now.
Comment 7 gorf 2018-04-24 07:52:22 UTC
This version solved this problem. Thank you.
Comment 8 John Ralls 2018-06-30 00:05:39 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=794482. Please update any external references or bookmarks.