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?

[xtreme-mobile]

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:

its a fresh installation mate

ive recently upgraded my forum to 3.06 and it wiped my board so im basically starting again, so didnt have any warning hacks installed

ill try and run this query now and see if anything happens and ill report here

cheers

dean

UPDATE

ok have just tried to run the query and it said this error when running:

MySQL said:

#1060 - Duplicate column name 'warning_bans'

Warning: mysql_result(): supplied argument is not a valid MySQL result resource in /usr/local/cpanel/base/3rdparty/phpMyAdmin/libraries/common.lib.php on line 682


any other ideas?

[sv1cec]

Originally Posted by xtreme-mobile

its a fresh installation mate

ive recently upgraded my forum to 3.06 and it wiped my board so im basically starting again, so didnt have any warning hacks installed

ill try and run this query now and see if anything happens and ill report here

cheers

dean

UPDATE

ok have just tried to run the query and it said this error when running:

MySQL said:

#1060 - Duplicate column name 'warning_bans'

Warning: mysql_result(): supplied argument is not a valid MySQL result resource in /usr/local/cpanel/base/3rdparty/phpMyAdmin/libraries/common.lib.php on line 682


any other ideas?

These are contradictory things. I mean in the first error message, it says that the column warning_bans is unknown (i.e. does not exist) and in the second, when you try to add it, it says that it exists.

I am not sure what to tell you. Are you sure you are using the same database, the same table names (any table prefix?)? I do not know.

[xtreme-mobile]

yeh am using the same data base, i dont know whts up with it, each step was followed and it works fine exept for the fact it dont work when they reach the warn limit

[sv1cec]

Originally Posted by xtreme-mobile

yeh am using the same data base, i dont know whts up with it, each step was followed and it works fine exept for the fact it dont work when they reach the warn limit

Do me a favor, run the following query:

describe users

Also, run the followings :

describe warning_options

and

describe warnings

Let's try to figure this out.

Rgds