Announcement

Collapse
No announcement yet.

Database Error

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

  • [Forum] Database Error

    I host a few vbulletin sites and one of them contacted me as to why they are getting emails (errors) I thought it was because the mysql server was restarting but I'm not sure. I commented out the technical email address line in the config file and pointed them all to me but only one site is emailing back errors. Starts out


    Database error in vBulletin :

    mysql_connect() [<a href='function.mysql-connect'>function.mysql-connect</a>]: Access denied for user 'rchelp5_rch'@'localhost' (using password: YES) /home/rchelp5/public_html/includes/class_core.php on line 317


    Database error in vBulletin :

    Cannot use database rchelp5_forum

    Database error in vBulletin 4.2.0:

    Invalid SQL:

    SELECT *
    FROM style
    WHERE (styleid = 7)
    OR styleid = 5
    ORDER BY styleid DESC
    LIMIT 1;

    Almost looks as if mysql connection was broken but why don't I get emails from the other sites they are on the same server? This was at 4 this morning the sql server shows it has been up longer than 4 hours, almost 40 hours actually.

  • #2
    That one site connection to database info is not correct. Need to check config.php for database name, username and password
    To be or not to be... Where the hell is the question????
    My psychiatrist told me I was crazy and I said I want a second opinion. He said okay, you're ugly too

    Live vBulletin 4.2.0 Multilingual * Alpha/Beta vB 4 - vB 5 Tier 1A
    CentOS 6.2 - Apache:2.2.15(Apache2Handler) - PHP:5.3.3 - MySQL:5.1.61
    Xampp/Win-XP - Apache v2.2.21(Apache2Handler) - PHP:5.3.8 - MySQL:5.5.16

    Comment


    • #3
      The config file was chattr so they couldn't have changed it

      - - - Updated - - -

      n/m they just told me they deleted their username from the control panel by accident mystery solved

      Comment


      • #4
        I still say double check it.. Info could be correct but missing or adding something as little as ( " )

        - - - Updated - - -

        Great
        To be or not to be... Where the hell is the question????
        My psychiatrist told me I was crazy and I said I want a second opinion. He said okay, you're ugly too

        Live vBulletin 4.2.0 Multilingual * Alpha/Beta vB 4 - vB 5 Tier 1A
        CentOS 6.2 - Apache:2.2.15(Apache2Handler) - PHP:5.3.3 - MySQL:5.1.61
        Xampp/Win-XP - Apache v2.2.21(Apache2Handler) - PHP:5.3.8 - MySQL:5.5.16

        Comment


        • #5
          Errors again nothing from the other forums just one

          Invalid SQL:

          SELECT * FROM rsslog
          WHERE uniquehash IN ('58efdc74e60a5dca41a2fe2837b6af0b', '1c8748c2cb6947dc21bbd15866130e64', '812b4cf979daebbae93f0986973fd30c', 'c5e655a05d7bd2709bf52a8ea1c9e2b2', '04834d7e920f332faafba323811c9de1', 'f5a2f3925d1b1b565bfc6451d6870553', '0cdedbee1b803585d180203bac6848aa', '6ec2cda47cdf04e53a6e3306a2ad81a2', 'e9dad4eab4716c7d621e398c2f72a7e0', '4559ce5527f8ceb0b3f9add6a526296f');

          MySQL Error : MySQL server has gone away
          Error Number : 2006
          Request Date : Tuesday, July 17th 2012 @ 02:52:31 AM
          Error Date : Tuesday, July 17th 2012 @ 02:54:21 AM
          Script :
          Referrer :
          IP Address : 173.245.95.187
          Username : Unregistered
          Classname : vB_Database
          MySQL Version :

          Invalid SQL:

          SELECT *
          FROM style
          WHERE (styleid = 8 AND userselect = 1)
          OR styleid = 8
          ORDER BY styleid ASC
          LIMIT 1;

          MySQL Error : MySQL server has gone away
          Error Number : 2006
          Request Date : Tuesday, July 17th 2012 @ 02:59:29 AM
          Error Date : Tuesday, July 17th 2012 @ 03:03:19 AM
          Script :
          Referrer :
          IP Address : 180.178.93.7
          Username : Unregistered
          Classname : vB_

          Comment


          • #6
            This is server related. You must talk to your host about this.

            Comment


            • #7
              https://www.vbulletin.com/forum/show...&postid=310265
              To be or not to be... Where the hell is the question????
              My psychiatrist told me I was crazy and I said I want a second opinion. He said okay, you're ugly too

              Live vBulletin 4.2.0 Multilingual * Alpha/Beta vB 4 - vB 5 Tier 1A
              CentOS 6.2 - Apache:2.2.15(Apache2Handler) - PHP:5.3.3 - MySQL:5.1.61
              Xampp/Win-XP - Apache v2.2.21(Apache2Handler) - PHP:5.3.8 - MySQL:5.5.16

              Comment


              • #8
                fyi I own the server, oddly though I am not getting emails from other vbulletin sites on the server just this one. Thanks Merjawy for the thread link

                Comment


                • #9
                  You're welcome. I hope you find some answers off of it
                  To be or not to be... Where the hell is the question????
                  My psychiatrist told me I was crazy and I said I want a second opinion. He said okay, you're ugly too

                  Live vBulletin 4.2.0 Multilingual * Alpha/Beta vB 4 - vB 5 Tier 1A
                  CentOS 6.2 - Apache:2.2.15(Apache2Handler) - PHP:5.3.3 - MySQL:5.1.61
                  Xampp/Win-XP - Apache v2.2.21(Apache2Handler) - PHP:5.3.8 - MySQL:5.5.16

                  Comment


                  • #10
                    wait time out might be a reason had it set to 45 not sure why however. strange this cropped up out

                    Comment

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