Bug 632252 – Scheduled Transactions lost when converting from XML to mySQL database.

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 632252 - Scheduled Transactions lost when converting from XML to mySQL database.


Summary:	Scheduled Transactions lost when converting from XML to mySQL database.


Status:	RESOLVED DUPLICATE of bug 627831

Product:	GnuCash
Classification:	Other
Component:	Backend - SQL
Version:	2.3.x
Hardware:	Other Linux

Importance:	Normal major
Target Milestone:	---
Assigned To:	Phil Longstaff
QA Contact:	Chris Shoemaker

URL:
Whiteboard:

Depends on:
Blocks:

Reported:	2010-10-15 20:18 UTC by stburkeuk
Modified:	2018-06-29 22:45 UTC

See Also:
GNOME target:	---
GNOME version:	---

Attachments
Trace containing SQL statement to create database? (723.43 KB, text/plain) 2010-10-15 20:18 UTC, stburkeuk	Details
as requested - trace from database load - part 1 (file too big ) (795.54 KB, application/x-compressed-tar) 2010-10-15 21:05 UTC, stburkeuk	Details
as requested - trace from database load - part 2 (file too big ) (598.77 KB, application/x-gzip) 2010-10-15 21:06 UTC, stburkeuk	Details

Description stburkeuk 2010-10-15 20:18:39 UTC

Created attachment 172454 [details]
Trace containing SQL statement to create database?

In testing 2.3.15 with a mySQL back end I have repeatedly had the following problem.

a) Open existing XML file in GnuCash.
b) Used File/Save As to save to mySQL 
c) check Scheduled Transaction editor -- details are there.
d) check accounts - entries generated by scheduled transactions are there.
e) Close GnuCash
f) Reopen GnuCash using mySQL back end.
g) Scheduled transaction entries on accounts lost
h) scheduled transactions in editor lost.

As I say this has happened each and every time I have imported the file from XML to mySQL.

GnuCash build statement - "This copy was built from r19435M on 2010-10-10."
System - running Fedora 13
Kernel - Linux 2.6.34.7-56.fc13.i686.PAE

gnucash.trace attached

If more details are needed drop me a mail.

Comment 1 Geert Janssens 2010-10-15 20:29:15 UTC

Thank you for your report. The trace file you attached is from the GnuCash run where you *load* the mysql database (created during step f.). This trace file looks completely normal.

Could you rerun your steps until step e) and then post the trace file ? That should contain traces of *saving* to mysql.

Comment 2 stburkeuk 2010-10-15 21:05:39 UTC

Created attachment 172457 [details]
as requested - trace from database load - part 1 (file too big )

can find a create table for schedxactions but no Insert INTO statement

Have also tried to create a new schedual transaction at end of file. - seems to have worked.

Comment 3 stburkeuk 2010-10-15 21:06:50 UTC

Created attachment 172458 [details]
as requested - trace from database load - part 2 (file too big )

Comment 4 stburkeuk 2010-10-15 21:16:08 UTC

just tried test with new xml created within 2.3.15 - converted fine.

Comment 5 stburkeuk 2010-10-15 21:35:28 UTC

Same result with conversion to SQLITE from historic xml file.

Comment 6 John Ralls 2010-10-26 04:29:44 UTC


*** This bug has been marked as a duplicate of bug 627831 ***

Comment 7 John Ralls 2018-06-29 22:45:55 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=632252. Please update any external references or bookmarks.