SQL Errors...

[MThornback]

I'm getting 2 of them....i'm not big on setting up queries...so any help to fix these would be really helpful:

In Warn.Php

Database error in vBulletin 3.0.7:

Invalid SQL:
UPDATE vb3_user SET
usergroupid = ,
displaygroupid = ,
warnings=1,
warning_bans = 1,
usertitle = 'Temporarily Banned'
WHERE userid = 4

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 '
displaygroupid = ,
warnings=1,
warning_bans

mysql error number: 1064


In http://www.webcadets.com/forum/admincp/admin_warn.php?act=viewstats2 :

Database error in vBulletin 3.0.7:

Invalid SQL: select wt.userid, wt.username, wt.usergroupid from
vb3_user wt WHERE usergroupid = OR usergroupid = OR usergroupid = ORDER BY userid
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 'OR usergroupid = OR usergroupid = ORDER BY userid' at line 2

mysql error number: 1064


Thoughts? Anyone?

[sv1cec]

Is your site properly set up? I mean the queries do not show any value passed for the usergroupid, or the displaygroup id. That should be the user group id, your users are in, in other words in a normally set-up site, it should be 2.

Please check that.

[MThornback]

I now feel...SO...very...stupid....problem solved.... :tired:

Thanks for the shake sv1cec :)

[sv1cec]

Most welcome Sir.