Bug Invaild SQL Select Error

[Nxt]

I keep seeing this error:
Database error in vBulletin 5.0.5:

Invalid SQL:

SELECT
user.*,
user.dbtech_vbshout_settings AS shoutsettings,
user.dbtech_vbshout_shoutstyle AS shoutstyle,
vbshout.*,
pmuser.username AS pmusername

FROM vb_dbtech_vbshout_shout AS vbshout
LEFT JOIN vb_user AS user ON(user.userid = vbshout.userid)
LEFT JOIN vb_user AS pmuser ON(pmuser.userid = vbshout.id)

WHERE vbshout.instanceid IN(-1, 0, 0)
AND vbshout.userid NOT IN(
SELECT ignoreuserid
FROM vb_dbtech_vbshout_ignorelist AS ignorelist
WHERE userid = 2
)
AND vbshout.forumid IN(0,5,6,12,13,11,12)
AND (
user.dbtech_vbshout_banned = '0' OR
vbshout.userid = -1
)
AND vbshout.type IN() AND vbshout.chatroomid = 0
ORDER BY shoutid 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.chatroomid = 0
ORDER BY shoutid DESC
LIMIT 20' at line 23
Error Number : 1064
Request Date : Sunday, October 6th 2013 @ 02:48:23 AM
Error Date : Sunday, October 6th 2013 @ 02:48:23 AM
Script : http:///ajax/api/vbshout_shoutbox/ajax

figured I should share it

 

[Fillip H.]

I've uploaded a potential hotfix for this, can you try re-downloading the mod and re-uploading /core/packages/dbtechvbshout/db/mysql/querydefs.php and let me know if that works for you?

 

[Nxt]

Uploaded. I'll report back if it happens. Thanks!

 

[Nxt]

Reporting back, just got about 100 emails stating this:
Database error in vBulletin 5.0.5:

Invalid SQL:

SELECT
user.*,
user.dbtech_vbshout_settings AS shoutsettings,
user.dbtech_vbshout_shoutstyle AS shoutstyle,
vbshout.*,
pmuser.username AS pmusername

FROM vb_dbtech_vbshout_shout AS vbshout
LEFT JOIN vb_user AS user ON(user.userid = vbshout.userid)
LEFT JOIN vb_user AS pmuser ON(pmuser.userid = vbshout.id)

WHERE vbshout.instanceid IN(-1, 0, 0)
AND vbshout.userid NOT IN(
SELECT ignoreuserid
FROM vb_dbtech_vbshout_ignorelist AS ignorelist
WHERE userid = 8
)
AND vbshout.forumid IN(0,5,6)
AND (
user.dbtech_vbshout_banned = '0' OR
vbshout.userid = -1
)
AND vbshout.type IN() AND vbshout.chatroomid = 0
ORDER BY shoutid 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.chatroomid = 0
ORDER BY shoutid DESC
LIMIT 20' at line 23
Error Number : 1064
Request Date : Saturday, October 12th 2013 @ 07:33:04 PM
Error Date : Saturday, October 12th 2013 @ 07:33:04 PM
Script : http:///ajax/api/vbshout_shoutbox/ajax

 

[Nxt]

Database error in vBulletin 5.0.5:

Invalid SQL:

SELECT
user.*,
user.dbtech_vbshout_settings AS shoutsettings,
user.dbtech_vbshout_shoutstyle AS shoutstyle,
vbshout.*,
pmuser.username AS pmusername

FROM vb_dbtech_vbshout_shout AS vbshout
LEFT JOIN vb_user AS user ON(user.userid = vbshout.userid)
LEFT JOIN vb_user AS pmuser ON(pmuser.userid = vbshout.id)

WHERE vbshout.instanceid IN(-1, 0, 0)
AND vbshout.userid NOT IN(
SELECT ignoreuserid
FROM vb_dbtech_vbshout_ignorelist AS ignorelist
WHERE userid = 2
)
AND vbshout.forumid IN(0,5,6,12,13,11,12)
AND (
user.dbtech_vbshout_banned = '0' OR
vbshout.userid = -1
)
AND vbshout.type IN() AND vbshout.chatroomid = 0
ORDER BY shoutid 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.chatroomid = 0
ORDER BY shoutid DESC
LIMIT 20' at line 23
Error Number : 1064
Request Date : Sunday, October 13th 2013 @ 11:44:37 PM
Error Date : Sunday, October 13th 2013 @ 11:44:37 PM

 

[Nxt]

I believe this was happening due to a newer version of PHP. Also, another bug that happens with the newest version of PHP is that you'll get a 200: parse error when sending a shout, the shout still sends but the error pops up in chat.

 

[Fillip H.]

What version of PHP did you upgrade to? I'll re-test it on that version as soon as I'm able

 

[Nxt]

ya it was using 5.4.21 now now ts back to 5.3.27