1.8.5 + iis6 + MsSql 2005 problem with note=expired [Solved]

[JCO]

Hi,

I was asked to install TestLink on one of our production servers but i've run into a very odd problem.

The webserver it's installed on is 2003 R2 with IIS6 + PHP 5.2.14 and a seperate db server with SQL2005 SP2 on it.

I followed the installtion guide and everything went fine, the db + tables were created.

However once i browse to the TestLink site i just get a white screen, both when the browser is still trying to display the site and after it has given up. This happens with both IE7/8 and FireFox 3.6.8.
No error message at all in the browser except the login.php?note=expired in the browser title bar.

There doesn't seem to be a lot of information about this problem. I've found this thread: http://www.teamst.org/forum/viewtopic.php?f=1&t=2646 but its proposed solution doesn't work for me.

I've looked at the userlog0.log file in the logs folder under the TestLink dir and found this whenever i tried to browse to the site:

[>>][4c591ac2e1694763335315][DEFAULT][/login.php][10/Aug/4 07:46:10]
[10/Aug/4 07:46:10][WARNING][<nosession>][GUI]
E_STRICT
Declaration of ADODB_mssql::PrepareSP() should be compatible with that of ADOConnection::PrepareSP() - in C:\Inetpub\wwwroot\TestLink\third_party\adodb\drivers\adodb-mssql.inc.php - Line 735
[10/Aug/4 07:46:10][WARNING][<nosession>][GUI]
E_STRICT
Declaration of ADODB_mssql::MetaPrimaryKeys() should be compatible with that of ADOConnection::MetaPrimaryKeys() - in C:\Inetpub\wwwroot\TestLink\third_party\adodb\drivers\adodb-mssql.inc.php - Line 735
[10/Aug/4 07:46:10][WARNING][<nosession>][GUI]
E_STRICT
Declaration of ADODB_mssql::MetaIndexes() should be compatible with that of ADOConnection::MetaIndexes() - in C:\Inetpub\wwwroot\TestLink\third_party\adodb\drivers\adodb-mssql.inc.php - Line 735
[<<][4c591ac2e1694763335315][DEFAULT][/login.php][10/Aug/4 07:46:10][10/Aug/4 07:46:11][took 0.364948 secs]
[>>][4c591ac346dcc235005220][DEFAULT][/login.php][10/Aug/4 07:46:11]
[<<][4c591ac346dcc235005220][DEFAULT][/login.php][10/Aug/4 07:46:11][10/Aug/4 07:47:11][took 60.559881 secs]
[>>][4c591bb6ae350501946313][DEFAULT][/firstlogin.php][10/Aug/4 07:50:14]
[10/Aug/4 07:50:14][WARNING][<nosession>][GUI]
E_STRICT
Declaration of ADODB_mssql::PrepareSP() should be compatible with that of ADOConnection::PrepareSP() - in C:\Inetpub\wwwroot\TestLink\third_party\adodb\drivers\adodb-mssql.inc.php - Line 735
[10/Aug/4 07:50:14][WARNING][<nosession>][GUI]
E_STRICT
Declaration of ADODB_mssql::MetaPrimaryKeys() should be compatible with that of ADOConnection::MetaPrimaryKeys() - in C:\Inetpub\wwwroot\TestLink\third_party\adodb\drivers\adodb-mssql.inc.php - Line 735
[10/Aug/4 07:50:14][WARNING][<nosession>][GUI]
E_STRICT
Declaration of ADODB_mssql::MetaIndexes() should be compatible with that of ADOConnection::MetaIndexes() - in C:\Inetpub\wwwroot\TestLink\third_party\adodb\drivers\adodb-mssql.inc.php - Line 735
[<<][4c591bb6ae350501946313][DEFAULT][/firstlogin.php][10/Aug/4 07:50:14][10/Aug/4 07:50:14][took 0.259473 secs]
[>>][4c591bb6edf95084059551][DEFAULT][/firstlogin.php][10/Aug/4 07:50:14]
[<<][4c591bb6edf95084059551][DEFAULT][/firstlogin.php][10/Aug/4 07:50:14][10/Aug/4 07:50:15][took 0.061832 secs]

The funny thing is that i can browse to the firstlogin.php page perfectly fine and i can create new users without issue. I've doublechecked the db and new users do get created there as well so there doesn't seem to be a connection problem there.

I thought maybe it was a security issue but after basically granting every possible permission in IIS and on file level it's still the same.

I'm running out of ideas, maybe the above log message can give someone a clue?

Thx in advance for any help.

[JCO]

The problem has been resolved by one of our devs after a lengthy debugging session.

in testlink\lib\funtions\plan.core.inc.php
function getTestPlansWithoutProject(&$db)
the column name ACTIVE (in caps) is not supported by SQL
if you change it to 'active'.. it works.

The same query runs for me on mysql
but throws error with MS SQL

After changing that sql query everything worked as it should.

[fman]

Great! - thanks a lot

this is a problem that sometimes arise with different DB when using ADODB.
Other similar problems arise when trying to access a key in a map, because UPPER CASE an lower case are important for PHP