Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Error with Base install of 1.0.5 and dev-master #21

Open
hadlee-ogilvy opened this issue Dec 16, 2021 · 1 comment
Open

Error with Base install of 1.0.5 and dev-master #21

hadlee-ogilvy opened this issue Dec 16, 2021 · 1 comment

Comments

@hadlee-ogilvy
Copy link

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?

@hadlee-ogilvy
Copy link
Author

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)

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

1 participant