The Arcive of vBulletin Modifications Site.

Error messages · **Released**: 07-27-2005

I got when i click Manage Warning Types

Code:

Database error in vBulletin 3.0.3:

Invalid SQL: select * from warning_types order by warn_points, warn_maturity, warn_name
mysql error: Unknown column 'warn_maturity' in 'order clause'

mysql error number: 1054

Date: Wednesday 27th of July 2005 02:37:44 AM
Script: /admin_warn.php?act=view
Referer: /index.php?do=nav

got

Code:

Database error in vBulletin 3.0.3:

Invalid SQL: select w.*,u.username as wusername,u.userid as wuserid,wt.*,wuser.username as warned_username_v,wuser.userid as warned_userid_v, ruser.username as removed_by_v, (w.warned_time+wt.warn_maturity*24*60*60) AS maturitydate from
	warnings w
	left join user wuser on(wuser.userid=w.warned_user)
	left join user u on(u.userid=w.warned_by)
	left join user ruser on(ruser.userid=w.removed_by)
	left join warning_types wt on(wt.tid=w.warned_warning_id) ORDER BY w.warned_time DESC LIMIT 0, 15
mysql error: Unknown column 'wt.warn_maturity' in 'field list'

when View Warning Logs

got

Code:

Database error in vBulletin 3.0.3:

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

when View Warned Users

got

Code:

Database error in vBulletin 3.0.3:

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

Statistics - Warnings per Warner

got

Code:

Database error in vBulletin 3.0.3:

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

on Statistics - Warnings per User

sv1cec · #2 07-27-2005, 08:06 AM

Your database tables have not been created or updated as they should be. Did you run the installation script (install_warn.php), or did you create the tables manually?

Try re-running that script again, or manually run the following queries:

Code:

ALTER TABLE ".TABLE_PREFIX."warning_types ADD COLUMN warn_maturity int(5)

then

Code:

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

Remember to edit or remove the ".TABLE_PREFIX." thing according to your environment.

Rgds

Skyline_GT · #3 07-27-2005, 08:13 AM

I ran the script.

there are still error for
View Warning Logs
View Warned Users
and
Statistics - Warnings per User

sv1cec · #4 07-27-2005, 08:37 AM

It seems as if the installation script didn't create several fields in the various tables. I am not sure why. Run this query:

Code:

ALTER TABLE ".TABLE_PREFIX."warning_types ADD COLUMN warn_permban char(3)

Better yet, open the install_warn.php script and verify that all the columns for all the tables are there. You can see what columns you have by running the following query:

Code:

DESCRIBE TABLE tablename

Somehow I have the feeling that there will be other fields that haven't been added.

Skyline_GT · #5 07-27-2005, 08:38 AM

Fixed them.
..

I wonder how come on the warn.php I see

Quote:

Once you reach warning level , you will be banned for days

but it doesnt show the number of days.. I already set it 10 in the option..

how come when I try to warn someone, the warn type are all gone..

sv1cec · #6 07-27-2005, 08:58 AM

Please make sure you have saved your options. Go to AWS options and change them according to your preferences. Click on Update and then verify that the updates are saved.

If not, you have not run the warn_install_setting.php script.

Skyline_GT · #7 07-27-2005, 09:00 AM

Quote:

Add the latest settings to the Advanced Warning System.
Running this part even if you have the latest version does not cause any harm.
You are running version 3.4.14.
This hack is version 3.4.14.

already ran before..and checked to make sure it is saved. i still don't see the number of days on the warn.php as well, all the warn types are gone when trying to warn people.

btw.. I installed the zero telorance hack before..

sv1cec · #8 07-27-2005, 09:36 AM

If you had Zero's hack before, there is a special script which should be run to do the updates. Did you run it? It is called upgrade_warn.php.

Skyline_GT · #9 07-27-2005, 09:37 AM

Quote:

Originally Posted by sv1cec

If you had Zero's hack before, there is a special script which should be run to do the updates. Did you run it? It is called upgrade_warn.php.

oh crap....
no good.

ok... but I still can't see any warning for the Warning Selection:

sv1cec · #10 07-27-2005, 09:42 AM

This hack has a lot of differences compared with Zero's. If the suggested upgrade procedure is not followed, strange things result. Sorry about that, it is well documented in the installation instructions.

I am not sure why the warning types do not show, I am not sure what is there in your database and what is not. I would suggest that you delete the tables that Zero's hack create and start from scratch.