PDA

View Full Version : SQL Bug - Installer


mr.gamesbay
February 5th, 2005, 12:24 PM
I can post this Thread in the Bugs Forum so i post it here.

I buy the vBadvanced Gallery, 20 minutes ago.
I try to run the installer (first time) and i have this error

Datenbankfehler in vBulletin 3.0.5:

Ungueltige SQL-Abfrage: CREATE TABLE adv_gallery_images (
imageid int(10) NOT NULL auto_increment,
title varchar(100) NOT NULL default '',
description text NOT NULL,
keywords varchar(255) NOT NULL default '',
catid smallint(5) unsigned NOT NULL default '0',
dateline int(10) unsigned NOT NULL default '0',
userid int(10) unsigned NOT NULL default '0',
username varchar(50) NOT NULL default '',
extension tinytext NOT NULL,
filename varchar(100) NOT NULL default '',
filesize int(10) unsigned NOT NULL default '0',
width smallint(5) unsigned NOT NULL default '0',
height smallint(5) unsigned NOT NULL default '0',
thumbname varchar(100) NOT NULL default '',
originalname varchar(255) NOT NULL default '',
originalfilesize int(10) unsigned NOT NULL default '0',
originalwidth smallint(5) NOT NULL default '0',
originalheight smallint(5) NOT NULL default '0',
views int(10) unsigned NOT NULL default '0',
posts int(10) unsigned NOT NULL default '0',
valid smallint(3) unsigned NOT NULL default '0',
open smallint(3) unsigned NOT NULL default '0',
sticky smallint(3) unsigned NOT NULL default '0',
notes varchar(255) NOT NULL default '',
ipaddress varchar(15) NOT NULL default '',
lastpostusername varchar(100) NOT NULL default '',
lastpostuserid int(10) unsigned NOT NULL default '0',
lastpostdateline int(10) unsigned NOT NULL default '0',
votenum smallint(5) unsigned NOT NULL default '0',
votetotal smallint(5) unsigned NOT NULL default '0',
PRIMARY KEY (imageid),
KEY userid (userid),
KEY cat (catid),
KEY userid (userid),
FULLTEXT KEY title (title),
FULLTEXT KEY description (description),
FULLTEXT KEY keywords (keywords)
) TYPE=MyISAM
mysql error: Duplicate key name 'userid'

mysql error number: 1061

Zachery
February 5th, 2005, 12:26 PM
Looks like a bug in the installer, but please use the proper support forum for it.