Announcement

Collapse
No announcement yet.

mysql error number: 1030

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

  • mysql error number: 1030

    Invalid SQL:
    SELECT setting.*, settinggroup.grouptitle
    FROM settinggroup AS settinggroup
    LEFT JOIN setting AS setting USING(grouptitle)
    WHERE settinggroup.displayorder <> 0
    ORDER BY settinggroup.displayorder, setting.displayorder

    mysql error: Got error -1 from table handler

    mysql error number: 1030

    Date: Wednesday 11th of August 2004 07:11:26 PM
    Script: http://www.??????.net/forums/admincp/options.php?null=0
    Referer: http://www.???????.net/forums/admincp/index.php?do=nav

    Any help?

    Regards
    الحمدُ للهِ الذي أنزلَ على عبدِهِ الكتابَ و لم يجعل لهُ عِوَجًا - سورة الكهف 1
    Winner - vB Board of the Month - March 2008
    Winner vB Board of Year 2005
    vbulletinclub.com

  • #2
    Run Repair/Optimize in the Admin CP:

    Admin CP -> Import & Maintenance -> Repair/Optimize Tables -> Check All -> Continue
    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


    • #3
      i've the same error today, vbulletin 3.0.4 tried repair but not happened why does this happens?

      Comment


      • #4
        mysql error: Got error -1 from table handler

        This error means that something happened to the databaase but MySQL could not find the exacct problem. Usually running repair/optimize should fix this. You may need to run it more than once.

        If you still have this problem, then check out this thread for other ways to repair a db:

        http://www.vbulletin.com/forum/showt...threadid=44909
        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...
        X