Announcement

Collapse
No announcement yet.

MySQL error on Crashed Site

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

  • MySQL error on Crashed Site

    http://boards.survivoraddicts.com/index.php

    PHP version: 4.3.1
    MySQL version: 4.0.11-gamma
    Apache version: 1.3.27

    Warning
    : 1 is not a valid MySQL-Link resource in /hsphere/local/home/survivor/boards.survivoraddicts.com/admin/db_mysql.php on line 93


    There seems to have been a slight problem with the SurvivorAddicts.com database.

    Please try again by pressing the refresh button in your browser.


    An E-Mail has been dispatched to our Technical Staff, who you can also contact if the problem persists.


    We apologise for any inconvenience.

    Database error in vBulletin 2.2.8:
    Invalid SQL: SELECT * FROM usergroup WHERE usergroupid=6
    mysql error:
    mysql error number:
    Date: Saturday 29th of March 2003 12:17:48 PM
    Script: http://boards.survivoraddicts.com/
    Referer:

    Warning: 1 is not a valid MySQL-Link resource in /hsphere/local/home/survivor/boards.survivoraddicts.com/admin/db_mysql.php on line 93

    There seems to have been a slight problem with the SurvivorAddicts.com database.
    Please try again by pressing the refresh button in your browser.


    An E-Mail has been dispatched to our Technical Staff, who you can also contact if the problem persists.


    We apologise for any inconvenience.

    Database error in vBulletin 2.2.8:
    Invalid SQL: UPDATE session SET lastactivity=1048969066,location='/' WHERE sessionhash='059eb97a5185325b83551dddcb2f82c7'
    mysql error:
    mysql error number:
    Date: Saturday 29th of March 2003 12:17:49 PM
    Script: http://boards.survivoraddicts.com/
    Referer:
    We have run repair.php
    I have tried to repair the usergroup table through phpMyAdmin
    We restored files from yesterday in case there was script corruption
    I have emptied the session table and then run repair.php
    I have emptied the session table and then tried to repair usergroup through phpMyAdmin

    Nothing is working.

    I have looked at these tables using phpMyAdmin and everything LOOKS normal to my untrained eye.

    Help?
    Last edited by Cygnus; Sat 29th Mar '03, 2:58pm.

  • #2
    Oh... and for what it is worth, I can log in to the control panel and have no problems navigating around there.

    Comment


    • #3
      From our sysadmin:

      I used mysql tools to fix this DB. no errors, no problems but forum doesn't work... old DB and old content..

      Comment


      • #4
        Have you added any hacks recently ??

        Comment


        • #5
          Originally posted by TripleH
          Have you added any hacks recently ??
          Nope. The last hack I added was about a month ago (vbArcadepro, I think) and the boards have been working flawlessly since then.

          Comment


          • #6
            I'm thinking it is an issue with PHP 4.3.1
            Lemme check something....

            Could you post a copy of your db_mysql.php (upload one that is) to these forums?
            ManagerJosh, Owner of 4 XenForo Licenses, 1 vBulletin Legacy License, 1 Internet Brands Suite License
            Director, WorldSims.org | Gaming Hosting Administrator, SimGames.net, Urban Online Entertainment

            Comment


            • #7
              Sure

              Here is db_mysql.php:
              Code:
              vB file code removed. Please do not post vB files.
              Last edited by Steve Machol; Sat 29th Mar '03, 6:26pm.

              Comment


              • #8
                OKay...I recommend this and give it a shot..

                Reupload the ORIGINAL db_mysql.php from the vBulletin229.zip from the members area (or one stored locally)

                It must be the original one, unaltered and with nocodehacks.

                See if that solves anything.
                ManagerJosh, Owner of 4 XenForo Licenses, 1 vBulletin Legacy License, 1 Internet Brands Suite License
                Director, WorldSims.org | Gaming Hosting Administrator, SimGames.net, Urban Online Entertainment

                Comment


                • #9
                  Same error.

                  I don't think that I have any hacks that altered db_mysql.php.

                  Comment


                  • #10
                    Did your host upgrade PHP/MySQL/Apache within the last 48hrs?
                    ManagerJosh, Owner of 4 XenForo Licenses, 1 vBulletin Legacy License, 1 Internet Brands Suite License
                    Director, WorldSims.org | Gaming Hosting Administrator, SimGames.net, Urban Online Entertainment

                    Comment


                    • #11
                      I think so. He rolled it back, though, and we were still having the same error.

                      Why? What's on your mind?

                      Comment


                      • #12
                        sounds like the database connection is being lost after it connects.

                        Do you have any mysql_close() or $DB_site->close(); in the code anywhere?
                        Scott MacVicar

                        My Blog | Twitter

                        Comment


                        • #13
                          I don't think we have anything in the code that looks like that.

                          The odd thing is that I have another site with the same host which has vBulletin boards and they have been working fine all along except for when the host has taken down the server for a reboot or what have you. We're moving MySQL and will retry in about an hour. Hoping that will do it...

                          Comment


                          • #14
                            If you want to pm me your forum details (ftp and admin password) I'll check all the code for it. It is not a database corruption there is a problem with the code which has caused it to close the connection at some point.
                            Scott MacVicar

                            My Blog | Twitter

                            Comment


                            • #15
                              Appreciate it greatly, Scott. If I am still having issues when we are done moving, I'll PM you all of the necessary info.

                              Comment

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