Announcement

Collapse
No announcement yet.

Weird database errors, help needed

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

  • Artaxerxes
    replied
    AWESOME ,

    Thanks everybody for your help!!

    Leave a comment:


  • Artaxerxes
    replied
    Cool, thanks for the info.

    Leave a comment:


  • Scott MacVicar
    replied
    depends on the size of the forum and server specifications.

    I know a large 5GB database can take 20 minutes to optimize / check all tables.

    vB.com in roughly 5 minutes

    smaller board in seconds.

    Leave a comment:


  • Artaxerxes
    replied
    How long does it take to run the repair.php file? Just so I know how long my our forum will be down?

    Thanks,

    Leave a comment:


  • Chruser
    replied
    zelaron.threadcheckerrorRecord at pos: 2280132 is not remove-markedzelaron.threadcheckerrorrecord delete-link-chain corruptedzelaron.threadcheckerrorCorruptRepairing table threadzelaron.threadrepairinfoWrong bytesec: 32-65-100 at 2280132; Skipped




    Seems to work again, thanks.

    Leave a comment:


  • Chruser
    replied
    No, I don't. Ugh, this isn't good.

    Leave a comment:


  • poolking
    replied
    Do you still have the 2.2.6 zip file? If so it is in the extras directory.

    Leave a comment:


  • Chruser
    replied
    Hmm, will repair.php from the 2.3.2 release work although I'm on 2.2.6? Besides, I'm encountering the error in a lot of random places, which isn't a good thing. Actually, go check it out for yourselves. A lot of threads seem to generate errors randomly. Oh, and view new posts doesn't work either:

    http://www.zelaron.com/forums

    Leave a comment:


  • Matthew Gordon
    replied
    I forget what error 127 actually is, but try running repair.php.

    Leave a comment:


  • Chruser
    started a topic Weird database errors, help needed

    Weird database errors, help needed

    This happens upon loading only one, specific forum category on the board:

    Database error in vBulletin 2.2.6:
    Invalid SQL:
    SELECT

    thread.threadid FROM thread
    LEFT JOIN user ON (thread.postuserid = user.userid)
    WHERE thread.forumid = 272
    AND thread.sticky=0

    AND thread.visible=1
    AND thread.lastpost >= 1062093933 AND sticky=0

    ORDER BY sticky DESC, thread.lastpost DESC
    LIMIT 0,25
    mysql error: Got error 127 from table handler
    mysql error number: 1030
    Date: Saturday 27th of September 2003 01:05:33 PM
    Script: http://www.zelaron.com/forums/forums...s=&forumid=272
    Referer:


    And I encounter this message in the admin panel itself:

    Database error in vBulletin Control Panel 2.2.6:
    Invalid SQL: SELECT count(*) AS count FROM thread WHERE dateline >= 1064638800
    mysql error: Got error 127 from table handler
    mysql error number: 1030
    Date: Saturday 27th of September 2003 01:03:35 PM
    Script: http://www.zelaron.com/forums/forums...s=&action=home
    Referer: http://www.zelaron.com/forums/admin/



    Any help would be appreciated. :/
widgetinstance 262 (Related Topics) skipped due to lack of content & hide_module_if_empty option.
Working...
X