Roundcube Community Forum

Hello,
I try to use Roundcube on a Windows Server and get the following error: the data types text and varchar are incompatible in the boolean and operator

My configuration:

• Windows Server 2008 R2 with IIS 7.5
• PHP 5.3.13
• "Microsoft SQL Driver v2.0 for PHP v5.2 in IIS" (installed via Microsoft Web Plattform installer)
• My connection string is: $rcmail_config['db_dsnw'] = 'sqlsrv://sa:password@server\\instance/database';
• hMailServer

The error after opening my (still empty) addressbook:

Quote[31-May-2012 13:24:03 UTC] PHP Parse error:  syntax error, unexpected T_STRING in C:\inetpub\wwwroot\roundcube\program\include\rcube_template.php(785) : eval()'d code on line 1
[31-May-2012 13:24:03 UTC] PHP Parse error:  syntax error, unexpected T_STRING in C:\inetpub\wwwroot\roundcube\program\include\rcube_template.php(785) : eval()'d code on line 1
[31-May-2012 13:24:03 UTC] PHP Parse error:  syntax error, unexpected T_ENCAPSED_AND_WHITESPACE in C:\inetpub\wwwroot\roundcube\program\include\rcube_template.php(785) : eval()'d code on line 1
[31-May-2012 13:25:46 UTC] PHP Parse error:  syntax error, unexpected T_STRING in C:\inetpub\wwwroot\roundcube\program\include\rcube_template.php(785) : eval()'d code on line 1
[31-May-2012 13:25:46 UTC] PHP Parse error:  syntax error, unexpected T_STRING in C:\inetpub\wwwroot\roundcube\program\include\rcube_template.php(785) : eval()'d code on line 1
[31-May-2012 13:25:46 UTC] MDB2 Error: unknown error (-1): _doQuery: [Error message: Could not execute statement]
[Last executed query: SELECT TOP 40 * FROM contacts AS c WHERE c.del<>1 AND c.user_id=2 ORDER BY (c.surname + c.firstname + c.name + c.email) ASC]
[Native code: 402]
[Native message: SQLState: 42000
Error Code: 402
Message: [Microsoft][SQL Server Native Client 11.0][SQL Server]Die Datentypen varchar und text sind im add-Operator inkompatibel.

As a result, it looks like I can't save new contacts.

I see two issues here. One is SQL query which doesn't work with MS SQL. The second is PHP code issue. Please, open (separate) tickets in bugtracker, we'll try to find a solution.

Thank you for the replay. The Tickets are here:
Ticket #1488505 (http://trac.roundcube.net/ticket/1488505) SQL query doesn't work with MS SQL
Ticket #1488506 (http://trac.roundcube.net/ticket/1488506) PHP code issue

Please feel free to rename them, if found a better description.