Linked ticket with changeset: r6332
Action performed by DavidMJ (Former Team Member) on Aug 30th 2006, 00:58
I've installed phpbb on a Windows 2003 Server box with a ODBC connection to a Microsoft SQL Server 2005 Enterprise SQL-server. The boards works fine until I click the search button, which gives me:
SQL ERROR [ mssql_odbc ]
[Microsoft][ODBC SQL Server Driver][SQL Server]The data types text and varchar are incompatible in the not equal to operator. [37000]
SQL
SELECT TOP 5 search_time, search_keywords FROM phpbb_search_results WHERE search_keywords <> '' ORDER BY search_time DESC
BACKTRACE
FILE: includes/db/mssql_odbc.php
LINE: 131
CALL: dbal_mssql_odbc->sql_error()
FILE: includes/db/mssql_odbc.php
LINE: 189
CALL: dbal_mssql_odbc->sql_query()
FILE: search.php
LINE: 888
CALL: dbal_mssql_odbc->sql_query_limit()