Gossamer Forum
Home : Products : Gossamer Links : Discussions :

Creating ClickTrack table ... failed

Quote Reply
Creating ClickTrack table ... failed
Everytime I try to run the installation on the new server I get:

--

Creating Users table ... ok!
Creating Links table ... ok!
Creating Changes table ... ok!
Creating Category table ... ok!
Creating Reviews table ... ok!
Creating CatLinks table ... ok!
Creating CatRelations table ... ok!
Creating Editors table ... ok!
Creating Verify table ... ok!
Creating Sessions table ... ok
Creating EmailTemplates table ... ok!
Creating EmailMailings table ... ok!
Creating MailingIndex table ... ok!
Creating MailingList table ... ok!
Creating MailingListIndex table ... ok!
Creating ClickTrack table ... failed (Failed to execute query: '
CREATE TABLE lsql_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: Can't create table './easyebook/lsql_ClickTrack.frm' (errno: 126))

--

It always stops at the same place. Any ideas why or how to fix it?

--

Kriis
Quote Reply
Re: [kriis] Creating ClickTrack table ... failed In reply to
Seems like your mysql is not correctly setup. It looks like your directory permissions are incorrect leading to mysqld not being able to create the new table.

Adrian
Quote Reply
Re: [kriis] Creating ClickTrack table ... failed In reply to
PRIMARY KEY (LinkID,IP,ClickType,ReviewID,LinkID,IP,ClickType,ReviewID,LinkID,IP,ClickType,ReviewID,LinkID,IP,ClickType,ReviewID)
)

This is a but in Links, in how the Indexes are exported. I forget why it happens. Remove the part in blue, then paste the code into the SQL Monitor, and the table will (most likely) be created.
You need to paste it into the MySQLMan -- as the Admin SQL Monitor sometimes misbehaves.



PUGDOG´┐Ż Enterprises, Inc.

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