vb.org Archive

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   vB3 General Discussions (https://vborg.vbsupport.ru/forumdisplay.php?f=111)
-   -   Database error while installing a plugin (think it has to do with mysql settings) (https://vborg.vbsupport.ru/showthread.php?t=194284)

Mithan 10-22-2008 04:29 PM
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.

Lynne 10-22-2008 04:49 PM
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?

Mithan 10-22-2008 07:43 PM
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

Lynne 10-22-2008 07:48 PM
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?).

Mithan 10-22-2008 07:58 PM
So you have no idea why I would keep getting a Duplicate Column Name error even if the column doesn't exist?

Lynne 10-22-2008 09:06 PM
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.


All times are GMT. The time now is 03:04 AM.

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.00934 seconds
  • Memory Usage 1,720KB
  • 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
  • (1)bbcode_code_printable
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)post_thanks_navbar_search
  • (1)printthread
  • (6)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