Error upgrading from 1.8.5 to 1.9.0 MS SQL Server 2005

leol · Post by **leol** » Tue Nov 16, 2010 4:25 am

I'm having some MS SQL Server 2005 DB upgrade issues when upgrading from 1.8.5 to 1.9.0.

Here are the steps to reproduce it:
1) Create a new testlink database and testlink user on the SQL Server instance.
2) Install TestLink 1.8.5 on the newly create testlink database
3) Login as admin/admin to check that the new TestLink 1.8.5 instance is running.
4) Extract 1.9.0 and upgrade the existing TestLink DB to 1.9.0.

I will get the following error messages during the upgrade.

TestLink 1.9 (Prague) TestLink 1.9 (Prague) - Upgrade

TestLink setup will now attempt to set
TestLink setup will now attempt to setup the database:

Creating connection to Database Server: OK!

Connecting to database `testlink`: OK!
Creating Testlink DB user `testlink`: OK! (ok - user_exists ok - grant assignment)
Processing:sql/alter_tables/1.9/mssql/DB.1.3/step1/db_schema_update.sql

==============================================================================

DB Access Error - debug_print_backtrace() OUTPUT START

==============================================================================

#0 database->exec_query(
ALTER TABLE /*prefix*/builds ADD creation_ts datetime NOT NULL DEFAULT now()) called at [C:\wamp\www\testlink-1.9.0\install\sqlParser.class.php:109]
#1 SqlParser->process(sql/alter_tables/1.9/mssql/DB.1.3/step1/db_schema_update.sql) called at [C:\wamp\www\testlink-1.9.0\install\installNewDB.php:428]

==============================================================================

==============================================================================

DB Access Error - debug_print_backtrace() OUTPUT START

==============================================================================

#0 database->exec_query(
ALTER TABLE /*prefix*/user_assignments ADD build_id INT NULL DEFAULT NULL,
ALTER TABLE /*prefix*/cfield_testprojects ADD location tinyint NOT NULL DEFAULT '1') called at [C:\wamp\www\testlink-1.9.0\install\sqlParser.class.php:109]
#1 SqlParser->process(sql/alter_tables/1.9/mssql/DB.1.3/step1/db_schema_update.sql) called at [C:\wamp\www\testlink-1.9.0\install\installNewDB.php:428]

==============================================================================

==============================================================================

DB Access Error - debug_print_backtrace() OUTPUT START

==============================================================================

#0 database->exec_query(ALTER TABLE req_specs DROP title ) called at [C:\wamp\www\testlink-1.9.0\install\migration\migrate_18\migrate_18_to_19.php:159]
#1 migrate_req_specs(database Object ([db] => ADODB_mssql Object ([databaseType] => mssql,[dataProvider] => mssql,[replaceQuote] => '',[fmtDate] => 'Y-m-d',[fmtTimeStamp] => 'Y-m-d H:i:s',[hasInsertID] => 1,[substr] => substring,[length] => len,[hasAffectedRows] => 1,[metaDatabasesSQL] => select name from sysdatabases where name <> 'master',[metaTablesSQL] => select name,case when type='U' then 'T' else 'V' end from sysobjects where (type='U' or type='V') and (name not in ('sysallocations','syscolumns','syscomments','sysdepends','sysfilegroups','sysfiles','sysfiles1','sysforeignkeys','sysfulltextcatalogs','sysindexes','sysindexkeys','sysmembers','sysobjects','syspermissions','sysprotects','sysreferences','systypes','sysusers','sysalternates','sysconstraints','syssegments','REFERENTIAL_CONSTRAINTS','CHECK_CONSTRAINTS','CONSTRAINT_TABLE_USAGE','CONSTRAINT_COLUMN_USAGE','VIEWS','VIEW_TABLE_USAGE','VIEW_COLUMN_USAGE','SCHEMATA','TABLES','TABLE_CONSTRAINTS','TABLE_PRIVILEGES','COLUMNS','COLUMN_DOMAIN_USAGE','COLUMN_PRIVILEGES','DOMAINS','DOMAIN_CONSTRAINTS','KEY_COLUMN_USAGE','dtproperties')),[metaColumnsSQL] => select c.name,t.name,c.length,
(case when c.xusertype=61 then 0 else c.xprec end),
(case when c.xusertype=61 then 0 else c.xscale end)
from syscolumns c join systypes t on t.xusertype=c.xusertype join sysobjects o on o.id=c.id where o.name='%s',[hasTop] => top,[hasGenID] => 1,[sysDate] => convert(datetime,convert(char,GetDate(),102),102),[sysTimeStamp] => GetDate(),[_has_mssql_init] => 1,[maxParameterLen] => 4000,[arrayClass] => ADORecordSet_array_mssql,[uniqueSort] => 1,[leftOuter] => *=,[rightOuter] => =*,[ansiOuter] => 1,[poorAffectedRows] => 1,[identitySQL] => select SCOPE_IDENTITY(),[uniqueOrderBy] => 1,[_bindInputArray] => 1,[forceNewConnect] => ,[_dropSeqSQL] => drop table %s,[database] => testlink,[host] => 192.168.1.120,[user] => sa,[password] => tier3pass,[debug] => ,[maxblobsize] => 262144,[concat_operator] => +,[random] => rand(),[upperCase] => upper,[true] => 1,[false] => 0,[nameQuote] => ",[charSet] => ,[emptyDate] => ,[emptyTimeStamp] => ,[lastInsID] => ,[hasLimit] => ,[readOnly] => ,[hasMoveFirst] => ,[hasTransactions] => 1,[genID] => 0,[raiseErrorFn] => ,[isoDates] => ,[cacheSecs] => 3600,[memCache] => ,[memCacheHost] => ,[memCachePort] => 11211,[memCacheCompress] => ,[sysUTimeStamp] => ,[noNullStrings] => ,[numCacheHits] => 0,[numCacheMisses] => 0,[pageExecuteCountRows] => 1,[autoRollback] => ,[fnExecute] => ,[fnCacheExecute] => ,[blobEncodeType] => ,[rsPrefix] => ADORecordSet_,[autoCommit] => 1,[transOff] => 0,[transCnt] => 0,[fetchMode] => 3,[null2null] => null,[_oldRaiseFn] => ,[_transOK] => ,[_connectionID] => Resource id #56,[_errorMsg] => Could not drop constraint. See previous errors.,[_errorCode] => ,[_queryID] => ,[_isPersistentConnection] => ,[_evalAll] => ,[_affected] => ,[_logsql] => ,[_transmode] => ,[databaseName] => testlink),[queries_array] => Array (),[is_connected] => 1,[nQuery] => 11,[overallDuration] => 0.1124,[] => 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 [C:\wamp\www\testlink-1.9.0\install\migration\migrate_18\migrate_18_to_19.php:45]
#2 migrate_18_to_19(database Object ([db] => ADODB_mssql Object ([databaseType] => mssql,[dataProvider] => mssql,[replaceQuote] => '',[fmtDate] => 'Y-m-d',[fmtTimeStamp] => 'Y-m-d H:i:s',[hasInsertID] => 1,[substr] => substring,[length] => len,[hasAffectedRows] => 1,[metaDatabasesSQL] => select name from sysdatabases where name <> 'master',[metaTablesSQL] => select name,case when type='U' then 'T' else 'V' end from sysobjects where (type='U' or type='V') and (name not in ('sysallocations','syscolumns','syscomments','sysdepends','sysfilegroups','sysfiles','sysfiles1','sysforeignkeys','sysfulltextcatalogs','sysindexes','sysindexkeys','sysmembers','sysobjects','syspermissions','sysprotects','sysreferences','systypes','sysusers','sysalternates','sysconstraints','syssegments','REFERENTIAL_CONSTRAINTS','CHECK_CONSTRAINTS','CONSTRAINT_TABLE_USAGE','CONSTRAINT_COLUMN_USAGE','VIEWS','VIEW_TABLE_USAGE','VIEW_COLUMN_USAGE','SCHEMATA','TABLES','TABLE_CONSTRAINTS','TABLE_PRIVILEGES','COLUMNS','COLUMN_DOMAIN_USAGE','COLUMN_PRIVILEGES','DOMAINS','DOMAIN_CONSTRAINTS','KEY_COLUMN_USAGE','dtproperties')),[metaColumnsSQL] => select c.name,t.name,c.length,
(case when c.xusertype=61 then 0 else c.xprec end),
(case when c.xusertype=61 then 0 else c.xscale end)
from syscolumns c join systypes t on t.xusertype=c.xusertype join sysobjects o on o.id=c.id where o.name='%s',[hasTop] => top,[hasGenID] => 1,[sysDate] => convert(datetime,convert(char,GetDate(),102),102),[sysTimeStamp] => GetDate(),[_has_mssql_init] => 1,[maxParameterLen] => 4000,[arrayClass] => ADORecordSet_array_mssql,[uniqueSort] => 1,[leftOuter] => *=,[rightOuter] => =*,[ansiOuter] => 1,[poorAffectedRows] => 1,[identitySQL] => select SCOPE_IDENTITY(),[uniqueOrderBy] => 1,[_bindInputArray] => 1,[forceNewConnect] => ,[_dropSeqSQL] => drop table %s,[database] => testlink,[host] => 192.168.1.120,[user] => sa,[password] => tier3pass,[debug] => ,[maxblobsize] => 262144,[concat_operator] => +,[random] => rand(),[upperCase] => upper,[true] => 1,[false] => 0,[nameQuote] => ",[charSet] => ,[emptyDate] => ,[emptyTimeStamp] => ,[lastInsID] => ,[hasLimit] => ,[readOnly] => ,[hasMoveFirst] => ,[hasTransactions] => 1,[genID] => 0,[raiseErrorFn] => ,[isoDates] => ,[cacheSecs] => 3600,[memCache] => ,[memCacheHost] => ,[memCachePort] => 11211,[memCacheCompress] => ,[sysUTimeStamp] => ,[noNullStrings] => ,[numCacheHits] => 0,[numCacheMisses] => 0,[pageExecuteCountRows] => 1,[autoRollback] => ,[fnExecute] => ,[fnCacheExecute] => ,[blobEncodeType] => ,[rsPrefix] => ADORecordSet_,[autoCommit] => 1,[transOff] => 0,[transCnt] => 0,[fetchMode] => 3,[null2null] => null,[_oldRaiseFn] => ,[_transOK] => ,[_connectionID] => Resource id #56,[_errorMsg] => Could not drop constraint. See previous errors.,[_errorCode] => ,[_queryID] => ,[_isPersistentConnection] => ,[_evalAll] => ,[_affected] => ,[_logsql] => ,[_transmode] => ,[databaseName] => testlink),[queries_array] => Array (),[is_connected] => 1,[nQuery] => 11,[overallDuration] => 0.1124,[] => 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 [C:\wamp\www\testlink-1.9.0\install\installNewDB.php:437]

