Index Error. Im Lost

Permalink 1 user found helpful
On the page that runs the scheduled jobs on my dash board i see this error.

mysql error: [145: Table './vjohnson_conc5/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 max(cvID) from CollectionVersions where cID = cv.cID)) inner join Collections c on (c.cID = if(p2.cID is null, p1.cID, p2.cID)) left join CollectionSearchIndexAttributes on (CollectionSearchIndexAttributes.cID = if (p2.cID is null, p1.cID, p2.cID)) where 1=1 and p1.cParentID = '0' and (p1.cIsTemplate = 0 or p2.cIsTemplate = 0) and (p1.cID not in (5,6,7,8,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32,33,34,35,36,37,38,39,40,41,43,44,45,46,47,48,49,50,51,52,53,54,55) or p2.cID not in (5,6,7,8,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32,33,34,35,36,37,38,39,40,41,43,44,45,46,47,48,49,50,51,52,53,54,55)) ")


website is JCclippers02.com

Any ideas?

 
Mainio replied on at Permalink Reply
Mainio
You should run the repair table MySQL command for that table. You need to know how to manually access your database to do this (from console or e.g. phpMyAdmin)

Here's the query you need to do:
REPAIR TABLE PageSearchIndex;
BrettDashwood replied on at Permalink Reply
BrettDashwood
I know this one was a while ago, but I have a similar issue. I can access the database through phpMyAdmin, but I have never done this before and am unsure what I am looking at when I open it.

Do I simply go to the Query tab and enter
REPAIR TABLE PageSearchIndex;
as an 'SQL query on database'?

And should I definitely be logged out of the site itself?
Mainio replied on at Permalink Reply
Mainio
Yes, anywhere you can access to your database, you can run it.

And as people always seem to forget this (at least when it comes to updating a site):
TAKE A DB BACKUP ALWAYS BEFORE YOU MODIFY ANYTHING IN IT!!!
JohntheFish replied on at Permalink Reply
JohntheFish
ConcreteOwl replied on at Permalink Reply
ConcreteOwl
phpMyAdmin has a very easy method of running basics queries on its tables,

This is how..

When logged into phpMyAdmin you will see on the left hand side of the page a list of tables within the database, at the top of the list is the database itself,
Click the database name, you will now see all the tables listed in the main page,
Select your table by ticking the box to the left of the table in your case 'PageSearchIndex',
Now scroll to the bottom of the list and in the "With selected:" drop down box choose "Repair table"

phpMyAdmin will run the query and will produce a page showing the results.
BrettDashwood replied on at Permalink Best Answer Reply
BrettDashwood
@Mainio @JohntheFish @weyboat

Thank you. Very much appreciated. All done.

BTW, in phpMyAdmin 3.4.11.1 it is slightly different.

I don't know when this changed, however I was worried when there was no drop down list under my tables.

The first part of your instructions is correct - select the database, and then select the table to be repaired from the left of screen - however you then need to click on the "Operations" tab in the main section of screen and then bottom left of that section is "Table maintenance" under which there are the options:

- Check table
- Analyze table
- Repair table
- Optimize table
- Flush the table (FLUSH)

...so I selected 'Repair table'

I just thought I'd detail this for those that may have a newer version of phpMyAdmin and find this needing help.