PDA

View Full Version : Warn user - SQL Error.


GoranTornqvist
02-03-2005, 12:55 PM
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

sv1cec
02-03-2005, 02:58 PM
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

GoranTornqvist
02-04-2005, 12:22 PM
Running:
WarningSystem_V3_1_2

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

sv1cec
02-04-2005, 12:49 PM
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