==============================================================================

migrate_testcases

==============================================================================

DB Access Error - debug_print_backtrace() OUTPUT START

==============================================================================

#0 database->exec_query(ALTER TABLE testprojects DROP option_reqs , DROP option_priority , DROP option_automation ) called at [C:\wamp\www\testlink-1.9.0\install\migration\migrate_18\migrate_18_to_19.php:211]
#1 migrate_project_options(database Object ([db] => ADODB_mssql Object ([databaseType] => mssql,[dataProvider] => mssql,[replaceQuote] => '',[fmtDate] => 'Y-m-d',[fmtTimeStamp] => 'Y-m-d H:i:s',[hasInsertID] => 1,[substr] => substring,[length] => len,[hasAffectedRows] => 1,[metaDatabasesSQL] => select name from sysdatabases where name <> 'master',[metaTablesSQL] => select name,case when type='U' then 'T' else 'V' end from sysobjects where (type='U' or type='V') and (name not in ('sysallocations','syscolumns','syscomments','sysdepends','sysfilegroups','sysfiles','sysfiles1','sysforeignkeys','sysfulltextcatalogs','sysindexes','sysindexkeys','sysmembers','sysobjects','syspermissions','sysprotects','sysreferences','systypes','sysusers','sysalternates','sysconstraints','syssegments','REFERENTIAL_CONSTRAINTS','CHECK_CONSTRAINTS','CONSTRAINT_TABLE_USAGE','CONSTRAINT_COLUMN_USAGE','VIEWS','VIEW_TABLE_USAGE','VIEW_COLUMN_USAGE','SCHEMATA','TABLES','TABLE_CONSTRAINTS','TABLE_PRIVILEGES','COLUMNS','COLUMN_DOMAIN_USAGE','COLUMN_PRIVILEGES','DOMAINS','DOMAIN_CONSTRAINTS','KEY_COLUMN_USAGE','dtproperties')),[metaColumnsSQL] => select c.name,t.name,c.length,
(case when c.xusertype=61 then 0 else c.xprec end),
(case when c.xusertype=61 then 0 else c.xscale end)
from syscolumns c join systypes t on t.xusertype=c.xusertype join sysobjects o on o.id=c.id where o.name='%s',[hasTop] => top,[hasGenID] => 1,[sysDate] => convert(datetime,convert(char,GetDate(),102),102),[sysTimeStamp] => GetDate(),[_has_mssql_init] => 1,[maxParameterLen] => 4000,[arrayClass] => ADORecordSet_array_mssql,[uniqueSort] => 1,[leftOuter] => *=,[rightOuter] => =*,[ansiOuter] => 1,[poorAffectedRows] => 1,[identitySQL] => select SCOPE_IDENTITY(),[uniqueOrderBy] => 1,[_bindInputArray] => 1,[forceNewConnect] => ,[_dropSeqSQL] => drop table %s,[database] => testlink,[host] => 192.168.1.120,[user] => sa,[password] => tier3pass,[debug] => ,[maxblobsize] => 262144,[concat_operator] => +,[random] => rand(),[upperCase] => upper,[true] => 1,[false] => 0,[nameQuote] => ",[charSet] => ,[emptyDate] => ,[emptyTimeStamp] => ,[lastInsID] => ,[hasLimit] => ,[readOnly] => ,[hasMoveFirst] => ,[hasTransactions] => 1,[genID] => 0,[raiseErrorFn] => ,[isoDates] => ,[cacheSecs] => 3600,[memCache] => ,[memCacheHost] => ,[memCachePort] => 11211,[memCacheCompress] => ,[sysUTimeStamp] => ,[noNullStrings] => ,[numCacheHits] => 0,[numCacheMisses] => 0,[pageExecuteCountRows] => 1,[autoRollback] => ,[fnExecute] => ,[fnCacheExecute] => ,[blobEncodeType] => ,[rsPrefix] => ADORecordSet_,[autoCommit] => 1,[transOff] => 0,[transCnt] => 0,[fetchMode] => 3,[null2null] => null,[_oldRaiseFn] => ,[_transOK] => ,[_connectionID] => Resource id #56,[_errorMsg] => Incorrect syntax near the keyword 'DROP'.,[_errorCode] => ,[_queryID] => ,[_isPersistentConnection] => ,[_evalAll] => ,[_affected] => ,[_logsql] => ,[_transmode] => ,[databaseName] => testlink),[queries_array] => Array (),[is_connected] => 1,[nQuery] => 14,[overallDuration] => 0.1298,[] => 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 [C:\wamp\www\testlink-1.9.0\install\migration\migrate_18\migrate_18_to_19.php:47]
#2 migrate_18_to_19(database Object ([db] => ADODB_mssql Object ([databaseType] => mssql,[dataProvider] => mssql,[replaceQuote] => '',[fmtDate] => 'Y-m-d',[fmtTimeStamp] => 'Y-m-d H:i:s',[hasInsertID] => 1,[substr] => substring,[length] => len,[hasAffectedRows] => 1,[metaDatabasesSQL] => select name from sysdatabases where name <> 'master',[metaTablesSQL] => select name,case when type='U' then 'T' else 'V' end from sysobjects where (type='U' or type='V') and (name not in ('sysallocations','syscolumns','syscomments','sysdepends','sysfilegroups','sysfiles','sysfiles1','sysforeignkeys','sysfulltextcatalogs','sysindexes','sysindexkeys','sysmembers','sysobjects','syspermissions','sysprotects','sysreferences','systypes','sysusers','sysalternates','sysconstraints','syssegments','REFERENTIAL_CONSTRAINTS','CHECK_CONSTRAINTS','CONSTRAINT_TABLE_USAGE','CONSTRAINT_COLUMN_USAGE','VIEWS','VIEW_TABLE_USAGE','VIEW_COLUMN_USAGE','SCHEMATA','TABLES','TABLE_CONSTRAINTS','TABLE_PRIVILEGES','COLUMNS','COLUMN_DOMAIN_USAGE','COLUMN_PRIVILEGES','DOMAINS','DOMAIN_CONSTRAINTS','KEY_COLUMN_USAGE','dtproperties')),[metaColumnsSQL] => select c.name,t.name,c.length,
(case when c.xusertype=61 then 0 else c.xprec end),
(case when c.xusertype=61 then 0 else c.xscale end)
from syscolumns c join systypes t on t.xusertype=c.xusertype join sysobjects o on o.id=c.id where o.name='%s',[hasTop] => top,[hasGenID] => 1,[sysDate] => convert(datetime,convert(char,GetDate(),102),102),[sysTimeStamp] => GetDate(),[_has_mssql_init] => 1,[maxParameterLen] => 4000,[arrayClass] => ADORecordSet_array_mssql,[uniqueSort] => 1,[leftOuter] => *=,[rightOuter] => =*,[ansiOuter] => 1,[poorAffectedRows] => 1,[identitySQL] => select SCOPE_IDENTITY(),[uniqueOrderBy] => 1,[_bindInputArray] => 1,[forceNewConnect] => ,[_dropSeqSQL] => drop table %s,[database] => testlink,[host] => 192.168.1.120,[user] => sa,[password] => tier3pass,[debug] => ,[maxblobsize] => 262144,[concat_operator] => +,[random] => rand(),[upperCase] => upper,[true] => 1,[false] => 0,[nameQuote] => ",[charSet] => ,[emptyDate] => ,[emptyTimeStamp] => ,[lastInsID] => ,[hasLimit] => ,[readOnly] => ,[hasMoveFirst] => ,[hasTransactions] => 1,[genID] => 0,[raiseErrorFn] => ,[isoDates] => ,[cacheSecs] => 3600,[memCache] => ,[memCacheHost] => ,[memCachePort] => 11211,[memCacheCompress] => ,[sysUTimeStamp] => ,[noNullStrings] => ,[numCacheHits] => 0,[numCacheMisses] => 0,[pageExecuteCountRows] => 1,[autoRollback] => ,[fnExecute] => ,[fnCacheExecute] => ,[blobEncodeType] => ,[rsPrefix] => ADORecordSet_,[autoCommit] => 1,[transOff] => 0,[transCnt] => 0,[fetchMode] => 3,[null2null] => null,[_oldRaiseFn] => ,[_transOK] => ,[_connectionID] => Resource id #56,[_errorMsg] => Incorrect syntax near the keyword 'DROP'.,[_errorCode] => ,[_queryID] => ,[_isPersistentConnection] => ,[_evalAll] => ,[_affected] => ,[_logsql] => ,[_transmode] => ,[databaseName] => testlink),[queries_array] => Array (),[is_connected] => 1,[nQuery] => 14,[overallDuration] => 0.1298,[] => 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 [C:\wamp\www\testlink-1.9.0\install\installNewDB.php:437]

