Log in

View Full Version : [help] im always get min 300message/day (database error)


geevest.com
05-30-2008, 05:53 PM
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-bugil-cover/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-professional-membership/994-khusus-dari-pink.html
Referrer : http://anakayam.us/forum/how-professional-membership/994-khusus-dari-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?

Lynne
05-30-2008, 06:04 PM
If your Guest list is always being reset, or 'erased', then I am guessing mysql is reseting itself. You need to look in your mysql error logs to see if this is happening. (I could have sworn you already posted about this and I suggested the exact same thing. edit: I did - Sometimes my guest always Kick Out (https://vborg.vbsupport.ru/showthread.php?t=180017))

For more reading about the errors:

MySQL Server has gone away: http://www.vbulletin.com/docs/html/troubleshoot_mysql_goneaway

MySQL can't connect: http://www.vbulletin.com/docs/html/cantconnect

geevest.com
05-30-2008, 06:08 PM
im not familiar with that.and my host support say thats nothing error in mysql vbulletin log.

how about if im upgrade my vbulletin in to vb.3.7.1 its my problem sovled?

Lynne
05-30-2008, 06:20 PM
how about if im upgrade my vbulletin in to vb.3.7.1 its my problem sovled?
No.

Marco van Herwaarden
05-31-2008, 08:26 AM
Check the uptime for MySQL. Most likely it gets restarted often.

PS My guess is that your host is not telling the complete truth. ;)

geevest.com
06-01-2008, 12:54 PM
until now my host support says its because vbulletin.not my host. :(
what should i do for this?

toonysnn
06-01-2008, 12:59 PM
It is your host. MySQL problems are server sided, most of the time.
Are you on a shared, VPS/VDS, or dedicated server?

geevest.com
06-02-2008, 02:49 PM
im using dedicated server.
maybe this thread problem move to : https://vborg.vbsupport.ru/showthread.php?t=181223