Log in

View Full Version : Database error while installing a plugin (think it has to do with mysql settings)


Mithan
10-22-2008, 04:29 PM
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/showthread.php?t=170592&page=4

However, I get the following error:
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 1224696771 at 1224696771 ---------------

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.