tinjon
04-17-2006, 05:40 PM
i used to be in a shared hosting, my site grew so moved to vps hosting. being a newbie to it, i've asked my host to copy the entire shared account over to my vps. and they did.
when i was in shared, i only used to get the "max user connection" mysql error. but eversince moving to vps, i'm getting that error and i'm being bombarded with other numerous mysql errors.
i' tried stop, start, restarting the vps itself, then start, stop, restart just the mysql service. no luck. changed localhost to 127.0.0.1 in the vb config.php file. still no luck. also tried restarting mysql from cpanel whm. same result. mysql is not available for just five mintues!!
please have a look at the image to get a sense of the errors i'm getting.
i need help.!!!!
here's the image link. http://img504.imageshack.us/img504/1156/helpme3ec.png (http://img504.imageshack.us/img504/1156/helpme3ec.png)
there's like 61 emails in each!
here are some sample errors. i hope anyone can help. :(
i'm so worried.
(i've got like almost a thousand of them since last night). :(
most of them are these:
mysql_connect(): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)
/home/joubonj/public_html/forum/includes/class_core.php on line 279
MySQL Error :
Error Number :
most of them are this kind and #1 below. .
just for curiosity, i checked out the mysql.sock file size and it said "unknown" . is that normal?
(and now its not even there. just checked.)
1) mysql_connect(): Lost connection to MySQL server during query
/home/joubonj/public_html/forum/includes/class_core.php on line 279
2) Invalid SQL:
SELECT COUNT(*) AS count, threadid, MAX(dateline) AS lastpost
FROM vbpost AS post
WHERE post.userid = 3847 AND
post.visible = 1 AND
post.threadid IN (0,1954,2394,265,2535,2472,1864,1925,120,1887,1884 ,2445,1553,968,1881,1255,456,2444,692,2387,2450,63 5,1268)
GROUP BY threadid;
MySQL Error : Lost connection to MySQL server during query
Error Number : 2013
3) Invalid SQL:
SELECT
userfield.*, usertextfield.*, user.*, UNIX_TIMESTAMP(passworddate) AS passworddate,
IF(displaygroupid=0, user.usergroupid, displaygroupid) AS displaygroupid,
language.phrasegroup_global AS phrasegroup_global,
language.options AS lang_options,
language.languagecode AS lang_code,
language.charset AS lang_charset,
language.locale AS lang_locale,
language.imagesoverride AS lang_imagesoverride,
language.dateoverride AS lang_dateoverride,
language.timeoverride AS lang_timeoverride,
language.registereddateoverride AS lang_registereddateoverride,
language.calformat1override AS lang_calformat1override,
language.calformat2override AS lang_calformat2override,
language.logdateoverride AS lang_logdateoverride,
language.decimalsep AS lang_decimalsep,
language.thousandsep AS lang_thousandsep
FROM vbuser AS user
LEFT JOIN vbuserfield AS userfield ON (user.userid = userfield.userid)
LEFT JOIN vbusertextfield AS usertextfield ON (usertextfield.userid = user.userid) INNER JOIN vblanguage AS language ON (language.languageid = IF(user.languageid = 0, 1, user.languageid))
WHERE user.userid = 1067;
MySQL Error : Lost connection to MySQL server during query
Error Number : 2013
4) Invalid SQL:
SELECT title, data
FROM vbdatastore
WHERE title IN ('','options','bitfields','forumcache','usergroupc ache','stylecache','languagecache','products','plu ginlist','cron');
MySQL Error : Lost connection to MySQL server during query
Error Number : 2013
and so on..
when i was in shared, i only used to get the "max user connection" mysql error. but eversince moving to vps, i'm getting that error and i'm being bombarded with other numerous mysql errors.
i' tried stop, start, restarting the vps itself, then start, stop, restart just the mysql service. no luck. changed localhost to 127.0.0.1 in the vb config.php file. still no luck. also tried restarting mysql from cpanel whm. same result. mysql is not available for just five mintues!!
please have a look at the image to get a sense of the errors i'm getting.
i need help.!!!!
here's the image link. http://img504.imageshack.us/img504/1156/helpme3ec.png (http://img504.imageshack.us/img504/1156/helpme3ec.png)
there's like 61 emails in each!
here are some sample errors. i hope anyone can help. :(
i'm so worried.
(i've got like almost a thousand of them since last night). :(
most of them are these:
mysql_connect(): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)
/home/joubonj/public_html/forum/includes/class_core.php on line 279
MySQL Error :
Error Number :
most of them are this kind and #1 below. .
just for curiosity, i checked out the mysql.sock file size and it said "unknown" . is that normal?
(and now its not even there. just checked.)
1) mysql_connect(): Lost connection to MySQL server during query
/home/joubonj/public_html/forum/includes/class_core.php on line 279
2) Invalid SQL:
SELECT COUNT(*) AS count, threadid, MAX(dateline) AS lastpost
FROM vbpost AS post
WHERE post.userid = 3847 AND
post.visible = 1 AND
post.threadid IN (0,1954,2394,265,2535,2472,1864,1925,120,1887,1884 ,2445,1553,968,1881,1255,456,2444,692,2387,2450,63 5,1268)
GROUP BY threadid;
MySQL Error : Lost connection to MySQL server during query
Error Number : 2013
3) Invalid SQL:
SELECT
userfield.*, usertextfield.*, user.*, UNIX_TIMESTAMP(passworddate) AS passworddate,
IF(displaygroupid=0, user.usergroupid, displaygroupid) AS displaygroupid,
language.phrasegroup_global AS phrasegroup_global,
language.options AS lang_options,
language.languagecode AS lang_code,
language.charset AS lang_charset,
language.locale AS lang_locale,
language.imagesoverride AS lang_imagesoverride,
language.dateoverride AS lang_dateoverride,
language.timeoverride AS lang_timeoverride,
language.registereddateoverride AS lang_registereddateoverride,
language.calformat1override AS lang_calformat1override,
language.calformat2override AS lang_calformat2override,
language.logdateoverride AS lang_logdateoverride,
language.decimalsep AS lang_decimalsep,
language.thousandsep AS lang_thousandsep
FROM vbuser AS user
LEFT JOIN vbuserfield AS userfield ON (user.userid = userfield.userid)
LEFT JOIN vbusertextfield AS usertextfield ON (usertextfield.userid = user.userid) INNER JOIN vblanguage AS language ON (language.languageid = IF(user.languageid = 0, 1, user.languageid))
WHERE user.userid = 1067;
MySQL Error : Lost connection to MySQL server during query
Error Number : 2013
4) Invalid SQL:
SELECT title, data
FROM vbdatastore
WHERE title IN ('','options','bitfields','forumcache','usergroupc ache','stylecache','languagecache','products','plu ginlist','cron');
MySQL Error : Lost connection to MySQL server during query
Error Number : 2013
and so on..