Created
January 16, 2011 19:17
-
-
Save avram/782055 to your computer and use it in GitHub Desktop.
Debug from multilingual-- broken collection
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
(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