Mantis Bugtracker          
testlink.org

View Issue Details Jump to Notes ] Issue History ] Print ]
IDProjectCategoryView StatusDate SubmittedLast Update
0008407TestLinkMigration/Upgrade Testlinkpublic2018-10-10 06:162018-10-13 18:06
Reporterhughkay 
Assigned Tofman 
PrioritynormalSeveritymajorReproducibilityalways
StatusassignedResolutionopen 
PlatformOSOS Version
Product Version1.9.18 (2018 Q3) 
Fixed in Version 
Summary0008407: MySQL Upgrade script from 1.9.16 to 1.9.17 is wrong WHEN USING testlink 1.9.18
Description"install/sql/alter_tables/1.9.17/mysql/DB.1.9.17/step1/db_schema_update.sql" was altered with commit "cb365cd5e99d9defe353010da7706526bb5c2128" a few days ago.

However, the changes should have been applied to version 1.9.18 of the sql file instead, i.e. "install/sql/alter_tables/1.9.18/mysql/DB.1.9.18/step1/db_schema_update.sql".

But now, the upgrade script from 1.9.16 to 1.9.17 is wrong.
Steps To Reproducetry to upgrade from 1.9.16 to 1.9.17 version with MySQL database will fail now.
TagsNo tags attached.
Database (MySQL,Postgres,etc)MySQL
Browser
PHP Version
TestCaseID
QA Team - Task Workflow StatusTBD
Attached Files

- Relationships
has duplicate 0008411closedfman Error in scripts upgrading to 1.9.17 

-  Notes
(0027979)
fman (administrator)
2018-10-10 15:52

what can i do with the sentence 'is wrong'?
what is wrong?
why do I need to work to discover what you know?

without better details I will close this issue
(0027982)
hughkay (reporter)
2018-10-11 06:41
edited on: 2018-10-11 06:43

@fman:
In my opinion you've simply updated the wrong file with the commit stated above.
You've updated the db_schema_update.sql file for 1.9.17 version instead of the one for 1.9.18 version.
The content you've commmitted to "install/sql/alter_tables/1.9.17/mysql/DB.1.9.17/step1/db_schema_update.sql" should rather be located at "install/sql/alter_tables/1.9.18/mysql/DB.1.9.18/step1/db_schema_update.sql" file.

Please compare the contents of the 1.9.17 db_schema_update.sql files for "mysql" and "mssql" / "postgres" of the latest code basis.
You'll notice that they're completely different.

(0027986)
fman (administrator)
2018-10-11 09:31

OK, thanks a lot for your help
I'm going to chek

best regards

- Issue History
Date Modified Username Field Change
2018-10-10 06:16 hughkay New Issue
2018-10-10 15:52 fman Note Added: 0027979
2018-10-10 15:52 fman Assigned To => fman
2018-10-10 15:52 fman Status new => feedback
2018-10-11 06:41 hughkay Note Added: 0027982
2018-10-11 06:41 hughkay Status feedback => assigned
2018-10-11 06:43 hughkay Note Edited: 0027982 View Revisions
2018-10-11 06:43 hughkay Note Edited: 0027982 View Revisions
2018-10-11 09:31 fman Note Added: 0027986
2018-10-13 18:05 fman QA Team - Task Workflow Status => TBD
2018-10-13 18:05 fman Product Version 1.9.17 (2018 Q1) => 1.9.18 (2018 Q3)
2018-10-13 18:05 fman Summary MySQL Upgrade script from 1.9.16 to 1.9.17 is wrong => MySQL Upgrade script from 1.9.16 to 1.9.17 is wrong WHEN USING testlink 1.9.18
2018-10-13 18:06 fman Relationship added has duplicate 0008411



Copyright © 2000 - 2018 MantisBT Team
Powered by Mantis Bugtracker