Skip to content

Instantly share code, notes, and snippets.

@avram avram/gist:781665
Created Jan 16, 2011

Embed
What would you like to do?
Error when installing zotero-multi-2.xpi over Zotero 2.1b4
[JavaScript Error: "uncaught exception: [Exception... "Component returned failure code: 0x80004005 (NS_ERROR_FAILURE) [mozIStorageConnection.createStatement]" nsresult: "0x80004005 (NS_ERROR_FAILURE)" location: "JS frame :: chrome://zotero/content/xpcom/db.js :: anonymous :: line 292" data: no] [QUERY: SELECT I.*, COALESCE(CASE (SELECT COUNT(*) FROM itemCreators IC LEFT JOIN itemTypeCreatorTypes ITCT ON (IC.creatorTypeID=ITCT.creatorTypeID AND ITCT.itemTypeID=I.itemTypeID) WHERE itemID=I.itemID AND primaryField=1) WHEN 0 THEN NULL WHEN 1 THEN (SELECT lastName FROM itemCreators IC NATURAL JOIN creators NATURAL JOIN creatorData LEFT JOIN itemTypeCreatorTypes ITCT ON (IC.creatorTypeID=ITCT.creatorTypeID AND ITCT.itemTypeID=I.itemTypeID) WHERE itemID=I.itemID AND primaryField=1) WHEN 2 THEN (SELECT (SELECT lastName FROM itemCreators IC NATURAL JOIN creators NATURAL JOIN creatorData LEFT JOIN itemTypeCreatorTypes ITCT ON (IC.creatorTypeID=ITCT.creatorTypeID AND ITCT.itemTypeID=I.itemTypeID) WHERE itemID=I.itemID AND primaryField=1 ORDER BY orderIndex LIMIT 1) || ' and ' || (SELECT lastName FROM itemCreators IC NATURAL JOIN creators NATURAL JOIN creatorData LEFT JOIN itemTypeCreatorTypes ITCT ON (IC.creatorTypeID=ITCT.creatorTypeID AND ITCT.itemTypeID=I.itemTypeID) WHERE itemID=I.itemID AND primaryField=1 ORDER BY orderIndex LIMIT 1,1)) ELSE (SELECT (SELECT lastName FROM itemCreators IC NATURAL JOIN creators NATURAL JOIN creatorData LEFT JOIN itemTypeCreatorTypes ITCT ON (IC.creatorTypeID=ITCT.creatorTypeID AND ITCT.itemTypeID=I.itemTypeID) WHERE itemID=I.itemID AND primaryField=1 ORDER BY orderIndex LIMIT 1) || ' et al.' ) END, CASE (SELECT COUNT(*) FROM itemCreators WHERE itemID=I.itemID AND creatorTypeID IN (3)) WHEN 0 THEN NULL WHEN 1 THEN (SELECT lastName FROM itemCreators NATURAL JOIN creators NATURAL JOIN creatorData WHERE itemID=I.itemID AND creatorTypeID IN (3)) WHEN 2 THEN (SELECT (SELECT lastName FROM itemCreators NATURAL JOIN creators NATURAL JOIN creatorData WHERE itemID=I.itemID AND creatorTypeID IN (3) ORDER BY orderIndex LIMIT 1) || ' and ' || (SELECT lastName FROM itemCreators NATURAL JOIN creators NATURAL JOIN creatorData WHERE itemID=I.itemID AND creatorTypeID IN (3) ORDER BY orderIndex LIMIT 1,1) ) ELSE (SELECT (SELECT lastName FROM itemCreators NATURAL JOIN creators NATURAL JOIN creatorData WHERE itemID=I.itemID AND creatorTypeID IN (3) ORDER BY orderIndex LIMIT 1) || ' et al.' ) END, CASE (SELECT COUNT(*) FROM itemCreators WHERE itemID=I.itemID AND creatorTypeID IN (2)) WHEN 0 THEN NULL WHEN 1 THEN (SELECT lastName FROM itemCreators NATURAL JOIN creators NATURAL JOIN creatorData WHERE itemID=I.itemID AND creatorTypeID IN (2)) WHEN 2 THEN (SELECT (SELECT lastName FROM itemCreators NATURAL JOIN creators NATURAL JOIN creatorData WHERE itemID=I.itemID AND creatorTypeID IN (2) ORDER BY orderIndex LIMIT 1) || ' and ' || (SELECT lastName FROM itemCreators NATURAL JOIN creators NATURAL JOIN creatorData WHERE itemID=I.itemID AND creatorTypeID IN (2) ORDER BY orderIndex LIMIT 1,1) ) ELSE (SELECT (SELECT lastName FROM itemCreators NATURAL JOIN creators NATURAL JOIN creatorData WHERE itemID=I.itemID AND creatorTypeID IN (2) ORDER BY orderIndex LIMIT 1) || ' et al.' ) END) AS firstCreator, (SELECT COUNT(*) FROM itemNotes INo WHERE sourceItemID=I.itemID AND INo.itemID NOT IN (SELECT itemID FROM deletedItems)) AS numNotes, (SELECT COUNT(*) FROM itemAttachments IA WHERE sourceItemID=I.itemID AND IA.itemID NOT IN (SELECT itemID FROM deletedItems)) AS numAttachments, COALESCE((SELECT lastName FROM itemCreators IC NATURAL JOIN (SELECT C.creatorID,COALESCE(A.lastName,C.lastName) AS lastName FROM (SELECT creatorID,lastName FROM creators NATURAL JOIN creatorData) C LEFT JOIN (SELECT creatorID,lastName FROM creatorsAlt NATURAL JOIN creatorDataAlt WHERE languageTag in (SELECT tag FROM zlsPreferences WHERE param='zoteroSort')) A ON C.creatorID=A.creatorID) LEFT JOIN itemTypeCreatorTypes ITCT WHERE ITCT.itemTypeID=I.itemTypeID AND itemID=I.itemID AND itemID=IC.itemID AND primaryField=1 ORDER BY orderIndex LIMIT 1),(SELECT lastName FROM itemCreators IC NATURAL JOIN (SELECT C.creatorID,COALESCE(A.lastName,C.lastName) AS lastName FROM (SELECT creatorID,lastName FROM creators NATURAL JOIN creatorData) C LEFT JOIN (SELECT creatorID,lastName FROM creatorsAlt NATURAL JOIN creatorDataAlt WHERE languageTag in (SELECT tag FROM zlsPreferences WHERE param='zoteroSort')) A ON C.creatorID=A.creatorID) LEFT JOIN itemTypeCreatorTypes ITCT WHERE ITCT.itemTypeID=I.itemTypeID AND itemID=I.itemID AND itemID=IC.itemID AND ITCT.creatorTypeID in (3) ORDER BY orderIndex LIMIT 1),(SELECT lastName FROM itemCreators IC NATURAL JOIN (SELECT C.creatorID,COALESCE(A.lastName,C.lastName) AS lastName FROM (SELECT creatorID,lastName FROM creators NATURAL JOIN creatorData) C LEFT JOIN (SELECT creatorID,lastName FROM creatorsAlt NATURAL JOIN creatorDataAlt WHERE languageTag in (SELECT tag FROM zlsPreferences WHERE param='zoteroSort')) A ON C.creatorID=A.creatorID) LEFT JOIN itemTypeCreatorTypes ITCT WHERE ITCT.itemTypeID=I.itemTypeID AND itemID=I.itemID AND itemID=IC.itemID AND ITCT.creatorTypeID in (2) ORDER BY orderIndex LIMIT 1)) AS sortCreator FROM items I WHERE 1 AND I.itemID IN (4225)] [ERROR: no such table: zlsPreferences] [QUERY: SELECT I.*, COALESCE(CASE (SELECT COUNT(*) FROM itemCreators IC LEFT JOIN itemTypeCreatorTypes ITCT ON (IC.creatorTypeID=ITCT.creatorTypeID AND ITCT.itemTypeID=I.itemTypeID) WHERE itemID=I.itemID AND primaryField=1) WHEN 0 THEN NULL WHEN 1 THEN (SELECT lastName FROM itemCreators IC NATURAL JOIN creators NATURAL JOIN creatorData LEFT JOIN itemTypeCreatorTypes ITCT ON (IC.creatorTypeID=ITCT.creatorTypeID AND ITCT.itemTypeID=I.itemTypeID) WHERE itemID=I.itemID AND primaryField=1) WHEN 2 THEN (SELECT (SELECT lastName FROM itemCreators IC NATURAL JOIN creators NATURAL JOIN creatorData LEFT JOIN itemTypeCreatorTypes ITCT ON (IC.creatorTypeID=ITCT.creatorTypeID AND ITCT.itemTypeID=I.itemTypeID) WHERE itemID=I.itemID AND primaryField=1 ORDER BY orderIndex LIMIT 1) || ' and ' || (SELECT lastName FROM itemCreators IC NATURAL JOIN creators NATURAL JOIN creatorData LEFT JOIN itemTypeCreatorTypes ITCT ON (IC.creatorTypeID=ITCT.creatorTypeID AND ITCT.itemTypeID=I.itemTypeID) WHERE itemID=I.itemID AND primaryField=1 ORDER BY orderIndex LIMIT 1,1)) ELSE (SELECT (SELECT lastName FROM itemCreators IC NATURAL JOIN creators NATURAL JOIN creatorData LEFT JOIN itemTypeCreatorTypes ITCT ON (IC.creatorTypeID=ITCT.creatorTypeID AND ITCT.itemTypeID=I.itemTypeID) WHERE itemID=I.itemID AND primaryField=1 ORDER BY orderIndex LIMIT 1) || ' et al.' ) END, CASE (SELECT COUNT(*) FROM itemCreators WHERE itemID=I.itemID AND creatorTypeID IN (3)) WHEN 0 THEN NULL WHEN 1 THEN (SELECT lastName FROM itemCreators NATURAL JOIN creators NATURAL JOIN creatorData WHERE itemID=I.itemID AND creatorTypeID IN (3)) WHEN 2 THEN (SELECT (SELECT lastName FROM itemCreators NATURAL JOIN creators NATURAL JOIN creatorData WHERE itemID=I.itemID AND creatorTypeID IN (3) ORDER BY orderIndex LIMIT 1) || ' and ' || (SELECT lastName FROM itemCreators NATURAL JOIN creators NATURAL JOIN creatorData WHERE itemID=I.itemID AND creatorTypeID IN (3) ORDER BY orderIndex LIMIT 1,1) ) ELSE (SELECT (SELECT lastName FROM itemCreators NATURAL JOIN creators NATURAL JOIN creatorData WHERE itemID=I.itemID AND creatorTypeID IN (3) ORDER BY orderIndex LIMIT 1) || ' et al.' ) END, CASE (SELECT COUNT(*) FROM itemCreators WHERE itemID=I.itemID AND creatorTypeID IN (2)) WHEN 0 THEN NULL WHEN 1 THEN (SELECT lastName FROM itemCreators NATURAL JOIN creators NATURAL JOIN creatorData WHERE itemID=I.itemID AND creatorTypeID IN (2)) WHEN 2 THEN (SELECT (SELECT lastName FROM itemCreators NATURAL JOIN creators NATURAL JOIN creatorData WHERE itemID=I.itemID AND creatorTypeID IN (2) ORDER BY orderIndex LIMIT 1) || ' and ' || (SELECT lastName FROM itemCreators NATURAL JOIN creators NATURAL JOIN creatorData WHERE itemID=I.itemID AND creatorTypeID IN (2) ORDER BY orderIndex LIMIT 1,1) ) ELSE (SELECT (SELECT lastName FROM itemCreators NATURAL JOIN creators NATURAL JOIN creatorData WHERE itemID=I.itemID AND creatorTypeID IN (2) ORDER BY orderIndex LIMIT 1) || ' et al.' ) END) AS firstCreator, (SELECT COUNT(*) FROM itemNotes INo WHERE sourceItemID=I.itemID AND INo.itemID NOT IN (SELECT itemID FROM deletedItems)) AS numNotes, (SELECT COUNT(*) FROM itemAttachments IA WHERE sourceItemID=I.itemID AND IA.itemID NOT IN (SELECT itemID FROM deletedItems)) AS numAttachments, COALESCE((SELECT lastName FROM itemCreators IC NATURAL JOIN (SELECT C.creatorID,COALESCE(A.lastName,C.lastName) AS lastName FROM (SELECT creatorID,lastName FROM creators NATURAL JOIN creatorData) C LEFT JOIN (SELECT creatorID,lastName FROM creatorsAlt NATURAL JOIN creatorDataAlt WHERE languageTag in (SELECT tag FROM zlsPreferences WHERE param='zoteroSort')) A ON C.creatorID=A.creatorID) LEFT JOIN itemTypeCreatorTypes ITCT WHERE ITCT.itemTypeID=I.itemTypeID AND itemID=I.itemID AND itemID=IC.itemID AND primaryField=1 ORDER BY orderIndex LIMIT 1),(SELECT lastName FROM itemCreators IC NATURAL JOIN (SELECT C.creatorID,COALESCE(A.lastName,C.lastName) AS lastName FROM (SELECT creatorID,lastName FROM creators NATURAL JOIN creatorData) C LEFT JOIN (SELECT creatorID,lastName FROM creatorsAlt NATURAL JOIN creatorDataAlt WHERE languageTag in (SELECT tag FROM zlsPreferences WHERE param='zoteroSort')) A ON C.creatorID=A.creatorID) LEFT JOIN itemTypeCreatorTypes ITCT WHERE ITCT.itemTypeID=I.itemTypeID AND itemID=I.itemID AND itemID=IC.itemID AND ITCT.creatorTypeID in (3) ORDER BY orderIndex LIMIT 1),(SELECT lastName FROM itemCreators IC NATURAL JOIN (SELECT C.creatorID,COALESCE(A.lastName,C.lastName) AS lastName FROM (SELECT creatorID,lastName FROM creators NATURAL JOIN creatorData) C LEFT JOIN (SELECT creatorID,lastName FROM creatorsAlt NATURAL JOIN creatorDataAlt WHERE languageTag in (SELECT tag FROM zlsPreferences WHERE param='zoteroSort')) A ON C.creatorID=A.creatorID) LEFT JOIN itemTypeCreatorTypes ITCT WHERE ITCT.itemTypeID=I.itemTypeID AND itemID=I.itemID AND itemID=IC.itemID AND ITCT.creatorTypeID in (2) ORDER BY orderIndex LIMIT 1)) AS sortCreator FROM items I WHERE 1 AND I.itemID IN (4225)] [ERROR: no such table: zlsPreferences]"]
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
You can’t perform that action at this time.