Jump to:

21305 Posts in 5736 Topics by 2603 members

General Questions

SilverStripe Forums » General Questions » "Error Saving Content" - triggered by using words "select" & "from" in content

General questions about getting started with SilverStripe that don't fit in any of the categories above.

Moderators: martimiz, Howard, Sean, Ryan M., biapar, Willr, Ingo, swaiba, simon_w

Page: 1 2
Go to End
Author Topic: 1821 Views
  • MateuszU
    Avatar
    Community Member
    87 Posts

    Re: "Error Saving Content" - triggered by using words "select" & "from" in content Link to this post

    Nah, I'm not a sysadmin, so won't be able to help you there. Try different approach, add this to your _config.php:

    SS_Log::add_writer(new SS_LogEmailWriter('your@email.address.it'), SS_Log::ERR);

    You should get the error message into your inbox.

    Mateusz

  • socks
    Avatar
    Community Member
    182 Posts

    Re: "Error Saving Content" - triggered by using words "select" & "from" in content Link to this post

    I have that in my _config. I do receive errors in general, just not for this scenario.

    Thanks for the effort, I appreciate it.

  • MateuszU
    Avatar
    Community Member
    87 Posts

    Re: "Error Saving Content" - triggered by using words "select" & "from" in content Link to this post

    Hmm so it looks like the error is not coming from SilverStripe layer, since you are in dev mode and have emails enabled.

    I think my next step in this case would be to hijack the query function call (probably in MySqlDatabase.php) and add some logging mechanism to dump all the executed queries (firebug, var_dump, or write to a file). Then you can have a look through raw queries and find the last one before the server crashes (probably the UPDATE one that stores the "select from" thing, right?).

    Then you could try this query in phpMyAdmin directly to see if it's something with the query itself.

    Mateusz

  • Jonn
    Avatar
    Community Member
    10 Posts

    Re: "Error Saving Content" - triggered by using words "select" & "from" in content Link to this post

    I'm running SS 2.4.3 and I'm having a similar issue anytime the word select or from is in the content I am trying to save it causes an Error Saving Content message and an 500 Internal Server Error tried the patch mentioned in this thread but that does not solve the problem.

    Anyone else run into this problem?

    1821 Views
Page: 1 2
Go to Top

Want to know more about the company that brought you SilverStripe? Then check out SilverStripe.com

Comments on this website? Please give feedback.