==============================================================================

Records to process: count($workingSet)

==============================================================================

DB Access Error - debug_print_backtrace() OUTPUT START

==============================================================================

#0 database->exec_query(/*
$Revision: 1.2 $
$Date: 2010/02/13 23:00:49 $
$Author: havlat $
$Name: testlink_1_9 $
*/
INSERT INTO /*prefix*/rights (id,description) VALUES (24,'platform_management')) called at [C:\wamp\www\testlink-1.9.0\install\sqlParser.class.php:109]
#1 SqlParser->process(sql/alter_tables/1.9/mssql/DB.1.3/stepZ/z_final_step.sql) called at [C:\wamp\www\testlink-1.9.0\install\installNewDB.php:451]

==============================================================================

==============================================================================

DB Access Error - debug_print_backtrace() OUTPUT START

==============================================================================

#0 database->exec_query(
INSERT INTO /*prefix*/rights (id,description) VALUES (25,'platform_view')) called at [C:\wamp\www\testlink-1.9.0\install\sqlParser.class.php:109]
#1 SqlParser->process(sql/alter_tables/1.9/mssql/DB.1.3/stepZ/z_final_step.sql) called at [C:\wamp\www\testlink-1.9.0\install\installNewDB.php:451]

==============================================================================

==============================================================================

DB Access Error - debug_print_backtrace() OUTPUT START

==============================================================================

#0 database->exec_query(
INSERT INTO /*prefix*/rights (id,description) VALUES (26,'project_infrastructure_edit')) called at [C:\wamp\www\testlink-1.9.0\install\sqlParser.class.php:109]
#1 SqlParser->process(sql/alter_tables/1.9/mssql/DB.1.3/stepZ/z_final_step.sql) called at [C:\wamp\www\testlink-1.9.0\install\installNewDB.php:451]

==============================================================================

==============================================================================

DB Access Error - debug_print_backtrace() OUTPUT START

==============================================================================

#0 database->exec_query(
INSERT INTO /*prefix*/rights (id,description) VALUES (27,'project_infrastructure_view')) called at [C:\wamp\www\testlink-1.9.0\install\sqlParser.class.php:109]
#1 SqlParser->process(sql/alter_tables/1.9/mssql/DB.1.3/stepZ/z_final_step.sql) called at [C:\wamp\www\testlink-1.9.0\install\installNewDB.php:451]

==============================================================================

Failed! - Upgrade failed!

TestLink setup couldn't install the default site into the selected database. The last error to occur was Cannot insert explicit value for identity column in table 'rights' when IDENTITY_INSERT is set to OFF. during the execution of SQL statement INSERT INTO /*prefix*/rights (id,description) VALUES (27,'project_infrastructure_view')

And the corresponding errors in the userlog0.log log file:

[>>][4ce20752efca2649076414][DEFAULT][/testlink-1.9.0/install/installNewDB.php][10/Nov/16 04:23:46]
[10/Nov/16 04:23:48][WARNING][<nosession>][GUI]
E_WARNING
mssql_execute() [<a href='function.mssql-execute'>function.mssql-execute</a>]: message: User, group, or role 'testlink' already exists in the current database. (severity 16) - in C:\wamp\www\testlink-1.9.0\third_party\adodb\drivers\adodb-mssql.inc.php - Line 771
[10/Nov/16 04:23:48][WARNING][<nosession>][GUI]
E_WARNING
mssql_execute() [<a href='function.mssql-execute'>function.mssql-execute</a>]: stored procedure execution failed - in C:\wamp\www\testlink-1.9.0\third_party\adodb\drivers\adodb-mssql.inc.php - Line 771
[10/Nov/16 04:23:48][WARNING][<nosession>][GUI]
E_STRICT
Creating default object from empty value - in C:\wamp\www\testlink-1.9.0\install\installUtils.php - Line 985
[10/Nov/16 04:23:48][WARNING][<nosession>][GUI]
E_WARNING
mssql_query() [<a href='function.mssql-query'>function.mssql-query</a>]: message: 'now' is not a recognized built-in function name. (severity 15) - in C:\wamp\www\testlink-1.9.0\third_party\adodb\drivers\adodb-mssql.inc.php - Line 775
[10/Nov/16 04:23:48][WARNING][<nosession>][GUI]
E_WARNING
mssql_query() [<a href='function.mssql-query'>function.mssql-query</a>]: Query failed - in C:\wamp\www\testlink-1.9.0\third_party\adodb\drivers\adodb-mssql.inc.php - Line 775
[10/Nov/16 04:23:48][ERROR][<nosession>][DATABASE]
ERROR ON exec_query() - database.class.php 0 - 'now' is not a recognized built-in function name. -
ALTER TABLE /*prefix*/builds ADD creation_ts datetime NOT NULL DEFAULT now() THE MESSAGE : SQL [4] executed [took 0.0051 secs][all took 0.0181 secs]:

