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...