Announcement

Collapse
No announcement yet.

Problems :(

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

  • Problems :(

    I tired updating the usernames/thread totals etc...and got this error :

    -----------

    Database error in vBulletin Control Panel 2.2.4:

    Invalid SQL: UPDATE thread SET lastpost=1017518705,replycount=0,postusername='AlecAddict', postuserid='181', lastposter='AlecAddict',attach=0 WHERE threadid=669
    mysql error: Got error 134 from table handler

    mysql error number: 1030

    Date: Sunday 31st of March 2002 02:51:16 PM
    Script: http://www.darkangeluk.com/forums/forums/admin/misc.php
    Referer: http://www.darkangeluk.com/forums/ad...action=chooser


    ------------

    mysql error: Got error 134 from table handler

    ^ That bit keeps popping up recently, I got that in an error when trying to view a thread, and also with a forum. I had installed hacks on my board board I reuploaded all the original files and I am still getting this. Any idea how to fix it??

    Thanks,

    Matt

  • #2
    you have a corrupted thread table

    you need to repair it via one of the following methods (WITH forum CLOSED!)

    1. you need to upload repair.php from your vB zip file to your /admin directory and run this url

    yourdomain.com/admin/repair.php?html=1&check=1

    2. or using mysqlcheck repair for 3.23.38 and above

    i.e. in shell/telnet/ssh type while mysql is running and forum is CLOSED:

    mysqlcheck -r -u mysqlusername -p databasename

    3. via myisamchk repair functions while mysql is shutdown/stopped in shell/telnet/ssh type :

    myisamchk -r -u root -p databasename

    option #3 most likely requires server and mysql root access to first stop mysql and then run myisamchk repair options.
    :: Always Back Up Forum Database + Attachments BEFORE upgrading !
    :: Nginx SPDY SSL - World Flags Demo [video results]
    :: vBulletin hacked forums: Clean Up Guide for VPS/Dedicated hosting users [ vbulletin.com blog summary ]

    Comment


    • #3
      What can I say! Lightning speed service, its GREAT!

      I have just done that and it appears to have fixed the problem, thank you so much

      Comment


      • #4
        Originally posted by Matt*is*thick
        What can I say! Lightning speed service, its GREAT!

        I have just done that and it appears to have fixed the problem, thank you so much
        no probs
        :: Always Back Up Forum Database + Attachments BEFORE upgrading !
        :: Nginx SPDY SSL - World Flags Demo [video results]
        :: vBulletin hacked forums: Clean Up Guide for VPS/Dedicated hosting users [ vbulletin.com blog summary ]

        Comment

        Loading...
        Working...
        X