PDA

View Full Version : database erreor


sabahor
03-19-2010, 05:13 AM
look this a huge problem i cant delet posts !!!
pic:
https://vborg.vbsupport.ru/

the errorDatabase error in vBulletin 4.0.1:

Invalid SQL:

DELETE searchcore, searchcore_text
FROM searchcore AS searchcore JOIN
searchcore_text AS searchcore_text ON
searchcore.searchcoreid = searchcore_text.searchcoreid
WHERE searchcore.groupcontenttypeid = 2 AND
searchcore.groupid = 28;

MySQL Error : Table './sabahor_drz/searchcore_text' is marked as crashed and should be repaired
Error Number : 145
Request Date : Friday, March 19th 2010 @ 08:07:29 AM
Error Date : Friday, March 19th 2010 @ 08:07:29 AM
Script : http://www.drz.co.il/inlinemod.php?do=dodeletethreads&threadids=29,28,262
Referrer : http://www.drz.co.il/inlinemod.php?forumid=2
IP Address : 109.65.108.56
Username : sabahor
Classname : vB_Database
MySQL Version : 5.1.41

borbole
03-19-2010, 11:44 AM
look this a huge problem i cant delet posts !!!
pic:
http://up202.siz.co.il/up2/fjzzouyt1gqi.jpg

the errorDatabase error in vBulletin 4.0.1:

Invalid SQL:

DELETE searchcore, searchcore_text
FROM searchcore AS searchcore JOIN
searchcore_text AS searchcore_text ON
searchcore.searchcoreid = searchcore_text.searchcoreid
WHERE searchcore.groupcontenttypeid = 2 AND
searchcore.groupid = 28;

MySQL Error : Table './sabahor_drz/searchcore_text' is marked as crashed and should be repaired
Error Number : 145
Request Date : Friday, March 19th 2010 @ 08:07:29 AM
Error Date : Friday, March 19th 2010 @ 08:07:29 AM
Script : http://www.drz.co.il/inlinemod.php?do=dodeletethreads&threadids=29,28,262
Referrer : http://www.drz.co.il/inlinemod.php?forumid=2
IP Address : 109.65.108.56
Username : sabahor
Classname : vB_Database
MySQL Version : 5.1.41


Try to repair the searchcore_text table.

sabahor
03-20-2010, 07:38 AM
how i repair it?

shozy
03-20-2010, 09:55 AM
i have the same prob dear :(

borbole
03-20-2010, 02:42 PM
how i repair it?

You can repair it at phpmyadmin in the cp of your host. Select the db that your forum resides on, select the table in question and all the way to the bottom where it says: With selected choose the Repair option.