Opened 10 years ago

Closed 10 years ago

#543 closed defect (fixed)

database migration error

Reported by: simon Owned by: dstillman
Priority: major Milestone: 1.0 Beta 4
Component: data layer Version: 1.0
Keywords: Cc:

Description

I assume I can fix this for my own database, but I got the following error migrating from r1170 to r1199:

[Exception... "Component returned failure code: 0x80004005 (NS_ERROR_FAILURE) [mozIStorageConnection.executeSimpleSQL]"  nsresult: "0x80004005 (NS_ERROR_FAILURE)"  location: "JS frame :: chrome://zotero/content/xpcom/db.js :: anonymous :: line 93"  data: no] [QUERY: UPDATE itemData SET fieldID=50 WHERE itemID IN (SELECT itemID FROM items WHERE itemTypeID=19) AND fieldID=60;] [ERROR: columns itemID, fieldID are not unique]

We should ensure that this doesn't happen for people migrating from b3 to b4

Change History (1)

comment:1 Changed 10 years ago by dstillman

  • Resolution set to fixed
  • Status changed from new to closed

(In [1201]) Fixes #543, database migration error

'number' data in B3 'patent' items should become 'applicationNumber', since there already was a 'patentNumber', even if going forward 'patentNumber' will map to the 'number' base field

Simon, if you still have a copy of the problematic data, please check that this fixes the upgrade path.

Note: See TracTickets for help on using tickets.