PhotoPost Photo Gallery Sales PhotoPost Sales Toll Free Phone Number
Mon-Fri 9am-4pm EST
  PhotoPost Photo Sharing Photo Gallery    Visualize community tm
| | | | | | | | |

Go Back   PhotoPost Community > General Forums > Before You Buy

Before You Buy Have questions about PhotoPost, ReviewPost and/or PhotoPost Classifieds before you buy?

Closed Thread
 
Thread Tools Rate Thread Display Modes
Old February 5th, 2005, 12:24 PM   #1
mr.gamesbay
Member
Verified Customer
 
Join Date: Sep 2004
Posts: 35
Exclamation SQL Bug - Installer

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

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
mr.gamesbay is offline  
Old February 5th, 2005, 12:26 PM   #2
Zachery
Ultimate Member
 
Join Date: Jan 2004
Posts: 2,196
Re: SQL Bug - Installer

Looks like a bug in the installer, but please use the proper support forum for it.
Zachery is offline  
Closed Thread


Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
 
Thread Tools
Display Modes Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off

Forum Jump


All times are GMT -5. The time now is 10:08 PM.

Powered by vBulletin® Version 3.8.1
Copyright ©2000 - 2014, Jelsoft Enterprises Ltd.