$db->db_now and MSSQL

0_o · Post by **0_o** » Tue Nov 17, 2009 3:37 pm

Hi!

We using Testlink+MSSQL.

We have installed testlink in the begining of this month. Everything was fine until 13 November. Since 13 nobody can create new test case. Testlink just did nothing and returns empty white screen.

After few hours of researching this problem I found out that problem is in SQL query. SQL query contains invalid date format in creation_ts field. The only one solution that I found is to modify db_now function of database class as follows:

Code: Select all


	function db_now()
	{
	    switch($this->db->databaseType)
    	{
      		case 'mssql':
				return "GETDATE()";
		default:
				return $this->db->DBTimeStamp(time());
		}
	}

Since that, all works fine!

Hope you will add this fix in next Testlink build.

Amaradana · Post by **Amaradana** » Tue Nov 17, 2009 4:15 pm

Even I am facing same Problem, But your solution did not solve my problem.

0_o · Post by **0_o** » Tue Nov 17, 2009 4:27 pm

Amaradana wrote:Even I am facing same Problem, But your solution did not solve my problem.

If you have the same problem with dates, you can try else to add:

Code: Select all


      		case 'odbc_mssql':
				return "GETDATE()";
                case 'adodb_mssql':
				return "GETDATE()";
                case 'mssql_n':
				return "GETDATE()";

in the same function. Maybe it can help.

Amaradana · Post by **Amaradana** » Tue Nov 17, 2009 4:42 pm

I doesn't know the problem, why it is causing, but i am facing same problem.