Hello,
I just subscribed to this list, after finding the solution to my crashing
gnucash in this thread. I think my additional information may be of value,
so excuse my barging in without proper introduction etc.
Okay. I shut down gnucash. Rebooted my Ubuntu 16.04 for a kernel upgrade and
started gnucash again. A side note: It may be important to know that gnucash
got upgraded automatically since the previous start. It is now at
1:2.6.16-1~getdeb1.
So, gnucash dumped core and googling on the error lead me to this thread.
And of course the cause was quickly found:
mysql> select * from transactions where guid='84<masked>f8'\G
*************************** 1. row ***************************
guid: 84<masked>f8
currency_guid: 83<masked>a4
num:
post_date: 0000-00-00 00:00:00
enter_date: 2005-09-09 14:21:36
description: <private>
1 row in set (0.00 sec)
I fixed this by issuing this SQL command instead of deleting the
transaction:
mysql> update transactions set post_date = '2005-09-09 00:00:00' where
guid='84<masked>f8';
.. and gnucash started up very well after this.
The difference / extra info here is:
* gnucash did not crash. I shut down the previous version gracefully.
* This particulair transaction has been there for almost 12 years now.
* It is the very first transaction in this particular account.
* A quick look in a backup from 6 month's ago also shows: post_date:
0000-00-00 00:00:00
* This never caused trouble while starting up before.
So.. maybe it is a regression issue that may bite others too?
--
View this message in context:
http://gnucash.1415818.n4.nabble.com/Gnucash-crashing-on-startup-tp4690116p4692101.html
Sent from the GnuCash - User mailing list archive at Nabble.com.
_______________________________________________
gnucash-user mailing list
gnucash-user@gnucash.org
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-----
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.
