Mantis Bugtracker          
testlink.org

View Issue Details Jump to Notes ] Issue History ] Print ]
IDProjectCategoryView StatusDate SubmittedLast Update
0008411TestLinkMigration/Upgrade Testlinkpublic2018-10-11 12:342018-10-13 18:06
Reportertitovetch 
Assigned Tofman 
PrioritynormalSeverityminorReproducibilityhave not tried
StatusclosedResolutionduplicate 
PlatformOSOS Version
Product Version1.9.16 (2016 Q4) 
Fixed in Version 
Summary0008411: Error in scripts upgrading to 1.9.17
Descriptioni'm upgrading from 1.9.16 to version 1.9.17 and i have executed all scripts except the attachments so is there is any problem with those or i can proceed to 1.9.18 normal
Additional Informationusing WAMP version 3.1.0 [apache 2.4.23 - mysql version 5.7.14 - php 7.0.10 ] do i need to upgrade MYSQL ?
TagsNo tags attached.
Database (MySQL,Postgres,etc)MySQL 5.7.14
BrowserChrome
PHP Version7.0.10
TestCaseID
QA Team - Task Workflow StatusTBD
Attached Filespng file icon pic 1.png [^] (40,766 bytes) 2018-10-11 12:34


png file icon pic 2.png [^] (23,927 bytes) 2018-10-11 12:35

- Relationships
duplicate of 0008407assignedfman MySQL Upgrade script from 1.9.16 to 1.9.17 is wrong WHEN USING testlink 1.9.18 

-  Notes
(0027990)
titovetch (reporter)
2018-10-11 12:43
edited on: 2018-10-11 12:44

and in case i have proceed with the upgrading to 1.9.18 these scripts shown error (# 1060 - Duplicate column name 'id'
) and the new version 1.9.18 working normal after the upgrade , i'm just share this to ensure the stabilize on the system



ALTER TABLE /*prefix*/req_coverage ADD COLUMN `id` int(10) unsigned primary KEY AUTO_INCREMENT FIRST;
ALTER TABLE /*prefix*/req_coverage ADD COLUMN `req_version_id` int(10) NOT NULL AFTER req_id;
ALTER TABLE /*prefix*/req_coverage ADD COLUMN `tcversion_id` int(10) NOT NULL AFTER testcase_id;
ALTER TABLE /*prefix*/req_coverage ADD COLUMN `link_status` int(11) NOT NULL DEFAULT '1' AFTER tcversion_id;
ALTER TABLE /*prefix*/req_coverage ADD COLUMN `is_active` int(11) NOT NULL DEFAULT '1' AFTER link_status;

ALTER TABLE /*prefix*/req_coverage DROP KEY /*prefix*/req_testcase;
ALTER TABLE /*prefix*/req_coverage ADD UNIQUE KEY /*prefix*/req_coverage_full_link (`req_id`,`req_version_id`,`testcase_id`,`tcversion_id`);


ALTER TABLE /*prefix*/testcase_keywords ADD COLUMN `tcversion_id` int(10) NOT NULL AFTER testcase_id;
ALTER TABLE /*prefix*/testcase_keywords DROP PRIMARY KEY;
ALTER TABLE /*prefix*/testcase_keywords ADD COLUMN `id` int(10) unsigned primary KEY AUTO_INCREMENT FIRST;
ALTER TABLE /*prefix*/testcase_keywords ADD UNIQUE KEY /*prefix*/idx01_testcase_keywords (`testcase_id`,`tcversion_id`,`keyword_id`);

ALTER TABLE /*prefix*/testcase_relations ADD COLUMN `link_status` tinyint(1) NOT NULL DEFAULT '1' AFTER relation_type;


- Issue History
Date Modified Username Field Change
2018-10-11 12:34 titovetch New Issue
2018-10-11 12:34 titovetch File Added: pic 1.png
2018-10-11 12:35 titovetch File Added: pic 2.png
2018-10-11 12:43 titovetch Note Added: 0027990
2018-10-11 12:44 titovetch Note Edited: 0027990 View Revisions
2018-10-13 18:06 fman Relationship added duplicate of 0008407
2018-10-13 18:06 fman QA Team - Task Workflow Status => TBD
2018-10-13 18:06 fman Status new => closed
2018-10-13 18:06 fman Assigned To => fman
2018-10-13 18:06 fman Resolution open => duplicate



Copyright © 2000 - 2018 MantisBT Team
Powered by Mantis Bugtracker