Go Back   vb.org Archive > vBulletin 3 Discussion > vB3 General Discussions
FAQ Community Calendar Today's Posts Search

Reply
 
Thread Tools Display Modes
  #1  
Old 10-22-2008, 04:29 PM
Mithan Mithan is offline
 
Join Date: Apr 2002
Posts: 96
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default Database error while installing a plugin (think it has to do with mysql settings)

I believe the problem I am having is related to my security settings with mysql NOT the mod I am trying to install, reason I am posting here. Maybe somebody knows what my problem may be.

I am using a new install of vB, so I doubt its vB itself causing the issue, but my server.

I am trying to install the following product:
https://vborg.vbsupport.ru/showthrea...=170592&page=4

However, I get the following error:
Code:
Database error in vBulletin 3.7.3:

Invalid SQL:
ALTER TABLE event ADD gwe_signup BOOL NOT NULL DEFAULT '0';

MySQL Error : Duplicate column name 'gwe_signup'
Error Number : 1060
Request Date : Tuesday, October 21st 2008 @ 09:30:50 AM
Error Date : Tuesday, October 21st 2008 @ 09:30:51 AM
Script : http://www.wowhq.com/forum2/admincp/...=productimport
Referrer : http://www.wowhq.com/forum2/admincp/...?do=productadd
IP Address : 67.225.32.128
Username : Mithan
Classname : vB_Database
MySQL Version : 4.1.21-log


Does anybody know if any settings could be causing that?

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

PS:
I have gone and deleted those tables manually and I have used the "over write" option when installing the product.

This still happens even on a clean install.
Reply With Quote
  #2  
Old 10-22-2008, 04:49 PM
Lynne's Avatar
Lynne Lynne is offline
 
Join Date: Sep 2004
Location: California/Idaho
Posts: 41,180
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

What do you mean you deleted the table - the whole event table? That is going to cause problems. This was a new database you made and then you ran the install.php script and it created all new tables? What version of vb did you install?
Reply With Quote
  #3  
Old 10-22-2008, 07:43 PM
Mithan Mithan is offline
 
Join Date: Apr 2002
Posts: 96
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

No, I meant I deleted the "gwe_signup" column and tried to re-install and it still wouldn't allow it to install.

VB version is 3.7.3
Reply With Quote
  #4  
Old 10-22-2008, 07:48 PM
Lynne's Avatar
Lynne Lynne is offline
 
Join Date: Sep 2004
Location: California/Idaho
Posts: 41,180
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

You should post about this in the modification thread. Perhaps the author knows why this isn't working. You should tell him the error you are getting (is it the same one even though you deleted the column?).
Reply With Quote
  #5  
Old 10-22-2008, 07:58 PM
Mithan Mithan is offline
 
Join Date: Apr 2002
Posts: 96
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

So you have no idea why I would keep getting a Duplicate Column Name error even if the column doesn't exist?
Reply With Quote
  #6  
Old 10-22-2008, 09:06 PM
Lynne's Avatar
Lynne Lynne is offline
 
Join Date: Sep 2004
Location: California/Idaho
Posts: 41,180
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

No, I have no idea why you keep getting this error. It could be that the plugin was written incorrectly, but you need to ask the author about this.
Reply With Quote
Reply


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 10:50 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.06495 seconds
  • Memory Usage 2,207KB
  • 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
  • (1)footer
  • (1)forumjump
  • (1)forumrules
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (1)navbar
  • (3)navbar_link
  • (120)option
  • (6)post_thanks_box
  • (6)post_thanks_button
  • (1)post_thanks_javascript
  • (1)post_thanks_navbar_search
  • (6)post_thanks_postbit_info
  • (6)postbit
  • (6)postbit_onlinestatus
  • (6)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