Page 1 of 1
Pages wont update/refresh!
Posted: Mon Nov 06, 2006 9:12 pm
by duplay
I have my CMS site on my MAC server for a couple months now, and when I select a page, open it, and either edit a current html link, or try to add new material to it, it doesnt reflect the changes on the web. If I do a preview, it shows. I submit, then revisit the page I just edited, it shows the edited info on the page via the CMS admin interface, but it never shows on actual live page.
The only work around I have found it to recreate the page new and add the link to the new page. Any help?
Re: Pages wont update/refresh!
Posted: Tue Nov 07, 2006 3:26 pm
by tsw
activate debug mode and look for errors, I think someone else had a similar problem and it was because the db user didn't have upgrade rights...
Re: Pages wont update/refresh!
Posted: Tue Nov 07, 2006 4:23 pm
by duplay
Can you please explain how to activate debug mode and to look for errors? Also, how can I check on if my DB user has upgrade rights. I am the admin of the DB?
Thanks,
Re: Pages wont update/refresh!
Posted: Tue Nov 07, 2006 4:32 pm
by tsw
in config.php there is a setting for debug mode (defaults to false)
mysql rights:
SHOW GRANTS FOR 'cms_user'@'hostname';
where hostname probably is localhost.
Re: Pages wont update/refresh!
Posted: Tue Nov 07, 2006 7:53 pm
by duplay
I have the debug on and see them at the bottom of the page. Would you like me to paste them to here? I see the word Error (0) (does that mean no error?) I can paste them all here if that will will. You also posted the mysql code to see rights for my db user? Where does that go? Thanks
Re: Pages wont update/refresh!
Posted: Tue Nov 07, 2006 8:20 pm
by tsw
error(0) means no error.
you can run that sql code from any sqlclient. (in linux just run mysql -uUSERNAME -p DATABASENAME and run the command) I think phpmyadmin can run sql code too but Im not too familiar with it...
Re: Pages wont update/refresh!
Posted: Tue Nov 07, 2006 8:21 pm
by duplay
Do you want me to post the debug here? It will allow me to changes pages, but not view live?
Re: Pages wont update/refresh!
Posted: Tue Nov 07, 2006 9:39 pm
by duplay
I have checked the rights for the DB users and I have full acess as well as my CMS user is set as a admin. I have other sites on the same server that were set up with the same db login and they are able to update without error. I am able to create new pages w/o issue, but it wont let me update links that are on a page or wihin a table. any thoughts?Thanks
Re: Pages wont update/refresh!
Posted: Thu Nov 08, 2007 12:38 pm
by visitor
I have the same problem after moving servers and upgrading from CMSMS v1.0.4 to 1.2, PHP4.4.3 to PHP 5.2.0 and Mysql 4.4.x to 5.0.33.
I haven't tried what tsw suggested yet, but i will in about a minute. Any further input would be great though. Oh yeah, and clearing the cache doesn't help either.
edit: Ok, it seems like the new server has some sort of caching mechanism. So i won't see updates to the site before that one has updated as well....