Helpful Information
 
 
Category: Advanced Warning System (AWS)
Warn user - SQL Error.

Hello, when warning a member, this error came up.
Looks like warning_bans value is empty, any ideas what to check for?

.............................................................................
Database error in vBulletin 3.0.6:

Invalid SQL:
UPDATE user SET
usergroupid = 8,
displaygroupid = 8,
warnings=3,
warning_level=4,
warning_bans = ,
usertitle = 'Temporarily Banned'
WHERE userid = 162

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 '
usertitle = 'Temporarily Banned'
WHERE userid = 162'

mysql error number: 1064

Date: Thursday 03rd of February 2005 03:04:08 PM
Script: http://xxx/Warn.php
Referer: http://xxx/Warn.php?do=WarnUser&id=162&post=1234
Username: xxx
IP Address: xxx

Hello, when warning a member, this error came up.
Looks like warning_bans value is empty, any ideas what to check for?

.............................................................................
Database error in vBulletin 3.0.6:

Invalid SQL:
UPDATE user SET
usergroupid = 8,
displaygroupid = 8,
warnings=3,
warning_level=4,
warning_bans = ,
usertitle = 'Temporarily Banned'
WHERE userid = 162

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 '
usertitle = 'Temporarily Banned'
WHERE userid = 162'

mysql error number: 1064

Date: Thursday 03rd of February 2005 03:04:08 PM
Script: http://xxx/Warn.php
Referer: http://xxx/Warn.php?do=WarnUser&id=162&post=1234
Username: xxx
IP Address: xxx
What version are you running? If different from the latest, please download the latest and upgrade.

Rgds

Running:
WarningSystem_V3_1_2

Ok...there's a 3.1.5 now...
Is it easy to upgrade, does it take a long time?

Running:
WarningSystem_V3_1_2

Ok...there's a 3.1.5 now...
Is it easy to upgrade, does it take a long time?
Nope, try upgrading and see if the error persists.

Rgds










privacy (GDPR)