Page 1 of 1

Apparent database corruption [solved]

Posted: Thu Aug 27, 2009 2:36 pm
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.

Re: Apparent database corruption [solved]

Posted: Mon Aug 31, 2009 10:27 am
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.