23581 Posts in 19403 Topics by 2893 members
General questions about getting started with SilverStripe that don't fit in any of the categories above.
Page: 1 2
|Go to End||Next >|
19 September 2010 at 9:30am Last edited: 24 September 2010 1:58pm
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?
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.
20 September 2010 at 6:30am
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.
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.
24 September 2010 at 2:13pm Last edited: 24 September 2010 2:13pm
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
384 ; Magic quotes for runtime-generated data, e.g. data from SQL, from exec(), etc.
385 magic_quotes_runtime = Off
387 ; Use Sybase-style magic quotes (escape ' with '' instead of \').
388 magic_quotes_sybase = Off
If 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!
24 September 2010 at 2:35pm
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.
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.
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.
Page: 1 2
|Go to Top||Next >|