Last login: Tue Aug 29 10:03:22 on ttyp3 Welcome to Darwin! takbookpro:~ stakats$ /Applications/Firefox.app/Contents/MacOS/firefox scholar(3): Integration HTTP server listening on 127.0.0.1:50001 scholar(5): SELECT version FROM version WHERE schema='schema' scholar(5): SELECT version FROM version WHERE schema='scrapers' scholar(5): SELECT version FROM version WHERE schema='lastcheck' scholar(4): Not enough time since last update -- not checking repository scholar(3): Setting repository check interval to 20864 seconds scholar(5): SELECT translatorID, type, label, target, detectCode IS NULL as noDetectCode FROM translators ORDER BY target IS NULL scholar(5): SELECT translatorID, detectCode FROM translators WHERE target IS NULL scholar(5): SELECT collectionID FROM collections C WHERE parentCollectionID IS NULL ORDER BY collectionName scholar(5): SELECT collectionID, collectionName, parentCollectionID, (SELECT COUNT(*) FROM collections WHERE parentCollectionID=C.collectionID)!=0 AS hasChildCollections, (SELECT COUNT(*) FROM collectionItems WHERE collectionID=C.collectionID)!=0 AS hasChildItems FROM collections C scholar(5): SELECT itemID FROM collectionItems WHERE collectionID=7693 scholar(5): SELECT savedSearchID AS id, savedSearchName AS name FROM savedSearches ORDER BY name scholar(4): Registering columnTree in notifier with hash '5s' scholar(5): SELECT A.itemID FROM items A LEFT JOIN itemNotes B USING (itemID) LEFT JOIN itemAttachments C ON (C.itemID=A.itemID) WHERE B.sourceItemID IS NULL AND C.sourceItemID IS NULL scholar(5): SELECT I.*, lastName || CASE ((SELECT COUNT(*) FROM itemCreators WHERE itemID=I.itemID)>1) WHEN 0 THEN '' ELSE ' et al.' END AS firstCreator, (SELECT COUNT(*) FROM itemNotes WHERE sourceItemID=I.itemID) AS numNotes, (SELECT COUNT(*) FROM itemAttachments WHERE sourceItemID=I.itemID) AS numAttachments FROM items I LEFT JOIN itemCreators IC ON (I.itemID=IC.itemID) LEFT JOIN creators C ON (IC.creatorID=C.creatorID) WHERE (IC.orderIndex=0 OR IC.orderIndex IS NULL) AND I.itemID IN (1692,3863,8318,9363,9528,9725,12848,13002,13221,14775,14871,15161) scholar(5): SELECT * FROM items LIMIT 1 scholar(5): SELECT itemTypeID AS id, typeName AS name FROM itemTypes order BY typeName scholar(4): Registering itemTree in notifier with hash 'bT' scholar(5): SELECT itemTypeID AS id, typeName AS name FROM itemTypes order BY typeName scholar(5): SELECT creatorTypeID AS id, creatorType AS name FROM creatorTypes order BY creatorType scholar(5): SELECT itemTypeID AS id, typeName AS name FROM itemTypes order BY typeName scholar(3): binding sandbox to http://www.google.com/firefox?client=firefox-a&rls=org.mozilla:en-US:official scholar(3): searching for translators for http://www.google.com/firefox?client=firefox-a&rls=org.mozilla:en-US:official scholar(3): executed detectCode for Embedded RDF scholar(3): executed detectCode for COinS scholar(3): binding sandbox to http://library.gmu.edu/ scholar(3): searching for translators for http://library.gmu.edu/ scholar(3): executed detectCode for Embedded RDF scholar(3): executed detectCode for COinS scholar(3): binding sandbox to http://www.lib.umich.edu/ scholar(3): searching for translators for http://www.lib.umich.edu/ scholar(3): executed detectCode for Embedded RDF scholar(3): executed detectCode for COinS scholar(3): binding sandbox to http://www.lib.umich.edu/electres/catalogs.html scholar(3): searching for translators for http://www.lib.umich.edu/electres/catalogs.html scholar(3): executed detectCode for Embedded RDF scholar(3): executed detectCode for COinS scholar(3): binding sandbox to http://mirlyn.lib.umich.edu/ scholar(3): searching for translators for http://mirlyn.lib.umich.edu/ scholar(3): executed detectCode for Embedded RDF scholar(3): executed detectCode for COinS scholar(3): binding sandbox to http://mirlyn.lib.umich.edu/F/?func=file&file_name=find-b scholar(3): searching for translators for http://mirlyn.lib.umich.edu/F/?func=file&file_name=find-b scholar(3): executed detectCode for Embedded RDF scholar(3): executed detectCode for COinS scholar(3): binding sandbox to http://mirlyn.lib.umich.edu/F/EYE18XPEN2JTMBJVM8QV8A9E37LEG9EMXRHJNIYLC28AUBXSP8-16103?func=scan&scan_code=AUT&scan_start=cooper%2C+frederick scholar(3): searching for translators for http://mirlyn.lib.umich.edu/F/EYE18XPEN2JTMBJVM8QV8A9E37LEG9EMXRHJNIYLC28AUBXSP8-16103?func=scan&scan_code=AUT&scan_start=cooper%2C+frederick scholar(5): SELECT detectCode FROM translators WHERE translatorID = ? scholar(5): Binding parameter 1 of type string: "cf87eca8-041d-b954-795a-2d86348999d5" scholar(3): executed detectCode for Aleph scholar(3): executed detectCode for Embedded RDF scholar(3): executed detectCode for COinS scholar(3): binding sandbox to http://mirlyn.lib.umich.edu/F/EYE18XPEN2JTMBJVM8QV8A9E37LEG9EMXRHJNIYLC28AUBXSP8-16103?func=scan&scan_code=AUT&scan_start=cooper%2C+frederick scholar(3): searching for translators for http://mirlyn.lib.umich.edu/F/EYE18XPEN2JTMBJVM8QV8A9E37LEG9EMXRHJNIYLC28AUBXSP8-16103?func=scan&scan_code=AUT&scan_start=cooper%2C+frederick scholar(5): SELECT detectCode FROM translators WHERE translatorID = ? scholar(5): Binding parameter 1 of type string: "cf87eca8-041d-b954-795a-2d86348999d5" scholar(3): executed detectCode for Aleph scholar(3): executed detectCode for Embedded RDF scholar(3): executed detectCode for COinS scholar(3): binding sandbox to http://mirlyn.lib.umich.edu/F/EYE18XPEN2JTMBJVM8QV8A9E37LEG9EMXRHJNIYLC28AUBXSP8-05854?func=accref&acc_sequence=011859164 scholar(3): searching for translators for http://mirlyn.lib.umich.edu/F/EYE18XPEN2JTMBJVM8QV8A9E37LEG9EMXRHJNIYLC28AUBXSP8-05854?func=accref&acc_sequence=011859164 scholar(5): SELECT detectCode FROM translators WHERE translatorID = ? scholar(5): Binding parameter 1 of type string: "cf87eca8-041d-b954-795a-2d86348999d5" scholar(3): executed detectCode for Aleph scholar(3): executed detectCode for Embedded RDF scholar(3): executed detectCode for COinS scholar(3): binding sandbox to http://mirlyn.lib.umich.edu/F/EYE18XPEN2JTMBJVM8QV8A9E37LEG9EMXRHJNIYLC28AUBXSP8-16103?func=scan&scan_code=AUT&scan_start=cooper%2C+frederick scholar(3): searching for translators for http://mirlyn.lib.umich.edu/F/EYE18XPEN2JTMBJVM8QV8A9E37LEG9EMXRHJNIYLC28AUBXSP8-16103?func=scan&scan_code=AUT&scan_start=cooper%2C+frederick scholar(5): SELECT detectCode FROM translators WHERE translatorID = ? scholar(5): Binding parameter 1 of type string: "cf87eca8-041d-b954-795a-2d86348999d5" scholar(3): executed detectCode for Aleph scholar(3): executed detectCode for Embedded RDF scholar(3): executed detectCode for COinS scholar(3): binding sandbox to http://mirlyn.lib.umich.edu/F/EYE18XPEN2JTMBJVM8QV8A9E37LEG9EMXRHJNIYLC28AUBXSP8-17256?func=find-acc&acc_sequence=011859164 scholar(3): searching for translators for http://mirlyn.lib.umich.edu/F/EYE18XPEN2JTMBJVM8QV8A9E37LEG9EMXRHJNIYLC28AUBXSP8-17256?func=find-acc&acc_sequence=011859164 scholar(5): SELECT detectCode FROM translators WHERE translatorID = ? scholar(5): Binding parameter 1 of type string: "cf87eca8-041d-b954-795a-2d86348999d5" scholar(3): executed detectCode for Aleph scholar(3): found translator Aleph scholar(3): executed detectCode for Embedded RDF scholar(3): executed detectCode for COinS scholar(3): binding sandbox to http://mirlyn.lib.umich.edu/F/EYE18XPEN2JTMBJVM8QV8A9E37LEG9EMXRHJNIYLC28AUBXSP8-17306?func=full-set-set&set_number=016294&set_entry=000001&format=999 scholar(3): searching for translators for http://mirlyn.lib.umich.edu/F/EYE18XPEN2JTMBJVM8QV8A9E37LEG9EMXRHJNIYLC28AUBXSP8-17306?func=full-set-set&set_number=016294&set_entry=000001&format=999 scholar(5): SELECT detectCode FROM translators WHERE translatorID = ? scholar(5): Binding parameter 1 of type string: "cf87eca8-041d-b954-795a-2d86348999d5" scholar(3): executed detectCode for Aleph scholar(3): found translator Aleph scholar(3): executed detectCode for Embedded RDF scholar(3): executed detectCode for COinS scholar(5): SELECT * FROM translators WHERE translatorID = ? AND type IN (4,5,6,7,12,13,14,15) scholar(5): Binding parameter 1 of type string: "cf87eca8-041d-b954-795a-2d86348999d5" scholar(3): translate called scholar(3): binding sandbox to http://mirlyn.lib.umich.edu/F/EYE18XPEN2JTMBJVM8QV8A9E37LEG9EMXRHJNIYLC28AUBXSP8-17306?func=full-set-set&set_number=016294&set_entry=000001&format=999 scholar(3): parsing code for Aleph scholar(5): SELECT * FROM translators WHERE translatorID = ? AND type IN (1,3,5,7,9,11,13,15) scholar(5): Binding parameter 1 of type string: "a6ee60df-1ddc-4aae-bb25-45e0537be973" scholar(3): parsing code for MARC scholar(3): created hidden browser scholar(3): loading http://mirlyn.lib.umich.edu/F/EYE18XPEN2JTMBJVM8QV8A9E37LEG9EMXRHJNIYLC28AUBXSP8-17306?func=full-set-set&set_number=016294&set_entry=000001&format=001 scholar(3): http://mirlyn.lib.umich.edu/F/EYE18XPEN2JTMBJVM8QV8A9E37LEG9EMXRHJNIYLC28AUBXSP8-17306?func=full-set-set&set_number=016294&set_entry=000001&format=001 has been loaded scholar(4): found 0 matches for 020a scholar(4): found 0 matches for 022a scholar(4): found 0 matches for 100a scholar(4): found 0 matches for 110a scholar(4): found 0 matches for 111a scholar(4): found 0 matches for 700a scholar(4): found 0 matches for 710a scholar(4): found 0 matches for 711a scholar(4): found 0 matches for 245ab scholar(4): found 0 matches for 250a scholar(4): found 0 matches for 260a scholar(4): found 0 matches for 260b scholar(4): found 0 matches for 260c scholar(4): found 0 matches for 300a scholar(4): found 0 matches for 440a scholar(4): found 0 matches for 084ab scholar(4): found 0 matches for 082a scholar(4): found 0 matches for 080ab scholar(4): found 0 matches for 070ab scholar(4): found 0 matches for 060ab scholar(4): found 0 matches for 050ab scholar(3): done from parent sandbox scholar(3): running handler 0 for itemDone scholar(3): Disabling Notifier notifications scholar(3): item has no title in handler 0 for itemDone scholar(3): deleted hidden browser scholar(3): translation complete scholar(3): running handler 0 for done scholar(4): Unregistering itemTree in notifier with hash 'bT' scholar(5): SELECT itemID FROM collectionItems WHERE collectionID=7693 scholar(4): Registering itemTree in notifier with hash '6T' scholar(4): Unregistering itemTree in notifier with hash '6T' scholar(5): SELECT A.itemID FROM items A LEFT JOIN itemNotes B USING (itemID) LEFT JOIN itemAttachments C ON (C.itemID=A.itemID) WHERE B.sourceItemID IS NULL AND C.sourceItemID IS NULL scholar(4): Registering itemTree in notifier with hash 'fH' scholar(4): Unregistering itemTree in notifier with hash 'fH' scholar(5): SELECT itemID FROM collectionItems WHERE collectionID=7693 scholar(4): Registering itemTree in notifier with hash 'Pp' scholar(4): Unregistering itemTree in notifier with hash 'Pp' scholar(5): SELECT A.itemID FROM items A LEFT JOIN itemNotes B USING (itemID) LEFT JOIN itemAttachments C ON (C.itemID=A.itemID) WHERE B.sourceItemID IS NULL AND C.sourceItemID IS NULL scholar(4): Registering itemTree in notifier with hash 'Cp' scholar(3): binding sandbox to http://library.gmu.edu/ scholar(3): searching for translators for http://library.gmu.edu/ scholar(3): executed detectCode for Embedded RDF scholar(3): executed detectCode for COinS scholar(3): binding sandbox to http://library.gmu.edu/resources/catalogs.html scholar(3): searching for translators for http://library.gmu.edu/resources/catalogs.html scholar(3): executed detectCode for Embedded RDF scholar(3): executed detectCode for COinS scholar(3): binding sandbox to http://magik.gmu.edu/cgi-bin/Pwebrecon.cgi?DB=local&PAGE=First scholar(3): searching for translators for http://magik.gmu.edu/cgi-bin/Pwebrecon.cgi?DB=local&PAGE=First scholar(5): SELECT detectCode FROM translators WHERE translatorID = ? scholar(5): Binding parameter 1 of type string: "88915634-1af6-c134-0171-56fd198235ed" scholar(3): TypeError: doc.forms.namedItem("frm") has no properties in executing detectCode for LOC/Voyager WebVoyage scholar(3): executed detectCode for Embedded RDF scholar(3): executed detectCode for COinS scholar(3): binding sandbox to http://magik.gmu.edu/cgi-bin/Pwebrecon.cgi?Search_Arg=spence%2C+jonathan&SL=None&Search_Code=NAME_&PID=qD%3F%5BxU%3FJxAoIoTOHuD%3F%5Bp%40%3F%5Bt%3C%3C%3C&SEQ=20060829101223&CNT=15&HIST=1 scholar(3): searching for translators for http://magik.gmu.edu/cgi-bin/Pwebrecon.cgi?Search_Arg=spence%2C+jonathan&SL=None&Search_Code=NAME_&PID=qD%3F%5BxU%3FJxAoIoTOHuD%3F%5Bp%40%3F%5Bt%3C%3C%3C&SEQ=20060829101223&CNT=15&HIST=1 scholar(5): SELECT detectCode FROM translators WHERE translatorID = ? scholar(5): Binding parameter 1 of type string: "88915634-1af6-c134-0171-56fd198235ed" scholar(3): TypeError: doc.forms.namedItem("frm").elements.namedItem("RD") has no properties in executing detectCode for LOC/Voyager WebVoyage scholar(3): executed detectCode for Embedded RDF scholar(3): executed detectCode for COinS scholar(3): binding sandbox to http://magik.gmu.edu/cgi-bin/Pwebrecon.cgi?Search%5FArg=spence%2C%20jonathan&SL=None&Search%5FCode=NAME%5F&CNT=15&PID=qDOSYU?JYAoIoTOHuDOSp@OSt%3C%3C%3C&BROWSE=2&HC=21&SID=1 scholar(3): searching for translators for http://magik.gmu.edu/cgi-bin/Pwebrecon.cgi?Search%5FArg=spence%2C%20jonathan&SL=None&Search%5FCode=NAME%5F&CNT=15&PID=qDOSYU?JYAoIoTOHuDOSp@OSt%3C%3C%3C&BROWSE=2&HC=21&SID=1 scholar(5): SELECT detectCode FROM translators WHERE translatorID = ? scholar(5): Binding parameter 1 of type string: "88915634-1af6-c134-0171-56fd198235ed" scholar(3): executed detectCode for LOC/Voyager WebVoyage scholar(3): found translator LOC/Voyager WebVoyage scholar(3): executed detectCode for Embedded RDF scholar(3): executed detectCode for COinS scholar(3): binding sandbox to http://magik.gmu.edu/cgi-bin/Pwebrecon.cgi?v1=10&ti=1,10&Search%5FArg=spence%2C%20jonathan&SL=None&Search%5FCode=NAME%5F&CNT=15&PID=qDoD_T?J_@oIoTOHuDoDp@oDt%3C%3C%3C&SEQ=20060829101305&SID=1 scholar(3): searching for translators for http://magik.gmu.edu/cgi-bin/Pwebrecon.cgi?v1=10&ti=1,10&Search%5FArg=spence%2C%20jonathan&SL=None&Search%5FCode=NAME%5F&CNT=15&PID=qDoD_T?J_@oIoTOHuDoDp@oDt%3C%3C%3C&SEQ=20060829101305&SID=1 scholar(5): SELECT detectCode FROM translators WHERE translatorID = ? scholar(5): Binding parameter 1 of type string: "88915634-1af6-c134-0171-56fd198235ed" scholar(3): executed detectCode for LOC/Voyager WebVoyage scholar(3): found translator LOC/Voyager WebVoyage scholar(3): executed detectCode for Embedded RDF scholar(3): executed detectCode for COinS scholar(5): SELECT * FROM translators WHERE translatorID = ? AND type IN (4,5,6,7,12,13,14,15) scholar(5): Binding parameter 1 of type string: "88915634-1af6-c134-0171-56fd198235ed" scholar(3): translate called scholar(3): binding sandbox to http://magik.gmu.edu/cgi-bin/Pwebrecon.cgi?v1=10&ti=1,10&Search%5FArg=spence%2C%20jonathan&SL=None&Search%5FCode=NAME%5F&CNT=15&PID=qDoD_T?J_@oIoTOHuDoDp@oDt%3C%3C%3C&SEQ=20060829101305&SID=1 scholar(3): parsing code for LOC/Voyager WebVoyage scholar(3): HTTP GET http://magik.gmu.edu/cgi-bin/Pwebrecon.cgi?Search_Arg=spence%2C%20jonathan&Search_Code=NAME_&SL=None&PID=qDoRWU%3FJWAoIoTOHuDoRp@oRt%3C%3C%3C&CNT=15&HC=21&ti=1%2C10&SID=1&RID=219146&BIB=219146&PID=qDoRWU%3FJWAoIoTOHuDoRp@oRt%3C%3C%3C&SEQ=20060829101318&EMAILADDRESS=None&RD=5&MAILADDY=&SAVE=Press+to+SAVE+or+PRINT scholar(5): SELECT * FROM translators WHERE translatorID = ? AND type IN (1,3,5,7,9,11,13,15) scholar(5): Binding parameter 1 of type string: "a6ee60df-1ddc-4aae-bb25-45e0537be973" scholar(3): translate called scholar(3): parsing code for MARC scholar(4): found 0 matches for 020a scholar(4): found 0 matches for 022a scholar(4): found 1 matches for 100a scholar(4): found 0 matches for 110a scholar(4): found 0 matches for 111a scholar(4): found 0 matches for 700a scholar(4): found 0 matches for 710a scholar(4): found 0 matches for 711a scholar(4): found 1 matches for 245ab scholar(4): found 0 matches for 250a scholar(4): found 1 matches for 260a scholar(4): found 1 matches for 260b scholar(4): found 1 matches for 260c scholar(4): found 1 matches for 300a scholar(4): found 0 matches for 440a scholar(4): found 0 matches for 084ab scholar(4): found 0 matches for 082a scholar(4): found 0 matches for 080ab scholar(4): found 0 matches for 070ab scholar(4): found 0 matches for 060ab scholar(4): found 0 matches for 050ab scholar(3): done from parent sandbox scholar(3): running handler 0 for itemDone scholar(5): SELECT creatorTypeID AS id, creatorType AS name FROM creatorTypes order BY creatorType scholar(3): discarded field notes for item: field does not exist scholar(3): discarded field tags for item: field does not exist scholar(3): discarded field attachments for item: field does not exist scholar(5): SELECT * FROM fieldFormats scholar(5): SELECT * FROM fields scholar(5): SELECT fieldID, itemTypeID FROM itemTypeFields scholar(3): Saving data for new item to database scholar(5): SELECT COUNT(*) FROM items WHERE itemID=2169 scholar(5): Beginning DB transaction scholar(5): Transaction in progress -- increasing level to 1 scholar(5): SELECT MIN(transactionID) FROM transactions WHERE transactionSetID=1 scholar(5): DELETE FROM transactionLog WHERE transactionID>=1 scholar(5): DELETE FROM transactions WHERE transactionID>=1 scholar(5): DELETE FROM transactionSets WHERE transactionSetID>0 scholar(5): Decreasing transaction level to 0 scholar(3): Beginning history transaction set add-item scholar(5): Transaction in progress -- increasing level to 1 scholar(5): INSERT INTO transactionSets (event, id) VALUES ('add-item', 0) scholar(5): INSERT INTO items (itemID,itemTypeID,title) VALUES (?,?,?) scholar(5): Binding parameter 1 of type int: 2169 scholar(5): Binding parameter 2 of type int: 2 scholar(5): Binding parameter 3 of type string: "The Gate of Heavenly Peace : the Chinese and their revolution, 1895-1980" scholar(5): UPDATE transactionSets SET id=2169 WHERE transactionSetID=1 scholar(5): INSERT INTO transactions (transactionSetID, context, action) VALUES (1, 'items.itemID.2169', 'add') scholar(5): SELECT ID.fieldID, value FROM itemData ID JOIN itemTypeFields ITF ON (ITF.itemTypeID=(SELECT itemTypeID FROM items WHERE itemID=?1) AND ITF.fieldID=ID.fieldID) WHERE itemID=?1 ORDER BY orderIndex scholar(5): Binding parameter 1 of type int: 2169 scholar(5): INSERT INTO itemData VALUES (?,?,?) scholar(5): Binding parameter 1 of type int: 2169 scholar(5): Binding parameter 2 of type int: 7 scholar(5): Binding parameter 3 of type string: "New York" scholar(5): INSERT INTO transactions (transactionSetID, context, action) VALUES (1, 'itemData.itemID-fieldID.2169-7', 'add') scholar(5): INSERT INTO itemData VALUES (?,?,?) scholar(5): Binding parameter 1 of type int: 2169 scholar(5): Binding parameter 2 of type int: 8 scholar(5): Binding parameter 3 of type string: "Viking Press" scholar(5): INSERT INTO transactions (transactionSetID, context, action) VALUES (1, 'itemData.itemID-fieldID.2169-8', 'add') scholar(5): INSERT INTO itemData VALUES (?,?,?) scholar(5): Binding parameter 1 of type int: 2169 scholar(5): Binding parameter 2 of type int: 14 scholar(5): Binding parameter 3 of type string: "1981" scholar(5): INSERT INTO transactions (transactionSetID, context, action) VALUES (1, 'itemData.itemID-fieldID.2169-14', 'add') scholar(5): INSERT INTO itemData VALUES (?,?,?) scholar(5): Binding parameter 1 of type int: 2169 scholar(5): Binding parameter 2 of type int: 10 scholar(5): Binding parameter 3 of type string: "465" scholar(5): INSERT INTO transactions (transactionSetID, context, action) VALUES (1, 'itemData.itemID-fieldID.2169-10', 'add') scholar(5): SELECT C.creatorID, C.*, creatorTypeID, orderIndex FROM itemCreators IC LEFT JOIN creators C USING (creatorID) WHERE itemID=2169 ORDER BY orderIndex scholar(5): SELECT creatorID FROM creators WHERE firstName=? AND lastName=? AND isInstitution=? scholar(5): Binding parameter 1 of type string: "Jonathan D." scholar(5): Binding parameter 2 of type string: "Spence" scholar(5): Binding parameter 3 of type int: 0 scholar(4): Adding new creator scholar(5): Transaction in progress -- increasing level to 2 scholar(5): SELECT COUNT(*) FROM creators WHERE creatorID=4034 scholar(5): INSERT INTO creators VALUES (?,?,?,?) scholar(5): Binding parameter 1 of type int: 4034 scholar(5): Binding parameter 2 of type string: "Jonathan D." scholar(5): Binding parameter 3 of type string: "Spence" scholar(5): Binding parameter 4 of type int: 0 scholar(5): Decreasing transaction level to 1 scholar(5): INSERT INTO transactions (transactionSetID, context, action) VALUES (1, 'creators.creatorID.4034', 'add') scholar(5): INSERT INTO itemCreators VALUES (2169,4034,1, 0) scholar(5): INSERT INTO transactions (transactionSetID, context, action) VALUES (1, 'itemCreators.itemID-creatorID-creatorTypeID.2169-4034-1', 'add') scholar(3): Committing history transaction set add-item scholar(5): Decreasing transaction level to 0 scholar(5): Committing transaction scholar(5): SELECT collectionID, collectionName, parentCollectionID, (SELECT COUNT(*) FROM collections WHERE parentCollectionID=C.collectionID)!=0 AS hasChildCollections, (SELECT COUNT(*) FROM collectionItems WHERE collectionID=C.collectionID)!=0 AS hasChildItems FROM collections C scholar(5): SELECT itemID FROM collectionItems WHERE collectionID=7693 scholar(3): Reloading 2169 scholar(5): SELECT I.*, lastName || CASE ((SELECT COUNT(*) FROM itemCreators WHERE itemID=I.itemID)>1) WHEN 0 THEN '' ELSE ' et al.' END AS firstCreator, (SELECT COUNT(*) FROM itemNotes WHERE sourceItemID=I.itemID) AS numNotes, (SELECT COUNT(*) FROM itemAttachments WHERE sourceItemID=I.itemID) AS numAttachments FROM items I LEFT JOIN itemCreators IC ON (I.itemID=IC.itemID) LEFT JOIN creators C ON (IC.creatorID=C.creatorID) WHERE (IC.orderIndex=0 OR IC.orderIndex IS NULL) AND I.itemID IN (2169) scholar(5): Beginning DB transaction scholar(5): SELECT tagID FROM tags WHERE tag=? scholar(5): Binding parameter 1 of type string: "China" scholar(4): Adding new tag scholar(5): Transaction in progress -- increasing level to 1 scholar(5): SELECT COUNT(*) FROM tags WHERE tagID=14969 scholar(5): INSERT INTO tags VALUES (?,?) scholar(5): Binding parameter 1 of type int: 14969 scholar(5): Binding parameter 2 of type string: "China" scholar(5): Decreasing transaction level to 0 scholar(5): INSERT OR IGNORE INTO itemTags VALUES (?,?) scholar(5): Binding parameter 1 of type int: 2169 scholar(5): Binding parameter 2 of type int: 14969 scholar(5): Committing transaction scholar(5): Beginning DB transaction scholar(5): SELECT tagID FROM tags WHERE tag=? scholar(5): Binding parameter 1 of type string: "History" scholar(5): INSERT OR IGNORE INTO itemTags VALUES (?,?) scholar(5): Binding parameter 1 of type int: 2169 scholar(5): Binding parameter 2 of type int: 11223 scholar(5): Committing transaction scholar(5): Beginning DB transaction scholar(5): SELECT tagID FROM tags WHERE tag=? scholar(5): Binding parameter 1 of type string: "20th century" scholar(4): Adding new tag scholar(5): Transaction in progress -- increasing level to 1 scholar(5): SELECT COUNT(*) FROM tags WHERE tagID=10712 scholar(5): INSERT INTO tags VALUES (?,?) scholar(5): Binding parameter 1 of type int: 10712 scholar(5): Binding parameter 2 of type string: "20th century" scholar(5): Decreasing transaction level to 0 scholar(5): INSERT OR IGNORE INTO itemTags VALUES (?,?) scholar(5): Binding parameter 1 of type int: 2169 scholar(5): Binding parameter 2 of type int: 10712 scholar(5): Committing transaction scholar(5): Beginning DB transaction scholar(5): SELECT tagID FROM tags WHERE tag=? scholar(5): Binding parameter 1 of type string: "China" scholar(5): INSERT OR IGNORE INTO itemTags VALUES (?,?) scholar(5): Binding parameter 1 of type int: 2169 scholar(5): Binding parameter 2 of type int: 14969 scholar(5): Committing transaction scholar(5): Beginning DB transaction scholar(5): INSERT OR IGNORE INTO itemTags VALUES (?,?) scholar(5): Binding parameter 1 of type int: 2169 scholar(5): Binding parameter 2 of type int: 11223 scholar(5): Committing transaction scholar(5): Beginning DB transaction scholar(5): SELECT tagID FROM tags WHERE tag=? scholar(5): Binding parameter 1 of type string: "1861-1912" scholar(4): Adding new tag scholar(5): Transaction in progress -- increasing level to 1 scholar(5): SELECT COUNT(*) FROM tags WHERE tagID=7228 scholar(5): INSERT INTO tags VALUES (?,?) scholar(5): Binding parameter 1 of type int: 7228 scholar(5): Binding parameter 2 of type string: "1861-1912" scholar(5): Decreasing transaction level to 0 scholar(5): INSERT OR IGNORE INTO itemTags VALUES (?,?) scholar(5): Binding parameter 1 of type int: 2169 scholar(5): Binding parameter 2 of type int: 7228 scholar(5): Committing transaction scholar(3): running handler 0 for itemDone scholar(3): translation complete scholar(3): translation complete scholar(3): running handler 0 for done scholar(4): Unregistering itemTree in notifier with hash 'Cp' scholar(5): SELECT itemID FROM collectionItems WHERE collectionID=7693 scholar(4): Registering itemTree in notifier with hash 'km' scholar(4): Unregistering itemTree in notifier with hash 'km' scholar(5): SELECT A.itemID FROM items A LEFT JOIN itemNotes B USING (itemID) LEFT JOIN itemAttachments C ON (C.itemID=A.itemID) WHERE B.sourceItemID IS NULL AND C.sourceItemID IS NULL scholar(4): Registering itemTree in notifier with hash 'Jc'