Pages wont update/refresh!

[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?

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

[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,

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

[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

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

[duplay]

Do you want me to post the debug here? It will allow me to changes pages, but not view live?

[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

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