Error messages

I got when i click Manage Warning Types

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

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

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

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

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

[Skyline_GT]

oh.. that do it.
finally it works
thanks man

[sv1cec]

Most welcome. Do go through the Admin section of AWS first and read every description in every option. Do the same with the Warning Types screens. It will allow you to understand how things are supposed to work.

Glad you got it working.

[Skyline_GT]

thanks man. I guess I didn't read it carefully..

[sv1cec]

Take care!