Mantis Bugtracker          
testlink.org

View Issue Details Jump to Notes ] Issue History ] Print ]
IDProjectCategoryView StatusDate SubmittedLast Update
0008766TestLinkDatabase MySQLpublic2019-09-18 01:022019-09-18 10:37
Reporterjessy 
Assigned To 
PriorityurgentSeveritymajorReproducibilityalways
StatusnewResolutionopen 
PlatformTestlink 1.9.4OSCentos 7 OS Version7
Product Version 
Fixed in Version 
Summary0008766: We are planning to update the Testlink version to latest and migrate it to new Centos 7 because Centos 6 is EOL.
DescriptionI am trying to migrate testlink 1.9.4 from Centos 6 to Centos 7 but after import DB on news server getting message that I need to update DB Schema from 1.4 to 1.5 but getting below errors :-

1. source /var/www/html/testlink/install/sql/alter_tables/1.9.4/mysql/DB.1.5/stepZ/z_final_step.sql;

Error is :-

ERROR 1146 (42S02) at line 28 in file: '/var/www/html/testlink/install/sql/alter_tables/1.9.4/mysql/DB.1.5/step1/db_schema_update.sql': Table 'testlink_194.node_types' doesn't exist
ERROR 1050 (42S01) at line 30 in file: '/var/www/html/testlink/install/sql/alter_tables/1.9.4/mysql/DB.1.5/step1/db_schema_update.sql': Table 'req_specs_revisions' already exists
ERROR 1050 (42S01) at line 50 in file: '/var/www/html/testlink/install/sql/alter_tables/1.9.4/mysql/DB.1.5/step1/db_schema_update.sql': Table 'issuetrackers' already exists
ERROR 1050 (42S01) at line 61 in file: '/var/www/html/testlink/install/sql/alter_tables/1.9.4/mysql/DB.1.5/step1/db_schema_update.sql': Table 'testproject_issuetracker' already exists
ERROR 1146 (42S02) at line 70 in file: '/var/www/html/testlink/install/sql/alter_tables/1.9.4/mysql/DB.1.5/step1/db_schema_update.sql': Table 'testlink_194.testprojects' doesn't exist
ERROR 1146 (42S02) at line 76 in file: '/var/www/html/testlink/install/sql/alter_tables/1.9.4/mysql/DB.1.5/step1/db_schema_update.sql': Table 'testlink_194.nodes_hierarchy' doesn't exist
ERROR 1146 (42S02) at line 85 in file: '/var/www/html/testlink/install/sql/alter_tables/1.9.4/mysql/DB.1.5/step1/db_schema_update.sql': Table 'testlink_194.nodes_hierarchy' doesn't exist
ERROR 1146 (42S02) at line 96 in file: '/vuse ar/www/html/testlink/install/sql/alter_tables/1.9.4/mysql/DB.1.5/step1/db_schema_update.sql': Table 'testlink_194.nodes_hierarchy' doesn't exist
ERROR 1146 (42S02) at line 102 in file: '/var/www/html/testlink/install/sql/alter_tables/1.9.4/mysql/DB.1.5/step1/db_schema_update.sql': Table 'testlink_194.req_specs' doesn't exist
Query OK, 0 rows affected (0.00 sec)
Rows matched: 0 Changed: 0 Warnings: 0

