Quoting Thomas in the original report. > If there are users affected by this bug who are without backup, a script > could be written to > automate rescue...
What would that involve? ** Description changed: Binary package hint: gourmet This is a critical bug that has been fixed in 0.14.2. The bug is fixed in the database upgrade code. Note to users experiencing this bug -- it is possible to recover your ingredients by going into the DB by hand, but there is no user-discoverable way to recover data. If there are users affected by this bug who are without backup, a script could be written to automate rescue... ================================================== suggested current workaround for Intrepid users: install https://launchpad.net/%7Er0lf/+archive/ppa/+files/gourmet_0.14.3-1_all.deb (provided by the Debian maintainer of the package, so it should be safe and worry-free) ================================================== exec summary as per https://wiki.ubuntu.com/StableReleaseUpdates#Procedure 1. This is fixed in versions 0.14.2 and higher. Current version in Jaunty is 0.14.2. 2.1. This bug leads to data loss. Over time, the ingredient table in the sqlite db is destroyed. Recipes are without ingredients from that point on. 2.2. upstream has introduced 2 measures in 0.14.2 to prevent this problem. First, at startup backups are made of the current db before touching it. Second, the data manipulation code for the table has been altered so that this problem should not occur anymore. The supplied minimal patch backports these two changes and these two changes only from the 355KB diff between 0.14.0 and 0.14.2. - 2.3. http://launchpadlibrarian.net/21969848/gourmet.debdiff + 2.3. suggested fix for intrepid-proposed: + http://launchpadlibrarian.net/21969848/gourmet.debdiff 2.4. TEST CASE: a) Install the Intrepid version of gourmet - b) uncompress http://launchpadlibrarian.net/21969330/recipes.db.bz2 into ~/.gourmet + b) uncompress http://launchpadlibrarian.net/21969330/recipes.db.bz2 into ~/.gourmet/recipes.db c) start gourmet twice and see that the ingredients for recipe1 are missing (I currently cannot reproduce this) d) try the same with the updated version and see that the ingredients stay 2.5 regression potential (Thomas, please comment on this) The data-loosing behavious is in the current package. At least backups are being made now, so the problem of actual data loss already means an improvement with no downside. (insert Thomas' comments as to how likely the code changes for table handling are to introduce a regression) -- Upgrading from 0.13.x to 0.14.0 wipes out ingredient database https://bugs.launchpad.net/bugs/291353 You received this bug notification because you are a member of Ubuntu Bugs, which is subscribed to Ubuntu. -- ubuntu-bugs mailing list [email protected] https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs
