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')

Quote Reply
Re: [kohoy] Missing LinkSQL_User and ClickTrack table In reply to
This for is for the old flatfile Links 2.0... You'll have better luck getting an answer by asking in the appropriate forum.

Philip
------------------
Limecat is not pleased.
Quote Reply
Re: [fuzzy logic] Missing LinkSQL_User and ClickTrack table In reply to
Isn't this the Link 2.0 forum?
in the admin panel it shows... Version: 2.1.2
Whish forum should I go? Thx

Last edited by:

kohoy: Jul 25, 2006, 8:57 PM
Quote Reply
Re: [kohoy] Missing LinkSQL_User and ClickTrack table In reply to
this forum is for Links 2.0, an entirely different program than Links SQL 2.0. All SQL versions fall under 'Gossamer Links'. I can see how it's a little confusing. When Links SQL v3 came out, it was renamed 'Gossamer Links', but the name change isn't reflected in the forum.

http://www.gossamer-threads.com/perl/gforum/gforum.cgi?category=5;

Philip
------------------
Limecat is not pleased.
Quote Reply
Re: [fuzzy logic] Missing LinkSQL_User and ClickTrack table In reply to
Thanks man~ I'll ask it again there.