Skip to content

Instantly share code, notes, and snippets.

@avram
Created January 16, 2011 19:17
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save avram/782055 to your computer and use it in GitHub Desktop.
Save avram/782055 to your computer and use it in GitHub Desktop.
Debug from multilingual-- broken collection
(4)(+0088212): Unregistering observer in notifier with hash 'pE'
(4)(+0000004): Registering observer for [item,collection-item,share-items,bucket] in notifier with hash XA'
(3)(+0000140): Refreshing items list
(5)(+0000001): SELECT tag FROM zlsPreferences WHERE profile=? AND param=?
(5)(+0000000): Binding parameter 1 of type string: "default"
(5)(+0000000): Binding parameter 2 of type string: "zoteroSort"
(5)(+0000002): Beginning DB transaction
(3)(+0000002): Beginning Notifier event queue
(3)(+0000000): Caching fields [title,date,firstCreator]
(5)(+0000001): Transaction in progress -- increasing level to 1
(5)(+0000003): SELECT ROWID FROM collections WHERE libraryID IS NULL AND key=?
(5)(+0000001): Binding parameter 1 of type string: "RTT6R82U"
(5)(+0000001): CREATE TEMPORARY TABLE tmpSearchResults_QdqhVFW4 AS SELECT itemID FROM items WHERE itemID NOT IN (SELECT itemID FROM deletedItems UNION SELECT itemID FROM itemNotes WHERE sourceItemID IS NOT NULL AND sourceItemID IN (SELECT itemID FROM deletedItems) UNION SELECT itemID FROM itemAttachments WHERE sourceItemID IS NOT NULL AND sourceItemID IN (SELECT itemID FROM deletedItems) ) AND (itemID NOT IN (SELECT itemID FROM itemNotes WHERE sourceItemID IS NOT NULL) AND itemID NOT IN (SELECT itemID FROM itemAttachments WHERE sourceItemID IS NOT NULL)) AND itemID IN (SELECT itemID FROM collectionItems WHERE (collectionID IN (?)))
(5)(+0000001): Binding parameter 1 of type int: 38
(5)(+0000019): CREATE INDEX tmpSearchResults_QdqhVFW4_itemID ON tmpSearchResults_QdqhVFW4(itemID)
(5)(+0000001): SELECT itemID FROM items WHERE itemID IN (SELECT itemID FROM items WHERE itemID NOT IN (SELECT itemID FROM deletedItems UNION SELECT itemID FROM itemNotes WHERE sourceItemID IS NOT NULL AND sourceItemID IN (SELECT itemID FROM deletedItems) UNION SELECT itemID FROM itemAttachments WHERE sourceItemID IS NOT NULL AND sourceItemID IN (SELECT itemID FROM deletedItems) )) AND (itemID IN (SELECT itemID FROM tmpSearchResults_QdqhVFW4) OR itemID IN (SELECT itemID FROM itemAttachments WHERE sourceItemID IN (SELECT itemID FROM tmpSearchResults_QdqhVFW4)) OR itemID IN (SELECT itemID FROM itemNotes WHERE sourceItemID IN (SELECT itemID FROM tmpSearchResults_QdqhVFW4)))
(5)(+0000079): DROP TABLE tmpSearchResults_QdqhVFW4
(5)(+0000001): Decreasing transaction level to 0
(5)(+0000004): Committing transaction
(3)(+0000000): Resetting Notifier event queue
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment