Re: [sqlite] On VACUUM I get "constraint failed"

Preston, Thanks for the advice. I dumped the sql and attempted to recreate the db and got this error: >sqlite3 -init db.sql test.db Loading resources from db.sql INSERT INTO "category_meta_information" VALUES(NULL, NULL, NULL, NULL, NULL); SQL error: category_meta_information.taxonomy_id may not

RE: [sqlite] On VACUUM I get "constraint failed"

Hard to tell from the schema that you attached where the problem might be... but try doing a .dump from the command line util and re-importing into a clean db, it should where expose the issue is. sqlite> .output db.sql sqlite> .dump sqlite> .exit sqlite3 -init db.sql test.db hope this helps