21307 Posts in 5737 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
| Go to End | Next > | |
| Author | Topic: | 1822 Views |
-
"Error Saving Content" - triggered by using words "select" & "from" in content
19 September 2010 at 9:30am Last edited: 24 September 2010 1:58pm
SS 2.4.1
DOM r414
SWFUpload r404
--------------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.
Previous Errors
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.phpI'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?
thanks
-
Re: "Error Saving Content" - triggered by using words "select" & "from" in content
19 September 2010 at 12:06pm
I think you are seeing that exact issue. Try out 2.4.2-rc1, install it and run dev/build (or just copy the patch and run dev/build) and let me know if its still an issue and I'll have to investigate further.
When you run dev/build you should see a bunch of removed records.
-
Re: "Error Saving Content" - triggered by using words "select" & "from" in content
20 September 2010 at 6:30am
Hey Will,
Still having the issue after upgrading to 2.4.2-rc1. I didn't see the removed records, but I think that may have happened when I initially updated the Version.php file.
I went back and played with localhost (still at 2.4.1) and it was having issues too, but more sporadically. Typing "select from" and hitting "Save" thru the "Error Saving Content", but then I immediately clicked "Save" again and everything was fine.
I tried that method on the webhost and it didn't help.
Not sure what else to try.
Thanks
-
Re: "Error Saving Content" - triggered by using words "select" & "from" in content
20 September 2010 at 7:06am Last edited: 24 September 2010 1:59pm
I just now went ahead and tried a fresh new installation of 2.4.2 with a new database. I didn't import any data from other database, just logged in after SS installed and typed "select from" on the About Us page...Same exact issue.
-
Re: "Error Saving Content" - triggered by using words "select" & "from" in content
24 September 2010 at 2:13pm Last edited: 24 September 2010 2:13pm
Hi socks,
Regarding the select+from, this is not really reproducible on the demo site, or at least I can't make it break. Are you sure your server is configured well? No magic quotes and suchlike?
381 ; Magic quotes for incoming GET/POST/Cookie data.
382 magic_quotes_gpc = Off
383
384 ; Magic quotes for runtime-generated data, e.g. data from SQL, from exec(), etc.
385 magic_quotes_runtime = Off
386
387 ; Use Sybase-style magic quotes (escape ' with '' instead of \').
388 magic_quotes_sybase = OffIf you can pinpoint the problem, you can start a ticket on our bugtracker open.silverstripe.org too, that's the best way to get attention if the issue is with the SilverStripe core!
Mateusz
-
Re: "Error Saving Content" - triggered by using words "select" & "from" in content
24 September 2010 at 2:35pm
Hey mateuzs,
I'm not sure the server is properly configured. OneWorldHosting (shared hosting) had register_globals on by default (I turned it off), and I had them switch MySQL servers before the install since the account was still using 4.0.
magic_quotes_gpc was On, I've turned it off in the INI file, but I still have the same issue. Any other config settings I should check? I've checked the server requirements page (http://doc.silverstripe.org/server-requirements) but didn't see anything wrong.
Thank you
-
Re: "Error Saving Content" - triggered by using words "select" & "from" in content
27 September 2010 at 9:21am
Just to be sure, have you resetted the server afterwards?
OK so the next thing is to get the error message. Switch the site to the dev mode (http://doc.silverstripe.org/environment-management) and check what's the exact error using the Firebug. Then we'll know how to fix it, hopefully.
Mateusz
-
Re: "Error Saving Content" - triggered by using words "select" & "from" in content
27 September 2010 at 12:23pm Last edited: 27 September 2010 12:24pm
I don't think I have the option to restart a server on shared hosting, do I?
I do have it in dev mode and I'm not getting any errors emailed to me... In Firebug I get this:
Failed to load resource: the server responded with a status of 500 (Internal Server Error)
(?)()admin (line 54)
(?)()admin (line 12)
[Break on this error] <img id="sitetree_toggle_closed" sr...e;" title="click to open this box" />\n
admin (line 54)If you would like to see it first hand, I don't mind giving u access to the cpanel or the admin since there's no content in there. You can send me a private message on IRC or give me an email address as I don't want to post that info here.
thanks again.
| 1822 Views | ||
| Go to Top | Next > |
