Removing tags

mronkko

I have a large collection with a couple of thousand tags. Since this number of tags causes Zotero to ocassionally freeze for a couple of seconds, I decided to remove all tags. I did this by deleting everything in the itemTags and tags database tables. However, this did not completely remove the tags: I still get tags displayed in the tag selector. These tags, however, do absolutely nothing.

Is there some cache that I need to delete as well?

Mikko

dstillman

Not unless Firefox is still open, but unless you changed a preference you shouldn't be able to access the Zotero database with Firefox open to begin with.

mronkko

I have done the following:
1) Use SQLite Manager firefox extension to run "delete from itemtags" and "delete from tags" from /zotero/zotero.sqlite under my Firefox profile
2) Restart Firefox

Still the tags show in the tag selector. The tags do nothing, though.

Mikko

dstillman

If you modified your database while Firefox was open using a separate (i.e., non-Zotero) DB connection, you may have corrupted your database.

SQL changes not made through the Zotero API (e.g., Zotero.DB.query(sql)) should only be made with Firefox closed.

Run a DB integrity check from the Advanced pane of the Zotero prefs or by running PRAGMA integrity_check; in sqlite3.

mronkko

This issue turned out to be a "stupid user" -error. I deleted the tags from a database under my firefox profile, but had previously relocated the Zotero database.

Mikko