[SOLVED] upgrade 1.8.0 to 1.9.0 stuck on installNewDB.php - TestLink

[SOLVED] upgrade 1.8.0 to 1.9.0 stuck on installNewDB.php

Moderators: Amaradana, TurboPT, TL Developers

4 posts • Page 1 of 1

chanukov: TestLink user; Posts: 4; Joined: Wed Jan 19, 2011 7:28 pm

[SOLVED] upgrade 1.8.0 to 1.9.0 stuck on installNewDB.php

Quote

Post by chanukov » Wed Jan 19, 2011 7:48 pm

First time it gets stuck showing only three lines and it never goes further when i refresh i get the following.

any and all help will be much apriciated

Code: Select all

estLink setup will now attempt to setup the database:

Creating connection to Database Server: OK!


Connecting to database `testlink`: OK!
Creating Testlink DB user `testlink-user`: OK! (ok - user_exists ok - grant assignment) 
Processing:sql/alter_tables/1.9/mysql/DB.1.3/step1/db_schema_update.sql
 ============================================================================== 
 DB Access Error - debug_print_backtrace() OUTPUT START 
 ============================================================================== 
#0  database->exec_query(/*
 * TestLink Open Source Project - http://testlink.sourceforge.net/ 
 * This script is distributed under the GNU General Public License 2 or later. 
 * 
 * SQL script: Update schema MySQL database for TestLink 1.9 from version 1.8 
 * "/ *prefix* /" - placeholder for tables with defined prefix, used by sqlParser.class.php.
 *
 * $Id: db_schema_update.sql,v 1.9 2010/07/22 14:14:42 asimon83 Exp $
 *
 * Important Warning: 
 * This file will be processed by sqlParser.class.php, that uses SEMICOLON to find end of SQL Sentences.
 * It is not intelligent enough to ignore  SEMICOLONS inside comments, then PLEASE
 * USE SEMICOLONS ONLY to signal END of SQL Statements.
 *
 * internal revision:
 *
 *  20100705 - asimon
 *  added new column build_id to user_assignments
 *
 *  20100308 - Julian
 *  req_relations table added
 *
 *  20090919 - franciscom
 *  value size for custom fields
 *
 *  20090717 - franciscom
 *  cfield_testprojects new field location
 *  testprojects new fiels is_public
 *  testplans new fiels is_public
 */
/* update some config data */
INSERT INTO /*prefix*/node_types (id,description) VALUES (8,'requirement_version')) called at [/var/www/html/testlink-1.9.0/install/sqlParser.class.php:109]
#1  SqlParser->process(sql/alter_tables/1.9/mysql/DB.1.3/step1/db_schema_update.sql) called at [/var/www/html/testlink-1.9.0/install/installNewDB.php:428]
 ============================================================================== 
 ============================================================================== 
 DB Access Error - debug_print_backtrace() OUTPUT START 
 ============================================================================== 
#0  database->exec_query(
INSERT INTO /*prefix*/node_types (id,description) VALUES (9,'testcase_step')) called at [/var/www/html/testlink-1.9.0/install/sqlParser.class.php:109]
#1  SqlParser->process(sql/alter_tables/1.9/mysql/DB.1.3/step1/db_schema_update.sql) called at [/var/www/html/testlink-1.9.0/install/installNewDB.php:428]
 ============================================================================== 
 ============================================================================== 
 DB Access Error - debug_print_backtrace() OUTPUT START 
 ============================================================================== 
#0  database->exec_query(
/* New Tables */
CREATE TABLE /*prefix*/req_versions (
  `id` int(10) unsigned NOT NULL,
  `version` smallint(5) unsigned NOT NULL default '1',
  `scope` text,
  `status` char(1) NOT NULL default 'V',
  `type` char(1) default NULL,
  `active` tinyint(1) NOT NULL default '1',
  `is_open` tinyint(1) NOT NULL default '1',
  `expected_coverage` int(10) NOT NULL default '1',
  `author_id` int(10) unsigned default NULL,
  `creation_ts` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `modifier_id` int(10) unsigned default NULL,
  `modification_ts` datetime NOT NULL default '0000-00-00 00:00:00',
  PRIMARY KEY  (`id`,`version`)
) DEFAULT CHARSET=utf8) called at [/var/www/html/testlink-1.9.0/install/sqlParser.class.php:109]
#1  SqlParser->process(sql/alter_tables/1.9/mysql/DB.1.3/step1/db_schema_update.sql) called at [/var/www/html/testlink-1.9.0/install/installNewDB.php:428]
 ============================================================================== 
 ============================================================================== 
 DB Access Error - debug_print_backtrace() OUTPUT START 
 ============================================================================== 
#0  database->exec_query(
CREATE TABLE /*prefix*/req_relations (
  `id` int(10) unsigned NOT NULL auto_increment,
  `source_id` int(10) unsigned NOT NULL,
  `destination_id` int(10) unsigned NOT NULL,
  `relation_type` smallint(5) unsigned NOT NULL default '1',
  `author_id` int(10) unsigned default NULL,
  `creation_ts` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY  (`id`)
) DEFAULT CHARSET=utf8) called at [/var/www/html/testlink-1.9.0/install/sqlParser.class.php:109]
#1  SqlParser->process(sql/alter_tables/1.9/mysql/DB.1.3/step1/db_schema_update.sql) called at [/var/www/html/testlink-1.9.0/install/installNewDB.php:428]
 ============================================================================== 
 ============================================================================== 
 DB Access Error - debug_print_backtrace() OUTPUT START 
 ============================================================================== 
