Details

    • Type: Sub-task
    • Status: Unverified Fix
    • Priority: Major
    • Resolution: Fixed
    • Affects Version/s: 3.0.7-PL1
    • Fix Version/s: 3.0.8-RC1
    • Component/s: Search
    • Labels:
      None
    • Environment:
      PHP 5.3.1, MSSQL 2008 SP1, Windows 7, Chrome 5.0.342.9

      Description

      Clicking the "Advanced Search" link when using the mssqlnative driver (http://area51.phpbb.com/phpBB/viewtopic.php?p=206934#p206934) causes a general error to be thrown;

      General Error
      SQL ERROR [ mssqlnative ]
       
      SQLSTATE: 42000 code: 402 message: [Microsoft][SQL Server Native Client 10.0][SQL Server]The data types text and varchar are incompatible in the not equal to operator. [402]
       
      SQL
       
      SELECT TOP 5 search_time, search_keywords FROM phpbb_search_results WHERE search_keywords <> '' ORDER BY search_time DESC
       
      BACKTRACE
       
      FILE: includes/db/mssqlnative.php
      LINE: 313
      CALL: dbal->sql_error()
       
      FILE: includes/db/mssqlnative.php
      LINE: 370
      CALL: dbal_mssqlnative->sql_query()
       
      FILE: includes/db/dbal.php
      LINE: 170
      CALL: dbal_mssqlnative->_sql_query_limit()
       
      FILE: search.php
      LINE: 1171
      CALL: dbal->sql_query_limit()
      

      This error can be resolved by inserting the following code on line 1158 of search.php;

      case 'mssqlnative':

        Activity

        Hide
        robhouse robhouse added a comment -

        Patched Attached.

        Show
        robhouse robhouse added a comment - Patched Attached.

          People

          • Assignee:
            ToonArmy Chris Smith
            Reporter:
            robhouse robhouse
          • Votes:
            0 Vote for this issue
            Watchers:
            0 Start watching this issue

            Dates

            • Created:
              Updated:
              Resolved:

              Development