Apparent database corruption [solved]

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.
Post Reply
User avatar
Charles Butcher
Forum Members
Forum Members
Posts: 103
Joined: Sat Jul 05, 2008 8:25 pm

Apparent database corruption [solved]

Post by Charles Butcher »

One of my pages has disappeared from the backend list, though it still shows up on the published site.

I tried the Reorder Pages command, as suggested here: http://forum.cmsmadesimple.org/index.ph ... 018.0.html, but this has neither restored the page to the list nor deleted it from the front end.

In the past I've had a few glitches where pages have appeared with duplicate numbers, but have always been able to fix the problem by shuffling pages up and down the hierarchy. This time it seems to be more serious.

Any suggestions? I have phpMyAdmin 2.8.2.4; can I use this to analyse or repair the database?

The "missing" page contained a photo album built with Album 0.9.3. Could this module be the source of the problem? If so, I apologise for posting in the wrong place.
Last edited by Charles Butcher on Mon Aug 31, 2009 10:20 am, edited 1 time in total.
User avatar
Charles Butcher
Forum Members
Forum Members
Posts: 103
Joined: Sat Jul 05, 2008 8:25 pm

Re: Apparent database corruption [solved]

Post by Charles Butcher »

Classic RTFM, for which I apologise.

I didn't imagine that problems with a specific module could cause pages to disappear from the list, but I was wrong. Album has some issues in this respect.

Learned how to use PHPMyAdmin to check the integrity of tables. If there's anyone else out there who, like me, basically hasn't a clue about MySQL or PHP but loves CMSms nonetheless, take heart -- you can learn bit by bit.
Post Reply

Return to “CMSMS Core”