Mantis Bugtracker          
testlink.org

View Issue Details Jump to Notes ] Issue History ] Print ]
IDProjectCategoryView StatusDate SubmittedLast Update
0008458TestLinkMigration/Upgrade Testlinkpublic2018-11-07 19:562018-11-07 21:22
Reporterdavid4coding 
Assigned Tofman 
PriorityhighSeverityblockReproducibilityalways
StatusresolvedResolutionno change required 
PlatformOSOS Version
Product Version1.9.18 (2018 Q3) 
Fixed in Version 
Summary0008458: when migrating from 1.9.17 to 1.9.18 if using mysql DB "code_tracker_enabled" column is not added in the migrations
DescriptionIf you migrated from 1.9.17 to 1.9.18 when you try to create a tc it will throw an error, by looking at the logs you'll find out is because some column missing in the DB, and it looks like the migrations missed this part.

Adding the following command to the migration will help to resolve the issue
ALTER TABLE /*prefix*/testprojects ADD COLUMN `code_tracker_enabled` tinyint(1) NOT NULL DEFAULT '0';
Steps To Reproduce1- update from 1.9.17 to 1.9.18
2- try to create a test case for any project
TagsNo tags attached.
Database (MySQL,Postgres,etc)MySQL
Browser
PHP Version
TestCaseID
QA Team - Task Workflow StatusTBD
Attached Files

- Relationships

-  Notes
(0028184)
david4coding (reporter)
2018-11-07 19:58

[18/Nov/7 15:43:41][ERROR][m141ma64jf7noq3jvdaoh1583f][DATABASE]
                ERROR ON exec_query() - database.class.php
1054 - Unknown column 'code_tracker_enabled' in 'field list' - /* Class:testproject - Method: isCodeTrackerEnabled */ SELECT code_tracker_enabled FROM testprojects WHERE id =958
THE MESSAGE : /* Class:testproject - Method: isCodeTrackerEnabled */ SELECT code_tracker_enabled FROM testprojects WHERE id =958
Query failed: errorcode[1054]
        errormsg:Unknown column 'code_tracker_enabled' in 'field list'
(0028185)
fman (administrator)
2018-11-07 21:01

this column is not part of 1.9.18, your problem is a sign of a bad previous migration to 1.9.17

- Issue History
Date Modified Username Field Change
2018-11-07 19:56 david4coding New Issue
2018-11-07 19:58 david4coding Note Added: 0028184
2018-11-07 21:01 fman Note Added: 0028185
2018-11-07 21:22 fman Note View State: 0028185: public
2018-11-07 21:22 fman QA Team - Task Workflow Status => TBD
2018-11-07 21:22 fman Status new => resolved
2018-11-07 21:22 fman Resolution open => no change required
2018-11-07 21:22 fman Assigned To => fman



Copyright © 2000 - 2018 MantisBT Team
Powered by Mantis Bugtracker