I just realized that I lost 2 tables(User and ClickTrack) when I try to build all from admin panel...
so I tried to re-install the table from setup but the following error occured... can anyone help?
Creating Users table ... failed (Failed to execute query: '
CREATE TABLE linkSQL_Users (
Username CHAR(50) NOT NULL,
Password CHAR(25) BINARY NOT NULL,
Email CHAR(75) NOT NULL,
Name CHAR(75),
Validation CHAR(20),
Status ENUM('Not Validated','Registered','Administrator') DEFAULT 'Registered' NOT NULL,
ReceiveMail ENUM('No','Yes') DEFAULT 'Yes' NOT NULL,
Newsletter ENUM('No','Yes') DEFAULT 'Yes' NOT NULL,
INDEX emailndx (Email),
UNIQUE emailndx (Email),
PRIMARY KEY (Username)
)
' Reason: Duplicate key name 'emailndx')
Creating Links table ... failed (table already exists)
Creating Changes table ... failed (table already exists)
Creating Category table ... failed (table already exists)
Creating Reviews table ... failed (table already exists)
Creating CatLinks table ... failed (table already exists)
Creating CatRelations table ... failed (table already exists)
Creating Editors table ... failed (table already exists)
Creating Verify table ... failed (table already exists)
Creating Sessions table ... failed (table already exists)
Creating EmailTemplates table ... failed (table already exists)
Creating EmailMailings table ... failed (table already exists)
Creating MailingIndex table ... failed (table already exists)
Creating MailingList table ... failed (table already exists)
Creating MailingListIndex table ... failed (table already exists)
Creating ClickTrack table ... failed (Failed to execute query: '
CREATE TABLE linkSQL_ClickTrack (
LinkID INT NOT NULL,
IP CHAR(25) NOT NULL,
ClickType ENUM('Rate','Hits','Review') NOT NULL,
ReviewID INT DEFAULT '0' NOT NULL,
Created TIMESTAMP NOT NULL,
INDEX cndx (Created),
PRIMARY KEY (LinkID,IP,ClickType,ReviewID,LinkID,IP,ClickType,ReviewID,LinkID,IP,ClickType,ReviewID,LinkID,IP,ClickType,ReviewID)
)
' Reason: Duplicate column name 'LinkID')
so I tried to re-install the table from setup but the following error occured... can anyone help?
Creating Users table ... failed (Failed to execute query: '
CREATE TABLE linkSQL_Users (
Username CHAR(50) NOT NULL,
Password CHAR(25) BINARY NOT NULL,
Email CHAR(75) NOT NULL,
Name CHAR(75),
Validation CHAR(20),
Status ENUM('Not Validated','Registered','Administrator') DEFAULT 'Registered' NOT NULL,
ReceiveMail ENUM('No','Yes') DEFAULT 'Yes' NOT NULL,
Newsletter ENUM('No','Yes') DEFAULT 'Yes' NOT NULL,
INDEX emailndx (Email),
UNIQUE emailndx (Email),
PRIMARY KEY (Username)
)
' Reason: Duplicate key name 'emailndx')
Creating Links table ... failed (table already exists)
Creating Changes table ... failed (table already exists)
Creating Category table ... failed (table already exists)
Creating Reviews table ... failed (table already exists)
Creating CatLinks table ... failed (table already exists)
Creating CatRelations table ... failed (table already exists)
Creating Editors table ... failed (table already exists)
Creating Verify table ... failed (table already exists)
Creating Sessions table ... failed (table already exists)
Creating EmailTemplates table ... failed (table already exists)
Creating EmailMailings table ... failed (table already exists)
Creating MailingIndex table ... failed (table already exists)
Creating MailingList table ... failed (table already exists)
Creating MailingListIndex table ... failed (table already exists)
Creating ClickTrack table ... failed (Failed to execute query: '
CREATE TABLE linkSQL_ClickTrack (
LinkID INT NOT NULL,
IP CHAR(25) NOT NULL,
ClickType ENUM('Rate','Hits','Review') NOT NULL,
ReviewID INT DEFAULT '0' NOT NULL,
Created TIMESTAMP NOT NULL,
INDEX cndx (Created),
PRIMARY KEY (LinkID,IP,ClickType,ReviewID,LinkID,IP,ClickType,ReviewID,LinkID,IP,ClickType,ReviewID,LinkID,IP,ClickType,ReviewID)
)
' Reason: Duplicate column name 'LinkID')
Missing LinkSQL_User and ClickTrack table