Skip to main content

This site requires you to update your browser. Your browsing experience maybe affected by not having the most up to date version.

Archive /

Our old forums are still available as a read-only archive.

Moderators: martimiz, Sean, biapar, Willr, Ingo, simon_w

Hosting on Webdrive (NZ) - Error saving content


Reply


5 Posts   1587 Views

Avatar
Double-A-Ron

Community Member, 604 Posts

7 July 2008 at 11:46am

Edited: 07/07/2008 11:50am

Hi All,

I have just setup my first completed SS on Webdrive NZ and begun testing the system. All seems well on the surface.

FYI - there are two must haves at the top of the htaccess file for this host:
php_value memory_limit 64M
php_value allow_call_time_pass_reference 1

You will intermittingly get memory exhausted errors without the first one, as Webdrive's default memory_limit is 20MB. This will always happen when you do a ?flush=1 or db/build/?flush=1 if you don't add it.

The one (and so far only) problem I am having is when trying to save a page in the CMS. It doesn't matter what page type I try (including the default Page), I get "Error saving content" in the lower left of the content window, and this error in Firebug:

POST http://www.domain.com/admin/?executeForm=EditForm 500 (1868ms)

Safe mode is turned off, and this is all working fine on local WAMP, so must be a configuration on the live server (I don't have access to raw logs).

Any ideas?
Aaron

Avatar
Willr

Forum Moderator, 5513 Posts

7 July 2008 at 1:00pm

If you turn dev mode on on the live site on the webserver (only temp, never want to leave a live site in dev mode) then try and save - under firebug -> Console the ajax request hopefully will return an error.

Avatar
Double-A-Ron

Community Member, 604 Posts

7 July 2008 at 1:20pm

Edited: 07/07/2008 1:21pm

Mean - I didn't know that works on the CMS side too for AJAX calls. Here is the first part of the error:

ERROR:Error 256: DATABASE ERROR: Couldn't run query: SELECT MAX(Version) + 1 FROM SiteTree_versions WHERE

RecordID = 15 | Table 'vivaexp.SiteTree_versions' doesn't exist

So a table naming thing again (I had to manually change all the table names to upper case because WAMP set them all to lowercase.

Ovbiously the word "_versions" needs to be lowercase. Can you confirm that this is across the board? Is there any others I should be aware of (like "_live"? Which is currently "_Live" on my system)

Cheers
Aaron

Avatar
Double-A-Ron

Community Member, 604 Posts

7 July 2008 at 1:32pm

Mean +1

Problem solved by changing "_Versions" to "_versions" on all the page type table names, including SiteTree_Versions.

Can I just have a clarification on the naming convention here please? Looking at a clean install, "_versions" is the only table name word that needs to be lowercase. "_Live" is supposed to be title cased.

Cheers
Aaron

Avatar
Double-A-Ron

Community Member, 604 Posts

7 July 2008 at 1:33pm

Edited: 07/07/2008 1:40pm

Hey Sam,

Cheers for the tip. I'll do that now too.

Aaron

EDIT - Hey, Sam's post is gone....