Database problem after first install

Hi there,

Installed this for the first time and all Admin CP features seem to work fine, but the problem occurs when I click on the 'Warn ____' or 'View ____'s warnings' links - they take me to a page that tells me I have a database problem with vBulletin with the following:

Database error in vBulletin 3.0.3:

Invalid SQL:
SELECT name, warnlvl, points
FROM warnings
ORDER BY (warnlvl) ASC, (worder) ASC
mysql error: Unknown column 'name' in 'field list'

mysql error number: 1054

Date: Wednesday 01st of June 2005 08:45:30 PM
Script: http://www.bigbrotherwebsite.net/for...814&post=48075
Referer: http://www.bigbrotherwebsite.net/for...ad.php?p=48086
Username: Big Brother
IP Address: 81.153.209.9

Anybody got any clues or ideas?? Please! I'm desperate!


- Joe

[sv1cec]

This is not AWS code. The select statement of this error does not exist inside AWS. Maybe you installed another hack?

Rgds

[mrpotatohead]

Ahh ok, I did try a few other warning ones first - so I'll try uninstalling them now.

Thanks,

Joe

[RichieBoy67]

I sent you a pm regarding this too

[mrpotatohead]

Yes, thank you, but I'm not willing to pay. I'm a broke student for starters!

- Joe

It seems like it's something to do with a 'warnings' table in my database. Don't suppose anybody could tell me which tables the AWS uses in the database - so i know which areas to remove for a previous warnings hack (v2.1) I had installed?

Thanks,

- Joe

[Marco van Herwaarden]

Just look up the database modification in the installation of that previous hack, and reverse the process.

[mrpotatohead]

How do I do that sorry? *embarassed*

Didn't the automatic installer make the changes to the database?

- Joe

[RichieBoy67]

Yes, thank you, but I'm not willing to pay. I'm a broke student for starters!

No problem....

[sv1cec]

AWS uses several tables in the database, you can see them, if you check the install_warn.php file. Mainly:

- warnings
- warning_types
- pmtext_warned
- ban_dates

It also alters the following standard tables:

- user
- userban
- post

I hope this helps.

[mrpotatohead]

Problem solved. Thanks guys.

- joe