Opened 10 years ago
Closed 10 years ago
#429 closed defect (fixed)
Fails to build new db
| Reported by: | stakats | Owned by: | dstillman |
|---|---|---|---|
| Priority: | critical | Milestone: | 1.0 Beta 3 |
| Component: | uncategorized | Version: | 1.0 |
| Keywords: | Cc: |
Description
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
Change History (1)
comment:1 Changed 10 years ago by dstillman
- Resolution set to fixed
- Status changed from new to closed
(In [922]) Fixes #429, Fails to build new db
Sorry about that