id	summary	reporter	owner	description	type	status	priority	milestone	component	version	resolution	keywords	cc
429	Fails to build new db	stakats	dstillman	"I've got a new SIRSI translator ready to roll, but I can't test it with r921 until we sort out a db issue.  If I delete my sqlite db with a clean install of 921, I get the following error when I start Firefox and Zotero tries to build a new db:

zotero(5): REPLACE INTO version (schema,version) VALUES (?,?)

zotero(5): Binding parameter 1 of type string: ""scrapers""

zotero(5): Binding parameter 2 of type int: 115

zotero(5): INSERT INTO items VALUES(123456789, 14, 'Zotero - Quick Start Guide', '2006-10-05 14:00:00', '2006-10-05 14:00:00')

zotero(5): INSERT INTO itemAttachments VALUES(123456789, NULL, 3, 'text/html', 25, NULL, NULL)

zotero(5): INSERT INTO itemData VALUES(123456789, 1, 'http://www.zotero.org/documentation/quick_start_guide')

zotero(5): INSERT INTO itemData VALUES(123456789, 27, '2006-10-05 14:00:00')

zotero(5): INSERT INTO itemNotes VALUES(123456789, NULL, ?)

zotero(1): [Exception... ""Component returned failure code: 0x80004005 (NS_ERROR_FAILURE) [mozIStorageConnection.createStatement]""  nsresult: ""0x80004005 (NS_ERROR_FAILURE)""  location: ""JS frame :: chrome://zotero/content/xpcom/db.js :: getStatement :: line 184""  data: no] [QUERY: INSERT INTO itemNotes VALUES(123456789, NULL, ?)] [ERROR: table itemNotes has 4 columns but 3 values were supplied] [QUERY: INSERT INTO itemNotes VALUES(123456789, NULL, ?)] [ERROR: table itemNotes has 4 columns but 3 values were supplied]

zotero(5): Rolling back transaction

zotero(5): Beginning DB transaction

zotero(5): SELECT version FROM version WHERE schema='fulltext'

zotero(3): [Exception... ""Component returned failure code: 0x80004005 (NS_ERROR_FAILURE) [mozIStorageConnection.createStatement]""  nsresult: ""0x80004005 (NS_ERROR_FAILURE)""  location: ""JS frame :: chrome://zotero/content/xpcom/db.js :: getStatement :: line 184""  data: no] [QUERY: SELECT version FROM version WHERE schema='fulltext'] [ERROR: no such table: version]

zotero(5): Rolling back transaction

zotero(3): Backing up database"	defect	closed	critical	1.0 Beta 3	uncategorized	1.0	fixed