Announcement

Collapse
No announcement yet.

Database problems

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

  • Database problems

    Whenever I try to access my forum I'm getting this error...

    -----------------------------------------
    Database error in vBulletin 2.2.7:

    Invalid SQL: INSERT INTO session (sessionhash,userid,host,useragent,lastactivity,althash,location) VALUES ('0d3ce1610f44e9e936da4df0f58924ce','1','24.98.72.56','Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1;','1033438459','','/forum/')
    mysql error: Can't open file: 'session.MYD'. (errno: 145)

    mysql error number: 1016

    Date: Monday 30th of September 2002 08:14:19 PM
    Script: http://plurplanet.com/forum/forum/
    Referer:
    -----------------------------------------

    I've tried uploading the repair.php file, but it gives me the same error. I've also tried to empty the session table with PHPmyAdmin (as suggested in another topic), but it gives me this error...

    -----------------------------------------
    SQL-query :

    SHOW KEYS FROM `session`

    MySQL said:


    Can't open file: 'session.MYD'. (errno: 145)
    -----------------------------------------

    Can anyone tell me how to fix this? Please!?!
    Spread Peace,
    Brian Gunter

    vBadvanced | EDMPlanet

  • #2
    Originally posted by Steve Machol
    Error code 145: Table was marked as crashed and should be repaired

    Your [session] table has crashed. 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/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. See if this fixes the problem.
    --filburt1, vBulletin.org/vBulletinTemplates.com moderator
    Web Design Forums.net: vB Board of the Month
    vBulletin Mail System (vBMS): webmail for your forum users

    Comment


    • #3
      Yup, I've tried that a few times. I tried running it from both the admin folder and the forums folder and I get the same error message above. It will show up and give me the instructions if I don't put anything after repair.php, but if I add the extra string after it I get the errors. Is there any other way I can fix this?
      Spread Peace,
      Brian Gunter

      vBadvanced | EDMPlanet

      Comment


      • #4
        You can try this query in PMA:
        Code:
        REPAIR TABLE session;
        --filburt1, vBulletin.org/vBulletinTemplates.com moderator
        Web Design Forums.net: vB Board of the Month
        vBulletin Mail System (vBMS): webmail for your forum users

        Comment


        • #5
          OMG thank you! That seems to have fixed everything.
          Spread Peace,
          Brian Gunter

          vBadvanced | EDMPlanet

          Comment


          • #6
            Perhaps I spoke too soon... It worked for about a minute, but now all I'm getting is a blank page...
            Spread Peace,
            Brian Gunter

            vBadvanced | EDMPlanet

            Comment


            • #7
              Running that query would not have resulted in blank pages. What URL are you going to?
              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


              • #8
                Well I ran the query and the site seemed to work fine for about a minute. Then when I tried to go to the forums page again it won't load up at all. The url is http://plurplanet.com/forum/
                Spread Peace,
                Brian Gunter

                vBadvanced | EDMPlanet

                Comment


                • #9
                  /me remembers an incident a few days ago with another user

                  This sounds crazy but do you have an admin/config.php file?
                  --filburt1, vBulletin.org/vBulletinTemplates.com moderator
                  Web Design Forums.net: vB Board of the Month
                  vBulletin Mail System (vBMS): webmail for your forum users

                  Comment


                  • #10
                    Yes, the admin/config.php file is there. I'm starting to think this is a problem with my server rather than vBulletin though because now I can not even FTP into it.
                    Spread Peace,
                    Brian Gunter

                    vBadvanced | EDMPlanet

                    Comment

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