#0  database->exec_query(
CREATE TABLE /*prefix*/tcsteps (  
  id int(10) unsigned NOT NULL,
  step_number INT NOT NULL DEFAULT '1',
  actions TEXT,
  expected_results TEXT,
  active tinyint(1) NOT NULL default '1',
  execution_type tinyint(1) NOT NULL default '1' COMMENT '1 -> manual, 2 -> automated',
  PRIMARY KEY (id)
) DEFAULT CHARSET=utf8) called at [/var/www/html/testlink-1.9.0/install/sqlParser.class.php:109]
#1  SqlParser->process(sql/alter_tables/1.9/mysql/DB.1.3/step1/db_schema_update.sql) called at [/var/www/html/testlink-1.9.0/install/installNewDB.php:428]
 ============================================================================== 
 ============================================================================== 
 DB Access Error - debug_print_backtrace() OUTPUT START 
 ============================================================================== 
#0  database->exec_query(
CREATE TABLE /*prefix*/platforms (
  id INTEGER UNSIGNED NOT NULL AUTO_INCREMENT,
  name VARCHAR(100) NOT NULL,
  testproject_id INTEGER UNSIGNED NOT NULL,
  notes text NOT NULL,
  PRIMARY KEY (id),
  UNIQUE KEY /*prefix*/idx_platforms (testproject_id,name)
) DEFAULT CHARSET=utf8) called at [/var/www/html/testlink-1.9.0/install/sqlParser.class.php:109]
#1  SqlParser->process(sql/alter_tables/1.9/mysql/DB.1.3/step1/db_schema_update.sql) called at [/var/www/html/testlink-1.9.0/install/installNewDB.php:428]
 ============================================================================== 
 ============================================================================== 
 DB Access Error - debug_print_backtrace() OUTPUT START 
 ============================================================================== 
#0  database->exec_query(
CREATE TABLE /*prefix*/testplan_platforms (
  id int(10) unsigned NOT NULL auto_increment,
  testplan_id int(10) unsigned NOT NULL,
  platform_id int(10) unsigned NOT NULL,
  PRIMARY KEY (id),
  UNIQUE KEY /*prefix*/idx_testplan_platforms(testplan_id,platform_id)
) DEFAULT CHARSET=utf8 COMMENT='Connects a testplan with platforms') called at [/var/www/html/testlink-1.9.0/install/sqlParser.class.php:109]
#1  SqlParser->process(sql/alter_tables/1.9/mysql/DB.1.3/step1/db_schema_update.sql) called at [/var/www/html/testlink-1.9.0/install/installNewDB.php:428]
 ============================================================================== 
 ============================================================================== 
 DB Access Error - debug_print_backtrace() OUTPUT START 
 ============================================================================== 
#0  database->exec_query(
CREATE TABLE /*prefix*/inventory (
	id int(10) unsigned NOT NULL auto_increment,
	`testproject_id` INT( 10 ) UNSIGNED NOT NULL ,
	`owner_id` INT(10) UNSIGNED NOT NULL ,
	`name` VARCHAR(255) NOT NULL ,
	`ipaddress` VARCHAR(255) NOT NULL ,
	`content` TEXT NULL ,
	`creation_ts` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP,
	`modification_ts` TIMESTAMP NOT NULL,
	PRIMARY KEY (`id`),
	KEY /*prefix*/inventory_idx1 (`testproject_id`)
) DEFAULT CHARSET=utf8) called at [/var/www/html/testlink-1.9.0/install/sqlParser.class.php:109]
#1  SqlParser->process(sql/alter_tables/1.9/mysql/DB.1.3/step1/db_schema_update.sql) called at [/var/www/html/testlink-1.9.0/install/installNewDB.php:428]
 ============================================================================== 
 ============================================================================== 
 DB Access Error - debug_print_backtrace() OUTPUT START 
 ============================================================================== 
#0  database->exec_query( 
/* Step 3 - simple structure updates */
/* builds */
ALTER TABLE /*prefix*/builds ADD COLUMN`author_id` int(10) unsigned default NULL) called at [/var/www/html/testlink-1.9.0/install/sqlParser.class.php:109]
#1  SqlParser->process(sql/alter_tables/1.9/mysql/DB.1.3/step1/db_schema_update.sql) called at [/var/www/html/testlink-1.9.0/install/installNewDB.php:428]
 ============================================================================== 
 ============================================================================== 
 DB Access Error - debug_print_backtrace() OUTPUT START 
 ============================================================================== 
#0  database->exec_query(
ALTER TABLE /*prefix*/builds ADD COLUMN `creation_ts` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP) called at [/var/www/html/testlink-1.9.0/install/sqlParser.class.php:109]
#1  SqlParser->process(sql/alter_tables/1.9/mysql/DB.1.3/step1/db_schema_update.sql) called at [/var/www/html/testlink-1.9.0/install/installNewDB.php:428]
 ============================================================================== 
 ============================================================================== 
 DB Access Error - debug_print_backtrace() OUTPUT START 
 ============================================================================== 
