Im getting DataBase Errors On The Following:

I just did a fresh install of the hack, here are my problems:

#1 when I try and look at the "View Warned User" ; "Statistics - Warnings per User" I get the following database error:

Database error in vBulletin 3.0.7:

Invalid SQL: SELECT COUNT(*) AS users FROM user AS user where warnings>0 OR alerts>0
mysql error: Unknown column 'warnings' in 'where clause'

mysql error number: 1054

Date: Sunday 01st of May 2005 07:34:09 PM
Script: http://www.websitename.net/forums/ad...iewwarnedusers
Referer: http://www.websitename.net/forums/ad...dex.php?do=nav



Also, when I attempt to click on the button to warn a member Im send to a screen with a 404 error file not found, yet "Warn.php" is in that folder. It appears that the "Warn.php" may not be working right....

ANy and All help to resolve this is greatly appriceated..

Don

[sv1cec]

The first issue has to do with your user table. There should be a column in it called 'warnings'. Add it by running the following query:

ALTER TABLE " . TABLE_PREFIX . "user ADD COLUMN warnings int(5) default '0'

As for your 404 error, that means that the system can't find the Warn.php file. Make sure that the file exists in your forum's root directory (where the directory admincp is), in other words in :

http://www.websitename.net/forums/

Rgds

[Vman]

I got the "Warn.php" file to work, but the sql is still not working right here is the error Im getting about I did what you said above:

SQL-query:

ALTER TABLE " . TABLE_PREFIX . "user ADD COLUMN warnings int( 5 ) default '0'

MySQL said: Documentation
#1064 - 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 '" . TABLE_PREFIX . "user ADD COLUMN warnings int(5) default '0'

I have uninstalled and installed this hack 4 times to get the exact same errors each time...Im ready to give up and give you full access to see if you can find the problem...hheheheheheh

Thanks for the help

Vman

ALso, if I run the cron "Kill Old Bans" this is the error I get:

Database error in vBulletin 3.0.7:

Invalid SQL: update user set warning_bans=-1 where userid=308
mysql error: Unknown column 'warning_bans' in 'field list'

mysql error number: 1054

Date: Monday 02nd of May 2005 01:02:41 PM
Script: http://www.bodybuildingcentral.net/f...cron&cronid=21
Referer: http://www.bodybuildingcentral.net/f....php?do=modify

I attempted to post a test warning on a member and here is the sql database error Im getting:

Database error in vBulletin 3.0.7:

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

mysql error number: 1054

Date: Monday 02nd of May 2005 01:21:55 PM
Script: http://www.bodybuildingcentral.net/forums/Warn.php
Referer: http://www.bodybuildingcentral.net/f...rNoPost&id=242

[sv1cec]

All your errors are related. The table user has not the proper columns in it. First of all, here is the query that you should use to add all the columns in this table:

ALTER TABLE `".TABLE_PREFIX."user` 
add `warnings` int(5) default '0',
add `warning_level` int(15) default '0', 
add `warning_bans` int(2) default '0',
add `alerts` int(5) default '0'

Also, please open your file kill_old_bans.php and find:

PHP Code:

$bans=$warn['warning_bans']-1; 


Right below that add:

PHP Code:

if ($bans<0)
        {
            $bans=0;
        } 


This was not the cause of your error, still you found me a bug in that script.

Oh, one more thing. Are you using a table prefix in your database? From the error messages, it looks as if you are not. If you are not, remove the ".TABLE_PREFIX." from the above query.

Let me know if you got it working.

[Vman]

what do you mean "table_prefix"? I have attempted the above and got an sql error again because of "table_prefix"

anyone?

[sv1cec]

A table prefix is a prefix you have defined when you installed your database. When you refer to a table in your database, for example the table user, how to you refer to it when you run a query? Do you call it "user" or something like "vb3_user" or "mydb_user"?

Try running the above query as shown below:

ALTER TABLE `user` 
add `warnings` int(5) default '0',
add `warning_level` int(15) default '0', 
add `warning_bans` int(2) default '0',
add `alerts` int(5) default '0'

Rgds

[Vman]

YUP!! that worked!...Thanks....... ;-)

[sv1cec]

Glad you sort it out.

Rgds