Ticket #232: scholar-refresh.txt

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'