Announcement

Collapse
No announcement yet.

Error 1016

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

  • Error 1016

    My community server gives this message to my email and I cannot get my vbulletin boards up. I have a win 2k server with vbulletin 2.3 on it. PHP 4.3.2 and MySQL 3.23. Our site is down and this is the error message I have been getting:


    Database error in vBulletin 2.3.0:

    Invalid SQL: DELETE FROM session WHERE sessionhash=''
    mysql error: Can't open file: 'session.MYD'. (errno: 145)

    mysql error number: 1016

    Date: Wednesday 09th of July 2003 09:44:18 PM
    Script: http://community.allhiphop.com/index.php
    Referer:


    I replaced my sessions.MYD .MYI and .frm with a backup as well as my sessions.php. I am at a loss. This went crazy after I ran out of disk space on my server on a non system drive. The drive now has over 2 GBS free but I am not able to get my site up still. Please help if you have any clues
    Last edited by sjulien; Thu 10th Jul '03, 1:08am.

  • #2
    Have you tried to delete the tables?
    And then just create new ones?

    Comment


    • #3
      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;
      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


      • #4
        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;

        Comment


        • #5
          Install phpmyadmin on your server and run the query from the sql tab.

          Comment


          • #6
            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.

            Comment


            • #7
              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;

              Comment


              • #8
                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;

                Comment


                • #9
                  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.
                  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


                  • #10
                    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;

                    Comment


                    • #11
                      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.)
                      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


                      • #12
                        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.)

                        Comment


                        • #13
                          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.
                          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


                          • #14
                            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.

                            Comment


                            • #15
                              When using phpmyadmin it won't even recognize our database.

                              Comment

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