[CMS] Database error

[Deverill]

Ive upgraded to MySQL 5.1.63 today

And I've got the following errors just now -

Doing a search -

Database error in vBulletin 4.2.0:

Invalid SQL:


SELECT searchcore.searchgroupid, searchgroup.dateline
FROM searchcore AS searchcore
JOIN searchcore_text AS searchcore_text ON (searchcore_text.searchcoreid = searchcore.searchcoreid)
JOIN searchgroup AS searchgroup ON (searchgroup.searchgroupid = searchcore.searchgroupid)


WHERE MATCH(searchcore_text.title, searchcore_text.keywordtext) AGAINST ('Volunteer roles') LIMIT 500;


MySQL Error : Table './midwife_forum/searchcore_text' is marked as crashed and should be repaired
Error Number : 145
Request Date : Tuesday, September 18th 2012 @ 11:03:14 AM
Error Date : Tuesday, September 18th 2012 @ 11:03:14 AM
Script : http://www.midwiferyonline.co.uk/search.php?do=process
Referrer : http://www.midwiferyonline.co.uk/con...unteer-with-us!
IP Address : 87.112.121.140
Username : Dappy
Classname : vB_Database
MySQL Version : 5.1.63-cll

Editing and saving a article I was presented with -

Database error in vBulletin 4.2.0: Invalid SQL: INSERT INTO searchcore_text (searchcoreid, title, keywordtext) VALUES ( 18041, 'Join the Midwifery & Nursing Online team and volunteer with us!', 'As you are all aware everyone here at Midwifery Online volunteers their time to help support us with what we do. None of us take a wage and we are proud to see a community come together to support one another.

What do I need to do?

- - - Updated - - -

I am also getting database errors when trying to delete posts.

[snakes1100]

The message states the table is crashed, you can use phpmyadmin to repair it, you can also repair via the admincp maintenance section.

[Deverill]

Is there any risk involved in repairing the tables? I've never done this before!

[soniceffect]

At the end of the day there is already a problem with the table, therefore you need to repair it regardless. This is something I have done many times and never caused me a problem, in fact has only ever fixed problems lol

[Deverill]

Phew all done and seems peace has been restored. I hate it when things go wrong!