#0  database->exec_query(
ALTER TABLE /*prefix*/builds ADD COLUMN `release_date` date NULL) called at [/var/www/html/testlink-1.9.0/install/sqlParser.class.php:109]
#1  SqlParser->process(sql/alter_tables/1.9/mysql/DB.1.3/step1/db_schema_update.sql) called at [/var/www/html/testlink-1.9.0/install/installNewDB.php:428]
 ============================================================================== 
 ============================================================================== 
 DB Access Error - debug_print_backtrace() OUTPUT START 
 ============================================================================== 
#0  database->exec_query(
ALTER TABLE /*prefix*/builds ADD COLUMN `closed_on_date` date NULL) called at [/var/www/html/testlink-1.9.0/install/sqlParser.class.php:109]
#1  SqlParser->process(sql/alter_tables/1.9/mysql/DB.1.3/step1/db_schema_update.sql) called at [/var/www/html/testlink-1.9.0/install/installNewDB.php:428]
 ============================================================================== 
 ============================================================================== 
 DB Access Error - debug_print_backtrace() OUTPUT START 
 ============================================================================== 
#0  database->exec_query(
/* user_assignments */
ALTER TABLE /*prefix*/user_assignments ADD COLUMN build_id int(10) unsigned default '0') called at [/var/www/html/testlink-1.9.0/install/sqlParser.class.php:109]
#1  SqlParser->process(sql/alter_tables/1.9/mysql/DB.1.3/step1/db_schema_update.sql) called at [/var/www/html/testlink-1.9.0/install/installNewDB.php:428]
 ============================================================================== 
 ============================================================================== 
 DB Access Error - debug_print_backtrace() OUTPUT START 
 ============================================================================== 
#0  database->exec_query(
/* cfield_testprojects */
ALTER TABLE /*prefix*/cfield_testprojects  ADD COLUMN location tinyint NOT NULL DEFAULT '1') called at [/var/www/html/testlink-1.9.0/install/sqlParser.class.php:109]
#1  SqlParser->process(sql/alter_tables/1.9/mysql/DB.1.3/step1/db_schema_update.sql) called at [/var/www/html/testlink-1.9.0/install/installNewDB.php:428]
 ============================================================================== 
 ============================================================================== 
 DB Access Error - debug_print_backtrace() OUTPUT START 
 ============================================================================== 
#0  database->exec_query(
/* tcversions */
ALTER TABLE /*prefix*/tcversions ADD COLUMN layout smallint(5) unsigned NOT NULL default '1') called at [/var/www/html/testlink-1.9.0/install/sqlParser.class.php:109]
#1  SqlParser->process(sql/alter_tables/1.9/mysql/DB.1.3/step1/db_schema_update.sql) called at [/var/www/html/testlink-1.9.0/install/installNewDB.php:428]
 ============================================================================== 
 ============================================================================== 
 DB Access Error - debug_print_backtrace() OUTPUT START 
 ============================================================================== 
#0  database->exec_query(
ALTER TABLE /*prefix*/tcversions ADD COLUMN `status` smallint(5) unsigned NOT NULL default '1') called at [/var/www/html/testlink-1.9.0/install/sqlParser.class.php:109]
#1  SqlParser->process(sql/alter_tables/1.9/mysql/DB.1.3/step1/db_schema_update.sql) called at [/var/www/html/testlink-1.9.0/install/installNewDB.php:428]
 ============================================================================== 
 ============================================================================== 
 DB Access Error - debug_print_backtrace() OUTPUT START 
 ============================================================================== 
#0  database->exec_query(
ALTER TABLE /*prefix*/tcversions ADD COLUMN preconditions TEXT NULL) called at [/var/www/html/testlink-1.9.0/install/sqlParser.class.php:109]
#1  SqlParser->process(sql/alter_tables/1.9/mysql/DB.1.3/step1/db_schema_update.sql) called at [/var/www/html/testlink-1.9.0/install/installNewDB.php:428]
 ============================================================================== 
 ============================================================================== 
 DB Access Error - debug_print_backtrace() OUTPUT START 
 ============================================================================== 
#0  database->exec_query(
/* testprojects */
ALTER TABLE /*prefix*/testprojects ADD COLUMN is_public tinyint NOT NULL DEFAULT '1') called at [/var/www/html/testlink-1.9.0/install/sqlParser.class.php:109]
#1  SqlParser->process(sql/alter_tables/1.9/mysql/DB.1.3/step1/db_schema_update.sql) called at [/var/www/html/testlink-1.9.0/install/installNewDB.php:428]
 ============================================================================== 
 ============================================================================== 
 DB Access Error - debug_print_backtrace() OUTPUT START 
 ============================================================================== 
#0  database->exec_query(
ALTER TABLE /*prefix*/testprojects ADD COLUMN `options` text) called at [/var/www/html/testlink-1.9.0/install/sqlParser.class.php:109]
#1  SqlParser->process(sql/alter_tables/1.9/mysql/DB.1.3/step1/db_schema_update.sql) called at [/var/www/html/testlink-1.9.0/install/installNewDB.php:428]
 ============================================================================== 
 ============================================================================== 
 DB Access Error - debug_print_backtrace() OUTPUT START 
 ============================================================================== 
