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

Note: See TracTickets for help on using tickets.