Gossamer Forum
Home : Products : Links 2.0 : Discussions :

Missing LinkSQL_User and ClickTrack table

Quote Reply
Missing LinkSQL_User and ClickTrack table
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')

Subject Author Views Date
Thread Missing LinkSQL_User and ClickTrack table kohoy 3271 Jul 25, 2006, 8:27 PM
Thread Re: [kohoy] Missing LinkSQL_User and ClickTrack table
fuzzy logic 3247 Jul 25, 2006, 8:51 PM
Thread Re: [fuzzy logic] Missing LinkSQL_User and ClickTrack table
kohoy 3237 Jul 25, 2006, 8:54 PM
Thread Re: [kohoy] Missing LinkSQL_User and ClickTrack table
fuzzy logic 3241 Jul 25, 2006, 9:56 PM
Post Re: [fuzzy logic] Missing LinkSQL_User and ClickTrack table
kohoy 3235 Jul 25, 2006, 10:13 PM