Dear Friends, I have tried to repair tables so many times.But it could not be repaired.When I check the taples it says "Table 'postindex' is marked as crashed and last (automatic?) repair failed"
The detailed information below:
Database error in vBulletin 3.7.1:
Invalid SQL:
INSERT IGNORE INTO postindex
(wordid, postid, score, intitle)
SELECT DISTINCT wordid, 924087, CASE title WHEN 'ccccccccccc' THEN 1 ELSE 1 END, CASE title WHEN 'ccccccccccc' THEN 1 ELSE 0 END
FROM word
WHERE title IN ('ccccccccccc');
MySQL Error : Table 'postindex' is marked as crashed and last (automatic?) repair failed
Error Number : 1195
Request Date : Thursday, November 27th 2008 @ 12:38:46 PM
Error Date : Thursday, November 27th 2008 @ 12:38:46 PM
Script : http://www.uydukurdu.com/forum/newre...reply&t=141339
Referrer : http://www.uydukurdu.com/forum/newre...ote=1&p=924086
IP Address : 81.********
Username : BoSS
Classname : vb_database
MySQL Version : 4.1.22-standard
The detailed information below:
Database error in vBulletin 3.7.1:
Invalid SQL:
INSERT IGNORE INTO postindex
(wordid, postid, score, intitle)
SELECT DISTINCT wordid, 924087, CASE title WHEN 'ccccccccccc' THEN 1 ELSE 1 END, CASE title WHEN 'ccccccccccc' THEN 1 ELSE 0 END
FROM word
WHERE title IN ('ccccccccccc');
MySQL Error : Table 'postindex' is marked as crashed and last (automatic?) repair failed
Error Number : 1195
Request Date : Thursday, November 27th 2008 @ 12:38:46 PM
Error Date : Thursday, November 27th 2008 @ 12:38:46 PM
Script : http://www.uydukurdu.com/forum/newre...reply&t=141339
Referrer : http://www.uydukurdu.com/forum/newre...ote=1&p=924086
IP Address : 81.********
Username : BoSS
Classname : vb_database
MySQL Version : 4.1.22-standard
Comment