Announcement

Collapse
No announcement yet.

[help] im always get min 300message/day (database error)

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

  • [help] im always get min 300message/day (database error)

    hello im always get 300 messages minimum/day.
    message is : error.

    Its the sample :
    Database error in vBulletin :

    mysql_connect() [<a href='function.mysql-connect'>function.mysql-connect</a>]: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)
    /home/zhazha/public_html/forum/includes/class_core.php on line 311

    MySQL Error :
    Error Number :
    Request Date : Friday, May 30th 2008 @ 02:49:16 PM
    Error Date : Friday, May 30th 2008 @ 02:49:17 PM
    Script : http://anakayam.us/forum/showthread.php?t=10412
    Referrer : http://anakayam.us/forum/indonesian-...er/index2.html
    IP Address : 125.163.208.178
    Username :
    Classname : vB_Database
    MySQL Version :

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

    mysql_connect() [<a href='function.mysql-connect'>function.mysql-connect</a>]: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)
    /home/zhazha/public_html/forum/includes/class_core.php on line 311

    MySQL Error :
    Error Number :
    Request Date : Friday, May 30th 2008 @ 02:49:14 PM
    Error Date : Friday, May 30th 2008 @ 02:49:15 PM
    Script : http://anakayam.us/forum/forumdisplay.php?f=18
    Referrer : http://anakayam.us/forum/
    IP Address : 125.163.7.157
    Username :
    Classname : vB_Database
    MySQL Version :==========
    ======================
    Database error in vBulletin 3.7.0:

    Invalid SQL:

    SELECT *
    FROM bbcode;

    MySQL Error : MySQL server has gone away
    Error Number : 2006
    Request Date : Friday, May 30th 2008 @ 02:49:10 PM
    Error Date : Friday, May 30th 2008 @ 02:49:14 PM
    Script : http://anakayam.us/forum/indonesian-bugil-cover/
    Referrer : http://anakayam.us/forum/
    IP Address : 222.124.219.54
    Username : gauzkeren
    Classname : vB_Database
    MySQL Version :
    ===================
    Database error in vBulletin 3.7.0:

    Invalid SQL:

    UPDATE session
    SET lastactivity = 1212173406, location = '/forum/', inforum = 0, inthread = 0, incalendar = 0, badlocation = 0, useragent = 'Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US; rv:1.8.1.12) Gecko/20080201 Firefox/2.0.0.6;MEGAUPLOAD 1.0'
    WHERE sessionhash = '2eef7daac48dba5fb6ea371c2ef75f62';

    MySQL Error : MySQL server has gone away
    Error Number : 2006
    Request Date : Friday, May 30th 2008 @ 02:50:06 PM
    Error Date : Friday, May 30th 2008 @ 02:50:18 PM
    Script : http://anakayam.us/forum/
    Referrer : http://anakayam.us/forum/
    IP Address : 203.89.24.230
    Username : Unregistered
    Classname : vB_Database
    MySQL Version :
    ===================
    Database error in vBulletin :

    mysql_connect() [<a href='function.mysql-connect'>function.mysql-connect</a>]: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)
    /home/zhazha/public_html/forum/includes/class_core.php on line 311

    MySQL Error :
    Error Number :
    Request Date : Friday, May 30th 2008 @ 02:50:17 PM
    Error Date : Friday, May 30th 2008 @ 02:50:18 PM
    Script : http://anakayam.us/forum/showthread.php?t=57
    Referrer : http://anakayam.us/forum/setengah-baya/
    IP Address : 202.59.166.78
    Username :
    Classname : vB_Database
    MySQL Version :
    ========================Database error in vBulletin 3.7.0:

    Invalid SQL:

    INSERT IGNORE INTO session
    (sessionhash, userid, host, idhash, lastactivity, location, styleid, languageid, loggedin, inforum, inthread, incalendar, badlocation, useragent, bypass, profileupdate)
    VALUES
    ('7fcd0b5937fd2656d9040d8c6a516c5c', 14418, '125.163.7.157', '4e2a8730267cc25f2374b5ebc92ecc15', 1212173404, '/forum/showthread.php?t=994', 0, 0, 1, 97, 994, 0, 0, 'Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US; rv:1.8.1.14) Gecko/20080404 Firefox/2.0.0.14;MEGAUPLOAD 1.0', 0, 0);

    MySQL Error : MySQL server has gone away
    Error Number : 2006
    Request Date : Friday, May 30th 2008 @ 02:50:04 PM
    Error Date : Friday, May 30th 2008 @ 02:50:13 PM
    Script : http://anakayam.us/forum/how-profess...dari-pink.html
    Referrer : http://anakayam.us/forum/how-profess...ri-pink-4.html
    IP Address : 125.163.7.157
    Username : bexaloy
    Classname : vB_Database
    MySQL Version :
    if i get error message in email . my guest always reset to 0 (kickout from my site)
    im confused about this.
    if im reinstall my forum in to vb.3.7.1,is my problem solved or not ?

    thanks
    how i can fixed this?

  • #2
    1. Assuming the db info in your config.php file is correct, this is a server issue. Please see this page for the causes of this error:

    http://www.vbulletin.com/docs/html/cantconnect

    2. This is a server issue. You'll need to contact your host about this. Here are the reasons for the MySQL server going away:

    http://www.vbulletin.com/forum/showt...265#post310265

    Also from the MySQL site:

    http://dev.mysql.com/doc/refman/5.0/en/gone-away.html
    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


    • #3
      my host support ask :

      Hello,

      Yes this limit affects all connections to the MySQL server.

      regards,


      its mean my visitor in my site is limit or what?

      Comment


      • #4
        What limit are they talking about?
        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


        • #5
          Hello,

          That is correct, if a visitor visits your site (and your site(s) require MySQL
          access) then yes this timeout setting will affect visitors.

          Hello,

          Yes this limit affects all connections to the MySQL server.

          regards,

          Hello,

          This change will not limit the amount of visitors to your site.

          All my edit has done is increase the timeout value before a connection is
          dropped. This will not affect the number of visitors to your site.

          its mean if user/guest visit my site is limited? visitor limited?
          Last edited by anakayam.us; Fri 30 May '08, 12:14pm.

          Comment

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