Duplicate Entry

Ask community to help.

Moderators: Amaradana, TurboPT, TL Developers

Duplicate Entry

Postby eichead88 » Thu Mar 09, 2017 2:25 pm

Hi! I have a Testlink app 1.9.3. And i want upgrade it ti 1.9.16 version. But when i upgrade DB Version across sql scripts (No matter what version), sql return error: Duplicate entry '36' for key 'PRIMARY' or more. Current DB Version 1.9.1.

For Example - Error with alter table script 1.9.8:

mysql -u root -p testlink_001 < /opt/testlink_app/html/install/sql/alter_tables/1.9.8/mysql/DB.1.9.8/step1/db_schema_update.sql
Enter password:
ERROR 1062 (23000) at line 41: Duplicate entry '36' for key 'PRIMARY'

With 1.9.9:

mysql -u root -p testlink_001 < /opt/testlink_app/html/install/sql/alter_tables/1.9.9/mysql/DB.1.9.9/step1/db_schema_update.sql
Enter password:
ERROR 1050 (42S01) at line 23: Table 'cfield_build_design_values' already exists

My DB don't have a version 1.9.9 ((

I trying to comment problem rows, but Immediately there is a problem with the next row (next insert, for example).

I have no idea for this trouble. Friends, please help.
eichead88
TestLink user
 
Posts: 1
Joined: Sun Jan 08, 2017 2:06 pm

Return to Installation and configuration



Who is online

Users browsing this forum: No registered users and 3 guests