Can't access stacks - getting error! Help

Permalink
mysql error: [145: Table './ndlourde_ndlourdes/PageSearchIndex' is marked as crashed and should be repaired] in EXECUTE("select p1.cID, pt.ctHandle from Pages p1 left join Pages p2 on (p1.cPointerID = p2.cID) left join PageTypes pt on (pt.ctID = (if (p2.cID is null, p1.ctID, p2.ctID))) left join PagePaths on (PagePaths.cID = p1.cID and PagePaths.ppIsCanonical = 1) left join PageSearchIndex psi on (psi.cID = if(p2.cID is null, p1.cID, p2.cID)) inner join CollectionVersions cv on (cv.cID = if(p2.cID is null, p1.cID, p2.cID) and cvID = (select cvID from CollectionVersions where cvIsApproved = 1 and cID = cv.cID)) inner join Collections c on (c.cID = if(p2.cID is null, p1.cID, p2.cID)) inner join Stacks on Stacks.cID = p1.cID left join CollectionSearchIndexAttributes on (CollectionSearchIndexAttributes.cID = if (p2.cID is null, p1.cID, p2.cID)) where 1=1 and p1.cParentID = '99' and stType = '20' and cvIsApproved = '1' and (p1.cIsTemplate = 0 or p2.cIsTemplate = 0) and p1.cIsActive = '1' ")

This is the error message I get when trying to access the stacks on one of the C5 websites I have created. I think it's a MySQL database error. What should I do to fix it?

Is it a recurring error? Coz I faced the same problem with another C5 website just last week (and it had a newer version of C5 than this one...) What can the problem be?

Thanks for any help!
Diana

DianaAyub
 
ronyDdeveloper replied on at Permalink Reply
ronyDdeveloper
Go to
http://www.yoursite.com/index.php/dashboard/system/backup_restore/d...

Then at the bottom check the checkbox called " Refresh core database tables and blocks." and click Refresh Databases.

Edit: BTW if the above process doesn't work, then you need to do it through phpmyadmin. Just browse the table called "PageSearchIndex" and click the operations tab. Then you will find a Repair option. That will repair your table.

Rony