San
Customer
I updated the site yesterday and today I have nothing but db errors.
Latest DB Error
Database error in vBulletin 4.1.11:
Invalid SQL:
SELECT
user.avatarid,
user.avatarrevision,
user.username,
user.usergroupid,
user.membergroupids,
user.infractiongroupid,
user.displaygroupid,
user.dbtech_vbshout_settings AS shoutsettings,
user.dbtech_vbshout_shoutstyle AS shoutstyle,
vbshout.*
, avatar.avatarpath, NOT ISNULL(customavatar.userid) AS hascustomavatar, customavatar.dateline AS avatardateline, customavatar.width AS avwidth, customavatar.height AS avheight, customavatar.height_thumb AS avheight_thumb, customavatar.width_thumb AS avwidth_thumb, customavatar.filedata_thumb,
pmuser.username AS pmusername
FROM dbtech_vbshout_shout AS vbshout
LEFT JOIN user AS user ON(user.userid = vbshout.userid)
LEFT JOIN avatar AS avatar ON (avatar.avatarid = user.avatarid)
LEFT JOIN customavatar AS customavatar ON (customavatar.userid = user.userid)
LEFT JOIN user AS pmuser ON(pmuser.userid = vbshout.id)
WHERE vbshout.instanceid IN(-1, 0, 1)
AND vbshout.userid NOT IN(
SELECT ignoreuserid
FROM dbtech_vbshout_ignorelist AS ignorelist
WHERE userid = 1
)
AND vbshout.forumid IN(1,20,52,21,37,10,28,8,9,4,5,15,11,43,44,45,46,47,12,13,48,14,49,50,51,29,30,31,32,33,34,35,36,38,39,41,40,6,16,17,18,19,7,22,23,24,25,27,0)
AND (
user.dbtech_vbshout_banned = '0' OR
vbshout.userid = -1
)
AND (
vbshout.userid IN(-1, 1) OR
vbshout.id IN(0, 1)
) AND vbshout.chatroomid = 0 AND vbshout.userid NOT IN(
SELECT userid
FROM user AS user
WHERE dbtech_vbshout_silenced = 1
AND userid != 1
)
ORDER BY dateline DESC
LIMIT 50;
MySQL Error : MySQL server has gone away
Error Number : 2006
Request Date : Friday, March 9th 2012 @ 12:42:14 PM
Error Date : Friday, March 9th 2012 @ 12:43:05 PM
Script : http://www.sangaming.com/vbshout.ph...er=DESC&pmtime=1331250069&v=29912041558345.36
Referrer : SanGaming
IP Address : 24.52.96.206
Username : XXXX
Classname : vB_Database
MySQL Version :
Latest DB Error
Database error in vBulletin 4.1.11:
Invalid SQL:
SELECT
user.avatarid,
user.avatarrevision,
user.username,
user.usergroupid,
user.membergroupids,
user.infractiongroupid,
user.displaygroupid,
user.dbtech_vbshout_settings AS shoutsettings,
user.dbtech_vbshout_shoutstyle AS shoutstyle,
vbshout.*
, avatar.avatarpath, NOT ISNULL(customavatar.userid) AS hascustomavatar, customavatar.dateline AS avatardateline, customavatar.width AS avwidth, customavatar.height AS avheight, customavatar.height_thumb AS avheight_thumb, customavatar.width_thumb AS avwidth_thumb, customavatar.filedata_thumb,
pmuser.username AS pmusername
FROM dbtech_vbshout_shout AS vbshout
LEFT JOIN user AS user ON(user.userid = vbshout.userid)
LEFT JOIN avatar AS avatar ON (avatar.avatarid = user.avatarid)
LEFT JOIN customavatar AS customavatar ON (customavatar.userid = user.userid)
LEFT JOIN user AS pmuser ON(pmuser.userid = vbshout.id)
WHERE vbshout.instanceid IN(-1, 0, 1)
AND vbshout.userid NOT IN(
SELECT ignoreuserid
FROM dbtech_vbshout_ignorelist AS ignorelist
WHERE userid = 1
)
AND vbshout.forumid IN(1,20,52,21,37,10,28,8,9,4,5,15,11,43,44,45,46,47,12,13,48,14,49,50,51,29,30,31,32,33,34,35,36,38,39,41,40,6,16,17,18,19,7,22,23,24,25,27,0)
AND (
user.dbtech_vbshout_banned = '0' OR
vbshout.userid = -1
)
AND (
vbshout.userid IN(-1, 1) OR
vbshout.id IN(0, 1)
) AND vbshout.chatroomid = 0 AND vbshout.userid NOT IN(
SELECT userid
FROM user AS user
WHERE dbtech_vbshout_silenced = 1
AND userid != 1
)
ORDER BY dateline DESC
LIMIT 50;
MySQL Error : MySQL server has gone away
Error Number : 2006
Request Date : Friday, March 9th 2012 @ 12:42:14 PM
Error Date : Friday, March 9th 2012 @ 12:43:05 PM
Script : http://www.sangaming.com/vbshout.ph...er=DESC&pmtime=1331250069&v=29912041558345.36
Referrer : SanGaming
IP Address : 24.52.96.206
Username : XXXX
Classname : vB_Database
MySQL Version :
