 | |  | |
February 5th, 2005, 12:36 PM
|
#1 (permalink)
| | Member Verified Customer
Join Date: Sep 2004
Posts: 35
| SQL Bug - Installer I can post this Thread in the Bugs Forum (mr.gamesbay, you do not have permission to access this page.) 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 Quote:
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
| |
| |
February 5th, 2005, 01:14 PM
|
#2 (permalink)
| | Guest | Re: SQL Bug - Installer
Please download the files from here again, upload the new install file, select the option to un-install, and then try reinstalling.
| |
| |
February 5th, 2005, 01:22 PM
|
#3 (permalink)
| | Member Verified Customer
Join Date: Sep 2004
Posts: 35
| Re: SQL Bug - Installer
Thanks, now the installer work |
| |
March 2nd, 2005, 12:41 PM
|
#4 (permalink)
| | Junior Member Verified Customer
Join Date: Jan 2005
Posts: 21
| Re: SQL Bug - Installer
I had the EXACT same trouble, when I looked at the originally downloaded installer file, it was dated from 1601. Wow, you guys must be old. Anyhow, what's that about!?
|
| | |
Currently Active Users Viewing This Thread: 1 (0 members and 1 guests) | | | | Thread Tools | | | | Display Modes | Rate This Thread | Linear Mode | |
Posting Rules
| You may not post new threads You may not post replies You may not post attachments You may not edit your posts HTML code is Off | | | All times are GMT -5. The time now is 11:27 PM. | |