You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
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?
The text was updated successfully, but these errors were encountered:
Also causing a server error when I search with this package installed on the server (I have tried changing to dev and then back to test and issue still persists)
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?
The text was updated successfully, but these errors were encountered: