Content change saved to MySQL but not showing on page

For questions and problems with the CMS core. This board is NOT for any 3rd party modules, addons, PHP scripts or anything NOT distributed with the CMS made simple package itself.
Locked
Edward

Content change saved to MySQL but not showing on page

Post by Edward »

I've been passed the baton of company webmaster.  We've recently changed our host, and I've managed to transfer the whole caboodle over to the new site:

http://www.techop.co.uk/

However, when I try to amend the content via CMSMadeSimple, the actual web page is NOT updated.  I've gone into the database and determined that the changes have been saved to the table:

SELECT * FROM `cms_content_props` WHERE 1

So, my question is - what more do I need to do to get the revised content from the database to the page?  Obviously, in the content Admin Panel I pressed "Apply" and then "Submit".  Is there a permissions issue on some cache somewhere?  I'm not seeing any error messages.

CMS Made Simple 0.13-beta4 "Canary"
phpMyAdmin 2.9.1.1 / MySQL 3.23.58

Thanks

Edward
cyberman

Re: Content change saved to MySQL but not showing on page

Post by cyberman »

Hi Edward,
Edward wrote: what more do I need to do to get the revised content from the database to the page?
Have you tried to clear cache (menu site admin > global settings)?
in the content Admin Panel I pressed "Apply" and then "Submit".
Normally it's enough to click "Apply" or "Submit".

"Submit" means Save and exit, "Apply" means only Save
Is there a permissions issue on some cache somewhere?
 

No, if you have the permission to change content changes should applied too.
CMS Made Simple 0.13-beta4 "Canary"
Think using of beta software on productive pages is not a good idea ::) ... maybe you should try to update to stable 0.13
Edward

Re: Content change saved to MySQL but not showing on page

Post by Edward »

Hy Cy

Cleared the cache - didn't work.

Changed from 0.13-beta4 "Canary" to CMS Made Simple 1.0.6 "Niihau" - RESULT!

Pages now updating correctly.

Fantastic.

Thanks

Edward
mikemee
Forum Members
Forum Members
Posts: 20
Joined: Sun May 21, 2006 11:31 am

Re: Content change saved to MySQL but not showing on page

Post by mikemee »

Ouch, same problem, same CMS version. Moved hosting recently (nicely automated via CPanel), but while I can edit a page, view it correctly in preview, no changes ever show up in the live version of the site. I've checked and opened up everything I can see in the /tmp directory, but still no joy ...

Any suggestions?  I could upgrade, but I'm reluctant to take the risk of spending all night tweaking templates etc as a result if its just a simple file permissions problem somewhere...

thx, michael
mikemee
Forum Members
Forum Members
Posts: 20
Joined: Sun May 21, 2006 11:31 am

Re: Content change saved to MySQL but not showing on page

Post by mikemee »

Tracked this down. The new hosting service has PHP running under my account, so tmp and tmp/template_c etc need to be owned by my account, and they were owned by apache. 

I cheated and renamed template_c to template_c_old and then created a new template_c and then everything started working again as expected.

:-)  And so I put off updating to the latest a bit longer - which I'm sure will come back to haunt me...
Locked

Return to “CMSMS Core”