DB upgrade from 1.9.3 to 1.9.4,5,... Duplicate entry '11'

Ask community to help.

Moderators: Amaradana, TurboPT, TL Developers

DB upgrade from 1.9.3 to 1.9.4,5,... Duplicate entry '11'

Postby wberry » Wed Dec 12, 2012 1:25 pm

Hi I'm using mysql to attempt to upgrade the database from 1.9.3 to 1.9.4
from the command line I change to the DB1.5 directory and run step 1 command : mysql <database name> <db_schema_update.sql

But I keep getting the following error: ERROR 1062 (23000) at line 28: Duplicate entry '11' for key 'PRIMARY'

I'm a database novice so any help would be great.

Thanks,
Wayne.
wberry
TestLink user
 
Posts: 11
Joined: Wed May 25, 2011 11:53 am

Re: DB upgrade from 1.9.3 to 1.9.4

Postby wberry » Wed Dec 12, 2012 2:48 pm

O/S is Ubuntu 12.04.01 LTS

Wayne.
wberry
TestLink user
 
Posts: 11
Joined: Wed May 25, 2011 11:53 am

Re: DB upgrade from 1.9.3 to 1.9.4

Postby fman » Wed Dec 12, 2012 4:30 pm

contact testlink.forum@gmail.com for instructions
fman
Member of TestLink Community
 
Posts: 3063
Joined: Tue Nov 15, 2005 7:19 am

Re: DB upgrade from 1.9.3 to 1.9.4,5, etc

Postby fman » Sun May 26, 2013 8:02 am

issue is related to an already existent record on node_types.
If you remove it from table before upgrading or remove the insert from upgrading scripts, everything will work ok.
fman
Member of TestLink Community
 
Posts: 3063
Joined: Tue Nov 15, 2005 7:19 am


Return to Installation and configuration



Who is online

Users browsing this forum: No registered users and 3 guests