Non-core contributed modules

Search broken with MS SQL Server + mssql_n

Details

  • Type: Bug Bug
  • Status: Resolved Resolved
  • Priority: Critical Critical
  • Resolution: Fixed
  • Affects Version/s: 1.8.2, 1.8.3, 1.8.4, 1.8.5, 1.9
  • Fix Version/s: None
  • Component/s: Patch: MrCute
  • Labels:
    None
  • Environment:
    Microsoft SQL Server, mssql_n ADODB driver
  • Database:
    Microsoft SQL
  • Affected Branches:
    MOODLE_18_STABLE, MOODLE_19_STABLE

Description

Search fails on SQL server due to the way the sql is built, and the way that the unicode N'string' is rewritten by the mssql_n module.

Error: Incorrect syntax near 'LIKEN'.

Fix: Add spaces around LIKE keywords!

Activity

Hide
Alastair Hole added a comment -

Added spaces before strings to avoid problems with unicode N string replacement with mssql_n

Show
Alastair Hole added a comment - Added spaces before strings to avoid problems with unicode N string replacement with mssql_n

People

Vote (0)
Watch (0)

Dates

  • Created:
    Updated:
    Resolved: