mysql error number: 2000

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • doron
    Senior Member
    • Apr 2000
    • 669

    mysql error number: 2000

    Suddenly started getting this trying to access one forum:

    Database error in vBulletin 2.3.0:

    Invalid SQL:
    SELECT

    thread.threadid
    FROM thread
    WHERE thread.forumid = 16
    AND thread.sticky=0
    AND thread.visible=1
    AND lastpost >= 1052358279 AND sticky=0

    ORDER BY sticky DESC, lastpost DESC
    LIMIT 0,40
    mysql error: Can't find record in 'thread'

    mysql error number: 2000

    Date: Friday 06th of June 2003 08:44:39 PM

    Trying to update the counters for the forums in the admin panel gets me:

    Database error in vBulletin Control Panel 2.3.0:

    Invalid SQL: SELECT COUNT(*) AS threads,SUM(replycount) AS replies FROM thread WHERE forumid=17 AND visible=1 AND open<>10
    mysql error: Got error 134 from table handler

    mysql error number: 2000

    Date: Friday 06th of June 2003 08:39:30 PM

    I tried running repair.php, but for table thread I get:

    "This table does not support check/repair/optimize"

    Anyone have any ideas?
  • Steve Machol
    Former Customer Support Manager
    • Jul 2000
    • 154488

    #2
    Run this query in phpMyAdmin:

    REPAIR TABLE thread;

    If you still have this problem them you'll need to convert this table type from ISAM to MyISAM. Again you use phpMyAdmin to 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

    • doron
      Senior Member
      • Apr 2000
      • 669

      #3
      Runnug that sql in phpMyAdmin gives me

      "The handler for the table doesn't support check/repair"

      How do I convert the table type using phpMyAdmin? Is there a faq for this?

      thanks
      Doron

      Comment

      • Steve Machol
        Former Customer Support Manager
        • Jul 2000
        • 154488

        #4
        It depends on the version of phpMyAdmin. You may need to poke around to fuind the appropriate option.
        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...