The Arcive of Official vBulletin Modifications Site.It is not a VB3 engine, just a parsed copy! |
|
#1
|
|||
|
|||
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. |
#2
|
||||
|
||||
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?
|
#3
|
|||
|
|||
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 |
#4
|
||||
|
||||
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?).
|
#5
|
|||
|
|||
So you have no idea why I would keep getting a Duplicate Column Name error even if the column doesn't exist?
|
#6
|
||||
|
||||
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.
|
|
|
X vBulletin 3.8.12 by vBS Debug Information | |
---|---|
|
|
More Information | |
Template Usage:
Phrase Groups Available:
|
Included Files:
Hooks Called:
|