ALTER TABLE /*prefix*/builds ADD creation_ts datetime NOT NULL DEFAULT now()
Query failed: errorcode[195]
errormsg:'now' is not a recognized built-in function name.
[10/Nov/16 04:23:48][WARNING][<nosession>][GUI]
E_WARNING
mssql_query() [<a href='function.mssql-query'>function.mssql-query</a>]: message: Incorrect syntax near the keyword 'ALTER'. (severity 15) - in C:\wamp\www\testlink-1.9.0\third_party\adodb\drivers\adodb-mssql.inc.php - Line 775
[10/Nov/16 04:23:48][WARNING][<nosession>][GUI]
E_WARNING
mssql_query() [<a href='function.mssql-query'>function.mssql-query</a>]: Query failed - in C:\wamp\www\testlink-1.9.0\third_party\adodb\drivers\adodb-mssql.inc.php - Line 775
[10/Nov/16 04:23:48][ERROR][<nosession>][DATABASE]
ERROR ON exec_query() - database.class.php 0 - Incorrect syntax near the keyword 'ALTER'. -
ALTER TABLE /*prefix*/user_assignments ADD build_id INT NULL DEFAULT NULL,
ALTER TABLE /*prefix*/cfield_testprojects ADD location tinyint NOT NULL DEFAULT '1' THE MESSAGE : SQL [6] executed [took 0.0053 secs][all took 0.0315 secs]:

ALTER TABLE /*prefix*/user_assignments ADD build_id INT NULL DEFAULT NULL,
ALTER TABLE /*prefix*/cfield_testprojects ADD location tinyint NOT NULL DEFAULT '1'
Query failed: errorcode[156]
errormsg:Incorrect syntax near the keyword 'ALTER'.
[10/Nov/16 04:23:48][WARNING][<nosession>][GUI]
E_WARNING
mssql_query() [<a href='function.mssql-query'>function.mssql-query</a>]: message: 'title' is not a constraint. (severity 16) - in C:\wamp\www\testlink-1.9.0\third_party\adodb\drivers\adodb-mssql.inc.php - Line 775
[10/Nov/16 04:23:48][WARNING][<nosession>][GUI]
E_WARNING
mssql_query() [<a href='function.mssql-query'>function.mssql-query</a>]: message: Could not drop constraint. See previous errors. (severity 16) - in C:\wamp\www\testlink-1.9.0\third_party\adodb\drivers\adodb-mssql.inc.php - Line 775
[10/Nov/16 04:23:48][WARNING][<nosession>][GUI]
E_WARNING
mssql_query() [<a href='function.mssql-query'>function.mssql-query</a>]: Query failed - in C:\wamp\www\testlink-1.9.0\third_party\adodb\drivers\adodb-mssql.inc.php - Line 775
[10/Nov/16 04:23:48][ERROR][<nosession>][DATABASE]
ERROR ON exec_query() - database.class.php 0 - Could not drop constraint. See previous errors. - ALTER TABLE req_specs DROP title THE MESSAGE : SQL [11] executed [took 0.0100 secs][all took 0.0588 secs]:
ALTER TABLE req_specs DROP title
Query failed: errorcode[3727]
errormsg:Could not drop constraint. See previous errors.
[10/Nov/16 04:23:48][WARNING][<nosession>][GUI]
E_WARNING
mssql_query() [<a href='function.mssql-query'>function.mssql-query</a>]: message: Incorrect syntax near the keyword 'DROP'. (severity 15) - in C:\wamp\www\testlink-1.9.0\third_party\adodb\drivers\adodb-mssql.inc.php - Line 775
[10/Nov/16 04:23:48][WARNING][<nosession>][GUI]
E_WARNING
mssql_query() [<a href='function.mssql-query'>function.mssql-query</a>]: Query failed - in C:\wamp\www\testlink-1.9.0\third_party\adodb\drivers\adodb-mssql.inc.php - Line 775
[10/Nov/16 04:23:48][ERROR][<nosession>][DATABASE]
ERROR ON exec_query() - database.class.php 0 - Incorrect syntax near the keyword 'DROP'. - ALTER TABLE testprojects DROP option_reqs , DROP option_priority , DROP option_automation THE MESSAGE : SQL [14] executed [took 0.0066 secs][all took 0.0802 secs]:
ALTER TABLE testprojects DROP option_reqs , DROP option_priority , DROP option_automation
Query failed: errorcode[156]
errormsg:Incorrect syntax near the keyword 'DROP'.
[10/Nov/16 04:23:48][WARNING][<nosession>][GUI]
E_WARNING
Invalid argument supplied for foreach() - in C:\wamp\www\testlink-1.9.0\install\migration\migrate_18\migrate_18_to_19.php - Line 358
[10/Nov/16 04:23:48][WARNING][<nosession>][GUI]
E_NOTICE
Undefined variable: nodesTypes - in C:\wamp\www\testlink-1.9.0\install\migration\migrate_18\migrate_18_to_19.php - Line 406
[10/Nov/16 04:23:48][WARNING][<nosession>][GUI]
E_WARNING
mssql_query() [<a href='function.mssql-query'>function.mssql-query</a>]: message: Cannot insert explicit value for identity column in table 'rights' when IDENTITY_INSERT is set to OFF. (severity 16) - in C:\wamp\www\testlink-1.9.0\third_party\adodb\drivers\adodb-mssql.inc.php - Line 775
[10/Nov/16 04:23:48][WARNING][<nosession>][GUI]
E_WARNING
mssql_query() [<a href='function.mssql-query'>function.mssql-query</a>]: Query failed - in C:\wamp\www\testlink-1.9.0\third_party\adodb\drivers\adodb-mssql.inc.php - Line 775
[10/Nov/16 04:23:48][ERROR][<nosession>][DATABASE]
ERROR ON exec_query() - database.class.php 0 - Cannot insert explicit value for identity column in table 'rights' when IDENTITY_INSERT is set to OFF. - /*
$Revision: 1.2 $
$Date: 2010/02/13 23:00:49 $
$Author: havlat $
$Name: testlink_1_9 $
*/
INSERT INTO /*prefix*/rights (id,description) VALUES (24,'platform_management') THE MESSAGE : SQL [20] executed [took 0.0060 secs][all took 0.1298 secs]:
/*
$Revision: 1.2 $
$Date: 2010/02/13 23:00:49 $
$Author: havlat $
$Name: testlink_1_9 $
*/
INSERT INTO /*prefix*/rights (id,description) VALUES (24,'platform_management')
Query failed: errorcode[544]
errormsg:Cannot insert explicit value for identity column in table 'rights' when IDENTITY_INSERT is set to OFF.
[10/Nov/16 04:23:49][WARNING][<nosession>][GUI]
E_WARNING
mssql_query() [<a href='function.mssql-query'>function.mssql-query</a>]: message: Cannot insert explicit value for identity column in table 'rights' when IDENTITY_INSERT is set to OFF. (severity 16) - in C:\wamp\www\testlink-1.9.0\third_party\adodb\drivers\adodb-mssql.inc.php - Line 775
[10/Nov/16 04:23:49][WARNING][<nosession>][GUI]
E_WARNING
mssql_query() [<a href='function.mssql-query'>function.mssql-query</a>]: Query failed - in C:\wamp\www\testlink-1.9.0\third_party\adodb\drivers\adodb-mssql.inc.php - Line 775
[10/Nov/16 04:23:49][ERROR][<nosession>][DATABASE]
ERROR ON exec_query() - database.class.php 0 - Cannot insert explicit value for identity column in table 'rights' when IDENTITY_INSERT is set to OFF. -
INSERT INTO /*prefix*/rights (id,description) VALUES (25,'platform_view') THE MESSAGE : SQL [21] executed [took 0.0073 secs][all took 0.1431 secs]:

