Go Back   vb.org Archive > vBulletin 3 Discussion > vB3 General Discussions
  #1  
Old 02-28-2008, 03:35 PM
Mrquarter Mrquarter is offline
 
Join Date: Feb 2008
Location: Florida
Posts: 23
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default Problem with a mod

Whenever I do THIS MOD I always get the error below:

Code:
Database error in vBulletin 3.7.0 Beta 4:

Invalid SQL:
INSERT INTO banners (bid, name, width, height, alt, flash, active) VALUES ('', 'quarterx1.gif', '800', '120', 'QuarterX', '0', '1');

MySQL Error   : Table '6241_forum.banners' doesn't exist
Error Number  : 1146
Date          : Wednesday, February 27th 2008 @ 02:59:45 PM
Script        : http://www.quarterx.org/forums/admincp/brotator.php?do=add
Referrer      : http://www.quarterx.org/forums/admincp/brotator.php?do=add
IP Address    : xxx.xxx.xxx.xxx
Username      : Tyler
Classname     : vB_Database
MySQL Version : 5.0.45
Any help with what is happening?
Reply With Quote
  #2  
Old 02-28-2008, 03:44 PM
G0F0RBR0KE G0F0RBR0KE is offline
 
Join Date: Mar 2005
Posts: 987
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

We suggest you post in the mod thread for further information toward your question.
Reply With Quote
  #3  
Old 02-28-2008, 04:14 PM
Mrquarter Mrquarter is offline
 
Join Date: Feb 2008
Location: Florida
Posts: 23
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

I did post in that thread, and its been 2 days and I got no response, so I posted it here.
Reply With Quote
  #4  
Old 02-28-2008, 04:22 PM
Boofo's Avatar
Boofo Boofo is offline
 
Join Date: Mar 2002
Location: Des Moines, IA (USA)
Posts: 15,776
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

2 days isn't really that long as most coders either work or have a life. Some even do both.
Reply With Quote
  #5  
Old 02-28-2008, 05:17 PM
Lynne's Avatar
Lynne Lynne is offline
 
Join Date: Sep 2004
Location: California/Idaho
Posts: 41,180
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

All we can tell you is that the error is spelled out:
Table '6241_forum.banners' doesn't exist

So, go see if that table really does exist. If it doesn't, take a look at the install code and reinstall it. Without knowing anything about the hack (I don't have it installed), that is the only advise I can give you.
Reply With Quote
  #6  
Old 02-28-2008, 06:43 PM
Mrquarter Mrquarter is offline
 
Join Date: Feb 2008
Location: Florida
Posts: 23
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

It does mean that the table is not installed, but I have tried re-installing the .xml a couple of times.
Reply With Quote
  #7  
Old 02-28-2008, 07:08 PM
TTG's Avatar
TTG TTG is offline
 
Join Date: May 2004
Location: Sth London
Posts: 1,042
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Quote:
Originally Posted by Boofo View Post
2 days isn't really that long as most coders either work or have a life. Some even do both.
O .. M .. G .. they are allowed to have a life
Reply With Quote
  #8  
Old 02-28-2008, 07:30 PM
Lynne's Avatar
Lynne Lynne is offline
 
Join Date: Sep 2004
Location: California/Idaho
Posts: 41,180
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Quote:
Originally Posted by Mrquarter View Post
It does mean that the table is not installed, but I have tried re-installing the .xml a couple of times.
But *is* it really not installed. Have you looked in the database? And, if you can't get it to install using the .xml, maybe grab the query from the .xml and run it directly. (Back up database before doing any such thing!)
Reply With Quote
  #9  
Old 02-28-2008, 07:46 PM
Boofo's Avatar
Boofo Boofo is offline
 
Join Date: Mar 2002
Location: Des Moines, IA (USA)
Posts: 15,776
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Don't just overwrite the hack. Completely uninstall it and then re-install it. Overwriting doesn't run the queries again unless they have been updated.

Quote:
Originally Posted by TTG View Post
O .. M .. G .. they are allowed to have a life
I wasn't referring to anyone here. We all know how most of them REALLY are.
Reply With Quote
  #10  
Old 02-28-2008, 07:54 PM
Brandon Sheley's Avatar
Brandon Sheley Brandon Sheley is offline
 
Join Date: Mar 2005
Location: Google Kansas
Posts: 4,678
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Quote:
Originally Posted by Mrquarter View Post
I did post in that thread, and its been 2 days and I got no response, so I posted it here.
It's best to ask in the support threads

Supported


Reply With Quote
Reply

Thread Tools
Display Modes

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 07:25 PM.


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.03963 seconds
  • Memory Usage 2,239KB
  • Queries Executed 11 (?)
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
  • (1)ad_showthread_firstpost
  • (1)ad_showthread_firstpost_sig
  • (1)ad_showthread_firstpost_start
  • (1)bbcode_code
  • (4)bbcode_quote
  • (1)footer
  • (1)forumjump
  • (1)forumrules
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (1)navbar
  • (3)navbar_link
  • (120)option
  • (10)post_thanks_box
  • (10)post_thanks_button
  • (1)post_thanks_javascript
  • (1)post_thanks_navbar_search
  • (10)post_thanks_postbit_info
  • (10)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_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
  • tag_fetchbit_complete
  • forumrules
  • navbits
  • navbits_complete
  • showthread_complete