hi
i have Problem when i up the products for vBulletin Project Tools
PHP Code:
Database error in vBulletin 3.6.7:
Invalid SQL:
CREATE TABLE pt_issue (
issueid INT UNSIGNED AUTO_INCREMENT NOT NULL,
projectid INT UNSIGNED NOT NULL DEFAULT 0,
issuestatusid INT UNSIGNED NOT NULL DEFAULT 0,
issuetypeid VARCHAR(25) NOT NULL DEFAULT '',
title VARCHAR(250) NOT NULL DEFAULT '',
summary VARCHAR(250) NOT NULL DEFAULT '',
submituserid INT UNSIGNED NOT NULL DEFAULT 0,
submitusername VARCHAR(100) NOT NULL DEFAULT '',
submitdate INT UNSIGNED NOT NULL DEFAULT 0,
appliesversionid INT UNSIGNED NOT NULL DEFAULT 0,
isaddressed SMALLINT UNSIGNED NOT NULL DEFAULT 0,
addressedversionid INT UNSIGNED NOT NULL DEFAULT 0,
priority SMALLINT UNSIGNED NOT NULL DEFAULT 1,
visible ENUM('moderation', 'visible', 'private', 'deleted') NOT NULL DEFAULT 'visible',
lastpost INT UNSIGNED NOT NULL DEFAULT 0,
lastactivity INT UNSIGNED NOT NULL DEFAULT 0,
lastpostuserid INT UNSIGNED NOT NULL DEFAULT 0,
lastpostusername VARCHAR(100) NOT NULL DEFAULT '',
firstnoteid INT UNSIGNED NOT NULL DEFAULT 0,
lastnoteid INT UNSIGNED NOT NULL DEFAULT 0,
attachcount INT UNSIGNED NOT NULL DEFAULT 0,
pendingpetitions INT UNSIGNED NOT NULL DEFAULT 0,
replycount INT UNSIGNED NOT NULL DEFAULT 0,
votepositive INT UNSIGNED NOT NULL DEFAULT 0,
votenegative INT UNSIGNED NOT NULL DEFAULT 0,
projectcategoryid INT UNSIGNED NOT NULL DEFAULT 0,
assignedusers INT UNSIGNED NOT NULL DEFAULT 0,
PRIMARY KEY (issueid),
KEY finder (projectid, visible, issuetypeid, lastpost),
KEY issuestatusid (issuestatusid),
FULLTEXT KEY textsearch (title, summary)
) ENGINE=MYISAM;
MySQL Error : Table 'pt_issue' already exists
Error Number : 1050
Date : Tuesday, July 3rd 2007 @ 06:12:24 AM
Script : http://www.xxxx.com/vb/alnaqbi/plugin.php?do=productimport
Referrer : http://www.xxxx.com/vb/alnaqbi/plugin.php?do=productadd
IP Address : 77.99.225.250
Username :
Classname : vb_database
plz help me