Status
Not open for further replies.

Pierce

Customer
Hi,

Issue is:

Noticed these DB errors:


Database error in vBulletin 4.2.0:

Invalid SQL:

SELECT COUNT(*) AS totalshouts

FROM minif_dbtech_vbshout_shout AS vbshout
LEFT JOIN minif_user AS user USING(userid)

WHERE vbshout.instanceid IN(-1, 0, 1)

AND (
vbshout.userid IN(-1, 0) OR
vbshout.id IN(0, 0)
)
AND vbshout.userid NOT IN(
SELECT ignoreuserid
FROM minif_dbtech_vbshout_ignorelist AS ignorelist
WHERE userid = 0
)
AND vbshout.forumid IN(132,122,10,73,80,76,98,148,11,77,57,133,13,65,33,64,5,113,67,177,97,43,19,45,250,129,7,50,163,192,124,190,146,102,158,187,222,51,101,165,194,118,156,247,52,199,191,193,121,168,179,272,240,162,213,211,212,242,246,276,239,248,251,252,268,253,254,269,256,234,131,17,117,147,255,154,188,219,157,198,249,217,218,273,233,18,152,189,237,138,150,201,181,151,155,170,184,225,228,229,79,196,195,63,126,241,89,46,48,137,159,232,258,274,208,214,215,275,104,174,175,278,277,96,216,206,26,160,172,164,207,119,171,227,127,169,36,265,266,267,100,224,244,205,236,238,78,197,144,130,185,186,94,24,71,120,257,231,93,25,75,226,245,8,9,60,92,68,29,74,139,83,27,28,31,66,91,39,134,34,81,210,110,135,136,0)
AND vbshout.chatroomid IN(0) AND vbshout.message LIKE '%hoRFcA <a href=\"http://hjovwrshrryo.com/\">hjovwrshrryo</a>, vrfdmjjaanyl, [link=http://mlfuwlsoqtnw.com/]mlfuwlsoqtnw[/link], http://ibsrjyeqljfc.com/%' AND vbshout.dateline >= AND vbshout.dateline <= AND user.username LIKE '%maqrkxbaw%';

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.dateline <= AND user.username LIKE '%maqrkxbaw%'' at line 18
Error Number : 1064
Request Date : Thursday, September 27th 2012 @ 02:25:36 AM
Error Date : Thursday, September 27th 2012 @ 02:25:36 AM
Script : http://www.minimins.com/vbshout.php...derby=DESC&perpage=10&do=archive&instanceid=1
Referrer : Shoutbox Archive
IP Address : 50.19.244.252
Username : maqrkxbaw
Classname : vB_Database_Slave_MySQLi
MySQL Version :

(maqrkxbaw is not a valid username)



Also have spam bots using the "Handle Reports" feature to spam the reports section. Have looked for an option to disable this for guests and cannot find any. Username shows up as N/A.

Pierce
 
Try updating to vBShout v6.0.8 to fix the first issue - I'll look into guest reporting for a future version :)
 
Status
Not open for further replies.

Similar threads

  • Locked
  • Support ticket
Question vBshout tcats
Replies
4
Views
880
  • Locked
  • Support ticket
Replies
4
Views
800
  • Locked
  • Support ticket
Replies
2
Views
812

Legacy vBShout

vBulletin 3.8.x vBulletin 4.x.x
Seller
DragonByte Technologies
Release date
Last update
Total downloads
3,167
Customer rating
5.00 star(s) 1 ratings
Back
Top