Announcement

Collapse
No announcement yet.

Error 1016

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

  • Cygnus
    replied
    I ran this and it fixed the problem right away.

    Thanks, Steve!

    Leave a comment:

  • Steve Machol
    Former Customer Support Manager

  • Steve Machol
    replied
    L-Mane, please post your problem in a new thread so we don't get confused.

    sjulien, your thread table is still bad:

    Error code 127: Record-file is crashed

    You need to run repair.php again.

    Leave a comment:

  • L-Mane
    Senior Member

  • L-Mane
    replied
    When using phpmyadmin it won't even recognize our database.

    Leave a comment:

  • sjulien
    New Member

  • sjulien
    replied
    This is the new error message I get only on one forum after I ran the code you gave me:

    Database error in vBulletin 2.3.0:

    Invalid SQL:
    SELECT

    thread.threadid
    FROM thread
    WHERE thread.forumid = 2
    AND thread.sticky=0
    AND thread.visible=1
    AND lastpost >= 1055355415 AND sticky=0

    ORDER BY sticky DESC, lastpost DESC
    LIMIT 0,25
    mysql error: Got error 127 from table handler

    mysql error number: 1030

    Date: Friday 11th of July 2003 02:16:55 PM
    Script: http://community.allhiphop.com/forum....php?forumid=2
    Referer: http://community.allhiphop.com/



    Like I said the entire site was down before now the site is up after I ran the code except our most popular forum it gives the above error message. At this piont having the site up is better than nothing but we would like to be back at 100% again. Any clues???


    Originally posted by Steve Machol
    What error message? If it's concerning the session table then running repair.php won't fix this. You'll need to run the query I gave you.

    Leave a comment:

  • Steve Machol
    Former Customer Support Manager

  • Steve Machol
    replied
    What error message? If it's concerning the session table then running repair.php won't fix this. You'll need to run the query I gave you.

    Leave a comment:

  • sjulien
    New Member

  • sjulien
    replied
    Thanks. I ran twice to make sure and I got all OK. But when I go to just this one forum on our site, the same error message still comes up. I restrated the server and still no luck. restarted IIS and MYSQL serveice and noe luck. It seems like maybe just that table is bad. Any way we can fix that?

    At least the other forums seem to be working well.


    Originally posted by Steve Machol
    Upload repair.php (it's in the 'extras' folder of the zip file) to your admin directory. Close your forums, then run it from your browser with this syntax:

    http://www.yourdomain.com/forum/admin/repair.php?html=1&check=1

    [Of course change the exact URL as appropriate for your forums.]

    If everything reports 'Ok' then reopen your forums. If not, then run it again. The second time everything should report Ok (except the session table which you can ignore.)

    Leave a comment:

  • Steve Machol
    Former Customer Support Manager

  • Steve Machol
    replied
    Upload repair.php (it's in the 'extras' folder of the zip file) to your admin directory. Close your forums, then run it from your browser with this syntax:

    http://www.yourdomain.com/forum/admin/repair.php?html=1&check=1

    [Of course change the exact URL as appropriate for your forums.]

    If everything reports 'Ok' then reopen your forums. If not, then run it again. The second time everything should report Ok (except the session table which you can ignore.)

    Leave a comment:

  • sjulien
    New Member

  • sjulien
    replied
    New Error 1030

    Another issue has occurrred One section of the boards and only this one link is giving this error message:

    Database error in vBulletin 2.3.0:

    Invalid SQL:
    SELECT

    thread.threadid
    FROM thread
    WHERE thread.forumid = 2
    AND thread.sticky=0
    AND thread.visible=1
    AND lastpost >= 1055344065 AND sticky=0

    ORDER BY sticky DESC, lastpost DESC
    LIMIT 0,25
    mysql error: Got error 127 from table handler

    mysql error number: 1030

    Date: Friday 11th of July 2003 11:07:45 AM
    Script: http://community.allhiphop.com/forum....php?forumid=2
    Referer: http://community.allhiphop.com/index.php?

    Any clue on how to fix this? The rest of the site is up just fine.



    Originally posted by Steve Machol
    Run this query:

    Code:
    DROP TABLE session;
    CREATE TABLE session (
    sessionhash char(32) NOT NULL,
    userid int(10) unsigned DEFAULT '0' NOT NULL,
    host char(50) NOT NULL,
    useragent char(50) NOT NULL,
    lastactivity int(10) unsigned DEFAULT '0' NOT NULL,
    location CHAR (255) not null,
    styleid smallint(5) unsigned DEFAULT '0' NOT NULL,
    althash CHAR (32) NOT NULL,
    PRIMARY KEY (sessionhash)
    ) TYPE=HEAP;

    Leave a comment:

  • Steve Machol
    Former Customer Support Manager

  • Steve Machol
    replied
    If you cannot access your database with phpMyAdmin then you'll need to contact your host and ask them to fix this.

    If you have telnet or ssh you can also login to the server and run that query from the MySQL prompt. To do this:

    1. Telnet or ssh into the server
    2. Run this comman at the shell:
    mysql -uUSERNAME -p DATABASENAME
    3. Enter your database password when prompted for it.
    4. Enter the query.
    5. Type 'exit' to leave the mysql prompt.

    Leave a comment:

  • sjulien
    New Member

  • sjulien
    replied
    STeve we did run the querey at the command line. I I got the error of couln't open uer.MYD I replaced the files and it worked fine. Thanks.

    Originally posted by Steve Machol
    Run this query:

    Code:
    DROP TABLE session;
    CREATE TABLE session (
    sessionhash char(32) NOT NULL,
    userid int(10) unsigned DEFAULT '0' NOT NULL,
    host char(50) NOT NULL,
    useragent char(50) NOT NULL,
    lastactivity int(10) unsigned DEFAULT '0' NOT NULL,
    location CHAR (255) not null,
    styleid smallint(5) unsigned DEFAULT '0' NOT NULL,
    althash CHAR (32) NOT NULL,
    PRIMARY KEY (sessionhash)
    ) TYPE=HEAP;

    Leave a comment:

  • sjulien
    New Member

  • sjulien
    replied
    Hey steve, when I tried to access my table, the page couln't be displayed. I couldn't even select the database to run the code. Any more help for this, our site has been down for over 2 days because of this. Please help.

    Originally posted by Steve Machol
    Run this query:

    Code:
    DROP TABLE session;
    CREATE TABLE session (
    sessionhash char(32) NOT NULL,
    userid int(10) unsigned DEFAULT '0' NOT NULL,
    host char(50) NOT NULL,
    useragent char(50) NOT NULL,
    lastactivity int(10) unsigned DEFAULT '0' NOT NULL,
    location CHAR (255) not null,
    styleid smallint(5) unsigned DEFAULT '0' NOT NULL,
    althash CHAR (32) NOT NULL,
    PRIMARY KEY (sessionhash)
    ) TYPE=HEAP;

    Leave a comment:

  • sjulien
    New Member

  • sjulien
    replied
    RThanks I did access my phpmyadmin. When I try to select my database on the left hand side I get a message that the page can not be displayed.

    What can I do at this point I can access the database. I tried from my PC and from the server directly with no luck.


    Originally posted by xiphoid
    Install phpmyadmin on your server and run the query from the sql tab.

    Leave a comment:

  • Floris
    Senior Member

  • Floris
    replied
    Install phpmyadmin on your server and run the query from the sql tab.

    Leave a comment:

  • sjulien
    New Member

  • sjulien
    replied
    I saw this in a previous post, how do I run that??? i have win 2000 server. Let me know where and how and I 'll do it.


    Originally posted by Steve Machol
    Run this query:

    Code:
    DROP TABLE session;
    CREATE TABLE session (
    sessionhash char(32) NOT NULL,
    userid int(10) unsigned DEFAULT '0' NOT NULL,
    host char(50) NOT NULL,
    useragent char(50) NOT NULL,
    lastactivity int(10) unsigned DEFAULT '0' NOT NULL,
    location CHAR (255) not null,
    styleid smallint(5) unsigned DEFAULT '0' NOT NULL,
    althash CHAR (32) NOT NULL,
    PRIMARY KEY (sessionhash)
    ) TYPE=HEAP;

    Leave a comment:

  • Steve Machol
    Former Customer Support Manager

  • Steve Machol
    replied
    Run this query:

    Code:
    DROP TABLE session;
    CREATE TABLE session (
    sessionhash char(32) NOT NULL,
    userid int(10) unsigned DEFAULT '0' NOT NULL,
    host char(50) NOT NULL,
    useragent char(50) NOT NULL,
    lastactivity int(10) unsigned DEFAULT '0' NOT NULL,
    location CHAR (255) not null,
    styleid smallint(5) unsigned DEFAULT '0' NOT NULL,
    althash CHAR (32) NOT NULL,
    PRIMARY KEY (sessionhash)
    ) TYPE=HEAP;

    Leave a comment:

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