Database error , I can t solve

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • ben_erhan
    Senior Member
    • Nov 2004
    • 142
    • 3.0.6

    Database error , I can t solve

    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
  • Steve Machol
    Former Customer Support Manager
    • Jul 2000
    • 154488

    #2
    To fix this run Repair/Optimize in the Admin CP. You may need to run it more than once to fix all errors:

    Admin CP -> Maintenance -> Repair/Optimize Tables -> Check All -> Continue

    If you cannot access the Admin CP you can also use phpMyAdmin to repair tables.

    If that doesn't work then this may be too damaged to fix with the normal methods. Please check out this thread for other ways to repair a db, particularly items #2 and 3:



    You may have to ask your host to try and repair this for you.
    Steve Machol, former vBulletin Customer Support Manager (and NOT retired!)
    Change CKEditor Colors to Match Style (for 4.1.4 and above)

    Steve Machol Photography


    Mankind is the only creature smart enough to know its own history, and dumb enough to ignore it.


    Comment

    widgetinstance 262 (Related Topics) skipped due to lack of content & hide_module_if_empty option.
    Working...