This is the strangest thing I've seen...
What triggers the error
The site only shows the error on the web host (works fine on localhost).
- I've since determined that when any text/content block in the CMS (Page Name, Navigation Label, Content, Site Config, etc) contains both the words "select" and "from", I get "Error Saving Content" when trying to Save or Publish.
- And it's really "select*" & "from*", so "selection", "selects", and "fromdkfjdl" will also trigger the issue. It doesn't matter where the words are in the Content,
nor in what order. For example, "Select the color you like best from the options below" will trigger the issue.
- This happens on every page type/template.
I was getting errors like this, but not anymore…
Error: Couldn't run query: INSERT INTO "RedirectorPage_versions" ("LinkToID", "ExternalURL", "RedirectionType", "RecordID", "Version") VALUES (25, null, 'Internal', 8, 10) Duplicate entry '8-10' for key 2
At line 536 in /xxx/sapphire/core/model/MySQLDatabase.php
I've updated Version.php ( http://open.silverstripe.org/ticket/5936 ) in core since the error seemed similar. Maybe I should try updating SS to the latest trunk version?