All Scheduled Transactions Disappear

[aeneas]

I don't recall anything unusual when opening the databases but I started and
stopped GnuCash several times after recognizing the problem but didn't do
anything that would cause a change to the database.  Something I probably
should mention is that a big reason for choosing to use MySQL is that I can
use different computers to process the accounts.  This includes a
combination of laptop and desktops where the desktops include both Windows
and Linux (Ubuntu) based systems.  I've also experimented with both the
version of GnuCash obtained from portableapps.com as well as the installed
version from the GnuCash website.  A definite consequence is that slightly
different versions of GnuCash have been used to process the same MySQL
database.  With that said, I have been aware that GnuCash doesn't permit
simultaneous access to a database and I'm pretty sure that I didn't
accidentally violate that restriction.

I've now restored 2 databases to my test system.  The first is the one I
backed up as soon as I realized that I had a problem.  The other is the one
which my hosting service restored today which was supposed to have been
backed up one week prior to experiencing the problem.  There were only about
a half dozen transactions entered during that time.  I haven't yet opened
either with GnuCash but have been doing some inspection with phpMyAdmin. 
Something I have noticed is that the "transactions_back" table in each DB
have the same number of rows and the most recently entered few rows appear
to be identical.  The "transactions" table on the most current version of
the database contains a lot fewer rows than the "transactions_back" table
but the most recently entered transactions are present.  In that, these are
the few transactions entered to the older DB version.  This implies that the
process for creating the new tables inserts the newer data first and the
older data last.  Does that sound plausible?

Before trying to undertake your repair suggestion I thought I'd try opening
these test versions with GnuCash.  Is there any possibility that GnuCash
will use, or can be made to use, the data from the "foo_back" tables or is
that a waste of time?  Note:  Now that I can restore either of these
databases to their current state I can afford to experiment without risking
further damage.



--
View this message in context: http://gnucash.1415818.n4.nabble.com/All-Scheduled-Transaction-Disappear-tp4688388p4688420.html
Sent from the GnuCash - User mailing list archive at Nabble.com.