Created
January 16, 2011 09:10
-
-
Save avram/781665 to your computer and use it in GitHub Desktop.
Error when installing zotero-multi-2.xpi over Zotero 2.1b4
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
[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