Skip to content

Instantly share code, notes, and snippets.

@mronkko

mronkko/gist:3051704

Created July 5, 2012 06:11
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 mronkko/3051704 to your computer and use it in GitHub Desktop.
Save mronkko/3051704 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
gistfile1.txt
--- Local copy of the file right after adding the item to Zotero Standalone ---
3080-la0003% ls -l /Users/mronkko/Dropbox/Apps/ZotPad-beta/IS57WTDX
total 352
-rw-r--r-- 1 mronkko 70000 178035 5 Hei 08:51 Perren and Ram - 2004 - Case-Study Method in Small Business and Entreprene.pdf
t3080-la0003% md5 /Users/mronkko/Dropbox/Apps/ZotPad-beta/IS57WTDX/Perren\ and\ Ram\ -\ 2004\ -\ Case-Study\ Method\ in\ Small\ Business\ and\ Entreprene.pdf
MD5 (/Users/mronkko/Dropbox/Apps/ZotPad-beta/IS57WTDX/Perren and Ram - 2004 - Case-Study Method in Small Business and Entreprene.pdf) = 207848f21db15ad741b7a3de25c8ff3c
--- Content of WebDAV folder after syncing Zotero Standalone ---
t3080-la0003% ls -l
total 282
-rwx------ 1 mronkko 70000 117 5 Hei 08:51 IS57WTDX.prop
-rwx------ 1 mronkko 70000 142936 5 Hei 08:51 IS57WTDX.zip
-rwx------ 1 mronkko 70000 1 5 Hei 08:51 lastsync
t3080-la0003% cat IS57WTDX.prop
<properties version="1">
<mtime>1341467479000</mtime>
<hash>207848f21db15ad741b7a3de25c8ff3c</hash>
</properties>%
t3080-la0003% unzip -l IS57WTDX.zip
Archive: IS57WTDX.zip
Length Date Time Name
-------- ---- ---- ----
178035 07-05-12 08:51 UGVycmVuIGFuZCBSYW0gLSAyMDA0IC0gQ2FzZS1TdHVkeSBNZXRob2QgaW4gU21hbGwgQnVzaW5lc3MgYW5kIEVudHJlcHJlbmUucGRm%ZB64
-------- -------
178035 1 file
--- Content of WebDAV folder after uploading a new version of the file using ZotPad ---
t3080-la0003% ls -l
total 523
-rwx------ 1 mronkko 70000 117 5 Hei 08:54 IS57WTDX.prop
-rwx------ 1 mronkko 70000 266584 5 Hei 08:54 IS57WTDX.zip
-rwx------ 1 mronkko 70000 1 5 Hei 08:54 lastsync
t3080-la0003% cat IS57WTDX.prop
<properties version="1">
<mtime>1341467669000</mtime>
<hash>81ff8318f15257e09137a228d12f67ee</hash>
</properties>%
t3080-la0003% unzip -l IS57WTDX.zip
Archive: IS57WTDX.zip
Length Date Time Name
-------- ---- ---- ----
283253 07-05-12 08:54 UGVycmVuIGFuZCBSYW0gLSAyMDA0IC0gQ2FzZS1TdHVkeSBNZXRob2QgaW4gU21hbGwgQnVzaW5lc3MgYW5kIEVudHJlcHJlbmUucGRm%ZB64
-------- -------
283253 1 file
---- Checking the MD5 of the compressed file on WebDAV ----
t3080-la0003% unzip IS57WTDX.zip
Archive: IS57WTDX.zip
inflating: UGVycmVuIGFuZCBSYW0gLSAyMDA0IC0gQ2FzZS1TdHVkeSBNZXRob2QgaW4gU21hbGwgQnVzaW5lc3MgYW5kIEVudHJlcHJlbmUucGRm%ZB64
t3080-la0003% md5 UGVycmVuIGFuZCBSYW0gLSAyMDA0IC0gQ2FzZS1TdHVkeSBNZXRob2QgaW4gU21hbGwgQnVzaW5lc3MgYW5kIEVudHJlcHJlbmUucGRm%ZB64
MD5 (UGVycmVuIGFuZCBSYW0gLSAyMDA0IC0gQ2FzZS1TdHVkeSBNZXRob2QgaW4gU21hbGwgQnVzaW5lc3MgYW5kIEVudHJlcHJlbmUucGRm%ZB64) = 81ff8318f15257e09137a228d12f67ee
t3080-la0003%
--- Local copy of the file right after syncing Zotero Standalone ---
t3080-la0003% ls -l /Users/mronkko/Dropbox/Apps/ZotPad-beta/IS57WTDX
total 352
-rw-r--r--@ 1 mronkko 70000 178035 5 Hei 08:54 Perren and Ram - 2004 - Case-Study Method in Small Business and Entreprene.pdf
t3080-la0003% md5 /Users/mronkko/Dropbox/Apps/ZotPad-beta/IS57WTDX/Perren\ and\ Ram\ -\ 2004\ -\ Case-Study\ Method\ in\ Small\ Business\ and\ Entreprene.pdf
MD5 (/Users/mronkko/Dropbox/Apps/ZotPad-beta/IS57WTDX/Perren and Ram - 2004 - Case-Study Method in Small Business and Entreprene.pdf) = 207848f21db15ad741b7a3de25c8ff3c
---- Content of debug id D1756702704 -----
[JavaScript Error: "no element found" {file: "http://mronkko:********@webdav.cloudme.com/mronkko/xios/zotero/" line: 1}]
[JavaScript Error: "no element found" {file: "http://mronkko:********@webdav.cloudme.com/mronkko/xios/zotero/" line: 1}]
[JavaScript Error: "no element found" {file: "http://mronkko:********@webdav.cloudme.com/mronkko/xios/zotero/" line: 1}]
[JavaScript Error: "no element found" {file: "http://mronkko:********@webdav.cloudme.com/mronkko/xios/zotero/" line: 1}]
[JavaScript Error: "no element found" {file: "http://mronkko:********@webdav.cloudme.com/mronkko/xios/zotero/" line: 1}]
[JavaScript Error: "no element found" {file: "http://mronkko:********@webdav.cloudme.com/mronkko/xios/zotero/" line: 1}]
[JavaScript Error: "no element found" {file: "http://mronkko:********@webdav.cloudme.com/mronkko/xios/zotero/" line: 1}]
[JavaScript Error: "no element found" {file: "http://mronkko:********@webdav.cloudme.com/mronkko/xios/zotero/" line: 1}]
[JavaScript Error: "no element found" {file: "http://mronkko:********@webdav.cloudme.com/mronkko/xios/zotero/" line: 1}]
[JavaScript Error: "no element found" {file: "http://mronkko:********@webdav.cloudme.com/mronkko/xios/zotero/" line: 1}]
[JavaScript Error: "no element found" {file: "http://mronkko:********@webdav.cloudme.com/mronkko/xios/zotero/" line: 1}]
[JavaScript Error: "no element found" {file: "http://mronkko:********@webdav.cloudme.com/mronkko/xios/zotero/" line: 1}]
[JavaScript Error: "no element found" {file: "http://mronkko:********@webdav.cloudme.com/mronkko/xios/zotero/" line: 1}]
[JavaScript Error: "no element found" {file: "http://mronkko:********@webdav.cloudme.com/mronkko/xios/zotero/" line: 1}]
[JavaScript Error: "no element found" {file: "http://mronkko:********@webdav.cloudme.com/mronkko/xios/zotero/" line: 1}]
[JavaScript Error: "no element found" {file: "http://mronkko:********@webdav.cloudme.com/mronkko/xios/zotero/" line: 1}]
[JavaScript Error: "no element found" {file: "http://mronkko:********@webdav.cloudme.com/mronkko/xios/zotero/" line: 1}]
[JavaScript Error: "no element found" {file: "http://mronkko:********@webdav.cloudme.com/mronkko/xios/zotero/" line: 1}]
[JavaScript Error: "no element found" {file: "http://mronkko:********@webdav.cloudme.com/mronkko/xios/zotero/" line: 1}]
[JavaScript Error: "no element found" {file: "http://mronkko:********@webdav.cloudme.com/mronkko/xios/zotero/" line: 1}]
[JavaScript Error: "no element found" {file: "http://mronkko:********@webdav.cloudme.com/mronkko/xios/zotero/" line: 1}]
[JavaScript Error: "no element found" {file: "http://mronkko:********@webdav.cloudme.com/mronkko/xios/zotero/" line: 1}]
[JavaScript Error: "no element found" {file: "http://mronkko:********@webdav.cloudme.com/mronkko/xios/zotero/" line: 1}]
[JavaScript Error: "no element found" {file: "http://mronkko:********@webdav.cloudme.com/mronkko/xios/zotero/" line: 1}]
[JavaScript Error: "no element found" {file: "http://mronkko:********@webdav.cloudme.com/mronkko/xios/zotero/" line: 1}]
version => 3.0.7, platform => MacIntel, oscpu => Intel Mac OS X 10.7, locale => en-US, appName => Zotero, appVersion => 3.0.7
=========================================================
(5)(+0639186): SELECT subject FROM relations WHERE predicate != ? UNION SELECT object FROM relations WHERE predicate != ?
(5)(+0000000): Binding parameter 1 of type string: "dc:isReplacedBy"
(5)(+0000000): Binding parameter 2 of type string: "dc:isReplacedBy"
(5)(+0000006): Beginning DB transaction
(3)(+0000000): Beginning Notifier event queue
(5)(+0000001): Committing transaction
(3)(+0000000): Resetting Notifier event queue
(3)(+0000001): Beginning server sync
(5)(+0000000): SELECT version FROM version WHERE schema='lastremotesync'
(5)(+0000000): SELECT version FROM version WHERE schema='lastlocalsync'
(3)(+0000000): HTTP POST version=9&sessionid=********&lastsync=1341467572 to https://sync.zotero.org/updated
(5)(+0000318): SELECT version FROM version WHERE schema='lastlocalsync'
(3)(+0000957): <?xml version="1.0"?>
<response version="9" timestamp="1341467697" userID="701495" defaultLibraryID="580787" updateKey="ba8616e979a326ec62531ffe49af6401" earliest="1314727213"><updated><items><item key="IS57WTDX" itemType="attachment" dateAdded="2012-07-05 05:51:19" dateModified="2012-07-05 05:54:32" sourceItem="R4DPHGBI" linkMode="1" mimeType="application/pdf" storageModTime="1341467669000" storageHash="81ff8318f15257e09137a228d12f67ee"><field name="url">http://isb.sagepub.com/cgi/reprint/22/1/83.pdf</field><field name="accessDate">2010-01-21 05:18:08</field><field name="title">Sage Journals Full Text PDF</field><path>storage:Perren and Ram - 2004 - Case-Study Method in Small Business and Entreprene.pdf</path></item></items></updated></response>
(5)(+0000000): Beginning DB transaction
(3)(+0000000): Beginning Notifier event queue
(5)(+0000000): SELECT value FROM settings WHERE setting='account' AND key='username'
(5)(+0000001): SELECT value FROM settings WHERE setting='account' AND key='userID'
(5)(+0000000): SELECT value FROM settings WHERE setting='account' AND key='libraryID'
(5)(+0000000): Committing transaction
(3)(+0000000): Resetting Notifier event queue
(5)(+0000000): Beginning DB transaction
(3)(+0000000): Beginning Notifier event queue
(3)(+0000000): Getting updated local creators
(5)(+0000000): SELECT ROWID FROM creators WHERE dateModified<?
(5)(+0000000): Binding parameter 1 of type string: "0000-00-00 00:00:00"
(5)(+0000001): SELECT ROWID FROM creators WHERE clientDateModified>?
(5)(+0000000): Binding parameter 1 of type string: "2012-07-05 05:52:52"
(3)(+0000001): Getting updated local items
(5)(+0000000): SELECT ROWID FROM items WHERE dateModified<?
(5)(+0000000): Binding parameter 1 of type string: "0000-00-00 00:00:00"
(5)(+0000001): SELECT ROWID FROM items WHERE clientDateModified>?
(5)(+0000000): Binding parameter 1 of type string: "2012-07-05 05:52:52"
(3)(+0000000): Getting updated local collections
(5)(+0000000): SELECT ROWID FROM collections WHERE dateModified<?
(5)(+0000000): Binding parameter 1 of type string: "0000-00-00 00:00:00"
(5)(+0000000): SELECT ROWID FROM collections WHERE clientDateModified>?
(5)(+0000000): Binding parameter 1 of type string: "2012-07-05 05:52:52"
(3)(+0000000): Getting updated local searches
(5)(+0000000): SELECT ROWID FROM savedSearches WHERE dateModified<?
(5)(+0000000): Binding parameter 1 of type string: "0000-00-00 00:00:00"
(5)(+0000000): SELECT ROWID FROM savedSearches WHERE clientDateModified>?
(5)(+0000000): Binding parameter 1 of type string: "2012-07-05 05:52:52"
(3)(+0000000): Getting updated local tags
(5)(+0000001): SELECT ROWID FROM tags WHERE dateModified<?
(5)(+0000000): Binding parameter 1 of type string: "0000-00-00 00:00:00"
(5)(+0000000): SELECT ROWID FROM tags WHERE clientDateModified>?
(5)(+0000000): Binding parameter 1 of type string: "2012-07-05 05:52:52"
(3)(+0000000): Getting updated local relations
(5)(+0000000): SELECT ROWID FROM relations WHERE clientDateModified<?
(5)(+0000000): Binding parameter 1 of type string: "0000-00-00 00:00:00"
(5)(+0000000): SELECT ROWID FROM relations WHERE clientDateModified>?
(5)(+0000000): Binding parameter 1 of type string: "2012-07-05 05:52:52"
(5)(+0000000): SELECT version FROM version WHERE schema='syncdeletelog'
(5)(+0000001): SELECT syncObjectTypeID, libraryID, key FROM syncDeleteLog WHERE timestamp>? ORDER BY timestamp
(5)(+0000000): Binding parameter 1 of type int: 1341467572
(3)(+0000001): Processing remotely changed creators
(3)(+0000000): Saving merged creators
(3)(+0000000): Deleting merged creators
(3)(+0000000): Processing remotely changed items
(4)(+0000000): Processing remote item null/IS57WTDX
(5)(+0000000): SELECT ROWID FROM items WHERE libraryID IS NULL AND key=?
(5)(+0000000): Binding parameter 1 of type string: "IS57WTDX"
(4)(+0000000): Matching local item exists
(4)(+0000001): Local item has not changed
(4)(+0000000): Field 'dateAdded' has not changed
(4)(+0000000): Field 'dateModified' has changed from '2012-07-05 05:51:19' to '2012-07-05 05:54:32'
(5)(+0000000): SELECT COUNT(*) FROM items WHERE itemID=?
(5)(+0000000): Binding parameter 1 of type int: 4
(5)(+0000000): SELECT charsetID FROM itemAttachments WHERE itemID=?
(5)(+0000000): Binding parameter 1 of type int: 4
(1)(+0000000): Invalid character set null
(5)(+0000000): SELECT tagID, name FROM tags WHERE tagID IN (SELECT tagID FROM itemTags WHERE itemID=?)
(5)(+0000000): Binding parameter 1 of type int: 4
(5)(+0000001): SELECT itemID FROM itemSeeAlso WHERE linkedItemID=?
(5)(+0000000): Binding parameter 1 of type int: 4
(4)(+0000000): Field 'itemTypeID' has not changed
(5)(+0000000): SELECT fieldName FROM fields WHERE fieldID IN (SELECT fieldID FROM itemData WHERE itemID=?)
(5)(+0000000): Binding parameter 1 of type int: 4
(3)(+0000000): Deleted state hasn't changed for item 4
(5)(+0000000): SELECT creatorID, creatorTypeID, orderIndex FROM itemCreators WHERE itemID=? ORDER BY orderIndex
(5)(+0000000): Binding parameter 1 of type int: 4
(3)(+0000000): Source item has not changed in Zotero.Item.setSourceKey()
(3)(+0000001): Note has not changed in Zotero.Item.setNote()
(1)(+0000000): Invalid character set
(4)(+0000000): No related items added
(3)(+0000000): Saving merged items
(5)(+0000000): Transaction in progress -- increasing level to 1
(5)(+0000000): SELECT COUNT(*) FROM items WHERE itemID=?
(5)(+0000000): Binding parameter 1 of type int: 4
(4)(+0000000): Updating database with new item data
(5)(+0000000): UPDATE items SET dateModified=?, clientDateModified=? WHERE itemID=?
(5)(+0000000): Binding parameter 1 of type string: "2012-07-05 05:54:32"
(5)(+0000000): Binding parameter 2 of type string: "2012-07-05 05:54:57"
(5)(+0000000): Binding parameter 3 of type int: 4
(3)(+0000000): Notifier.trigger('modify', 'item', [4]) queued
(3)(+0000001): Reloading items 4
(5)(+0000000): 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 FROM items I WHERE 1 AND I.itemID IN (4)
(5)(+0000001): Decreasing transaction level to 0
(3)(+0000000): Deleting merged items
(5)(+0000000): SELECT ROWID FROM items WHERE libraryID IS NULL AND key=?
(5)(+0000000): Binding parameter 1 of type string: "IS57WTDX"
(3)(+0000000): Checking for locally changed attachment files
(5)(+0000000): Transaction in progress -- increasing level to 1
(5)(+0000000): SELECT itemID, linkMode, path, storageModTime, storageHash, syncState FROM itemAttachments JOIN items USING (itemID) WHERE linkMode IN (?,?) AND syncState IN (?,?) AND itemID IN (?)
(5)(+0000000): Binding parameter 1 of type int: 0
(5)(+0000000): Binding parameter 2 of type int: 1
(5)(+0000000): Binding parameter 3 of type int: 0
(5)(+0000000): Binding parameter 4 of type int: 2
(5)(+0000000): Binding parameter 5 of type int: 4
(5)(+0000001): SELECT linkMode FROM itemAttachments WHERE itemID=?
(5)(+0000000): Binding parameter 1 of type int: 4
(5)(+0000000): SELECT path FROM itemAttachments WHERE itemID=?
(5)(+0000000): Binding parameter 1 of type int: 4
(3)(+0000000): Item mod time is 1341467669000
(3)(+0000000): Marking attachment 4 for download
(5)(+0000000): UPDATE itemAttachments SET syncState=? WHERE itemID=?
(5)(+0000000): Binding parameter 1 of type int: 1
(5)(+0000000): Binding parameter 2 of type string: "4"
(5)(+0000000): Decreasing transaction level to 0
(3)(+0000000): Processing remotely changed collections
(3)(+0000000): Saving merged collections
(3)(+0000001): Deleting merged collections
(3)(+0000000): Processing remotely changed searches
(3)(+0000000): Saving merged searches
(3)(+0000000): Deleting merged searches
(3)(+0000000): Processing remotely changed tags
(3)(+0000000): Saving merged tags
(3)(+0000000): Deleting merged tags
(3)(+0000000): Processing remotely changed relations
(3)(+0000000): Saving merged relations
(3)(+0000000): Deleting merged relations
(3)(+0000000): Processing locally changed creators
(3)(+0000000): Processing locally changed items
(3)(+0000000): Processing locally changed collections
(3)(+0000000): Processing locally changed searches
(3)(+0000000): Processing locally changed tags
(3)(+0000000): Processing locally changed relations
(5)(+0000000): SELECT value FROM settings WHERE setting='account' AND key='libraryID'
(3)(+0000000): Processing locally deleted creators
(3)(+0000000): Processing locally deleted items
(3)(+0000000): Processing locally deleted collections
(3)(+0000000): Processing locally deleted searches
(3)(+0000000): Processing locally deleted tags
(3)(+0000000): Processing locally deleted relations
(3)(+0000001): Nothing to upload to server
(5)(+0000000): REPLACE INTO version VALUES ('lastremotesync', ?)
(5)(+0000000): Binding parameter 1 of type string: "1341467697"
(5)(+0000000): REPLACE INTO version VALUES ('lastlocalsync', ?)
(5)(+0000000): Binding parameter 1 of type int: 1341467697
(5)(+0000000): Committing transaction
(3)(+0000003): Resetting Notifier event queue
(3)(+0000000): Committing Notifier event queue [modify-item: 1]
(3)(+0000000): Notifier.trigger('modify', 'item', [4]) called [observers: 4]
(4)(+0000000): Calling notify('modify') on observer with hash 'Gl'
(5)(+0000000): Beginning DB transaction
(3)(+0000000): Beginning Notifier event queue
(5)(+0000000): Committing transaction
(3)(+0000000): Resetting Notifier event queue
(4)(+0000000): Calling notify('modify') on observer with hash 'Uz'
(4)(+0000000): Calling notify('modify') on observer with hash 'aq'
(4)(+0000000): Calling notify('modify') on observer with hash '43'
(5)(+0000000): SELECT sourceItemID FROM itemAttachments WHERE itemID=?
(5)(+0000000): Binding parameter 1 of type int: 4
(3)(+0000001): Refreshing hash map
(5)(+0000000): SELECT A.itemID, value AS title FROM itemAttachments A NATURAL JOIN items I LEFT JOIN itemData ID ON (fieldID=110 AND A.itemID=ID.itemID) LEFT JOIN itemDataValues IDV ON (ID.valueID=IDV.valueID) WHERE sourceItemID=? AND A.itemID NOT IN (SELECT itemID FROM deletedItems)
(5)(+0000000): Binding parameter 1 of type int: 3
(5)(+0000000): SELECT N.itemID, title FROM itemNotes N NATURAL JOIN items WHERE sourceItemID=? AND N.itemID NOT IN (SELECT itemID FROM deletedItems)
(5)(+0000000): Binding parameter 1 of type int: 3
(3)(+0000001): Refreshing hash map
(3)(+0000000): Setting mode to 'edit'
(3)(+0000000): Refreshing attachment box
(5)(+0000001): SELECT fieldID, value FROM itemData NATURAL JOIN itemDataValues WHERE itemID=?
(5)(+0000000): Binding parameter 1 of type int: 4
(5)(+0000001): SELECT indexedPages, totalPages AS total FROM fulltextItems WHERE itemID=?
(5)(+0000000): Binding parameter 1 of type int: 4
(5)(+0000001): SELECT mimeType FROM itemAttachments WHERE itemID=?
(5)(+0000000): Binding parameter 1 of type int: 4
(5)(+0000000): SELECT indexedPages, totalPages AS total FROM fulltextItems WHERE itemID=?
(5)(+0000000): Binding parameter 1 of type int: 4
(5)(+0000000): SELECT indexedPages, totalPages AS total FROM fulltextItems WHERE itemID=?
(5)(+0000000): Binding parameter 1 of type int: 4
(3)(+0000000): setting links on top
(5)(+0000001): SELECT ROWID FROM items WHERE libraryID IS NULL AND key=?
(5)(+0000000): Binding parameter 1 of type string: "R4DPHGBI"
(3)(+0000000): Reloading tags
(5)(+0000000): SELECT tagID, name FROM tags WHERE tagID IN (SELECT tagID FROM itemTags WHERE itemID=?)
(5)(+0000000): Binding parameter 1 of type int: 4
(5)(+0000000): SELECT tagID, name FROM tags WHERE tagID IN (SELECT tagID FROM itemTags WHERE itemID=?)
(5)(+0000000): Binding parameter 1 of type int: 4
(5)(+0000001): SELECT linkedItemID FROM itemSeeAlso WHERE itemID=?
(5)(+0000000): Binding parameter 1 of type int: 4
(5)(+0000000): SELECT itemID FROM itemSeeAlso WHERE linkedItemID=?
(5)(+0000000): Binding parameter 1 of type int: 4
(5)(+0000000): SELECT itemID FROM itemSeeAlso WHERE linkedItemID=?
(5)(+0000000): Binding parameter 1 of type int: 4
(3)(+0000000): Refreshing note editor
(5)(+0000000): SELECT note FROM itemNotes WHERE itemID=?
(5)(+0000000): Binding parameter 1 of type int: 4
(3)(+0000005): Textbox value hasn't changed
(3)(+0000001): Getting WebDAV password
(3)(+0000003): Beginning WebDAV file sync
(3)(+0000000): Checking for locally changed attachment files
(5)(+0000000): Beginning DB transaction
(3)(+0000000): Beginning Notifier event queue
(5)(+0000000): SELECT itemID, linkMode, path, storageModTime, storageHash, syncState FROM itemAttachments JOIN items USING (itemID) WHERE linkMode IN (?,?) AND syncState IN (?,?) AND libraryID IS NULL
(5)(+0000000): Binding parameter 1 of type int: 0
(5)(+0000000): Binding parameter 2 of type int: 1
(5)(+0000000): Binding parameter 3 of type int: 0
(5)(+0000000): Binding parameter 4 of type int: 2
(3)(+0000001): No synced files have changed locally
(5)(+0000000): Committing transaction
(3)(+0000000): Resetting Notifier event queue
(3)(+0000000): HTTP OPTIONS for http://mronkko:********@webdav.cloudme.com/mronkko/xios/zotero/
(3)(+0000031): HTTP GET http://mronkko:********@webdav.cloudme.com/mronkko/xios/zotero/lastsync
(3)(+0000022): 1
(3)(+0000000): ===>200<===(number)
(3)(+0000000): Last successful storage sync was Thu Jul 05 2012 08:54:31 GMT+0300 (EEST)
(5)(+0000000): SELECT COUNT(*) FROM itemAttachments WHERE syncState=?
(5)(+0000000): Binding parameter 1 of type int: 4
(5)(+0000000): SELECT version FROM version WHERE schema='storage_webdav'
(5)(+0000001): SELECT itemID FROM itemAttachments JOIN items USING (itemID) WHERE syncState IN (?,?) AND path!='' AND libraryID IS NULL
(5)(+0000000): Binding parameter 1 of type int: 1
(5)(+0000000): Binding parameter 2 of type int: 4
(3)(+0000000): Resetting download queue
(3)(+0000000): Finished requests: 0
(3)(+0000000): Total requests: 1
(5)(+0000000): SELECT syncState FROM itemAttachments WHERE itemID=?
(5)(+0000000): Binding parameter 1 of type int: 4
(5)(+0000000): SELECT storageModTime FROM itemAttachments WHERE itemID=?
(5)(+0000000): Binding parameter 1 of type int: 4
(3)(+0000001): Initializing request 'null/IS57WTDX'
(3)(+0000000): Queuing download request 'null/IS57WTDX'
(3)(+0000000): Starting download request 'null/IS57WTDX'
(5)(+0000000): SELECT ROWID FROM items WHERE libraryID IS NULL AND key=?
(5)(+0000000): Binding parameter 1 of type string: "IS57WTDX"
(3)(+0000000): HTTP GET http://mronkko:********@webdav.cloudme.com/mronkko/xios/zotero/IS57WTDX.prop
(5)(+0000001): SELECT itemID FROM itemAttachments JOIN items USING (itemID) WHERE syncState IN (?,?) AND linkMode IN (?,?) AND libraryID IS NULL
(5)(+0000000): Binding parameter 1 of type int: 0
(5)(+0000000): Binding parameter 2 of type int: 3
(5)(+0000000): Binding parameter 3 of type int: 0
(5)(+0000000): Binding parameter 4 of type int: 1
(3)(+0000000): No files to upload
(3)(+0000022): <properties version="1">
<mtime>1341467669000</mtime>
<hash>81ff8318f15257e09137a228d12f67ee</hash>
</properties>
(3)(+0000000): ===>2<===(number)
(3)(+0000001): Saving http://mronkko:********@webdav.cloudme.com/mronkko/xios/zotero/IS57WTDX.zip with saveURI()
(3)(+0000021): onStateChange
(2)(+0000000): progressMax has changed from 0 to 266584 for request 'null/IS57WTDX'
(3)(+0000199): onStateChange
(3)(+0000000): Finished download of /Users/mronkko/Library/Application Support/Zotero/Profiles/nwan9wfd.mronkko2/zotero/tmp/IS57WTDX.zip.tmp
(3)(+0000010): ZIP file is OK
(2)(+0000001): Not deleting symlink 'Perren and Ram - 2004 - Case-Study Method in Small Business and Entreprene.pdf'
(3)(+0000000): Extracting Perren and Ram - 2004 - Case-Study Method in Small Business and Entreprene.pdf
(2)(+0000000): ZIP entry 'Perren and Ram - 2004 - Case-Study Method in Small Business and Entreprene.pdf' already exists
(5)(+0000001): Beginning DB transaction
(3)(+0000000): Beginning Notifier event queue
(5)(+0000000): SELECT syncState FROM itemAttachments WHERE itemID=?
(5)(+0000000): Binding parameter 1 of type int: 4
(5)(+0000001): Transaction in progress -- increasing level to 1
(5)(+0000000): UPDATE itemAttachments SET storageHash=? WHERE itemID=?
(5)(+0000000): Binding parameter 1 of type string: "207848f21db15ad741b7a3de25c8ff3c"
(5)(+0000000): Binding parameter 2 of type int: 4
(5)(+0000001): Decreasing transaction level to 0
(5)(+0000000): UPDATE itemAttachments SET syncState=? WHERE itemID=?
(5)(+0000000): Binding parameter 1 of type int: 2
(5)(+0000000): Binding parameter 2 of type int: 4
(5)(+0000000): Transaction in progress -- increasing level to 1
(5)(+0000000): UPDATE itemAttachments SET storageModTime=? WHERE itemID=?
(5)(+0000000): Binding parameter 1 of type int64: 1341467669000
(5)(+0000000): Binding parameter 2 of type int: 4
(5)(+0000000): Decreasing transaction level to 0
(5)(+0000000): Committing transaction
(3)(+0000002): Resetting Notifier event queue
(3)(+0000000): Finishing download request 'null/IS57WTDX'
(3)(+0000000): Finished requests: 1
(3)(+0000000): Total requests: 1
(3)(+0000000): Download queue is done
(3)(+0000000): Active requests: 0
(3)(+0000000): Errors:
(3)(+0000000):
(3)(+0000001): HTTP PUT '1' to http://mronkko:********@webdav.cloudme.com/mronkko/xios/zotero/lastsync
(3)(+0000066):
(3)(+0000000): ===>204<===(number)
(3)(+0000000): HTTP GET http://mronkko:********@webdav.cloudme.com/mronkko/xios/zotero/lastsync
(3)(+0000024): 1
(3)(+0000000): ===>200<===(number)
(3)(+0000000): Last successful storage sync was Thu Jul 05 2012 08:54:57 GMT+0300 (EEST)
(5)(+0000000): REPLACE INTO version VALUES ('storage_webdav', ?)
(5)(+0000000): Binding parameter 1 of type int: 1341467697
(3)(+0000003): WebDAV sync is complete
(5)(+0000000): SELECT value FROM settings WHERE setting='account' AND key='userID'
(3)(+0000000): Beginning ZFS file sync
(3)(+0000000): Checking for locally changed attachment files
(5)(+0000000): Beginning DB transaction
(3)(+0000000): Beginning Notifier event queue
(5)(+0000000): SELECT itemID, linkMode, path, storageModTime, storageHash, syncState FROM itemAttachments JOIN items USING (itemID) WHERE linkMode IN (?,?) AND syncState IN (?,?) AND libraryID IS NOT NULL
(5)(+0000000): Binding parameter 1 of type int: 0
(5)(+0000000): Binding parameter 2 of type int: 1
(5)(+0000000): Binding parameter 3 of type int: 0
(5)(+0000000): Binding parameter 4 of type int: 2
(3)(+0000049): No synced files have changed locally
(5)(+0000000): Committing transaction
(3)(+0000000): Resetting Notifier event queue
(3)(+0000001): HTTP GET https://mronkko2:********@api.zotero.org/?auth=1
(3)(+0000388): HTTP GET https://mronkko2:********@api.zotero.org/users/701495/laststoragesync?auth=1
(3)(+0000173): 1341241710
(3)(+0000000): ===>200<===(number)
(3)(+0000000): Last successful storage sync was Mon Jul 02 2012 18:08:30 GMT+0300 (EEST)
(5)(+0000000): SELECT COUNT(*) FROM itemAttachments WHERE syncState=?
(5)(+0000001): Binding parameter 1 of type int: 4
(5)(+0000000): SELECT version FROM version WHERE schema='storage_zfs'
(3)(+0000000): Last ZFS sync time hasn't changed -- skipping file download step
(5)(+0000000): SELECT itemID FROM itemAttachments JOIN items USING (itemID) WHERE syncState IN (?,?) AND linkMode IN (?,?) AND libraryID IS NOT NULL
(5)(+0000000): Binding parameter 1 of type int: 0
(5)(+0000000): Binding parameter 2 of type int: 3
(5)(+0000000): Binding parameter 3 of type int: 0
(5)(+0000000): Binding parameter 4 of type int: 1
(3)(+0000000): No files to upload
(3)(+0000001): Beginning server sync
(5)(+0000000): SELECT version FROM version WHERE schema='lastremotesync'
(5)(+0000000): SELECT version FROM version WHERE schema='lastlocalsync'
(3)(+0000000): HTTP POST version=9&sessionid=********&lastsync=1341467697 to https://sync.zotero.org/updated
(3)(+0000405): <?xml version="1.0"?>
<response version="9" timestamp="1341467698" userID="701495" defaultLibraryID="580787" updateKey="ba8616e979a326ec62531ffe49af6401" earliest="1314727213"><updated/></response>
(5)(+0000001): Beginning DB transaction
(3)(+0000000): Beginning Notifier event queue
(5)(+0000000): SELECT value FROM settings WHERE setting='account' AND key='username'
(5)(+0000000): SELECT value FROM settings WHERE setting='account' AND key='userID'
(5)(+0000000): SELECT value FROM settings WHERE setting='account' AND key='libraryID'
(5)(+0000000): Committing transaction
(3)(+0000000): Resetting Notifier event queue
(5)(+0000000): Beginning DB transaction
(3)(+0000000): Beginning Notifier event queue
(3)(+0000001): Getting updated local creators
(5)(+0000000): SELECT ROWID FROM creators WHERE dateModified<?
(5)(+0000000): Binding parameter 1 of type string: "0000-00-00 00:00:00"
(5)(+0000000): SELECT ROWID FROM creators WHERE clientDateModified>?
(5)(+0000000): Binding parameter 1 of type string: "2012-07-05 05:54:57"
(3)(+0000000): Getting updated local items
(5)(+0000000): SELECT ROWID FROM items WHERE dateModified<?
(5)(+0000000): Binding parameter 1 of type string: "0000-00-00 00:00:00"
(5)(+0000000): SELECT ROWID FROM items WHERE clientDateModified>?
(5)(+0000000): Binding parameter 1 of type string: "2012-07-05 05:54:57"
(3)(+0000000): Getting updated local collections
(5)(+0000000): SELECT ROWID FROM collections WHERE dateModified<?
(5)(+0000001): Binding parameter 1 of type string: "0000-00-00 00:00:00"
(5)(+0000000): SELECT ROWID FROM collections WHERE clientDateModified>?
(5)(+0000000): Binding parameter 1 of type string: "2012-07-05 05:54:57"
(3)(+0000000): Getting updated local searches
(5)(+0000000): SELECT ROWID FROM savedSearches WHERE dateModified<?
(5)(+0000000): Binding parameter 1 of type string: "0000-00-00 00:00:00"
(5)(+0000000): SELECT ROWID FROM savedSearches WHERE clientDateModified>?
(5)(+0000000): Binding parameter 1 of type string: "2012-07-05 05:54:57"
(3)(+0000000): Getting updated local tags
(5)(+0000000): SELECT ROWID FROM tags WHERE dateModified<?
(5)(+0000000): Binding parameter 1 of type string: "0000-00-00 00:00:00"
(5)(+0000000): SELECT ROWID FROM tags WHERE clientDateModified>?
(5)(+0000000): Binding parameter 1 of type string: "2012-07-05 05:54:57"
(3)(+0000000): Getting updated local relations
(5)(+0000000): SELECT ROWID FROM relations WHERE clientDateModified<?
(5)(+0000000): Binding parameter 1 of type string: "0000-00-00 00:00:00"
(5)(+0000001): SELECT ROWID FROM relations WHERE clientDateModified>?
(5)(+0000000): Binding parameter 1 of type string: "2012-07-05 05:54:57"
(5)(+0000000): SELECT version FROM version WHERE schema='syncdeletelog'
(5)(+0000000): SELECT syncObjectTypeID, libraryID, key FROM syncDeleteLog WHERE timestamp>? ORDER BY timestamp
(5)(+0000000): Binding parameter 1 of type int: 1341467697
(3)(+0000001): No changes received from server
(3)(+0000000): Processing locally changed creators
(3)(+0000000): Processing locally changed items
(3)(+0000000): Processing locally changed collections
(3)(+0000000): Processing locally changed searches
(3)(+0000000): Processing locally changed tags
(3)(+0000000): Processing locally changed relations
(5)(+0000001): SELECT value FROM settings WHERE setting='account' AND key='libraryID'
(3)(+0000000): Processing locally deleted creators
(3)(+0000000): Processing locally deleted items
(3)(+0000000): Processing locally deleted collections
(3)(+0000000): Processing locally deleted searches
(3)(+0000000): Processing locally deleted tags
(3)(+0000000): Processing locally deleted relations
(3)(+0000000): Nothing to upload to server
(5)(+0000000): REPLACE INTO version VALUES ('lastremotesync', ?)
(5)(+0000000): Binding parameter 1 of type string: "1341467698"
(5)(+0000000): REPLACE INTO version VALUES ('lastlocalsync', ?)
(5)(+0000000): Binding parameter 1 of type int: 1341467699
(5)(+0000000): Committing transaction
(3)(+0000002): Resetting Notifier event queue
(5)(+0006385): SELECT COUNT(*) FROM fulltextItems WHERE (indexedPages IS NOT NULL AND indexedPages=totalPages) OR (indexedChars IS NOT NULL AND indexedChars=totalChars)
(5)(+0000000): SELECT COUNT(*) FROM fulltextItems WHERE (indexedPages IS NOT NULL AND indexedPages<totalPages) OR (indexedChars IS NOT NULL AND indexedChars<totalChars)
(5)(+0000000): SELECT COUNT(*) FROM itemAttachments WHERE itemID NOT IN (SELECT itemID FROM fulltextItems WHERE indexedPages IS NOT NULL OR indexedChars IS NOT NULL)
(5)(+0000001): SELECT COUNT(*) FROM fulltextWords
(3)(+0000039): DATE: retrieved with algorithms: {"year":2008,"month":10,"day":11}
(3)(+0000000): DATE: retrieved with algorithms: {"year":2010,"month":0,"day":27}
(3)(+0000000): DATE: retrieved with algorithms: {"year":2011,"month":11,"day":5}
(3)(+0000000): DATE: retrieved with algorithms: {"year":2010,"month":2,"day":15}
(3)(+0000001): DATE: retrieved with algorithms: {"year":2011,"month":7,"day":26}
(3)(+0000000): DATE: retrieved with algorithms: {"year":2012,"month":0,"day":1}
(3)(+0000000): DATE: retrieved with algorithms: {"year":2009,"month":11,"day":1}
(3)(+0000000): DATE: retrieved with algorithms: {"year":2011,"month":7,"day":18}
(3)(+0000001): DATE: retrieved with algorithms: {"year":2009,"month":11,"day":15}
(3)(+0000000): DATE: retrieved with algorithms: {"year":2011,"month":4,"day":28}
(3)(+0000000): DATE: retrieved with algorithms: {"year":2012,"month":0,"day":1}ß
(3)(+0000000): DATE: retrieved with algorithms: {"year":2008,"month":8,"day":16}
(3)(+0000005): Translate: WARNING: new Zotero.Translate() is deprecated; please don't use this if you don't have to
(3)(+0000001): Translate: All translator detect calls and RPC calls complete
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment