Announcement

Collapse
No announcement yet.

mySQL Error 1030

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

  • Steve Machol
    replied
    My guess is that your host did not really do option #3 otherwise the problem would have been fixed.

    We can take a look at this for you but my suspicion is that only your host will be able to fix this database. Fill out a support ticket at:

    http://www.vbulletin.com/members/support_form.php

    Be sure to include the login info to your Admin CP and phpMyAdmin.

    Leave a comment:


  • ricks
    replied
    I was finally able to run the repair query in phpmyadmin. This time I shut the board down and ran the query as:

    REPAIR TABLE user;
    REPAIR TABLE userfield;

    It said the queries ran OK but the two tables are still corrupt.

    How do I recover from this?

    The two tables are currently displaying 30 of the 197 users registered. Can this be used as a start?

    Thanks

    Leave a comment:


  • ricks
    replied
    Originally posted by Steve Machol
    You'll need to use one of these options then:

    http://www.vbulletin.com/forum/showt...threadid=44909
    I tried option 1.

    I can't do option 2 because my web host has not upgraded their mySQL.

    They say they did option 3 and it didn't work.

    Its time for an option 4; or help in explaining how to rebuild without loosing my message base.

    If I can't fix the user and userfield tables what can I do to recover?

    Thanks

    Leave a comment:


  • Steve Machol
    replied
    You'll need to use one of these options then:

    http://www.vbulletin.com/forum/showt...threadid=44909

    Leave a comment:


  • ricks
    replied
    Originally posted by Steve Machol
    Sometimes you need to run repair more than once for it to catch and fix all errors. Glad it's working.
    I have vBulletin back on line but I have two corrupt tables, user & userfield.

    When I try to use phpmyadmin to run the query REPAIR TABLE user; I get the following error message "The handler for the table doesn't support check/repair".

    I just got an email from wyenet saying they tried to run the repairs I sent them, which was a copy of the 3 listed on the forum here.

    They are running mySQL 3.23.36.

    Is there another way to repair the tables?

    I have upgraded to 2.2.9 and run repair.php. It didn't help.

    Thanks

    Leave a comment:


  • Steve Machol
    replied
    Sometimes you need to run repair more than once for it to catch and fix all errors. Glad it's working.

    Leave a comment:


  • ricks
    replied
    Originally posted by Steve Machol
    Run repair.php again and post the exact error message you get from running this.
    I ran repair.php and it ran OK and appears to have stopped the error emails.

    Thanks

    Leave a comment:


  • Steve Machol
    replied
    Run repair.php again and post the exact error message you get from running this.

    Leave a comment:


  • ricks
    replied
    OK. I ran phpmyadmin and did a delete session.

    I got the forum back, but now I am getting email errors like:

    Database error in vBulletin 2.2.7:
    Invalid SQL: INSERT INTO search (searchid,query,dateline,querystring,showposts,userid,ipaddress) VALUES (NULL,'1=1 AND thread.lastpost>=1044017631 AND thread.open<>10',1044126684,'',0,7,'65.58.238.68')
    mysql error: Duplicate entry '' for key 2
    mysql error number: 1062
    Date: Saturday 01st of February 2003 01:11:24 PM
    Script: http://www.homebased2.com/forums/for...?action=getnew
    Referer: http://www.homebased2.com/forums/index.php?

    The error messages may not have been identical when I ran repair.php but they had the same error number 1030.

    Thanks.

    Leave a comment:


  • Steve Machol
    replied
    I don't see any way the running repair.php would produce that exact same error. What is the exact error you get?

    Leave a comment:


  • ricks
    replied
    Originally posted by Steve Machol
    What version of MySQL is running? Can't you use repair.php?
    My web host, wyenet, is running 3.23.36.

    I tried running repair.php but the same error message as in my first post would pop up.

    Leave a comment:


  • Steve Machol
    replied
    What version of MySQL is running? Can't you use repair.php?

    Leave a comment:


  • ricks
    started a topic mySQL Error 1030

    mySQL Error 1030

    I am getting the following error message:

    Database error in vBulletin Control Panel 2.2.7:
    Invalid SQL: INSERT INTO session (sessionhash,userid,host,useragent,lastactivity,althash,location) VALUES ('8f4af7365f2d0327c30da37ae42cd4be','1','68.11.120.3','Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.0;','1044118582','','')
    mysql error: Got error -1 from table handler
    mysql error number: 1030
    Date: Saturday 01st of February 2003 10:56:22 AM
    Script: http://www.homebased2.com/forums/forums/admin/index.php
    Referer:

    I have tried phpmyadmin and it doesn't work.

    My web host is running a version of mySQL prior to mysqlcheck.

    Is there a way I could download the db to my computer, repair it and then restore it?

    Or an easier way to fix the problem?

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