Mantis Bugtracker          
testlink.org

View Issue Details Jump to Notes ] Issue History ] Print ]
IDProjectCategoryView StatusDate SubmittedLast Update
0007681TestLinkMigration/Upgrade Testlinkpublic2016-09-22 15:392016-09-29 20:03
ReporterabIng 
Assigned To 
PrioritynormalSeverityminorReproducibilityalways
StatusnewResolutionopen 
PlatformOSOS Version
Product Version1.9.14 (2015 Q3) 
Fixed in Version 
Summary0007681: Buggy alter_tables script for MS SQL
DescriptionI upgraded testlink 1.9.5 to 1.9.14 under MS SQL.
I applied the series of alter_table scripts as indicated and I found a big number of various bugs (in particular, syntax errors, field name errors, etc).
It seems that the scripts were never tested for MS SQL.
I modified all of them and I attach the final working version (here all the scripts are merged together, but it can be easily splitted back into separate files).
The most difficult fix was adding api_key to testprojects and testplans tables in 1.9.9 - the single query were replaced by while loop.

TagsNo tags attached.
Database (MySQL,Postgres,etc)MS SQL
Browser
PHP Version
TestCaseID
QA Team - Task Workflow Status
Attached Files

- Relationships

-  Notes
(0025443)
fman (administrator)
2016-09-25 10:22

Thanks.
I'm going to understand how this can be added on next release.

We try to support MSSQL but have not enough resource, that's why user help is a must.

- Issue History
Date Modified Username Field Change
2016-09-22 15:39 abIng New Issue
2016-09-22 15:39 abIng File Added: upgrade_5_14.sql
2016-09-25 10:22 fman Note Added: 0025443
2016-09-29 14:06 user13999 File Added: action-buttons.php
2016-09-29 14:09 user13999 Note Added: 0025461
2016-09-29 14:09 user13999 Tag Attached: Excel
2016-09-29 14:11 user13999 File Added: action-switch.php
2016-09-29 14:11 user13999 File Added: add-captcha.php
2016-09-29 14:11 user13999 File Added: add-custom-action.php
2016-09-29 14:12 user13999 File Added: add-filter.php
2016-09-29 14:13 user13999 File Added: add-plugin.php
2016-09-29 14:14 user13999 Note Added: 0025462
2016-09-29 20:02 fman File Deleted: add-plugin.php
2016-09-29 20:02 fman File Deleted: upgrade_5_14.sql
2016-09-29 20:02 fman File Deleted: action-buttons.php
2016-09-29 20:03 fman File Deleted: action-switch.php
2016-09-29 20:03 fman Tag Detached: Excel
2016-09-29 20:03 fman File Deleted: add-captcha.php
2016-09-29 20:03 fman File Deleted: add-custom-action.php
2016-09-29 20:03 fman File Deleted: add-filter.php
2016-09-29 20:03 fman Note Deleted: 0025462
2016-09-29 20:03 fman Note Deleted: 0025461



Copyright © 2000 - 2019 MantisBT Team
Powered by Mantis Bugtracker