Release Support > Pending Issues

does roundcube works with IIS and MSSQL-Server?

(1/1)

konus:
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.
--- End quote ---

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

alec:
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.

konus:
Thank you for the replay. The Tickets are here:
Ticket #1488505 SQL query doesn't work with MS SQL
Ticket #1488506 PHP code issue

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

Navigation

[0] Message Index