INSERT INTO /*prefix*/rights (id,description) VALUES (25,'platform_view')
Query failed: errorcode[544]
errormsg:Cannot insert explicit value for identity column in table 'rights' when IDENTITY_INSERT is set to OFF.
[10/Nov/16 04:23:49][WARNING][<nosession>][GUI]
E_WARNING
mssql_query() [<a href='function.mssql-query'>function.mssql-query</a>]: message: Cannot insert explicit value for identity column in table 'rights' when IDENTITY_INSERT is set to OFF. (severity 16) - in C:\wamp\www\testlink-1.9.0\third_party\adodb\drivers\adodb-mssql.inc.php - Line 775
[10/Nov/16 04:23:49][WARNING][<nosession>][GUI]
E_WARNING
mssql_query() [<a href='function.mssql-query'>function.mssql-query</a>]: Query failed - in C:\wamp\www\testlink-1.9.0\third_party\adodb\drivers\adodb-mssql.inc.php - Line 775
[10/Nov/16 04:23:49][ERROR][<nosession>][DATABASE]
ERROR ON exec_query() - database.class.php 0 - Cannot insert explicit value for identity column in table 'rights' when IDENTITY_INSERT is set to OFF. -
INSERT INTO /*prefix*/rights (id,description) VALUES (26,'project_infrastructure_edit') THE MESSAGE : SQL [22] executed [took 0.0076 secs][all took 0.158 secs]:

INSERT INTO /*prefix*/rights (id,description) VALUES (26,'project_infrastructure_edit')
Query failed: errorcode[544]
errormsg:Cannot insert explicit value for identity column in table 'rights' when IDENTITY_INSERT is set to OFF.
[10/Nov/16 04:23:49][WARNING][<nosession>][GUI]
E_WARNING
mssql_query() [<a href='function.mssql-query'>function.mssql-query</a>]: message: Cannot insert explicit value for identity column in table 'rights' when IDENTITY_INSERT is set to OFF. (severity 16) - in C:\wamp\www\testlink-1.9.0\third_party\adodb\drivers\adodb-mssql.inc.php - Line 775
[10/Nov/16 04:23:49][WARNING][<nosession>][GUI]
E_WARNING
mssql_query() [<a href='function.mssql-query'>function.mssql-query</a>]: Query failed - in C:\wamp\www\testlink-1.9.0\third_party\adodb\drivers\adodb-mssql.inc.php - Line 775
[10/Nov/16 04:23:49][ERROR][<nosession>][DATABASE]
ERROR ON exec_query() - database.class.php 0 - Cannot insert explicit value for identity column in table 'rights' when IDENTITY_INSERT is set to OFF. -
INSERT INTO /*prefix*/rights (id,description) VALUES (27,'project_infrastructure_view') THE MESSAGE : SQL [23] executed [took 0.0066 secs][all took 0.1722 secs]:

INSERT INTO /*prefix*/rights (id,description) VALUES (27,'project_infrastructure_view')
Query failed: errorcode[544]
errormsg:Cannot insert explicit value for identity column in table 'rights' when IDENTITY_INSERT is set to OFF.
[<<][4ce20752efca2649076414][DEFAULT][/testlink-1.9.0/install/installNewDB.php][10/Nov/16 04:23:46][10/Nov/16 04:23:49][took 2.147045 secs]

Please let me know if there are any suggestions. Thanks.

Post by **fman** » Tue Nov 16, 2010 3:33 pm

SQL server 2008 is unsupported

leol · Post by **leol** » Wed Nov 17, 2010 7:03 am

This issue occurs on MS SQL Server 2005.
As you can see from the errors logs, they are mostly syntax errors in the scripts
install\sql\alter_tables\1.9\mssql\DB.1.3\step1\db_schema_update.sql
install\sql\alter_tables\1.9\mssql\DB.1.3\stepZ\z_final_step.sql

Post by **fman** » Wed Nov 17, 2010 9:34 pm

If you can send me your DB I will test migration procedure
depending size mail can not be good option => use dropbox or other site of this type

francisco.mancardi@gmail.com

leol · Post by **leol** » Thu Nov 18, 2010 2:16 am

The problem occurs when upgrading a fresh install of 1.8.5 to 1.9.0.
Do you really need me to send you the DB?

Anyway I have resolved some of the issues in the scripts, please commit it cvs for me.
install\sql\alter_tables\1.9\mssql\DB.1.3\step1\db_schema_update.sql
install\sql\alter_tables\1.9\mssql\DB.1.3\stepZ\z_final_step.sql

db_schema_update.sql:

Code: Select all

-- $Revision: 1.2 $
-- $Date: 2010/07/22 14:14:46 $
-- $Author: asimon83 $
-- $RCSfile: db_schema_update.sql,v $
-- DB: MSSQL
--
-- 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.
--
--
-- rev: 
-- 20100705 - asimon - added new column build_id to user_assignments
--
-- Step 1 - Drops if needed

-- Step 2 - new tables
--

-- Step 3 - table changes

-- testprojects
ALTER TABLE /*prefix*/testprojects ADD is_public tinyint NOT NULL DEFAULT '1';

-- testplans
ALTER TABLE /*prefix*/testplans ADD is_public tinyint NOT NULL DEFAULT '1';

-- builds
ALTER TABLE /*prefix*/builds ADD author_id INT NULL DEFAULT NULL;
ALTER TABLE /*prefix*/builds ADD creation_ts datetime NOT NULL DEFAULT GETDATE();
ALTER TABLE /*prefix*/builds ADD relase_date datetime NOT NULL;

-- user_assignments
ALTER TABLE /*prefix*/user_assignments ADD build_id INT NULL DEFAULT NULL;

-- cfield_testprojects
ALTER TABLE /*prefix*/cfield_testprojects  ADD location tinyint NOT NULL DEFAULT '1';

-- tcversions

-- testplan_tcversions
ALTER TABLE testplan_tcversions ADD author_id INT NULL DEFAULT NULL;
ALTER TABLE testplan_tcversions ADD creation_ts DATETIME NOT NULL DEFAULT GETDATE();

z_final_step.sql:

Code: Select all

/* 
$Revision: 1.2 $
$Date: 2010/02/13 23:00:49 $
$Author: havlat $
$Name: testlink_1_9 $
*/
set IDENTITY_INSERT rights on;
INSERT INTO /*prefix*/rights (id,description) VALUES (24,'platform_management');
INSERT INTO /*prefix*/rights (id,description) VALUES (25,'platform_view');
INSERT INTO /*prefix*/rights (id,description) VALUES (26,'project_infrastructure_edit');
INSERT INTO /*prefix*/rights (id,description) VALUES (27,'project_infrastructure_view');
set IDENTITY_INSERT rights off;

INSERT INTO /*prefix*/role_rights (role_id,right_id) VALUES (8,24);
INSERT INTO /*prefix*/role_rights (role_id,right_id) VALUES (8,25);
INSERT INTO /*prefix*/role_rights (role_id,right_id) VALUES (8,26);
INSERT INTO /*prefix*/role_rights (role_id,right_id) VALUES (8,27);
INSERT INTO /*prefix*/role_rights (role_id,right_id) VALUES (9,24);
INSERT INTO /*prefix*/role_rights (role_id,right_id) VALUES (9,25);
INSERT INTO /*prefix*/role_rights (role_id,right_id) VALUES (9,26);
INSERT INTO /*prefix*/role_rights (role_id,right_id) VALUES (9,27);
INSERT INTO /*prefix*/role_rights (role_id,right_id) VALUES (6,25);
INSERT INTO /*prefix*/role_rights (role_id,right_id) VALUES (6,27);

INSERT INTO /*prefix*/db_version (version,upgrade_ts,notes) VALUES ('DB 1.3',GETDATE(),'');

Here are the remaining errors after applying the script fixes above:
From the web interface:

TestLink 1.9 (Prague) TestLink 1.9 (Prague) - Upgrade

TestLink setup will now attempt to setup the database:

Creating connection to Database Server: OK!

Connecting to database `testlink`: OK!
Creating Testlink DB user `testlink`: OK! (ok - user_exists ok - grant assignment)
Processing:sql/alter_tables/1.9/mssql/DB.1.3/step1/db_schema_update.sql

==============================================================================

DB Access Error - debug_print_backtrace() OUTPUT START

==============================================================================