#0  database->exec_query(
/* testplans */
ALTER TABLE /*prefix*/testplans ADD COLUMN is_public tinyint NOT NULL DEFAULT '1') called at [/var/www/html/testlink-1.9.0/install/sqlParser.class.php:109]
#1  SqlParser->process(sql/alter_tables/1.9/mysql/DB.1.3/step1/db_schema_update.sql) called at [/var/www/html/testlink-1.9.0/install/installNewDB.php:428]
 ============================================================================== 
 ============================================================================== 
 DB Access Error - debug_print_backtrace() OUTPUT START 
 ============================================================================== 
#0  database->exec_query(
/* testplan_tcversions */
ALTER TABLE /*prefix*/testplan_tcversions ADD COLUMN author_id int(10) unsigned default NULL) called at [/var/www/html/testlink-1.9.0/install/sqlParser.class.php:109]
#1  SqlParser->process(sql/alter_tables/1.9/mysql/DB.1.3/step1/db_schema_update.sql) called at [/var/www/html/testlink-1.9.0/install/installNewDB.php:428]
 ============================================================================== 
 ============================================================================== 
 DB Access Error - debug_print_backtrace() OUTPUT START 
 ============================================================================== 
#0  database->exec_query(
ALTER TABLE /*prefix*/testplan_tcversions ADD COLUMN creation_ts TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP) called at [/var/www/html/testlink-1.9.0/install/sqlParser.class.php:109]
#1  SqlParser->process(sql/alter_tables/1.9/mysql/DB.1.3/step1/db_schema_update.sql) called at [/var/www/html/testlink-1.9.0/install/installNewDB.php:428]
 ============================================================================== 
 ============================================================================== 
 DB Access Error - debug_print_backtrace() OUTPUT START 
 ============================================================================== 
#0  database->exec_query(
ALTER TABLE /*prefix*/testplan_tcversions ADD COLUMN platform_id int(10) unsigned NOT NULL default '0') called at [/var/www/html/testlink-1.9.0/install/sqlParser.class.php:109]
#1  SqlParser->process(sql/alter_tables/1.9/mysql/DB.1.3/step1/db_schema_update.sql) called at [/var/www/html/testlink-1.9.0/install/installNewDB.php:428]
 ============================================================================== 
 ============================================================================== 
 DB Access Error - debug_print_backtrace() OUTPUT START 
 ============================================================================== 
#0  database->exec_query(
/* NEED TO ALTER INDEX */
/* 1 - drop old index */
DROP INDEX /*prefix*/tp_tcversion ON /*prefix*/testplan_tcversions) called at [/var/www/html/testlink-1.9.0/install/sqlParser.class.php:109]
#1  SqlParser->process(sql/alter_tables/1.9/mysql/DB.1.3/step1/db_schema_update.sql) called at [/var/www/html/testlink-1.9.0/install/installNewDB.php:428]
 ============================================================================== 
 ============================================================================== 
 DB Access Error - debug_print_backtrace() OUTPUT START 
 ============================================================================== 
#0  database->exec_query(
CREATE UNIQUE INDEX /*prefix*/testplan_tcversions_tplan_tcversion ON /*prefix*/testplan_tcversions (testplan_id,tcversion_id,platform_id)) called at [/var/www/html/testlink-1.9.0/install/sqlParser.class.php:109]
#1  SqlParser->process(sql/alter_tables/1.9/mysql/DB.1.3/step1/db_schema_update.sql) called at [/var/www/html/testlink-1.9.0/install/installNewDB.php:428]
 ============================================================================== 
 ============================================================================== 
 DB Access Error - debug_print_backtrace() OUTPUT START 
 ============================================================================== 
#0  database->exec_query(
/* executions */
ALTER TABLE /*prefix*/executions  ADD COLUMN platform_id int(10) unsigned NOT NULL default '0') called at [/var/www/html/testlink-1.9.0/install/sqlParser.class.php:109]
#1  SqlParser->process(sql/alter_tables/1.9/mysql/DB.1.3/step1/db_schema_update.sql) called at [/var/www/html/testlink-1.9.0/install/installNewDB.php:428]
 ============================================================================== 
 ============================================================================== 
 DB Access Error - debug_print_backtrace() OUTPUT START 
 ============================================================================== 
#0  database->exec_query(
/* milestones */
ALTER TABLE /*prefix*/milestones ADD COLUMN start_date date NOT NULL default '0000-00-00') called at [/var/www/html/testlink-1.9.0/install/sqlParser.class.php:109]
#1  SqlParser->process(sql/alter_tables/1.9/mysql/DB.1.3/step1/db_schema_update.sql) called at [/var/www/html/testlink-1.9.0/install/installNewDB.php:428]
 ============================================================================== 
 ============================================================================== 
 DB Access Error - debug_print_backtrace() OUTPUT START 
 ============================================================================== 
