|Anonymous | Login | Signup for a new account||2019-08-22 06:08 UTC|
|Main | My View | View Issues | Change Log | My Account|
|View Issue Details|
|ID||Project||Category||View Status||Date Submitted||Last Update|
|0007681||TestLink||Migration/Upgrade Testlink||public||2016-09-22 15:39||2016-09-29 20:03|
|Product Version||1.9.14 (2015 Q3)|
|Fixed in Version|
|Summary||0007681: Buggy alter_tables script for MS SQL|
|Description||I 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.
|Tags||No tags attached.|
|Database (MySQL,Postgres,etc)||MS SQL|
|QA Team - Task Workflow Status|
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.
|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|