mysql search engine database error

Permalink
Hey concrete5'ers. When I make an edit I get this error: Fatal error: Uncaught exception 'ADODB_Exception' with message 'mysql error: [145: Table './capitala_cnccaa/PageSearchIndex' is marked as crashed and should be repaired] in EXECUTE("UPDATE PageSearchIndex SET cName='About Us',cDescription='',cPath='/about-us',cDatePublic='2011-11-02 14:11:21',content='746 Walker Road Suite 16-D Great Falls, VA 22066 \r\nPhone : 866-255-0009     571-335-8888    Fax : 571-335-8889   \r\n   \r\n We practice the \"ART\" of medicine... \r\nVision \r\n \r\n \r\n\r\n \r\n \r\nCapital Anesthesia Associates’ (CAA) vision is to be the preeminent provider of choice for office based anesthesia services in the Washington D.C. Metro area.  We provide unparalleled safe, efficient, and patient-focused anesthesia services that are tailored to meet the individualized needs of patients and health care providers. \r\n \r\n  \r\n \r\nMission \r\n \r\n \r\n\r\n \r\n   \r\n At Capital Anesthesia Associates’ (CAA) we practice the &ldquo in /home/capitala/public_html/officeanesthesia.com/concrete/libraries/3rdparty/adodb/adodb-exceptions.inc.php on line 78

So I went to backup the database and I was going to do re-install but I have this error: mysql error: [145: Table './capitala_cnccaa/PageSearchIndex' is marked as crashed and should be repaired] in EXECUTE("SELECT * FROM PageSearchIndex")

So I went to jobs and tried to update the index search engine and I get this error: mysql error: [145: Table './capitala_cnccaa/PageSearchIndex' is marked as crashed and should be repaired] in EXECUTE("select p1.cID, pt.ctHandle from Pages p1 left join PageTypes pt on (pt.ctID = p1.ctID) left join PagePaths on (PagePaths.cID = p1.cID an

It seems like I just cant win today. Please help me out.

Thanks in advance

 
andrew replied on at Permalink Best Answer Reply
andrew
If you have access to either MySQL on the command line or PhpMyAdmin, you need to run the query

repair table PageSearchIndex


I don't think you can even backup the table until you do this. Fortunately I've never had a repair table operation fail. It shouldn't take too long and you should be able to backup/run jobs/etc... once you do this.
merge replied on at Permalink Reply
I just logged in and selected repair db and its all good. Thanks
JoshRendezvous replied on at Permalink Reply
JoshRendezvous
Thanks for your help on this, you rock!