#0  database->exec_query(
/* req_spec */
ALTER TABLE /*prefix*/req_specs ADD COLUMN doc_id VARCHAR(64) NOT NULL DEFAULT 'RS_DOC_ID') called at [/var/www/html/testlink-1.9.0/install/sqlParser.class.php:109]
#1  SqlParser->process(sql/alter_tables/1.9/mysql/DB.1.3/step1/db_schema_update.sql) called at [/var/www/html/testlink-1.9.0/install/installNewDB.php:428]
 ============================================================================== 

 ============================================================================== 
 DB Access Error - debug_print_backtrace() OUTPUT START 
 ============================================================================== 
#0  database->exec_query( INSERT INTO req_versions  (id,scope,status,type,author_id,creation_ts,modifier_id,modification_ts,   version,expected_coverage)   SELECT id,scope,status,type,author_id,creation_ts,modifier_id,modification_ts,            1 AS version, 1 AS expected_coverage  FROM requirements) called at [/var/www/html/testlink-1.9.0/install/migration/migrate_18/migrate_18_to_19.php:83]
#1  migrate_requirements(database Object ([db] => ADODB_mysql Object ([databaseType] => mysql,[dataProvider] => mysql,[hasInsertID] => 1,[hasAffectedRows] => 1,[metaTablesSQL] => SHOW TABLES,[metaColumnsSQL] => SHOW COLUMNS FROM `%s`,[fmtTimeStamp] => 'Y-m-d H:i:s',[hasLimit] => 1,[hasMoveFirst] => 1,[hasGenID] => 1,[isoDates] => 1,[sysDate] => CURDATE(),[sysTimeStamp] => NOW(),[hasTransactions] => ,[forceNewConnect] => 1,[poorAffectedRows] => 1,[clientFlags] => 0,[substr] => substring,[nameQuote] => `,[compat323] => ,[_genIDSQL] => update %s set id=LAST_INSERT_ID(id+1);,[_genSeqSQL] => create table %s (id int not null),[_genSeqCountSQL] => select count(*) from %s,[_genSeq2SQL] => insert into %s values (%s),[_dropSeqSQL] => drop table %s,[database] => testlink,[host] => localhost,[user] => root,[password] => ,[debug] => ,[maxblobsize] => 262144,[concat_operator] => +,[length] => length,[random] => rand(),[upperCase] => upper,[fmtDate] => 'Y-m-d',[true] => 1,[false] => 0,[replaceQuote] => \',[charSet] => ,[metaDatabasesSQL] => ,[uniqueOrderBy] => ,[emptyDate] =>  ,[emptyTimeStamp] =>  ,[lastInsID] => ,[hasTop] => ,[readOnly] => ,[genID] => 0,[raiseErrorFn] => ,[cacheSecs] => 3600,[memCache] => ,[memCacheHost] => ,[memCachePort] => 11211,[memCacheCompress] => ,[sysUTimeStamp] => ,[arrayClass] => ADORecordSet_array,[noNullStrings] => ,[numCacheHits] => 0,[numCacheMisses] => 0,[pageExecuteCountRows] => 1,[uniqueSort] => ,[leftOuter] => ,[rightOuter] => ,[ansiOuter] => ,[autoRollback] => ,[fnExecute] => ,[fnCacheExecute] => ,[blobEncodeType] => ,[rsPrefix] => ADORecordSet_,[autoCommit] => 1,[transOff] => 0,[transCnt] => 0,[fetchMode] => 2,[null2null] => null,[_oldRaiseFn] => ,[_transOK] => ,[_connectionID] => Resource id #55,[_errorMsg] => Unknown column 'scope' in 'field list',[_errorCode] => ,[_queryID] => ,[_isPersistentConnection] => ,[_bindInputArray] => ,[_evalAll] => ,[_affected] => ,[_logsql] => ,[_transmode] => ,[databaseName] => testlink),[queries_array] => Array (),[is_connected] => 1,[nQuery] => 46,[overallDuration] => 0.126,[] => 0,[] => 0), Array ([assignment_status] => assignment_status,[assignment_types] => assignment_types,[attachments] => attachments,[builds] => builds,[cfield_design_values] => cfield_design_values,[cfield_execution_values] => cfield_execution_values,[cfield_node_types] => cfield_node_types,[cfield_testplan_design_values] => cfield_testplan_design_values,[cfield_testprojects] => cfield_testprojects,[custom_fields] => custom_fields,[db_version] => db_version,[events] => events,[execution_bugs] => execution_bugs,[executions] => executions,[inventory] => inventory,[keywords] => keywords,[milestones] => milestones,[node_types] => node_types,[nodes_hierarchy] => nodes_hierarchy,[object_keywords] => object_keywords,[platforms] => platforms,[req_coverage] => req_coverage,[req_relations] => req_relations,[req_specs] => req_specs,[req_suites] => req_suites,[requirements] => requirements,[req_versions] => req_versions,[rights] => rights,[risk_assignments] => risk_assignments,[role_rights] => role_rights,[roles] => roles,[tcversions] => tcversions,[tcsteps] => tcsteps,[testcase_keywords] => testcase_keywords,[testplan_platforms] => testplan_platforms,[testplan_tcversions] => testplan_tcversions,[testplans] => testplans,[testprojects] => testprojects,[testsuites] => testsuites,[text_templates] => text_templates,[transactions] => transactions,[user_assignments] => user_assignments,[user_group] => user_group,[user_group_assign] => user_group_assign,[user_testplan_roles] => user_testplan_roles,[user_testproject_roles] => user_testproject_roles,[users] => users)) called at [/var/www/html/testlink-1.9.0/install/migration/migrate_18/migrate_18_to_19.php:44]
#2  migrate_18_to_19(database Object ([db] => ADODB_mysql Object ([databaseType] => mysql,[dataProvider] => mysql,[hasInsertID] => 1,[hasAffectedRows] => 1,[metaTablesSQL] => SHOW TABLES,[metaColumnsSQL] => SHOW COLUMNS FROM `%s`,[fmtTimeStamp] => 'Y-m-d H:i:s',[hasLimit] => 1,[hasMoveFirst] => 1,[hasGenID] => 1,[isoDates] => 1,[sysDate] => CURDATE(),[sysTimeStamp] => NOW(),[hasTransactions] => ,[forceNewConnect] => 1,[poorAffectedRows] => 1,[clientFlags] => 0,[substr] => substring,[nameQuote] => `,[compat323] => ,[_genIDSQL] => update %s set id=LAST_INSERT_ID(id+1);,[_genSeqSQL] => create table %s (id int not null),[_genSeqCountSQL] => select count(*) from %s,[_genSeq2SQL] => insert into %s values (%s),[_dropSeqSQL] => drop table %s,[database] => testlink,[host] => localhost,[user] => root,[password] => ,[debug] => ,[maxblobsize] => 262144,[concat_operator] => +,[length] => length,[random] => rand(),[upperCase] => upper,[fmtDate] => 'Y-m-d',[true] => 1,[false] => 0,[replaceQuote] => \',[charSet] => ,[metaDatabasesSQL] => ,[uniqueOrderBy] => ,[emptyDate] =>  ,[emptyTimeStamp] =>  ,[lastInsID] => ,[hasTop] => ,[readOnly] => ,[genID] => 0,[raiseErrorFn] => ,[cacheSecs] => 3600,[memCache] => ,[memCacheHost] => ,[memCachePort] => 11211,[memCacheCompress] => ,[sysUTimeStamp] => ,[arrayClass] => ADORecordSet_array,[noNullStrings] => ,[numCacheHits] => 0,[numCacheMisses] => 0,[pageExecuteCountRows] => 1,[uniqueSort] => ,[leftOuter] => ,[rightOuter] => ,[ansiOuter] => ,[autoRollback] => ,[fnExecute] => ,[fnCacheExecute] => ,[blobEncodeType] => ,[rsPrefix] => ADORecordSet_,[autoCommit] => 1,[transOff] => 0,[transCnt] => 0,[fetchMode] => 2,[null2null] => null,[_oldRaiseFn] => ,[_transOK] => ,[_connectionID] => Resource id #55,[_errorMsg] => Unknown column 'scope' in 'field list',[_errorCode] => ,[_queryID] => ,[_isPersistentConnection] => ,[_bindInputArray] => ,[_evalAll] => ,[_affected] => ,[_logsql] => ,[_transmode] => ,[databaseName] => testlink),[queries_array] => Array (),[is_connected] => 1,[nQuery] => 46,[overallDuration] => 0.126,[] => 0,[] => 0), Array ([assignment_status] => assignment_status,[assignment_types] => assignment_types,[attachments] => attachments,[builds] => builds,[cfield_design_values] => cfield_design_values,[cfield_execution_values] => cfield_execution_values,[cfield_node_types] => cfield_node_types,[cfield_testplan_design_values] => cfield_testplan_design_values,[cfield_testprojects] => cfield_testprojects,[custom_fields] => custom_fields,[db_version] => db_version,[events] => events,[execution_bugs] => execution_bugs,[executions] => executions,[inventory] => inventory,[keywords] => keywords,[milestones] => milestones,[node_types] => node_types,[nodes_hierarchy] => nodes_hierarchy,[object_keywords] => object_keywords,[platforms] => platforms,[req_coverage] => req_coverage,[req_relations] => req_relations,[req_specs] => req_specs,[req_suites] => req_suites,[requirements] => requirements,[req_versions] => req_versions,[rights] => rights,[risk_assignments] => risk_assignments,[role_rights] => role_rights,[roles] => roles,[tcversions] => tcversions,[tcsteps] => tcsteps,[testcase_keywords] => testcase_keywords,[testplan_platforms] => testplan_platforms,[testplan_tcversions] => testplan_tcversions,[testplans] => testplans,[testprojects] => testprojects,[testsuites] => testsuites,[text_templates] => text_templates,[transactions] => transactions,[user_assignments] => user_assignments,[user_group] => user_group,[user_group_assign] => user_group_assign,[user_testplan_roles] => user_testplan_roles,[user_testproject_roles] => user_testproject_roles,[users] => users)) called at [/var/www/html/testlink-1.9.0/install/installNewDB.php:437]
 ============================================================================== 
