Page 1 of 1
Content change saved to MySQL but not showing on page
Posted: Fri May 04, 2007 8:29 am
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
Re: Content change saved to MySQL but not showing on page
Posted: Fri May 04, 2007 9:18 am
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
Re: Content change saved to MySQL but not showing on page
Posted: Fri May 04, 2007 11:25 am
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
Re: Content change saved to MySQL but not showing on page
Posted: Fri Jun 15, 2007 5:11 am
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
Re: Content change saved to MySQL but not showing on page
Posted: Fri Jun 15, 2007 5:47 am
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...