Skip to content

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

@hadlee-ogilvy

Description

@hadlee-ogilvy

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?

Metadata

Metadata

Assignees

No one assigned

    Labels

    No labels
    No labels

    Type

    No type
    No fields configured for issues without a type.

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions