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