Announcement

Collapse
No announcement yet.

SQL data base error

Collapse
X
 
  • Filter
  • Time
  • Show
Clear All
new posts

  • SQL data base error

    My server host told me to optimise my tables and run a repair of the tables, now Im getting the following error come through

    Database error in vBulletin 3.8.1:

    Invalid SQL:

    REPLACE INTO postindex
    (wordid, postid, score, intitle)
    VALUES
    (100, 9, 1, 0), (101, 9, 1, 0), (1, 9, 1, 0), (102, 9, 1, 0), (99, 9, 1, 0);

    MySQL Error : Table 'postindex' is marked as crashed and last (automatic?) repair failed
    Error Number : 1195
    Request Date : Wednesday, October 14th 2009 @ 12:08:16 PM
    Error Date : Wednesday, October 14th 2009 @ 12:08:16 PM
    Script : http://www.thespainforum.com/admincp/misc.php?do=buildpostindex
    Referrer : http://www.thespainforum.com/admincp/misc.php?do=chooser
    IP Address : ########
    Username : #####
    Classname : vB_Database
    MySQL Version : 4.1.22-standard-log

    Is there anyway of sorting this out, Im at my wits end and as you can imagine, just a bit stressed
    .

  • #2
    When I run repair optimise from the admin panel, I get the following error

    postindex Check Warning: Table is marked as crashed and last repair failed postindex Check Warning: 3 clients are using or haven't closed the table properly postindex Check Error: Found 1537 keys of 3221228 postindex Check Error: Corrupt postindex
    .

    Comment


    • #3
      Take a look at this - 3 ways to repair a database See if another method will help in repairing the table.

      Please don't PM or VM me for support - I only help out in the threads.
      vBulletin Manual & vBulletin 4.0 Code Documentation (API)
      Want help modifying your vbulletin forum? Head on over to vbulletin.org
      If I post CSS and you don't know where it goes, throw it into the additional.css template.

      W3Schools <- awesome site for html/css help

      Comment

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