Bug tracker

This ticket has been moved to our new tracker. Open Ticket PHPBB3-1569 now.

MS Sql: data type mismatch (fix completed in vcs)

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()

Comments / History

Linked ticket with changeset: r6332

Action performed by DavidMJ (Former Team Member) on Aug 30th 2006, 00:58

Ticket details

Related SVN changesets