0008280: Installation script fails (MS SQL used)

(0027582)
abIng (reporter)
2018-06-13 12:39

I found the solution.
Several problems are found

1) In file installUtils.php, line 169:
       $users[] = trim($row['LOGINNAME']);
should be
       $users[] = trim($row['LoginName']);

2) I commented out the line 855 of the same file installUtils.php:
       mssql_free_statement($stmt[1]);
Really, the variable $stmt is a string here, not an array.

3) I removed constraints for the first fields of the tables plugins and plugins_configuration in the file sql/mssql/testlink_create_tables.sql, see http://mantis.testlink.org/view.php?id=7680 [^]

After that, the installation script finished OK.
The last problem appeared in 1.9.15; the two first problems appeared in 1.9.17.

(0027591)
fman (administrator)
2018-06-16 17:01

>> should be
>> $users[] = trim($row['LoginName']);

well this can not be fixed this way because probably works only for the Microsoft world

>>2) I commented out the line 855 of the same file installUtils.php:
>> mssql_free_statement($stmt[1]);

this probably depends on changes on MSSQL drivers

(0027597)
fman (administrator)
2018-06-16 17:50

Just for the records:
I've checked installUtils.php for version 1.9.14 and 1.9.17 and there are no differences on the MSSQL parts, then is very strange that you will be able to do installation on 1.9.14 without issues.

(0027944)
fman (administrator)
2018-10-06 12:17

1.9.18 released

Issue History
Date Modified	Username	Field	Change
2018-06-04 14:51	abIng	New Issue
2018-06-04 14:51	abIng	File Added: logpng.7z
2018-06-13 12:39	abIng	Note Added: 0027582
2018-06-16 17:01	fman	Note Added: 0027591
2018-06-16 17:01	fman	Relationship added	related to 0007680
2018-06-16 17:50	fman	Note Added: 0027597
2018-06-16 17:52	fman	QA Team - Task Workflow Status	=> READY FOR TESTING
2018-06-16 17:52	fman	Status	new => resolved
2018-06-16 17:52	fman	Fixed in Version	=> 1.9.18 (2018 Q3)
2018-06-16 17:52	fman	Resolution	open => fixed
2018-06-16 17:52	fman	Assigned To	=> fman
2018-10-06 12:17	fman	Note Added: 0027944
2018-10-06 12:17	fman	Status	resolved => closed

Notes
(0027582) abIng (reporter) 2018-06-13 12:39	I found the solution. Several problems are found 1) In file installUtils.php, line 169: $users[] = trim($row['LOGINNAME']); should be $users[] = trim($row['LoginName']); 2) I commented out the line 855 of the same file installUtils.php: mssql_free_statement($stmt[1]); Really, the variable $stmt is a string here, not an array. 3) I removed constraints for the first fields of the tables plugins and plugins_configuration in the file sql/mssql/testlink_create_tables.sql, see http://mantis.testlink.org/view.php?id=7680 [^] After that, the installation script finished OK. The last problem appeared in 1.9.15; the two first problems appeared in 1.9.17.

(0027591) fman (administrator) 2018-06-16 17:01	>> should be >> $users[] = trim($row['LoginName']); well this can not be fixed this way because probably works only for the Microsoft world >>2) I commented out the line 855 of the same file installUtils.php: >> mssql_free_statement($stmt[1]); this probably depends on changes on MSSQL drivers

(0027597) fman (administrator) 2018-06-16 17:50	Just for the records: I've checked installUtils.php for version 1.9.14 and 1.9.17 and there are no differences on the MSSQL parts, then is very strange that you will be able to do installation on 1.9.14 without issues.

(0027944) fman (administrator) 2018-10-06 12:17	1.9.18 released