Bug Error Number : 1060 - Duplicate column name 'screenshot'

[Gecuba]

MySQL Error 1060 during reinstall - Duplicate column name 'screenshot'

I try to install this mod on my test-forum (some month ago I already installed the lite version), but I get mySQL error after xml-file import:

Invalid SQL:

	ALTER TABLE dbtech_downloads_fileinfo
	ADD COLUMN `screenshot` ENUM('0','1') NOT NULL DEFAULT '0';

MySQL Error   : Duplicate column name 'screenshot'
Error Number  : 1060

The same problem I found in this thead, but there is no any solution in answers.

 

[Fillip H.]

That's not the same problem - two vastly different mods.

Can you please uninstall the previous version before attempting to reinstall this version, then see if that works?

 

[Gecuba]

I can reinstall - but the result is the same - MySQL during importing of xml file.
I can't uninstall or delete this mod in AdminCP - there is no VbDolwnloads link in products-mods section.

 

[Fillip H.]

Can you try going into phpMyAdmin and manually deleting all tables beginning with dbtech_downloads_ then try again?

 

[Gecuba]

I deleted just the 'screenshot' string in one of the tables and reinstalled. But that's the quite unsmooth process of reinstallation...

Today I bought the pro version, installed it on test forum and noticed else one problem - posted here

 

[Fillip H.]

Installation issues will be fixed in v1.4.0 (currently in development), and the topic you posted in has a workaround in the meanwhile