Hi,
We have recently migrated our email server to win2008r2 and sql2008 express with hmailserver and roundcube. Everything in rc works great except when we attempt to create and save email contacts in the address book, we encounter the following errors in the logs as follows:
[09-Jul-2012 11:28:00 +0800]: DB Error: MDB2 Error: unknown error Query: _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=1 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]The data types varchar and text are incompatible in the add operator. ] in C:\roundcubemail-0.7.2\program\include\rcube_mdb2.php on line 719 (GET /?_task=addressbook&_action=list&_source=0&_remote=1&_unlock=loading1341804483113&_=1341804483115)
Appreciate any advice or workarounds. Thanks guys!
