PDA

View Full Version : Database problem after first install

mrpotatohead
06-01-2005, 05:46 PM
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/forum/warn.php?do=WarnUser&id=1814&post=48075
Referer: http://www.bigbrotherwebsite.net/forum/showthread.php?p=48086
Username: Big Brother
IP Address: 81.153.209.9


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


- Joe
sv1cec
06-02-2005, 03:34 AM
This is not AWS code. The select statement of this error does not exist inside AWS. Maybe you installed another hack?

Rgds
mrpotatohead
06-02-2005, 02:11 PM
Ahh ok, I did try a few other warning ones first - so I'll try uninstalling them now.

Thanks,

Joe
RichieBoy67
06-02-2005, 02:32 PM
I sent you a pm regarding this too :)
mrpotatohead
06-02-2005, 02:46 PM
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
06-02-2005, 05:22 PM
Just look up the database modification in the installation of that previous hack, and reverse the process.
mrpotatohead
06-02-2005, 05:28 PM
How do I do that sorry? *embarassed*

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

- Joe
RichieBoy67
06-02-2005, 06:01 PM
Yes, thank you, but I'm not willing to pay. I'm a broke student for starters!




No problem....
sv1cec
06-02-2005, 07:57 PM
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
06-03-2005, 02:44 AM
Problem solved. Thanks guys.

- joe
sv1cec
06-03-2005, 03:06 AM
You are welcome. Glad you have it solved.