#0 database->exec_query(ALTER TABLE req_specs DROP title ) called at [C:\wamp\www\testlink-1.9.0\install\migration\migrate_18\migrate_18_to_19.php:159]
#1 migrate_req_specs(database Object ([db] => ADODB_mssql Object ([databaseType] => mssql,[dataProvider] => mssql,[replaceQuote] => '',[fmtDate] => 'Y-m-d',[fmtTimeStamp] => 'Y-m-d H:i:s',[hasInsertID] => 1,[substr] => substring,[length] => len,[hasAffectedRows] => 1,[metaDatabasesSQL] => select name from sysdatabases where name <> 'master',[metaTablesSQL] => select name,case when type='U' then 'T' else 'V' end from sysobjects where (type='U' or type='V') and (name not in ('sysallocations','syscolumns','syscomments','sysdepends','sysfilegroups','sysfiles','sysfiles1','sysforeignkeys','sysfulltextcatalogs','sysindexes','sysindexkeys','sysmembers','sysobjects','syspermissions','sysprotects','sysreferences','systypes','sysusers','sysalternates','sysconstraints','syssegments','REFERENTIAL_CONSTRAINTS','CHECK_CONSTRAINTS','CONSTRAINT_TABLE_USAGE','CONSTRAINT_COLUMN_USAGE','VIEWS','VIEW_TABLE_USAGE','VIEW_COLUMN_USAGE','SCHEMATA','TABLES','TABLE_CONSTRAINTS','TABLE_PRIVILEGES','COLUMNS','COLUMN_DOMAIN_USAGE','COLUMN_PRIVILEGES','DOMAINS','DOMAIN_CONSTRAINTS','KEY_COLUMN_USAGE','dtproperties')),[metaColumnsSQL] => select c.name,t.name,c.length,
(case when c.xusertype=61 then 0 else c.xprec end),
(case when c.xusertype=61 then 0 else c.xscale end)
from syscolumns c join systypes t on t.xusertype=c.xusertype join sysobjects o on o.id=c.id where o.name='%s',[hasTop] => top,[hasGenID] => 1,[sysDate] => convert(datetime,convert(char,GetDate(),102),102),[sysTimeStamp] => GetDate(),[_has_mssql_init] => 1,[maxParameterLen] => 4000,[arrayClass] => ADORecordSet_array_mssql,[uniqueSort] => 1,[leftOuter] => *=,[rightOuter] => =*,[ansiOuter] => 1,[poorAffectedRows] => 1,[identitySQL] => select SCOPE_IDENTITY(),[uniqueOrderBy] => 1,[_bindInputArray] => 1,[forceNewConnect] => ,[_dropSeqSQL] => drop table %s,[database] => testlink,[host] => 192.168.1.73,[user] => sa,[password] => tier3pass,[debug] => ,[maxblobsize] => 262144,[concat_operator] => +,[random] => rand(),[upperCase] => upper,[true] => 1,[false] => 0,[nameQuote] => ",[charSet] => ,[emptyDate] => ,[emptyTimeStamp] => ,[lastInsID] => ,[hasLimit] => ,[readOnly] => ,[hasMoveFirst] => ,[hasTransactions] => 1,[genID] => 0,[raiseErrorFn] => ,[isoDates] => ,[cacheSecs] => 3600,[memCache] => ,[memCacheHost] => ,[memCachePort] => 11211,[memCacheCompress] => ,[sysUTimeStamp] => ,[noNullStrings] => ,[numCacheHits] => 0,[numCacheMisses] => 0,[pageExecuteCountRows] => 1,[autoRollback] => ,[fnExecute] => ,[fnCacheExecute] => ,[blobEncodeType] => ,[rsPrefix] => ADORecordSet_,[autoCommit] => 1,[transOff] => 0,[transCnt] => 0,[fetchMode] => 3,[null2null] => null,[_oldRaiseFn] => ,[_transOK] => ,[_connectionID] => Resource id #56,[_errorMsg] => Could not drop constraint. See previous errors.,[_errorCode] => ,[_queryID] => ,[_isPersistentConnection] => ,[_evalAll] => ,[_affected] => ,[_logsql] => ,[_transmode] => ,[databaseName] => testlink),[queries_array] => Array (),[is_connected] => 1,[nQuery] => 12,[overallDuration] => 0.1294,[] => 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 [C:\wamp\www\testlink-1.9.0\install\migration\migrate_18\migrate_18_to_19.php:45]
#2 migrate_18_to_19(database Object ([db] => ADODB_mssql Object ([databaseType] => mssql,[dataProvider] => mssql,[replaceQuote] => '',[fmtDate] => 'Y-m-d',[fmtTimeStamp] => 'Y-m-d H:i:s',[hasInsertID] => 1,[substr] => substring,[length] => len,[hasAffectedRows] => 1,[metaDatabasesSQL] => select name from sysdatabases where name <> 'master',[metaTablesSQL] => select name,case when type='U' then 'T' else 'V' end from sysobjects where (type='U' or type='V') and (name not in ('sysallocations','syscolumns','syscomments','sysdepends','sysfilegroups','sysfiles','sysfiles1','sysforeignkeys','sysfulltextcatalogs','sysindexes','sysindexkeys','sysmembers','sysobjects','syspermissions','sysprotects','sysreferences','systypes','sysusers','sysalternates','sysconstraints','syssegments','REFERENTIAL_CONSTRAINTS','CHECK_CONSTRAINTS','CONSTRAINT_TABLE_USAGE','CONSTRAINT_COLUMN_USAGE','VIEWS','VIEW_TABLE_USAGE','VIEW_COLUMN_USAGE','SCHEMATA','TABLES','TABLE_CONSTRAINTS','TABLE_PRIVILEGES','COLUMNS','COLUMN_DOMAIN_USAGE','COLUMN_PRIVILEGES','DOMAINS','DOMAIN_CONSTRAINTS','KEY_COLUMN_USAGE','dtproperties')),[metaColumnsSQL] => select c.name,t.name,c.length,
(case when c.xusertype=61 then 0 else c.xprec end),
(case when c.xusertype=61 then 0 else c.xscale end)
from syscolumns c join systypes t on t.xusertype=c.xusertype join sysobjects o on o.id=c.id where o.name='%s',[hasTop] => top,[hasGenID] => 1,[sysDate] => convert(datetime,convert(char,GetDate(),102),102),[sysTimeStamp] => GetDate(),[_has_mssql_init] => 1,[maxParameterLen] => 4000,[arrayClass] => ADORecordSet_array_mssql,[uniqueSort] => 1,[leftOuter] => *=,[rightOuter] => =*,[ansiOuter] => 1,[poorAffectedRows] => 1,[identitySQL] => select SCOPE_IDENTITY(),[uniqueOrderBy] => 1,[_bindInputArray] => 1,[forceNewConnect] => ,[_dropSeqSQL] => drop table %s,[database] => testlink,[host] => 192.168.1.73,[user] => sa,[password] => tier3pass,[debug] => ,[maxblobsize] => 262144,[concat_operator] => +,[random] => rand(),[upperCase] => upper,[true] => 1,[false] => 0,[nameQuote] => ",[charSet] => ,[emptyDate] => ,[emptyTimeStamp] => ,[lastInsID] => ,[hasLimit] => ,[readOnly] => ,[hasMoveFirst] => ,[hasTransactions] => 1,[genID] => 0,[raiseErrorFn] => ,[isoDates] => ,[cacheSecs] => 3600,[memCache] => ,[memCacheHost] => ,[memCachePort] => 11211,[memCacheCompress] => ,[sysUTimeStamp] => ,[noNullStrings] => ,[numCacheHits] => 0,[numCacheMisses] => 0,[pageExecuteCountRows] => 1,[autoRollback] => ,[fnExecute] => ,[fnCacheExecute] => ,[blobEncodeType] => ,[rsPrefix] => ADORecordSet_,[autoCommit] => 1,[transOff] => 0,[transCnt] => 0,[fetchMode] => 3,[null2null] => null,[_oldRaiseFn] => ,[_transOK] => ,[_connectionID] => Resource id #56,[_errorMsg] => Could not drop constraint. See previous errors.,[_errorCode] => ,[_queryID] => ,[_isPersistentConnection] => ,[_evalAll] => ,[_affected] => ,[_logsql] => ,[_transmode] => ,[databaseName] => testlink),[queries_array] => Array (),[is_connected] => 1,[nQuery] => 12,[overallDuration] => 0.1294,[] => 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 [C:\wamp\www\testlink-1.9.0\install\installNewDB.php:437]