ERROR 1146 (42S02) at line 112 in file: '/var/www/html/testlink/install/sql/alter_tables/1.9.4/mysql/DB.1.5/step1/db_schema_update.sql': Table 'testlink_194.req_specs' doesn't exist
ERROR 1146 (42S02) at line 113 in file: '/var/www/html/testlink/install/sql/alter_tables/1.9.4/mysql/DB.1.5/step1/db_schema_update.sql': Table 'testlink_194.req_specs' doesn't exist
ERROR 1146 (42S02) at line 114 in file: '/var/www/html/testlink/install/sql/alter_tables/1.9.4/mysql/DB.1.5/step1/db_schema_update.sql': Table 'testlink_194.req_specs' doesn't exist
ERROR 1146 (42S02) at line 115 in file: '/var/www/html/testlink/install/sql/alter_tables/1.9.4/mysql/DB.1.5/step1/db_schema_update.sql': Table 'testlink_194.req_specs' doesn't exist
ERROR 1146 (42S02) at line 116 in file: '/var/www/html/testlink/install/sql/alter_tables/1.9.4/mysql/DB.1.5/step1/db_schema_update.sql': Table 'testlink_194.req_specs' doesn't exist
ERROR 1146 (42S02) at line 117 in file: '/var/www/html/testlink/install/sql/alter_tables/1.9.4/mysql/DB.1.5/step1/db_schema_update.sql': Table 'testlink_194.req_specs' doesn't exist
ERROR 1146 (42S02) at line 118 in file: '/var/www/html/testlink/install/sql/alter_tables/1.9.4/mysql/DB.1.5/step1/db_schema_update.sql': Table 'testlink_194.req_specs' doesn't exist
ERROR 1146 (42S02) at line 120 in file: '/var/www/html/testlink/install/sql/alter_tables/1.9.4/mysql/DB.1.5/step1/db_schema_update.sql': Table 'testlink_194.req_specs' doesn't exist
ERROR 1146 (42S02) at line 124 in file: '/var/www/html/testlink/install/sql/alter_tables/1.9.4/mysql/DB.1.5/step1/db_schema_update.sql': Table 'testlink_194.users' doesn't exist
ERROR 1146 (42S02) at line 125 in file: '/var/www/html/testlink/install/sql/alter_tables/1.9.4/mysql/DB.1.5/step1/db_schema_update.sql': Table 'testlink_194.users' doesn't exist
ERROR 1146 (42S02) at line 126 in file: '/var/www/html/testlink/install/sql/alter_tables/1.9.4/mysql/DB.1.5/step1/db_schema_update.sql': Table 'testlink_194.users' doesn't exist
ERROR 1146 (42S02) at line 127 in file: '/var/www/html/testlink/install/sql/alter_tables/1.9.4/mysql/DB.1.5/step1/db_schema_update.sql': Table 'testlink_194.users' doesn't exist
ERROR 1146 (42S02) at line 132 in file: '/var/www/html/testlink/install/sql/alter_tables/1.9.4/mysql/DB.1.5/step1/db_schema_update.sql': Table 'testlink_194.rights' doesn't exist
ERROR 1146 (42S02) at line 133 in file: '/var/www/html/testlink/install/sql/alter_tables/1.9.4/mysql/DB.1.5/step1/db_schema_update.sql': Table 'testlink_194.rights' doesn't exist
ERROR 1146 (42S02) at line 134 in file: '/var/www/html/testlink/install/sql/alter_tables/1.9.4/mysql/DB.1.5/step1/db_schema_update.sql': Table 'testlink_194.rights' doesn't exist
ERROR 1146 (42S02) at line 135 in file: '/var/www/html/testlink/install/sql/alter_tables/1.9.4/mysql/DB.1.5/step1/db_schema_update.sql': Table 'testlink_194.rights' doesn't exist
ERROR 1146 (42S02) at line 136 in file: '/var/www/html/testlink/install/sql/alter_tables/1.9.4/mysql/DB.1.5/step1/db_schema_update.sql': Table 'testlink_194.rights' doesn't exist
ERROR 1146 (42S02) at line 140 in file: '/var/www/html/testlink/install/sql/alter_tables/1.9.4/mysql/DB.1.5/step1/db_schema_update.sql': Table 'testlink_194.role_rights' doesn't exist
ERROR 1146 (42S02) at line 141 in file: '/var/www/html/testlink/install/sql/alter_tables/1.9.4/mysql/DB.1.5/step1/db_schema_update.sql': Table 'testlink_194.role_rights' doesn't exist
ERROR 1146 (42S02) at line 142 in file: '/var/www/html/testlink/install/sql/alter_tables/1.9.4/mysql/DB.1.5/step1/db_schema_update.sql': Table 'testlink_194.role_rights' doesn't exist
MariaDB [testlink_194]> Ctrl-C -- exit!




Step -2

ERROR 1146 (42S02) at line 25 in file: '/var/www/html/testlink/install/sql/alter_tables/1.9.4/mysql/DB.1.5/stepZ/z_final_step.sql': Table 'testlink_194.db_version' doesn't exist

ERROR 1146 (42S02): Table 'testlink_194.db_version' doesn't exist
Additional InformationActaully now We are planning to update the Testlink version to latest and migrate it to new Centos 7 because Centos 6 is EOL.
TagsNo tags attached.
Database (MySQL,Postgres,etc)mysql Ver 15.1 Distrib 5.5.60-MariaDB, for Linux
BrowserChrome
PHP Version5.4.6
TestCaseID
QA Team - Task Workflow Status
Attached Filestxt file icon DB error.txt [^] (5,941 bytes) 2019-09-18 01:02 [Show Content]

- Relationships

-  Notes
(0029173)
fman (administrator)
2019-09-18 10:37

Your version is too old to be able to provide help,
I'm sorry

- Issue History
Date Modified Username Field Change
2019-09-18 01:02 jessy New Issue
2019-09-18 01:02 jessy File Added: DB error.txt
2019-09-18 10:37 fman Note Added: 0029173



Copyright © 2000 - 2019 MantisBT Team
Powered by Mantis Bugtracker