No custom addons from File just 3 dataobjects, works on in dev but breaks in test/live
[Alert] Uncaught SilverStripe\ORM\Connect\DatabaseException: Couldn't run query: SELECT DISTINCT AS "" FROM "SearchDocument" UNION SELECT DISTINCT ClassName, "File_Live"."ID", ParentID, Title, _utf8'' AS "MenuTitle", _utf8'' AS "URLSegment", _utf8'' AS "Content", LastEdited, Created, Name, MATCH (Name, Title) AGAINST ('test') AS "Relevance", NULL AS "CanViewType" FROM "File_Live" WHERE (MATCH (Name, Title) AGAINST ('test*' IN BOOLEAN MODE) AND ClassName = 'SilverStripe\Assets\File' AND ShowInSearch 0) ORDER BY "Relevance" DESC LIMIT 0, 10000 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'AS "" FROM "SearchDocument" UNION SELECT DISTINCT ClassName, "File_Live"."ID", ' at line 1 in
getting this with
"silverstripe/recipe-plugin": "^1.5",
"silverstripe/recipe-cms": "4.7.2",
Anyone had this issue before?
No custom addons from File just 3 dataobjects, works on in dev but breaks in test/live
[Alert] Uncaught SilverStripe\ORM\Connect\DatabaseException: Couldn't run query: SELECT DISTINCT AS "" FROM "SearchDocument" UNION SELECT DISTINCT ClassName, "File_Live"."ID", ParentID, Title, _utf8'' AS "MenuTitle", _utf8'' AS "URLSegment", _utf8'' AS "Content", LastEdited, Created, Name, MATCH (Name, Title) AGAINST ('test') AS "Relevance", NULL AS "CanViewType" FROM "File_Live" WHERE (MATCH (Name, Title) AGAINST ('test*' IN BOOLEAN MODE) AND ClassName = 'SilverStripe\Assets\File' AND ShowInSearch 0) ORDER BY "Relevance" DESC LIMIT 0, 10000 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'AS "" FROM "SearchDocument" UNION SELECT DISTINCT ClassName, "File_Live"."ID", ' at line 1 in
getting this with
"silverstripe/recipe-plugin": "^1.5",
"silverstripe/recipe-cms": "4.7.2",
Anyone had this issue before?