Restart USDA database download

Asked by Don Matthews on 2013-09-26

How do you start the USDA database download from the command line?

I clicked on the "Nutritional Information" plugin which quickly started the category index download, but the actual update of the information in the database never started. It hung on "updating 1 of 1786" (or thereabouts). When I quit Gourmet Manager, the download obviously stopped (if in fact it ever started) and will not start again.

I have completely uninstalled and re-installed the program via Synaptics manager and removed the .gourmet folder in /user/shared, but there are evidently some other configuration files that are NOT removed and so the update will not start again.

I am on Precise Pangolin and version 0.15.9-1 of Gourmet Manager. All updates are up to date.

Your assistance is appreciated.

Thanks,
-DON-

Question information

Language:
English Edit question
Status:
Answered
For:
Gourmet Edit question
Assignee:
No assignee Edit question
Last query:
Last reply:
Launchpad Janitor (janitor) said : #1

This question was expired because it remained in the 'Open' state without activity for the last 15 days.

Bernhard Reiter (ockham-razor) said : #2

Sorry for not answering this earlier.

To solve your issue, you need to delete the tables named "nutrition", "nutritionaliases", and "nutritionconversions" from your recipe SQLite database, which is named recipes.db and located in the (hidden) ".gourmet" subfolder of your home directory.

Before doing that, run gourmet once again and make sure the Nutritional Information plugin is deactivated.

Then, to run the SQLite tool (which you might need to install first; the relevant package is called sqlite3) from a command prompt, enter

sqlite3 ~/.gourmet/recipes.db

Then, at the "sqlite>" prompt, enter the following commands:

drop table nutrition;
drop table nutritionaliases;
drop table nutritionconversions;
.exit

(Note the semicolons and dot!)

After that, running gourmet again and re-activating the Nutritional Information Plugin should restart the nutritional database download.

Can you help with this problem?

Provide an answer of your own, or ask Don Matthews for more information if necessary.

To post a message you must log in.