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

Ask community to help.

Moderators: Amaradana, TurboPT, TL Developers

Post Reply
wberry
TestLink user
Posts: 11
Joined: Wed May 25, 2011 11:53 am

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

Post by wberry »

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

Post by wberry »

O/S is Ubuntu 12.04.01 LTS

Wayne.
fman
Member of TestLink Community
Posts: 3123
Joined: Tue Nov 15, 2005 7:19 am

Re: DB upgrade from 1.9.3 to 1.9.4

Post by fman »

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

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

Post by fman »

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.
Post Reply