I'm working on an upgade from 1.8 to 2.0.1. I'm doing this work on a test server.
I've gotten the database copied and upgraded, and everything is working.
I wanted to get all the new valuemaps and mappings, so I carefully copied from the file "data.sql" all the new valuemaps. I changed the valuemapid of those items which conflicted with existing values and inserted them into the database. I then did the same for the mappings.
All the new mappings show up nicely on the "value mapping" page, but I can't add new ones. I get duplicate entry errors (see errormessage below). But I can't figure out where it is getting the new valuemapid and mappingid from. I suspect it is being stored somewhere else in the database.
Anybody have any ideas?
here is the error I get when I try to insert a new value map:
Error in query [INSERT INTO valuemaps (name,valuemapid) VALUES ('testValue','9')] [Duplicate entry '9' for key 'PRIMARY']
SQL statement execution has failed "INSERT INTO valuemaps (name,valuemapid) VALUES ('testValue','9')".
I've gotten the database copied and upgraded, and everything is working.
I wanted to get all the new valuemaps and mappings, so I carefully copied from the file "data.sql" all the new valuemaps. I changed the valuemapid of those items which conflicted with existing values and inserted them into the database. I then did the same for the mappings.
All the new mappings show up nicely on the "value mapping" page, but I can't add new ones. I get duplicate entry errors (see errormessage below). But I can't figure out where it is getting the new valuemapid and mappingid from. I suspect it is being stored somewhere else in the database.
Anybody have any ideas?
here is the error I get when I try to insert a new value map:
Error in query [INSERT INTO valuemaps (name,valuemapid) VALUES ('testValue','9')] [Duplicate entry '9' for key 'PRIMARY']
SQL statement execution has failed "INSERT INTO valuemaps (name,valuemapid) VALUES ('testValue','9')".
Comment