Error messages

[Skyline_GT]

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

[sv1cec]

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:


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


then


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]

I ran the script.

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

[sv1cec]

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


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:


DESCRIBE TABLE tablename


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

[Skyline_GT]

Fixed them.
..

I wonder how come on the warn.php I see


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]

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]

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]

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]

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]

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.

[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/Warn.php?do=ViewWarnings&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.

[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!