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]

hm.. everything in the database is there. I double checked them..

btw.. how can you delete all the tables that the other mod create..

[sv1cec]

If you are sure that everything is in the database, there is no reason to delete the tables. The question is, how sure are you? AWS creates 5 tables (6 in version 3.4.15) and alters the following tables from the original vB database:

- user
- userban
- post

If you are sure that the 5 new tables are there, with the proper fields, and the changes in the 3 other tables are made, there is no point to erase them.

Verify to me that the tables are correct and then we will try to figure out your problem(s).

[Skyline_GT]

100% since I change them by hand...and i double check them. and I believe you are talking about 3.4.14

the tables that I add or modifly are
warnings
warning_types
warning_options
warn_notes
userban
user
post
pmtext_warned
ban_dates

[sv1cec]

You did these by hand? That's why there were fields missing. OK, now what are your problems?

[Skyline_GT]

i did them by hands since after I ran the install, it doesn't make change to the table that are already credted by the previous mod..
the current problem is that when I am trying to warn a person, under warn selection, it doesn't show any warning type.
Only seee "Choose A Warning"

however, when you go to this page
http://www.gamerzplanet.net/forums/W...ings&id=238483
you can see the different types of warning..

[sv1cec]

This can't be due to your changes. After you click on the Warn XYZ link (or button), you are in Warn.php. That should be OK, as it comes from the zip. You have uploaded the new files to your server, haven't you?

[Skyline_GT]

i upload everything to the server.

[sv1cec]

OK, let's see, you go to Warn XYZ and you can not select any of the warnings you have created. Further down, on that same page, can you see the list of the Warning Types?

[Skyline_GT]

no I dont see the list of warning types there..

[sv1cec]

Then there are no warning types defined, or at least they are not defined as post-related. Check out that you have define warning types and that they are post-related.