==============================================================================

migrate_testcases

==============================================================================

DB Access Error - debug_print_backtrace() OUTPUT START

==============================================================================

#0 database->exec_query(ALTER TABLE testprojects DROP option_reqs , DROP option_priority , DROP option_automation ) called at [C:\wamp\www\testlink-1.9.0\install\migration\migrate_18\migrate_18_to_19.php:211]
#1 migrate_project_options(database Object ([db] => ADODB_mssql Object ([databaseType] => mssql,[dataProvider] => mssql,[replaceQuote] => '',[fmtDate] => 'Y-m-d',[fmtTimeStamp] => 'Y-m-d H:i:s',[hasInsertID] => 1,[substr] => substring,[length] => len,[hasAffectedRows] => 1,[metaDatabasesSQL] => select name from sysdatabases where name <> 'master',[metaTablesSQL] => select name,case when type='U' then 'T' else 'V' end from sysobjects where (type='U' or type='V') and (name not in ('sysallocations','syscolumns','syscomments','sysdepends','sysfilegroups','sysfiles','sysfiles1','sysforeignkeys','sysfulltextcatalogs','sysindexes','sysindexkeys','sysmembers','sysobjects','syspermissions','sysprotects','sysreferences','systypes','sysusers','sysalternates','sysconstraints','syssegments','REFERENTIAL_CONSTRAINTS','CHECK_CONSTRAINTS','CONSTRAINT_TABLE_USAGE','CONSTRAINT_COLUMN_USAGE','VIEWS','VIEW_TABLE_USAGE','VIEW_COLUMN_USAGE','SCHEMATA','TABLES','TABLE_CONSTRAINTS','TABLE_PRIVILEGES','COLUMNS','COLUMN_DOMAIN_USAGE','COLUMN_PRIVILEGES','DOMAINS','DOMAIN_CONSTRAINTS','KEY_COLUMN_USAGE','dtproperties')),[metaColumnsSQL] => select c.name,t.name,c.length,
(case when c.xusertype=61 then 0 else c.xprec end),
(case when c.xusertype=61 then 0 else c.xscale end)
from syscolumns c join systypes t on t.xusertype=c.xusertype join sysobjects o on o.id=c.id where o.name='%s',[hasTop] => top,[hasGenID] => 1,[sysDate] => convert(datetime,convert(char,GetDate(),102),102),[sysTimeStamp] => GetDate(),[_has_mssql_init] => 1,[maxParameterLen] => 4000,[arrayClass] => ADORecordSet_array_mssql,[uniqueSort] => 1,[leftOuter] => *=,[rightOuter] => =*,[ansiOuter] => 1,[poorAffectedRows] => 1,[identitySQL] => select SCOPE_IDENTITY(),[uniqueOrderBy] => 1,[_bindInputArray] => 1,[forceNewConnect] => ,[_dropSeqSQL] => drop table %s,[database] => testlink,[host] => 192.168.1.73,[user] => sa,[password] => tier3pass,[debug] => ,[maxblobsize] => 262144,[concat_operator] => +,[random] => rand(),[upperCase] => upper,[true] => 1,[false] => 0,[nameQuote] => ",[charSet] => ,[emptyDate] => ,[emptyTimeStamp] => ,[lastInsID] => ,[hasLimit] => ,[readOnly] => ,[hasMoveFirst] => ,[hasTransactions] => 1,[genID] => 0,[raiseErrorFn] => ,[isoDates] => ,[cacheSecs] => 3600,[memCache] => ,[memCacheHost] => ,[memCachePort] => 11211,[memCacheCompress] => ,[sysUTimeStamp] => ,[noNullStrings] => ,[numCacheHits] => 0,[numCacheMisses] => 0,[pageExecuteCountRows] => 1,[autoRollback] => ,[fnExecute] => ,[fnCacheExecute] => ,[blobEncodeType] => ,[rsPrefix] => ADORecordSet_,[autoCommit] => 1,[transOff] => 0,[transCnt] => 0,[fetchMode] => 3,[null2null] => null,[_oldRaiseFn] => ,[_transOK] => ,[_connectionID] => Resource id #56,[_errorMsg] => Unknown object type 'option_automation' used in a CREATE, DROP, or ALTER statement.,[_errorCode] => ,[_queryID] => ,[_isPersistentConnection] => ,[_evalAll] => ,[_affected] => ,[_logsql] => ,[_transmode] => ,[databaseName] => testlink),[queries_array] => Array (),[is_connected] => 1,[nQuery] => 15,[overallDuration] => 0.1986,[] => 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 [C:\wamp\www\testlink-1.9.0\install\migration\migrate_18\migrate_18_to_19.php:47]
#2 migrate_18_to_19(database Object ([db] => ADODB_mssql Object ([databaseType] => mssql,[dataProvider] => mssql,[replaceQuote] => '',[fmtDate] => 'Y-m-d',[fmtTimeStamp] => 'Y-m-d H:i:s',[hasInsertID] => 1,[substr] => substring,[length] => len,[hasAffectedRows] => 1,[metaDatabasesSQL] => select name from sysdatabases where name <> 'master',[metaTablesSQL] => select name,case when type='U' then 'T' else 'V' end from sysobjects where (type='U' or type='V') and (name not in ('sysallocations','syscolumns','syscomments','sysdepends','sysfilegroups','sysfiles','sysfiles1','sysforeignkeys','sysfulltextcatalogs','sysindexes','sysindexkeys','sysmembers','sysobjects','syspermissions','sysprotects','sysreferences','systypes','sysusers','sysalternates','sysconstraints','syssegments','REFERENTIAL_CONSTRAINTS','CHECK_CONSTRAINTS','CONSTRAINT_TABLE_USAGE','CONSTRAINT_COLUMN_USAGE','VIEWS','VIEW_TABLE_USAGE','VIEW_COLUMN_USAGE','SCHEMATA','TABLES','TABLE_CONSTRAINTS','TABLE_PRIVILEGES','COLUMNS','COLUMN_DOMAIN_USAGE','COLUMN_PRIVILEGES','DOMAINS','DOMAIN_CONSTRAINTS','KEY_COLUMN_USAGE','dtproperties')),[metaColumnsSQL] => select c.name,t.name,c.length,
(case when c.xusertype=61 then 0 else c.xprec end),
(case when c.xusertype=61 then 0 else c.xscale end)
from syscolumns c join systypes t on t.xusertype=c.xusertype join sysobjects o on o.id=c.id where o.name='%s',[hasTop] => top,[hasGenID] => 1,[sysDate] => convert(datetime,convert(char,GetDate(),102),102),[sysTimeStamp] => GetDate(),[_has_mssql_init] => 1,[maxParameterLen] => 4000,[arrayClass] => ADORecordSet_array_mssql,[uniqueSort] => 1,[leftOuter] => *=,[rightOuter] => =*,[ansiOuter] => 1,[poorAffectedRows] => 1,[identitySQL] => select SCOPE_IDENTITY(),[uniqueOrderBy] => 1,[_bindInputArray] => 1,[forceNewConnect] => ,[_dropSeqSQL] => drop table %s,[database] => testlink,[host] => 192.168.1.73,[user] => sa,[password] => tier3pass,[debug] => ,[maxblobsize] => 262144,[concat_operator] => +,[random] => rand(),[upperCase] => upper,[true] => 1,[false] => 0,[nameQuote] => ",[charSet] => ,[emptyDate] => ,[emptyTimeStamp] => ,[lastInsID] => ,[hasLimit] => ,[readOnly] => ,[hasMoveFirst] => ,[hasTransactions] => 1,[genID] => 0,[raiseErrorFn] => ,[isoDates] => ,[cacheSecs] => 3600,[memCache] => ,[memCacheHost] => ,[memCachePort] => 11211,[memCacheCompress] => ,[sysUTimeStamp] => ,[noNullStrings] => ,[numCacheHits] => 0,[numCacheMisses] => 0,[pageExecuteCountRows] => 1,[autoRollback] => ,[fnExecute] => ,[fnCacheExecute] => ,[blobEncodeType] => ,[rsPrefix] => ADORecordSet_,[autoCommit] => 1,[transOff] => 0,[transCnt] => 0,[fetchMode] => 3,[null2null] => null,[_oldRaiseFn] => ,[_transOK] => ,[_connectionID] => Resource id #56,[_errorMsg] => Unknown object type 'option_automation' used in a CREATE, DROP, or ALTER statement.,[_errorCode] => ,[_queryID] => ,[_isPersistentConnection] => ,[_evalAll] => ,[_affected] => ,[_logsql] => ,[_transmode] => ,[databaseName] => testlink),[queries_array] => Array (),[is_connected] => 1,[nQuery] => 15,[overallDuration] => 0.1986,[] => 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 [C:\wamp\www\testlink-1.9.0\install\installNewDB.php:437]

