Announcement

Collapse
No announcement yet.

Database Errors on VB2.4.4

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

  • Database Errors on VB2.4.4

    Database error in vBulletin 2.2.4:

    Invalid SQL: REPLACE INTO searchindex (wordid,postid,intitle) VALUES (271,81608,0),(91640,81608,0),(129139,81608,0),(3338,81608,0),(1814,81608,0)
    mysql error: Got error -1 from table handler

    mysql error number: 1030

    Date: Sunday 24th of March 2002 11:29:34 PM
    Script: http://www.htmlforums.com/newreply.php
    Referer: http://www.htmlforums.com/newreply....&threadid=12242

    This happens when a new post or a new reply is made. In addition postcounts are not incrementing and the new folder isn't appearing. DOes anyone have any ideas?
    Jason M. DesRoches
    Co-Founder / Business Development
    Big Resources Network
    [email protected]
    ICQ: 17947522

  • #2
    Here's another error:

    Database error in vBulletin 2.2.4:

    Invalid SQL: REPLACE INTO searchindex (wordid,postid,intitle) VALUES (3416,81609,0),(1942,81609,0),(1814,81609,0),(9,81609,0),(2633,81609,0),(468,81609,0),(303 9,81609,0)
    ,(1675,81609,0),(4154,81609,0),(128932,81609,0),(9213,81609,0),(91753,81609,0),(3683,81609 ,0),(12681
    4,81609,0),(343,81609,0),(129238,81609,0),(112154,81609,0),(2956,81609,0),(129134,81609,0) ,(2022,816
    09,0),(5233,81609,0),(608,81609,0),(28934,81609,0),(612,81609,0),(4968,81609,0),(74070,816 09,0),(721
    8,81609,0),(28780,81609,0),(129331,81609,0),(340,81609,0),(91482,81609,0),(416,81609,0),(2 3346,81609
    ,0),(71,81609,0),(63,81609,0)
    mysql error: Got error -1 from table handler

    mysql error number: 1030

    Date: Sunday 24th of March 2002 11:32:35 PM
    Script: http://www.htmlforums.com/newreply.php
    Referer: http://www.htmlforums.com/newreply....&threadid=12242
    Jason M. DesRoches
    Co-Founder / Business Development
    Big Resources Network
    [email protected]
    ICQ: 17947522

    Comment


    • #3
      It sounds like your searchindex table got corrupted. You could try emptying the index and rebuiding it again in the Update Counters section of the Admin CP. Be aware that this could be very server intensive. You might want to shut off your forums while you do this.
      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


      • #4
        how do i empty the index? Is this done automatically when I rebuild it in the update counters section?
        Jason M. DesRoches
        Co-Founder / Business Development
        Big Resources Network
        [email protected]
        ICQ: 17947522

        Comment


        • #5
          Nm, found it, thanks.
          Jason M. DesRoches
          Co-Founder / Business Development
          Big Resources Network
          [email protected]
          ICQ: 17947522

          Comment

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