migrate_testcases
 ============================================================================== 
 DB Access Error - debug_print_backtrace() OUTPUT START 
 ============================================================================== 
#0  database->exec_query( INSERT INTO tcsteps  (id,actions,expected_results,active,execution_type)  SELECT id,steps,expected_results,active,execution_type  FROM tcversions) called at [/var/www/html/testlink-1.9.0/install/migration/migrate_18/migrate_18_to_19.php:305]
#1  migrate_testcases(database Object ([db] => ADODB_mysql Object ([databaseType] => mysql,[dataProvider] => mysql,[hasInsertID] => 1,[hasAffectedRows] => 1,[metaTablesSQL] => SHOW TABLES,[metaColumnsSQL] => SHOW COLUMNS FROM `%s`,[fmtTimeStamp] => 'Y-m-d H:i:s',[hasLimit] => 1,[hasMoveFirst] => 1,[hasGenID] => 1,[isoDates] => 1,[sysDate] => CURDATE(),[sysTimeStamp] => NOW(),[hasTransactions] => ,[forceNewConnect] => 1,[poorAffectedRows] => 1,[clientFlags] => 0,[substr] => substring,[nameQuote] => `,[compat323] => ,[_genIDSQL] => update %s set id=LAST_INSERT_ID(id+1);,[_genSeqSQL] => create table %s (id int not null),[_genSeqCountSQL] => select count(*) from %s,[_genSeq2SQL] => insert into %s values (%s),[_dropSeqSQL] => drop table %s,[database] => testlink,[host] => localhost,[user] => root,[password] => ,[debug] => ,[maxblobsize] => 262144,[concat_operator] => +,[length] => length,[random] => rand(),[upperCase] => upper,[fmtDate] => 'Y-m-d',[true] => 1,[false] => 0,[replaceQuote] => \',[charSet] => ,[metaDatabasesSQL] => ,[uniqueOrderBy] => ,[emptyDate] =>  ,[emptyTimeStamp] =>  ,[lastInsID] => ,[hasTop] => ,[readOnly] => ,[genID] => 0,[raiseErrorFn] => ,[cacheSecs] => 3600,[memCache] => ,[memCacheHost] => ,[memCachePort] => 11211,[memCacheCompress] => ,[sysUTimeStamp] => ,[arrayClass] => ADORecordSet_array,[noNullStrings] => ,[numCacheHits] => 0,[numCacheMisses] => 0,[pageExecuteCountRows] => 1,[uniqueSort] => ,[leftOuter] => ,[rightOuter] => ,[ansiOuter] => ,[autoRollback] => ,[fnExecute] => ,[fnCacheExecute] => ,[blobEncodeType] => ,[rsPrefix] => ADORecordSet_,[autoCommit] => 1,[transOff] => 0,[transCnt] => 0,[fetchMode] => 2,[null2null] => null,[_oldRaiseFn] => ,[_transOK] => ,[_connectionID] => Resource id #55,[_errorMsg] => Duplicate entry '7221' for key 1,[_errorCode] => ,[_queryID] => ,[_isPersistentConnection] => ,[_bindInputArray] => ,[_evalAll] => ,[_affected] => ,[_logsql] => ,[_transmode] => ,[databaseName] => testlink),[queries_array] => Array (),[is_connected] => 1,[nQuery] => 56,[overallDuration] => 0.1624,[] => 0,[] => 0), Array ([assignment_status] => assignment_status,[assignment_types] => assignment_types,[attachments] => attachments,[builds] => builds,[cfield_design_values] => cfield_design_values,[cfield_execution_values] => cfield_execution_values,[cfield_node_types] => cfield_node_types,[cfield_testplan_design_values] => cfield_testplan_design_values,[cfield_testprojects] => cfield_testprojects,[custom_fields] => custom_fields,[db_version] => db_version,[events] => events,[execution_bugs] => execution_bugs,[executions] => executions,[inventory] => inventory,[keywords] => keywords,[milestones] => milestones,[node_types] => node_types,[nodes_hierarchy] => nodes_hierarchy,[object_keywords] => object_keywords,[platforms] => platforms,[req_coverage] => req_coverage,[req_relations] => req_relations,[req_specs] => req_specs,[req_suites] => req_suites,[requirements] => requirements,[req_versions] => req_versions,[rights] => rights,[risk_assignments] => risk_assignments,[role_rights] => role_rights,[roles] => roles,[tcversions] => tcversions,[tcsteps] => tcsteps,[testcase_keywords] => testcase_keywords,[testplan_platforms] => testplan_platforms,[testplan_tcversions] => testplan_tcversions,[testplans] => testplans,[testprojects] => testprojects,[testsuites] => testsuites,[text_templates] => text_templates,[transactions] => transactions,[user_assignments] => user_assignments,[user_group] => user_group,[user_group_assign] => user_group_assign,[user_testplan_roles] => user_testplan_roles,[user_testproject_roles] => user_testproject_roles,[users] => users)) called at [/var/www/html/testlink-1.9.0/install/migration/migrate_18/migrate_18_to_19.php:46]
#2  migrate_18_to_19(database Object ([db] => ADODB_mysql Object ([databaseType] => mysql,[dataProvider] => mysql,[hasInsertID] => 1,[hasAffectedRows] => 1,[metaTablesSQL] => SHOW TABLES,[metaColumnsSQL] => SHOW COLUMNS FROM `%s`,[fmtTimeStamp] => 'Y-m-d H:i:s',[hasLimit] => 1,[hasMoveFirst] => 1,[hasGenID] => 1,[isoDates] => 1,[sysDate] => CURDATE(),[sysTimeStamp] => NOW(),[hasTransactions] => ,[forceNewConnect] => 1,[poorAffectedRows] => 1,[clientFlags] => 0,[substr] => substring,[nameQuote] => `,[compat323] => ,[_genIDSQL] => update %s set id=LAST_INSERT_ID(id+1);,[_genSeqSQL] => create table %s (id int not null),[_genSeqCountSQL] => select count(*) from %s,[_genSeq2SQL] => insert into %s values (%s),[_dropSeqSQL] => drop table %s,[database] => testlink,[host] => localhost,[user] => root,[password] => ,[debug] => ,[maxblobsize] => 262144,[concat_operator] => +,[length] => length,[random] => rand(),[upperCase] => upper,[fmtDate] => 'Y-m-d',[true] => 1,[false] => 0,[replaceQuote] => \',[charSet] => ,[metaDatabasesSQL] => ,[uniqueOrderBy] => ,[emptyDate] =>  ,[emptyTimeStamp] =>  ,[lastInsID] => ,[hasTop] => ,[readOnly] => ,[genID] => 0,[raiseErrorFn] => ,[cacheSecs] => 3600,[memCache] => ,[memCacheHost] => ,[memCachePort] => 11211,[memCacheCompress] => ,[sysUTimeStamp] => ,[arrayClass] => ADORecordSet_array,[noNullStrings] => ,[numCacheHits] => 0,[numCacheMisses] => 0,[pageExecuteCountRows] => 1,[uniqueSort] => ,[leftOuter] => ,[rightOuter] => ,[ansiOuter] => ,[autoRollback] => ,[fnExecute] => ,[fnCacheExecute] => ,[blobEncodeType] => ,[rsPrefix] => ADORecordSet_,[autoCommit] => 1,[transOff] => 0,[transCnt] => 0,[fetchMode] => 2,[null2null] => null,[_oldRaiseFn] => ,[_transOK] => ,[_connectionID] => Resource id #55,[_errorMsg] => Duplicate entry '7221' for key 1,[_errorCode] => ,[_queryID] => ,[_isPersistentConnection] => ,[_bindInputArray] => ,[_evalAll] => ,[_affected] => ,[_logsql] => ,[_transmode] => ,[databaseName] => testlink),[queries_array] => Array (),[is_connected] => 1,[nQuery] => 56,[overallDuration] => 0.1624,[] => 0,[] => 0), Array ([assignment_status] => assignment_status,[assignment_types] => assignment_types,[attachments] => attachments,[builds] => builds,[cfield_design_values] => cfield_design_values,[cfield_execution_values] => cfield_execution_values,[cfield_node_types] => cfield_node_types,[cfield_testplan_design_values] => cfield_testplan_design_values,[cfield_testprojects] => cfield_testprojects,[custom_fields] => custom_fields,[db_version] => db_version,[events] => events,[execution_bugs] => execution_bugs,[executions] => executions,[inventory] => inventory,[keywords] => keywords,[milestones] => milestones,[node_types] => node_types,[nodes_hierarchy] => nodes_hierarchy,[object_keywords] => object_keywords,[platforms] => platforms,[req_coverage] => req_coverage,[req_relations] => req_relations,[req_specs] => req_specs,[req_suites] => req_suites,[requirements] => requirements,[req_versions] => req_versions,[rights] => rights,[risk_assignments] => risk_assignments,[role_rights] => role_rights,[roles] => roles,[tcversions] => tcversions,[tcsteps] => tcsteps,[testcase_keywords] => testcase_keywords,[testplan_platforms] => testplan_platforms,[testplan_tcversions] => testplan_tcversions,[testplans] => testplans,[testprojects] => testprojects,[testsuites] => testsuites,[text_templates] => text_templates,[transactions] => transactions,[user_assignments] => user_assignments,[user_group] => user_group,[user_group_assign] => user_group_assign,[user_testplan_roles] => user_testplan_roles,[user_testproject_roles] => user_testproject_roles,[users] => users)) called at [/var/www/html/testlink-1.9.0/install/installNewDB.php:437]
 ==============================================================================

chanukov: TestLink user; Posts: 4; Joined: Wed Jan 19, 2011 7:28 pm

Re: upgrade from 1.8.0 to 1.9.0 stuck on installNewDB.php

Quote

Post by chanukov » Fri Jan 28, 2011 10:53 pm

ok so this was resolved when doing the upgrade to 1.9.1 when i found out i needed to drop some tables to make the upgrade work

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

Re: upgrade from 1.8.0 to 1.9.0 stuck on installNewDB.php

Quote

Post by fman » Sat Jan 29, 2011 9:17 am

please share here your solution

chanukov: TestLink user; Posts: 4; Joined: Wed Jan 19, 2011 7:28 pm

Re: [SOLVED] upgrade 1.8.0 to 1.9.0 stuck on installNewDB.ph

Quote

Post by chanukov » Tue Feb 01, 2011 1:21 am

my solution involved upgrading to 1.9.1 instead of 1.9 and also after upgrade fails the first time make sure to ALTER TABLE testprojects DROP COLUMN option_reqs, DROP COLUMN option_priority, DROP COLUMN option_automation;

not certain this will fix error on 1.9.0 as well but it does lead to success for upgrade on 1.9.1

Post Reply

4 posts • Page 1 of 1

Return to “Installation and configuration”