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

This is an old bug, has to do with how the mysql indexes were dumped in older versions. If you had multiple keys, each had it's own line, rather than grouped on one.

The problem is this:

INDEX emailndx (Email),
UNIQUE emailndx (Email),

The index "emailndx" was both an Index and Unique. The old "dump" inserted two lines, which to the importer were excuted separately giving the error of "duplicate key" when really it should have been only "Unique"

Now, if you had (Email, Username, Age) or something, you could have gotten from 3 to 9 entries ;) A really, really wacky bug.

What version of Links are you using? This should have been fixed up awhile ago. I know I talked with alex about it, and haven't hit it in awhile. (meaning years).


PUGDOG� Enterprises, Inc.

The best way to contact me is to NOT use Email.
Please leave a PM here.

My LinkSQL's version is 2.1.2
where can I find patch or fixes?
Thx

Download LinksSQL-2.2.1.tar.gz

It's still in the licensed scripts area.

That should fix most of the problems, I'm sure.


PUGDOG� Enterprises, Inc.

The best way to contact me is to NOT use Email.
Please leave a PM here.