[ORM] Error: Uncaught SS_DatabaseException on specific search string

[eolant]

SS 3.2.0-3.3.1 - standard installation through composer.
Search is enabled using FulltextSearchable::enable();
If search string ends with > e.g. hello> SS throws error:

[User Error] Uncaught SS_DatabaseException: Couldn't run query: SELECT DISTINCT count(*) FROM "SiteTree_Live" WHERE ( MATCH (Title, MenuTitle, Content, MetaDescription) AGAINST ('hello>*' IN BOOLEAN MODE) + MATCH (Title, MenuTitle, Content, MetaDescription) AGAINST ('hello>*' IN BOOLEAN MODE) AND ShowInSearch 0) syntax error, unexpected $end, expecting FTS_TERM or FTS_NUMB or '*'
GET /home/SearchForm?Search=hello%3E&action_results=L
Line 55 in /Users/vitaly/www/sstest/framework/model/connect/DBConnector.php

[kinglozzer]

Similar issue to silverstripe/silverstripe-framework#3212 perhaps?

[tractorcow]

Yes, similar issue, but new proof of concept. :D

[sminnee]

See also silverstripe/silverstripe-framework#3212

[sminnee]

I've added a test for this to 4.x-dev and it appears to be fixed; can we confirm that? #2320

[maxime-rainville]

#2320 addressed the issue for SS4.

Unfortunately, SilverStripe 3 has entered limited support in June 2018. This means we'll only be fixing critical bugs and security issues for SilverStripe 3 going forward.

You can read the SilverStripe Roadmap for more information on our support commitments.