vb.org Archive - Database problem after first install

vb.org Archive (https://vborg.vbsupport.ru/index.php)

- Advanced Warning System (AWS) (https://vborg.vbsupport.ru/forumdisplay.php?f=105)

- - Database problem after first install (https://vborg.vbsupport.ru/showthread.php?t=82356)

mrpotatohead

06-01-2005 05:46 PM

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:

Quote:

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

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

Quote:

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.

All times are GMT. The time now is 04:44 PM.

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.01000 seconds Memory Usage 1,727KB Queries Executed 10 (?)
More Information
Template Usage: (1)ad_footer_end (1)ad_footer_start (1)ad_header_end (1)ad_header_logo (1)ad_navbar_below (2)bbcode_quote_printable (1)footer (1)gobutton (1)header (1)headinclude (6)option (1)post_thanks_navbar_search (1)printthread (11)printthreadbit (1)spacer_close (1)spacer_open Phrase Groups Available: global postbit showthread	Included Files: ./printthread.php ./global.php ./includes/init.php ./includes/class_core.php ./includes/config.php ./includes/functions.php ./includes/class_hook.php ./includes/modsystem_functions.php ./includes/class_bbcode_alt.php ./includes/class_bbcode.php ./includes/functions_bigthree.php Hooks Called: init_startup init_startup_session_setup_start init_startup_session_setup_complete cache_permissions fetch_threadinfo_query fetch_threadinfo fetch_foruminfo style_fetch cache_templates global_start parse_templates global_setup_complete printthread_start bbcode_fetch_tags bbcode_create bbcode_parse_start bbcode_parse_complete_precache bbcode_parse_complete printthread_post printthread_complete
Messages: