warn member error

hi guys

have installed the hack but when i click warn member and click what warnig i want to give i get the following error

Database error in vBulletin 3.0.6:

Invalid SQL: update user set warning_level='3', warnings='1' where userid='166'
mysql error: Unknown column 'warnings' in 'field list'

mysql error number: 1054

Date: Saturday 05th of February 2005 10:25:27 AM
Script: http://www.extreme-mobile.com/forums/Warn.php
Referer: http://www.extreme-mobile.com/forums...=166&post=1319
Username: admin

any ideas whats wrong?

many thanks

dean

can anyone help with this?

[sv1cec]

Yes, it is obvious that the warnings column does not exist in your table. Add it by running the following query:

ALTER TABLE `user` ADD COLUMN `warnings` int(5)

Rgds

[xtreme-mobile]

thanks for your reply mate, i added the query but now get a differnt error:



Database error in vBulletin 3.0.6:

Invalid SQL:
UPDATE user SET
usergroupid = 28,
displaygroupid = 28,
warnings=2,
warning_level=11,
warning_bans = ,
usertitle = 'Temporarily Banned'
WHERE userid = 166

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 = 166' a

mysql error number: 1064

Date: Monday 07th of February 2005 01:10:51 AM
Script: http://www.extreme-mobile.com/forums/Warn.php
Referer: http://www.extreme-mobile.com/forums...=166&post=1319
Username: admin
IP Address: xxx.xxx.xxx.xx

[sv1cec]

Originally Posted by xtreme-mobile

thanks for your reply mate, i added the query but now get a differnt error:



Database error in vBulletin 3.0.6:

Invalid SQL:
UPDATE user SET
usergroupid = 28,
displaygroupid = 28,
warnings=2,
warning_level=11,
warning_bans = ,
usertitle = 'Temporarily Banned'
WHERE userid = 166

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 = 166' a

mysql error number: 1064

Date: Monday 07th of February 2005 01:10:51 AM
Script: http://www.extreme-mobile.com/forums/Warn.php
Referer: http://www.extreme-mobile.com/forums...=166&post=1319
Username: admin
IP Address: xxx.xxx.xxx.xx

Which version of AWS are you running? There doesn't seem to be any error with the SQL statement, except that 'a' , at WHERE userid = 166' a

But I am not sure if that's from the error message or it got there when copying and pasting.

Also, does that happen every time you issue a warning to a user, or only when that user reaches the ban limit?

rgds

[xtreme-mobile]

ok im using 3.15 i think

it seems to be working ok, BUT when they go over the maximum warn points (10 in my forums case)

it then shows this error

Database error in vBulletin 3.0.6:

Invalid SQL:
UPDATE user SET
usergroupid = 28,
displaygroupid = 28,
warnings=5,
warning_level=12,
warning_bans = ,
usertitle = 'Temporarily Banned'
WHERE userid = 166

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 = 166' a

mysql error number: 1064

Date: Monday 07th of February 2005 11:48:09 AM
Script: http://www.extreme-mobile.com/forums/Warn.php
Referer: http://www.extreme-mobile.com/forums...=166&post=1319
Username: admin
IP Address: xx.xxx.xx.x

so basically when they have reached the banned limit the error occurs

any ideas?

regards

dean

[sv1cec]

Originally Posted by xtreme-mobile

ok im using 3.15 i think

it seems to be working ok, BUT when they go over the maximum warn points (10 in my forums case)

it then shows this error

Database error in vBulletin 3.0.6:

Invalid SQL:
UPDATE user SET
usergroupid = 28,
displaygroupid = 28,
warnings=5,
warning_level=12,
warning_bans = ,
usertitle = 'Temporarily Banned'
WHERE userid = 166

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 = 166' a

mysql error number: 1064

Date: Monday 07th of February 2005 11:48:09 AM
Script: http://www.extreme-mobile.com/forums/Warn.php
Referer: http://www.extreme-mobile.com/forums...=166&post=1319
Username: admin
IP Address: xx.xxx.xx.x

so basically when they have reached the banned limit the error occurs

any ideas?

regards

dean

Please try to upload the file includes/funtions_warning.php to your web server. Download the zip file from the initial thread and extract the above file. Then upload it to your web server. It looks as if the syntax of that file is wrong, near line 304. If you can send me some of the lines of that file, say from line 290 up to 320, I can check it out, but I am sure that the latest one is working fine, haven't touched that file for a while.

Rgds

[Revan]

The error is the fact that it tries to update the warning_bans with an empty string.
This would solve itself if sv1 would just wrap ' around all variables parsing to SQL.
(Then again, this way of halting SQL errors makes detecting errors harder, but meh)

[sv1cec]

Originally Posted by Revan

The error is the fact that it tries to update the warning_bans with an empty string.
This would solve itself if sv1 would just wrap ' around all variables parsing to SQL.
(Then again, this way of halting SQL errors makes detecting errors harder, but meh)

Revan,

I do not think so. it doesn't act like that on my site, for some reason. If you check the code, warning_bans should have a value, either 1 or previous value+1. So I do not think that's the problem.

We will only know when we'll see the code.

Rgds

[xtreme-mobile]

right guys ive downloaded the latest files and replaced the "functions_warnings" file on my account and i get the following error when i put the user up to the ban limit

Database error in vBulletin 3.0.6:

Invalid SQL:
UPDATE user SET
usergroupid = 28,
displaygroupid = 28,
warnings=7,
warning_bans = 1,
usertitle = 'Temporarily Banned'
WHERE userid = 166

mysql error: Unknown column 'warning_bans' in 'field list'

mysql error number: 1054

Date: Tuesday 08th of February 2005 01:48:57 PM
Script: http://www.extreme-mobile.com/forums/Warn.php
Referer: http://www.extreme-mobile.com/forums...=166&post=1319
Username: admin
IP Address: xxx.xxx.xxx.xx

any ideas? also i dont understand what code you wnat me to show you? sorry mate am quite an amature at this

[sv1cec]

Originally Posted by xtreme-mobile

right guys ive downloaded the latest files and replaced the "functions_warnings" file on my account and i get the following error when i put the user up to the ban limit

Database error in vBulletin 3.0.6:

Invalid SQL:
UPDATE user SET
usergroupid = 28,
displaygroupid = 28,
warnings=7,
warning_bans = 1,
usertitle = 'Temporarily Banned'
WHERE userid = 166

mysql error: Unknown column 'warning_bans' in 'field list'

mysql error number: 1054

Date: Tuesday 08th of February 2005 01:48:57 PM
Script: http://www.extreme-mobile.com/forums/Warn.php
Referer: http://www.extreme-mobile.com/forums...=166&post=1319
Username: admin
IP Address: xxx.xxx.xxx.xx

any ideas? also i dont understand what code you wnat me to show you? sorry mate am quite an amature at this

I guess you had installed a previous version first and now you are upgrading. That's why you do not have the warning_bans column. Try running this query:

ALTER TABLE user ADD COLUMN warning_bans int(2)

Remember to add any table prefix if you are using one. Let me know if that works.

rgds