[Xplorer4x4]

Ok well I have several problems. Here we go:

1)First problem comes up when using the AWS menu in ACP. I can use the managing warning options but when I click Manage Warning Types I see the bar that sayd Current Warning Types but I get a DB error above it:

PHP Code:

Database error in vBulletin 3.5.0 Release Candidate 3:
Invalid SQL:
select * from warning_types order by warn_points, warn_maturity, warn_name;
MySQL Error : Unknown column 'warn_maturity' in 'order clause'
Error Number : 1054
Date         : Saturday, September 17th 2005 @ 12:29:21 PM
Script     : /forums/admincp/admin_warn.php?act=view
Referrer     : /forums/admincp/index.php?do=nav
IP Address : 12.220.52.153
Username     : Xplorer4x4
Classname    : vb_database 


Warn User and View User Warnings. However when i click View Warnings Logs I get a white DB Error page:

PHP Code:

Database error in vBulletin 3.5.0 Release Candidate 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'
Error Number : 1054
Date         : Saturday, September 17th 2005 @ 12:30:41 PM
Script     : /forums/admincp/admin_warn.php?act=viewlogs
Referrer     : /forums/admincp/index.php?do=nav
Username     : Xplorer4x4
Classname    : vb_database 


When I click the setting for Statistics - Warnings For Users I get a DB Error:

PHP Code:

Database error in vBulletin 3.5.0 Release Candidate 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'
Error Number : 1054
Date         : Saturday, September 17th 2005 @ 12:35:34 PM
Script     : /forums/admincp/admin_warn.php?act=viewwarnedusers&type=warnings
Referrer     : /forums/admincp/index.php?do=nav
Username     : Xplorer4x4
Classname    : vb_database 


Also take note I had this installed on vB3.0. I noticed in the Statistics-Warnings Per Type that all my old warnings descriptions are active, but the warnings issued count is off.

I also had some problems with my postbit_legacy template, but I assume thats what I get for doing template mods at near 4AM.

Any ideas?