==============================================================================

Records to process: count($workingSet)
OK!
Writing configuration file: OK!

YOUR ATTENTION PLEASE:
To have a fully functional installation You need to configure mail server settings, following this steps

* copy from config.inc.php, [SMTP] Section into custom_config.inc.php.
* complete correct data regarding email addresses and mail server.

Upgrade was successful!
You can now log into the TestLink (using login name:admin / password:admin - Please Click Me!).

From the logs:

[>>][4ce47f52d6965880714252][DEFAULT][/testlink-1.9.0/install/installNewDB.php][10/Nov/18 01:20:18]
[10/Nov/18 01:20:20][WARNING][<nosession>][GUI]
E_WARNING
mssql_execute() [<a href='function.mssql-execute'>function.mssql-execute</a>]: message: User, group, or role 'testlink' already exists in the current database. (severity 16) - in C:\wamp\www\testlink-1.9.0\third_party\adodb\drivers\adodb-mssql.inc.php - Line 771
[10/Nov/18 01:20:20][WARNING][<nosession>][GUI]
E_WARNING
mssql_execute() [<a href='function.mssql-execute'>function.mssql-execute</a>]: stored procedure execution failed - in C:\wamp\www\testlink-1.9.0\third_party\adodb\drivers\adodb-mssql.inc.php - Line 771
[10/Nov/18 01:20:20][WARNING][<nosession>][GUI]
E_STRICT
Creating default object from empty value - in C:\wamp\www\testlink-1.9.0\install\installUtils.php - Line 985
[10/Nov/18 01:20:20][WARNING][<nosession>][GUI]
E_WARNING
mssql_query() [<a href='function.mssql-query'>function.mssql-query</a>]: message: 'title' is not a constraint. (severity 16) - in C:\wamp\www\testlink-1.9.0\third_party\adodb\drivers\adodb-mssql.inc.php - Line 775
[10/Nov/18 01:20:20][WARNING][<nosession>][GUI]
E_WARNING
mssql_query() [<a href='function.mssql-query'>function.mssql-query</a>]: message: Could not drop constraint. See previous errors. (severity 16) - in C:\wamp\www\testlink-1.9.0\third_party\adodb\drivers\adodb-mssql.inc.php - Line 775
[10/Nov/18 01:20:20][WARNING][<nosession>][GUI]
E_WARNING
mssql_query() [<a href='function.mssql-query'>function.mssql-query</a>]: Query failed - in C:\wamp\www\testlink-1.9.0\third_party\adodb\drivers\adodb-mssql.inc.php - Line 775
[10/Nov/18 01:20:20][ERROR][<nosession>][DATABASE]
ERROR ON exec_query() - database.class.php 0 - Could not drop constraint. See previous errors. - ALTER TABLE req_specs DROP title THE MESSAGE : SQL [12] executed [took 0.0094 secs][all took 0.12 secs]:
ALTER TABLE req_specs DROP title
Query failed: errorcode[3727]
errormsg:Could not drop constraint. See previous errors.
[10/Nov/18 01:20:20][WARNING][<nosession>][GUI]
E_WARNING
mssql_query() [<a href='function.mssql-query'>function.mssql-query</a>]: message: Incorrect syntax near the keyword 'DROP'. (severity 15) - in C:\wamp\www\testlink-1.9.0\third_party\adodb\drivers\adodb-mssql.inc.php - Line 775
[10/Nov/18 01:20:20][WARNING][<nosession>][GUI]
E_WARNING
mssql_query() [<a href='function.mssql-query'>function.mssql-query</a>]: message: Unknown object type 'option_priority' used in a CREATE, DROP, or ALTER statement. (severity 15) - in C:\wamp\www\testlink-1.9.0\third_party\adodb\drivers\adodb-mssql.inc.php - Line 775
[10/Nov/18 01:20:20][WARNING][<nosession>][GUI]
E_WARNING
mssql_query() [<a href='function.mssql-query'>function.mssql-query</a>]: message: Unknown object type 'option_automation' used in a CREATE, DROP, or ALTER statement. (severity 15) - in C:\wamp\www\testlink-1.9.0\third_party\adodb\drivers\adodb-mssql.inc.php - Line 775
[10/Nov/18 01:20:20][WARNING][<nosession>][GUI]
E_WARNING
mssql_query() [<a href='function.mssql-query'>function.mssql-query</a>]: Query failed - in C:\wamp\www\testlink-1.9.0\third_party\adodb\drivers\adodb-mssql.inc.php - Line 775
[10/Nov/18 01:20:20][ERROR][<nosession>][DATABASE]
ERROR ON exec_query() - database.class.php 0 - Unknown object type 'option_automation' used in a CREATE, DROP, or ALTER statement. - ALTER TABLE testprojects DROP option_reqs , DROP option_priority , DROP option_automation THE MESSAGE : SQL [15] executed [took 0.0131 secs][all took 0.1855 secs]:
ALTER TABLE testprojects DROP option_reqs , DROP option_priority , DROP option_automation
Query failed: errorcode[343]
errormsg:Unknown object type 'option_automation' used in a CREATE, DROP, or ALTER statement.
[10/Nov/18 01:20:20][WARNING][<nosession>][GUI]
E_WARNING
Invalid argument supplied for foreach() - in C:\wamp\www\testlink-1.9.0\install\migration\migrate_18\migrate_18_to_19.php - Line 358
[10/Nov/18 01:20:20][WARNING][<nosession>][GUI]
E_NOTICE
Undefined variable: nodesTypes - in C:\wamp\www\testlink-1.9.0\install\migration\migrate_18\migrate_18_to_19.php - Line 406
[<<][4ce47f52d6965880714252][DEFAULT][/testlink-1.9.0/install/installNewDB.php][10/Nov/18 01:20:18][10/Nov/18 01:20:20][took 1.893071 secs]

Post by **fman** » Thu Nov 18, 2010 6:16 am

1. yes, I need the db -> this allows me to do same test
2. open issue on mantis and upload the code you have fixed there
3. do not paste incredible amount of text on notes, makes reading the post very difficult

leol · Post by **leol** » Thu Nov 18, 2010 6:27 am

OK will do...
I want to use attachments but I couldn't see an attachment option.

Post by **fman** » Thu Nov 18, 2010 6:27 pm

need to talk to forum guy to understand if attached is disabled.
I will wait for your db

leol · Post by **leol** » Fri Nov 19, 2010 12:50 am

I couldn't attach the 385KB file to mantis, I've emailed webmaster@mantis.testlink.org about the problem.

Please refer to the mantis issue here: http://mantis.testlink.org/view.php?id=4033
The file is available here: http://jump.fm/OYNDS

TestLink

Error upgrading from 1.8.5 to 1.9.0 MS SQL Server 2005

Error upgrading from 1.8.5 to 1.9.0 MS SQL Server 2005

Re: Error upgrading from 1.8.5 to 1.9.0 MS SQL Server 2005/2

Re: Error upgrading from 1.8.5 to 1.9.0 MS SQL Server 2005

Re: Error upgrading from 1.8.5 to 1.9.0 MS SQL Server 2005

Re: Error upgrading from 1.8.5 to 1.9.0 MS SQL Server 2005

Re: Error upgrading from 1.8.5 to 1.9.0 MS SQL Server 2005

Re: Error upgrading from 1.8.5 to 1.9.0 MS SQL Server 2005

Re: Error upgrading from 1.8.5 to 1.9.0 MS SQL Server 2005

Re: Error upgrading from 1.8.5 to 1.9.0 MS SQL Server 2005