Issues upgrading from 1.7.4 to 1.8

[wferrarini]

Hi All;

I posted this as a reply to another issue but I felt I should create a new posting because the problem is slightly different.

I have 1.7.4 running on 2003 Server with xamp for my http and mysql

When I tried to upgrade my database I got the following error.

This is the error message I am receiving when I try to upgrade my 1.74 database to 1.8

TestLink setup will now attempt to setup the database:

Creating connection to Database Server: OK!

Checking MySQL version: OK! (5.0.67 >= 4.1.0)


Connecting to database `testlink`: OK!
Creating Testlink DB user `testlink`: OK! (ok - user_exists ok - grant assignment)
Processing:sql/alter_tables/1.8/mysql/DB.1.2/db_schema_update.sqlERROR ON exec_query() - database.class.php
1050 - Table 'cfield_testplan_design_values' already exists - CREATE TABLE `cfield_testplan_design_values` ( field_id int(10) NOT NULL default '0', link_id int(10) NOT NULL default '0' COMMENT 'point to testplan_tcversion id', value varchar(255) NOT NULL default '', PRIMARY KEY (`field_id`,`link_id`), KEY `idx_cfield_tplan_design_val` (`link_id`) ) DEFAULT CHARSET=utf8

THE MESSAGE :: SQL [14] executed [took 0.0179 secs][all took 1.2975 secs]: CREATE TABLE `cfield_testplan_design_values` ( field_id int(10) NOT NULL default '0', link_id int(10) NOT NULL default '0' COMMENT 'point to testplan_tcversion id', value varchar(255) NOT NULL default '', PRIMARY KEY (`field_id`,`link_id`), KEY `idx_cfield_tplan_design_val` (`link_id`) ) DEFAULT CHARSET=utf8 Query failed: errorcode[1050] errormsg:Table 'cfield_testplan_design_values' already exists

Processing:sql/alter_tables/1.8/mysql/DB.1.2/z_final_step.sql
Failed! - Upgrade failed!

TestLink setup couldn't install the default site into the selected database. The last error to occur was Table 'cfield_testplan_design_values' already exists during the execution of SQL statement CREATE TABLE `cfield_testplan_design_values` ( field_id int(10) NOT NULL default '0', link_id int(10) NOT NULL default '0' COMMENT 'point to testplan_tcversion id', value varchar(255) NOT NULL default '', PRIMARY KEY (`field_id`,`link_id`), KEY `idx_cfield_tplan_design_val` (`link_id`) ) DEFAULT CHARSET=utf8


If I try to run it again it tells me that the database schema is correct.

How should I proceed?

[fman]

STEP 0 - BACKUP YOUR DB not once but twice
STEP 1 - use upgrade to add new tables and fields on you TL 1.7 db
STEP 2 - use migration

everything must work ok

let us know