The schema for the table 'fields' is currently (as of zotero 1.0.4):

CREATE TABLE fields (
fieldID INTEGER PRIMARY KEY,
fieldName TEXT,
fieldFormatID INT,
FOREIGN KEY (fieldFormatID) REFERENCES fieldFormat(fieldFormatID)
);

The FOREIGN KEY references a non-existing table fieldFormat (how the *hell* could such a thing possibly happen ? Looks like a good candidate for an sqlite bug report... anyway)

The correct FOREIGN KEY definition should be:

FOREIGN KEY (fieldFormatID) REFERENCES fieldFormats(fieldFormatID)

The following SQL statements solve the problem:

CREATE TEMPORARY TABLE fieldsTemp AS SELECT * FROM fields;
DROP TABLE fields;
CREATE TABLE IF NOT EXISTS fields (
fieldID INTEGER PRIMARY KEY,
fieldName TEXT,
fieldFormatID INT,
FOREIGN KEY (fieldFormatID) REFERENCES fieldFormats(fieldFormatID)
);
INSERT INTO fields SELECT * FROM fieldsTemp;
DROP TABLE fieldsTemp;

Thanks in advance. A consistent schema is necessary for ORM tools like SQLalchemy to create an object representation of the data using reflection.