Uploaded image for project: 'phpBB3'
  1. phpBB3
  2. PHPBB3-10751

MS SQL Error when searching Admin Log

    Details

    • Type: Bug
    • Status: Unverified Fix
    • Priority: Blocker
    • Resolution: Fixed
    • Affects Version/s: 3.0.10
    • Fix Version/s: 3.0.11-RC1
    • Component/s: Search
    • Labels:
      None

      Description

      General Error
      SQL ERROR [ mssqlnative ]

      SQLSTATE: 42000 code: 8116 message: [Microsoft][SQL Server Native Client 10.0][SQL Server]Argument data type text is invalid for argument 1 of lower function. [8116]

      SQL

      SELECT COUNT(l.log_id) AS total_entries FROM phpbb_log l, phpbb_users u WHERE l.log_type = 0 AND l.user_id = u.user_id AND l.log_time >= 0 AND (LOWER(l.log_data) LIKE '%altair%' ESCAPE '\')

      BACKTRACE

      FILE: [ROOT]/includes/db/mssqlnative.php
      LINE: 321
      CALL: dbal->sql_error()

      FILE: [ROOT]/includes/functions_admin.php
      LINE: 2607
      CALL: dbal_mssqlnative->sql_query()

      FILE: [ROOT]/includes/acp/acp_logs.php
      LINE: 130
      CALL: view_log()

      FILE: [ROOT]/includes/functions_module.php
      LINE: 507
      CALL: acp_logs->main()

      FILE: [ROOT]/adm/index.php
      LINE: 74
      CALL: p_master->load_active()

        Activity

        Hide
        Noxwizard Patrick Webster added a comment -

        On MSSQL, LOWER() really wants something with a bounded length, like a varchar. In order to make it work on a TEXT type, we have to convert it to a bounded type, one way is by using SUBSTRING().

        LOWER(SUBSTRING(l.log_data, 1, DATALENGTH(l.log_data)))

        Show
        Noxwizard Patrick Webster added a comment - On MSSQL, LOWER() really wants something with a bounded length, like a varchar. In order to make it work on a TEXT type, we have to convert it to a bounded type, one way is by using SUBSTRING(). LOWER(SUBSTRING(l.log_data, 1, DATALENGTH(l.log_data)))

          People

          • Assignee:
            bantu Andreas Fischer
            Reporter:
            Kirthel Kirthel
          • Votes:
            0 Vote for this issue
            Watchers:
            0 Start watching this issue

            Dates

            • Created:
              Updated:
              Resolved:

              Development