Unexpected Error after Client Edit
Permalink
Hey all. A client made a "simple" edit to a page, hit publish and was presented with this error. Can anyone help me decipher it?
An exception occurred while executing 'SELECT p.cID FROM Pages p LEFT JOIN PagePaths pp ON (p.cID = pp.cID and pp.ppIsCanonical = true) LEFT JOIN PageSearchIndex psi ON p.cID = psi.cID LEFT JOIN PageTypes pt ON p.ptID = pt.ptID INNER JOIN Collections c ON p.cID = c.cID INNER JOIN CollectionVersions cv ON p.cID = cv.cID LEFT JOIN CollectionSearchIndexAttributes csi ON c.cID = csi.cID WHERE (cvName != ?) AND (pt.ptID = ?) AND ((ak_exclude_page_list = 0 or ak_exclude_page_list is null)) AND (p.cPointerID < 1) AND (p.cIsTemplate = 0) AND (cvIsApproved = 1) AND (p.cIsActive = ?) AND (p.cIsSystemPage = ?) ORDER BY p.cDisplayOrder asc' with params ["", "11", true, false]: SQLSTATE[HY000]: General error: 145 Table './impressi_2016/PageSearchIndex' is marked as crashed and should be repaired
An exception occurred while executing 'SELECT p.cID FROM Pages p LEFT JOIN PagePaths pp ON (p.cID = pp.cID and pp.ppIsCanonical = true) LEFT JOIN PageSearchIndex psi ON p.cID = psi.cID LEFT JOIN PageTypes pt ON p.ptID = pt.ptID INNER JOIN Collections c ON p.cID = c.cID INNER JOIN CollectionVersions cv ON p.cID = cv.cID LEFT JOIN CollectionSearchIndexAttributes csi ON c.cID = csi.cID WHERE (cvName != ?) AND (pt.ptID = ?) AND ((ak_exclude_page_list = 0 or ak_exclude_page_list is null)) AND (p.cPointerID < 1) AND (p.cIsTemplate = 0) AND (cvIsApproved = 1) AND (p.cIsActive = ?) AND (p.cIsSystemPage = ?) ORDER BY p.cDisplayOrder asc' with params ["", "11", true, false]: SQLSTATE[HY000]: General error: 145 Table './impressi_2016/PageSearchIndex' is marked as crashed and should be repaired
Thank you very much!
I opened mysql, went to the impressi_2016 database, found the PageSearchIndex table, selected it and repaired that table. Problem solved!
This site was very helpful as to how to repair tables:https://www.a2hosting.com/kb/cpanel/cpanel-database-features/optimiz...
I opened mysql, went to the impressi_2016 database, found the PageSearchIndex table, selected it and repaired that table. Problem solved!
This site was very helpful as to how to repair tables:https://www.a2hosting.com/kb/cpanel/cpanel-database-features/optimiz...
Well done! Thanks for posting that link; it will be useful for those who may follow.
IIRC, REPAIR TABLE might fix it. But first, back up your site files and database—and don't over-write your previous backups.