No way to restore default equipment

Bug #1109652 reported by serandor
6
This bug affects 1 person
Affects Status Importance Assigned to Milestone
Brewtarget
Confirmed
Wishlist
Unassigned

Bug Description

This is sort of more of a feature request.
I accidentally deleted some of the default equipment. Now I can't figure out how to get it back. Reinstalling a new copy of brewtarget didn't do it either.
Thanks!

Philip (rocketman768)
Changed in brewtarget:
status: New → Confirmed
importance: Medium → Wishlist
Revision history for this message
Mik Firestone (mikfire) wrote :

There is a way. It isn't pretty, but there is a way.

Our shiny new database doesn't actually delete things, it simply marks them as deleted and you don't see them. If you want to recover the equipment, you can do the following:
  1. Close brewtarget
  2. cd into your data directory, ~/.config/brewtarget by default
  3. Make a backup copy
  4. No. I am not kidding. Make a backup copy.
  5. Run these commands:
        sqlite3 database.sqlite 'update table equipment set delete=0 where delete=1'
  6. Start brewtarget

You should see all of your equipment back. If my SQL was awful, just restore the backup copy.

We will be implementing an undelete feature soon, but we just couldn't do it in this version.

To post a comment you must log in.
This report contains Public information  
Everyone can see this information.

Other bug subscribers

Remote bug watches

Bug watches keep track of this bug in other bug trackers.