Go Back   vb.org Archive > vBulletin Modifications > Archive > vB.org Archives > Premium Archives > Advanced Warning System (AWS)
Reload this Page Database problem after first install
FAQ Members List Calendar Search Today's Posts Mark Forums Read

Closed Thread
Page 1 of 2 1 2
 
Thread Tools
Database problem after first install Details »»
Database problem after first install
Version: , by mrpotatohead mrpotatohead is offline
Developer Last Online: Mar 2009 Show Printable Version Email this Page
Version: Unknown Rating:
Released: 06-01-2005 Last Update: Never Installs: 0
 
No support by the author.

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

Show Your Support

  • This modification may not be copied, reproduced or published elsewhere without author's permission.

Comments
  #2  
Old 06-02-2005, 03:34 AM
sv1cec sv1cec is offline
 
Join Date: May 2004
Location: Athens, Greece
Posts: 2,091
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default
This is not AWS code. The select statement of this error does not exist inside AWS. Maybe you installed another hack?

Rgds
  #3  
Old 06-02-2005, 02:11 PM
mrpotatohead mrpotatohead is offline
 
Join Date: Jul 2004
Posts: 24
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default
Ahh ok, I did try a few other warning ones first - so I'll try uninstalling them now.

Thanks,

Joe
  #4  
Old 06-02-2005, 02:32 PM
RichieBoy67's Avatar
RichieBoy67 RichieBoy67 is offline
 
Join Date: Apr 2004
Location: CT - Down in a hole..
Posts: 3,057
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default
I sent you a pm regarding this too
  #5  
Old 06-02-2005, 02:46 PM
mrpotatohead mrpotatohead is offline
 
Join Date: Jul 2004
Posts: 24
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default
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
  #6  
Old 06-02-2005, 05:22 PM
Marco van Herwaarden Marco van Herwaarden is offline
 
Join Date: Jul 2004
Posts: 25,415
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default
Just look up the database modification in the installation of that previous hack, and reverse the process.
  #7  
Old 06-02-2005, 05:28 PM
mrpotatohead mrpotatohead is offline
 
Join Date: Jul 2004
Posts: 24
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default
How do I do that sorry? *embarassed*

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

- Joe
  #8  
Old 06-02-2005, 06:01 PM
RichieBoy67's Avatar
RichieBoy67 RichieBoy67 is offline
 
Join Date: Apr 2004
Location: CT - Down in a hole..
Posts: 3,057
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default
Quote:
Yes, thank you, but I'm not willing to pay. I'm a broke student for starters!



No problem....
  #9  
Old 06-02-2005, 07:57 PM
sv1cec sv1cec is offline
 
Join Date: May 2004
Location: Athens, Greece
Posts: 2,091
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default
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.
  #10  
Old 06-03-2005, 02:44 AM
mrpotatohead mrpotatohead is offline
 
Join Date: Jul 2004
Posts: 24
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default
Problem solved. Thanks guys.

- joe
Closed Thread
Page 1 of 2 1 2

« Previous Thread | Next Thread »
Thread Tools

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts
BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Forum Jump


All times are GMT. The time now is 05:10 PM.

Contact Us - Archive - Top

Powered by vBulletin® Version 3.8.12 by vBS
Copyright ©2000 - 2025, vBulletin Solutions Inc.
X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.04171 seconds
  • Memory Usage 2,276KB
  • Queries Executed 25 (?)
More Information
Template Usage:
  • (1)SHOWTHREAD
  • (1)ad_footer_end
  • (1)ad_footer_start
  • (1)ad_header_end
  • (1)ad_header_logo
  • (1)ad_navbar_below
  • (1)ad_showthread_beforeqr
  • (2)bbcode_quote
  • (1)footer
  • (1)forumjump
  • (1)forumrules
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (1)modsystem_post
  • (1)navbar
  • (6)navbar_link
  • (120)option
  • (1)pagenav
  • (1)pagenav_curpage
  • (1)pagenav_pagelink
  • (10)post_thanks_box
  • (10)post_thanks_button
  • (1)post_thanks_javascript
  • (1)post_thanks_navbar_search
  • (10)post_thanks_postbit_info
  • (9)postbit
  • (10)postbit_onlinestatus
  • (10)postbit_wrapper
  • (1)spacer_close
  • (1)spacer_open
  • (1)tagbit_wrapper 
Phrase Groups Available:
  • global
  • inlinemod
  • postbit
  • posting
  • reputationlevel
  • showthread
Included Files:
  • ./showthread.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/functions_bigthree.php
  • ./includes/class_postbit.php
  • ./includes/class_bbcode.php
  • ./includes/functions_reputation.php
  • ./includes/functions_post_thanks.php 
Hooks Called:
  • init_startup
  • init_startup_session_setup_start
  • init_startup_session_setup_complete
  • cache_permissions
  • fetch_postinfo_query
  • fetch_postinfo
  • fetch_threadinfo_query
  • fetch_threadinfo
  • fetch_foruminfo
  • style_fetch
  • cache_templates
  • global_start
  • parse_templates
  • global_setup_complete
  • showthread_start
  • showthread_getinfo
  • forumjump
  • showthread_post_start
  • showthread_query_postids
  • showthread_query
  • bbcode_fetch_tags
  • bbcode_create
  • showthread_postbit_create
  • postbit_factory
  • postbit_display_start
  • post_thanks_function_post_thanks_off_start
  • post_thanks_function_post_thanks_off_end
  • post_thanks_function_fetch_thanks_start
  • post_thanks_function_fetch_thanks_end
  • post_thanks_function_thanked_already_start
  • post_thanks_function_thanked_already_end
  • fetch_musername
  • postbit_imicons
  • bbcode_parse_start
  • bbcode_parse_complete_precache
  • bbcode_parse_complete
  • postbit_display_complete
  • post_thanks_function_can_thank_this_post_start
  • pagenav_page
  • pagenav_complete
  • tag_fetchbit_complete
  • forumrules
  • navbits
  • navbits_complete
  • showthread_complete