Prepend minus symbol in `filter` parameter cause SQL syntax error

FLEXIcontent / flexicontent-cck

Advanced content management for Joomla

http://www.flexicontent.org

82 stars 53 forks source link

Prepend minus symbol in `filter` parameter cause SQL syntax error #1112

Closed akunzai closed 1 year ago

akunzai commented 1 year ago

The prepend minus symbol in filter parameter generating problematic SQL statement like MATCH (ie.search_index) AGAINST ('+-vvvtest*' IN BOOLEAN MODE) in the MySQL boolean full-text searching

Steps to reproduce

pass query string ?filter=-test to the category view form URL

Errors

mysqli_sql_exception: syntax error, unexpected '-'