Go Back   vb.org Archive > vBulletin 3 Discussion > vB3 Programming Discussions

Reply
 
Thread Tools Display Modes
  #11  
Old 02-15-2008, 09:43 PM
semaXD semaXD is offline
 
Join Date: Nov 2007
Posts: 12
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

install what the "sponsor it" stuff i uploaded it and it gave me

Database error in vBulletin 3.6.8:

Invalid SQL:

SELECT set_value, varname
FROM sponsor_settings
WHERE varname IN ('sponsor_active', 'sponsor_title', 'sponsor_message', 'sponsor_position', 'sponsor_columns', 'sponsor_redirect', 'sponsor_file', 'sponsor_imgpath');

MySQL Error : Unknown column 'set_value' in 'field list'
Error Number : 1054
Date : Friday, February 15th 2008 @ 03:38:48 PM
Script : http://girlfriendsfilms.com/forum/login.php?do=login
Referrer : http://girlfriendsfilms.com/forum/admincp/index.php
IP Address : 71.156.44.190
Username : GFadmin
Classname : vb_database
Reply With Quote
  #12  
Old 02-15-2008, 09:49 PM
semaXD semaXD is offline
 
Join Date: Nov 2007
Posts: 12
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default



ok got it thanks guys for the help just had to walk away and switch a few things around in the tables back in action!!
Reply With Quote
  #13  
Old 02-15-2008, 11:55 PM
Boofo's Avatar
Boofo Boofo is offline
 
Join Date: Mar 2002
Location: Des Moines, IA (USA)
Posts: 15,776
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Glad to hear it. What did you have to do?
Reply With Quote
  #14  
Old 02-16-2008, 03:52 AM
cheesegrits's Avatar
cheesegrits cheesegrits is offline
 
Join Date: May 2006
Posts: 500
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Quote:
Originally Posted by Boofo View Post
She could also re-install the product and allow overwrite so the tables would be there. And then uninstall it properly.
I'm pretty sure re-installing with allow overwrite doesn't rerun the install code, so it won't recreate missing tables

-- hugh
Reply With Quote
  #15  
Old 02-16-2008, 04:42 AM
Boofo's Avatar
Boofo Boofo is offline
 
Join Date: Mar 2002
Location: Des Moines, IA (USA)
Posts: 15,776
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Are you sure? I thought it did.
Reply With Quote
  #16  
Old 02-16-2008, 04:44 AM
semaXD semaXD is offline
 
Join Date: Nov 2007
Posts: 12
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

i did exactly what you and chris said reinstalled it the added the tables back empty, i had to add a second column and then it populated I did ther removal in the cp and bada bing bada boom we are back in action!!

thanks again for your quick help on this you guys rock!!
Reply With Quote
  #17  
Old 02-16-2008, 04:51 AM
Boofo's Avatar
Boofo Boofo is offline
 
Join Date: Mar 2002
Location: Des Moines, IA (USA)
Posts: 15,776
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Great! Now you know what to do if you ever run into the same kind of problem again. Ain't it fun to learn?

Did re-installing the hack add back the table or did you have to do that manually?
Reply With Quote
  #18  
Old 02-16-2008, 05:05 AM
semaXD semaXD is offline
 
Join Date: Nov 2007
Posts: 12
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

To be honest i didnt check it was up, so i got a bottle of wine and called it a week~~

--------------- Added [DATE]1203146168[/DATE] at [TIME]1203146168[/TIME] ---------------

oh wait do you mean b4 it came back up? yea we did it manually then got the wine
Reply With Quote
  #19  
Old 02-16-2008, 05:25 AM
Boofo's Avatar
Boofo Boofo is offline
 
Join Date: Mar 2002
Location: Des Moines, IA (USA)
Posts: 15,776
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Wine seems to help with a lot on vbulletin errors I have found out. Beer is another good error fixer.
Reply With Quote
  #20  
Old 02-16-2008, 02:58 PM
cheesegrits's Avatar
cheesegrits cheesegrits is offline
 
Join Date: May 2006
Posts: 500
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Quote:
Originally Posted by Boofo View Post
Are you sure? I thought it did.
Nope. From the ACP plugin.php code:

PHP Code:
            // Run if: code version is * (meaning always run), no version
            //        previously installed, or if the code is for a newer version
            //        than is currently installed
            
if ($code['version'] == '*' OR $installed_version === null OR is_newer_version($code['version'], $installed_version))
            {
                eval(
$code['installcode']);
            } 
It only runs install code on first install, or if you are installing a newer version (and then it only runs the new version's code).

Re-running the current version code on an update would be a bit disasterous for all those install codes that start out with "drop table if exists".

-- hugh
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 04:36 PM.


Powered by vBulletin® Version 3.8.12 by vBS
Copyright ©2000 - 2024, vBulletin Solutions Inc.
X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.04353 seconds
  • Memory Usage 2,253KB
  • 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_php
  • (2)bbcode_quote
  • (1)footer
  • (1)forumjump
  • (1)forumrules
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (1)navbar
  • (3)navbar_link
  • (120)option
  • (1)pagenav
  • (1)pagenav_curpage
  • (2)pagenav_pagelink
  • (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
  • pagenav_page
  • pagenav_complete
  • tag_fetchbit_complete
  • forumrules
  • navbits
  • navbits_complete
  • showthread_complete