www

commit 0c3529170f304e6ff9d5792d27666ee9046c5e07
parent a89388e77a04c914393b171b0819a6ce8c56a918
Author: Dan Stillman <dstillman@zotero.org>
Date:   Mon,  4 Nov 2013 04:36:39 -0500

Order by clientDateModified DESC when getting content to upload

This way content from newly added/modified items will get uploaded
before content from older items.

Diffstat:
M
chrome/content/zotero/xpcom/fulltext.js
 | 
3
++-

1 file changed, 2 insertions(+), 1 deletion(-)
diff --git a/chrome/content/zotero/xpcom/fulltext.js b/chrome/content/zotero/xpcom/fulltext.js
@@ -591,7 +591,8 @@ Zotero.Fulltext = new function(){
 		var chars = 0;
 		var contentItems = [];
 		var sql = "SELECT itemID, indexedChars, totalChars, indexedPages, totalPages "
-			+ "FROM fulltextItems WHERE synced=" + SYNC_STATE_UNSYNCED;
+			+ "FROM fulltextItems JOIN items USING (itemID) WHERE synced=" + SYNC_STATE_UNSYNCED
+			+ " ORDER BY clientDateModified DESC";
 		var rows = Zotero.DB.query(sql) || [];
 		for each (let row in rows) {
 			let text;