Announcement

Collapse
No announcement yet.

SQL ERROR 1030 - Errror 127 from Table Handler

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

  • DiscussAnything
    replied
    Thanks Steve and Squall.

    I am back up and running.

    Leave a comment:


  • Steve Machol
    replied
    No, it won't display anything until it's done.

    Leave a comment:


  • DiscussAnything
    replied
    Does it display anything, while running?

    I launched the 'script' but then it just shows a white IE page, at the bottom is says opening page URL and it is still doing that...about 5 minutes later.

    The database is pretty large, about 800 megs.

    Leave a comment:


  • Steve Machol
    replied
    The amount of time depends on the size of the database. It should only be a few minutes unless the db is extremely large.

    Leave a comment:


  • DiscussAnything
    replied
    Thanks for your help Steve and Squall.

    Going to run repair.php now, and see how that goes. ::crosses fingers::


    About how long, do you think repair.php will take the run? (have a meeting in an hour and will get another admin to do it if that is not sufficient)

    Leave a comment:


  • Steve Machol
    replied
    Just run repair.php.

    <moving to correct forum>

    Leave a comment:


  • DiscussAnything
    replied
    Originally posted by squall14716
    Upload repair.php from the extras folder in the ZIP to your admin folder and run http://www.yoursite.com/forums/admin...html=1&check=1

    EDIT: repair.php fixes the tables for you.
    Just, for 100% clarity. If I run repair.php, then I do not need to run the SQL Queries.

    Leave a comment:


  • Matthew Gordon
    replied
    Upload repair.php from the extras folder in the ZIP to your admin folder and run http://www.yoursite.com/forums/admin...html=1&check=1

    EDIT: repair.php fixes the tables for you.

    Leave a comment:


  • DiscussAnything
    replied
    Squall-

    Do I run repair.php after I fix the tables? And with what flags? And what does it do for me?

    Leave a comment:


  • Matthew Gordon
    replied
    Originally posted by DiscussAnything
    Steve-

    Under Import and Maint. I only have the following options

    Import & Maintenance
    Back-up Database
    BB Import Systems
    Update Counters

    Please advise
    He's using vB 2.2.6. Which makes this the wrong forum.

    Leave a comment:


  • DiscussAnything
    replied
    Oh, steve, im sorry, I see the miscommunication. I posted this in the wrong forum. I am running 2.2.X of vB, not 3.

    I must have been browsing a search result when I posted this, and got it in the wrong forum...

    In that case, is the query the only way to do?

    Leave a comment:


  • Steve Machol
    replied
    You may need to make sure you are a Super Admin (in config.php.

    Also to run a single query you first need to give yourself permission to run queries in the Admin CP. To do this, edit this section of config.php:
    PHP Code:
    // ****** USERS WITH QUERY RUNNING PERMISSIONS ******
    // The users specified here will be allowed to run queries from the control panel.
    // See the above entries for more information on the format.
    // Please note that the ability to run queries is quite powerful. You may wish
    // to remove all user IDs from this list for security reasons.
    $canrunqueries 'x'
    ...with x being your userid number. Then to run a query:

    Admin CP -> Import & Maintenance -> Execute SQL Query

    Leave a comment:


  • DiscussAnything
    replied
    Steve-

    Under Import and Maint. I only have the following options

    Import & Maintenance
    Back-up Database
    BB Import Systems
    Update Counters

    Please advise

    Leave a comment:


  • Matthew Gordon
    replied
    Code:
    REPAIR TABLE post;
    That is all you'll really need to run, unless there are more corrupted tables.

    I'd still advise you to run repair.php as it will check, repair, and optimize all the tables.

    EDIT: Bah, Steve beat me to it.

    Leave a comment:


  • Steve Machol
    replied
    You can run this in the Admin CP or in phpMyAdmin. The query is:

    REPAIR TABLE post;

    So far your errors indicate this is the only table affected.

    Leave a comment:

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