[pcam]

At first the user was in the COPPA Awaiting Registration group and then was approved and in both situations received many emails back to back from vbulletin stating these errors.

Database error in vBulletin 3.8.7:

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, user.dbtech_vbshop_purchase,
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 =
)
AND vbshout.forumid IN(10,536,22,61,537,13,36,23,24,25,26,27,37,39,38, 40,44,45,50,48,49,53,51,52,47,56,58,57,55,54,295,3 5,538,30,32,14,31,33,15,16,34,19,471,539,544,41,42 ,43,46,486,502,503,504,505,506,507,508,509,510,511 ,512,513,514,515,516,517,518,519,520,521,522,523,5 24,525,526,527,528,529,530,531,532,533,534,535,550 ,551,552,553,554,555,556,557,558,559,560,561,562,5 63,540,545,564,565,566,482,483,546,1028,1355,1029, 1356,1030,1357,1031,1032,1033,1034,1035,1036,1037, 1039,1038,1040,1041,1042,1043,1044,1045,1046,1047, 1048,1049,1050,1051,1052,1053,1054,1055,1056,1057, 1058,1059,1060,1061,1062,1063,1064,1065,1066,1067, 1068,1069,1070,1071,1072,1073,1074,1075,1076,1077, 1078,1079,1080,1081,1082,1083,1084,1085,1086,1087, 1088,1089,1090,1091,1092,484,1093,1094,1095,1096,1 097,1098,1099,1100,1101,1102,1103,1104,1105,1106,1 107,1108,1109,1110,1111,1112,1113,1114,1115,1116,1 117,1118,1119,1120,1121,1122,1123,1124,1125,1126,1 127,1128,1129,1130,1131,1132,1133,1134,1135,1136,1 137,1138,1139,1!
140,1141,1142,1143,1144,1145,1146,1147,1148,1149,1 150,1151,1152,1153,1154,1155,1156,1157,485,547,115 8,1289,1159,1291,1160,1290,1161,1292,1162,1293,116 3,1294,1164,1295,1165,1166,1296,1167,1297,1168,129 8,1169,1299,1170,1300,1171,1301,1172,1302,1173,130 3,1174,1304,1175,1305,1176,1306,1177,1307,1178,130 8,1179,1309,1180,1310,1181,1311,1182,1312,1183,131 3,1184,1314,1185,1315,1186,1316,1187,1317,1188,131 8,1189,1319,1190,1320,1191,1321,1192,1322,1193,132 3,1194,1324,1195,1325,1196,1326,1197,1327,1198,132 8,1199,1329,1200,1330,1201,1331,1202,1332,1203,133 3,1204,1334,1205,1335,1206,1336,1207,1337,1208,133 8,1209,1339,1210,1340,1211,1341,1212,1342,1213,134 3,1214,1344,1215,1345,1216,1346,1217,1347,1218,134 8,1219,1349,1220,1350,1221,1351,1222,1352,541,11,6 2,1223,1224,1225,1226,1227,1228,1229,1230,1231,123 2,1233,1234,1235,1236,1237,1238,1239,1240,1241,124 2,1243,1244,1245,1246,1247,1248,1249,1250,1251,125 2,1253,1254,1255,1256,1257,1258,1259,1260,1261,126 2,1263,1264,1265,1266,1267,1268,1269,1!
270,1271,1272,1273,1274,1275,1276,1277,1278,1279,1 280,1281,128!
2,1283,1284,1285,1286,1287,542,548,489,63,74,87,80 ,81,82,75,77,76,78,79,83,84,85,86,88,89,90,91,92,9 3,94,95,96,97,98,99,100,101,102,103,104,105,106,10 7,108,109,110,111,112,113,114,115,116,117,118,119, 120,121,122,123,124,125,64,148,149,150,151,152,153 ,154,155,157,158,159,160,161,162,163,164,165,166,1 67,168,169,170,171,172,173,174,175,176,178,179,180 ,181,182,65,138,139,140,141,142,143,144,145,146,14 7,267,268,269,66,183,184,185,186,187,188,189,190,1 91,193,265,266,194,195,196,197,198,199,200,201,202 ,203,204,205,206,207,208,209,210,212,211,213,214,2 15,216,217,219,218,220,221,222,223,224,225,226,227 ,228,229,230,231,232,233,234,235,236,237,238,239,2 40,241,242,243,244,245,246,247,248,249,250,251,252 ,253,254,255,258,256,257,259,260,261,262,263,264,7 3,126,127,128,129,130,132,133,134,135,136,137,131, 71,270,271,272,273,274,275,276,277,278,279,280,281 ,282,283,284,285,286,287,288,289,290,291,292,293,1 2,60,473,59,543,328,436,455,437,438,439,440,441,44 2,443,444,445,446,447,448,449,450,451,!
452,453,454,456,457,458,459,460,461,462,463,364,36 7,368,373,371,366,369,365,370,374,375,372,376,393, 395,392,383,385,387,386,381,388,378,384,379,389,39 4,390,391,377,382,380,396,397,400,398,399,401,402, 404,403,405,414,416,406,413,411,407,412,409,410,40 8,417,415,329,348,350,472,351,352,340,344,342,341, 343,330,332,333,345,347,346,334,337,338,339,336,33 5,353,356,360,361,363,355,358,362,357,354,331,359, 464,465,466,467,468,469,470,427,428,429,430,434,31 1,312,313,314,315,316,317,318,319,320,321,322,323, 324,325,326,431,327,418,432,423,433,420,421,296,29 7,298,299,300,301,302,303,304,305,306,307,308,309, 310,294,17,18,490,497,577,766,499,498,0)
AND (
user.dbtech_vbshout_banned = '0' OR
vbshout.userid = -1
)
AND (
vbshout.userid IN(-1, ) OR
vbshout.id IN(0, )
)AND vbshout.type NOT IN(64,128) AND vbshout.chatroomid = 0
ORDER BY dateline DESC
LIMIT 20;

MySQL Error : You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ')
AND vbshout.forumid IN(10,536,22,61,537,13,36,23,24,25,26,27,37,39,38, 40,4' at line 28
Error Number : 1064
Request Date : Monday, February 25th 2013 @ 04:15:34 PM
Error Date : Monday, February 25th 2013 @ 04:15:35 PM
Script : http://www.ircforums.com/vbshout.php...542045720852.3
Referrer : http://www.xxx.com
IP Address : 123.456.789.012
Username : Usertest
Classname : vB_Database
MySQL Version :

Permissions

Usergroup Can View Shoutbox Can View Archive Can Shout Can Edit Own Shouts Can Edit Others' Shouts Can Prune Can Set Sticky Can Ban Can Search Archive Is Auto Idle Can Create Chat Room Is Protected Group Can Moderate Chat Show Moderator Actions
(COPPA) Users Awaiting Moderation

Can view and can view archive

Regular Users (where the user was approved to)

Can view, can view archive, can shout