Hi everyone.
I was trying to do a new install of links sql v 2.1.2 and everything worked out great untill I got to the part in the setup where the tables had to be created. I encountered the following error:
Results: Creating Users table ... ok!
Creating Links table ... failed (Failed to execute query: '
CREATE TABLE lsql_Links (
ID INT unsigned NOT NULL AUTO_INCREMENT,
Title CHAR(100) NOT NULL,
URL CHAR(255) NOT NULL DEFAULT 'http://',
LinkOwner CHAR(50) NOT NULL DEFAULT 'admin',
Add_Date DATE NOT NULL,
Mod_Date DATE NOT NULL,
Description TEXT,
Contact_Name CHAR(255),
Contact_Email CHAR(255),
Hits INT DEFAULT '0' NOT NULL,
isNew ENUM('No','Yes') DEFAULT 'No' NOT NULL,
isChanged ENUM('No','Yes') DEFAULT 'No' NOT NULL,
isPopular ENUM('No','Yes') DEFAULT 'No' NOT NULL,
isValidated ENUM('No','Yes') DEFAULT 'Yes' NOT NULL,
Rating FLOAT(12,2) DEFAULT '0' NOT NULL,
Votes SMALLINT unsigned DEFAULT '0' NOT NULL,
Status SMALLINT DEFAULT '0' NOT NULL,
Date_Checked DATETIME DEFAULT '',
Timestmp TIMESTAMP,
INDEX stndx (Status),
INDEX valndx (isValidated),
INDEX userndx (LinkOwner),
INDEX popndx (isPopular),
INDEX newndx (isNew),
INDEX urlndx (URL),
PRIMARY KEY (ID)
)
' Reason: Invalid default value for 'Date_Checked')
Creating Changes table ... ok!
Creating Category table ... failed (Failed to execute query: '
CREATE TABLE lsql_Category (
ID INT unsigned NOT NULL AUTO_INCREMENT,
Name CHAR(255) NOT NULL,
FatherID INT unsigned DEFAULT '0' NOT NULL,
Full_Name CHAR(255) NOT NULL,
Description TEXT,
Meta_Description TEXT,
Meta_Keywords TEXT,
Header TEXT,
Footer TEXT,
Category_Template CHAR(20),
Number_of_Links INT DEFAULT '0' NOT NULL,
Has_New_Links ENUM('No','Yes') DEFAULT 'No' NOT NULL,
Has_Changed_Links ENUM('No','Yes') DEFAULT 'No' NOT NULL,
Newest_Link DATE DEFAULT '',
Timestmp TIMESTAMP,
INDEX namndx (Full_Name),
INDEX fthrindex (FatherID),
INDEX catndx (Name),
PRIMARY KEY (ID)
)
' Reason: Invalid default value for 'Newest_Link')
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: Duplicate column name 'LinkID')
I tried creating a new database and user and install to that one, but it doesn't work either...
One thing to be specified is that my sql server is on a different box so I connect using the hostname rather then localhost, but I don't belive that this affects the matter in question.
Can anyone help?
Thanks
I was trying to do a new install of links sql v 2.1.2 and everything worked out great untill I got to the part in the setup where the tables had to be created. I encountered the following error:
Code:
SQL Server Settings Results: Creating Users table ... ok!
Creating Links table ... failed (Failed to execute query: '
CREATE TABLE lsql_Links (
ID INT unsigned NOT NULL AUTO_INCREMENT,
Title CHAR(100) NOT NULL,
URL CHAR(255) NOT NULL DEFAULT 'http://',
LinkOwner CHAR(50) NOT NULL DEFAULT 'admin',
Add_Date DATE NOT NULL,
Mod_Date DATE NOT NULL,
Description TEXT,
Contact_Name CHAR(255),
Contact_Email CHAR(255),
Hits INT DEFAULT '0' NOT NULL,
isNew ENUM('No','Yes') DEFAULT 'No' NOT NULL,
isChanged ENUM('No','Yes') DEFAULT 'No' NOT NULL,
isPopular ENUM('No','Yes') DEFAULT 'No' NOT NULL,
isValidated ENUM('No','Yes') DEFAULT 'Yes' NOT NULL,
Rating FLOAT(12,2) DEFAULT '0' NOT NULL,
Votes SMALLINT unsigned DEFAULT '0' NOT NULL,
Status SMALLINT DEFAULT '0' NOT NULL,
Date_Checked DATETIME DEFAULT '',
Timestmp TIMESTAMP,
INDEX stndx (Status),
INDEX valndx (isValidated),
INDEX userndx (LinkOwner),
INDEX popndx (isPopular),
INDEX newndx (isNew),
INDEX urlndx (URL),
PRIMARY KEY (ID)
)
' Reason: Invalid default value for 'Date_Checked')
Creating Changes table ... ok!
Creating Category table ... failed (Failed to execute query: '
CREATE TABLE lsql_Category (
ID INT unsigned NOT NULL AUTO_INCREMENT,
Name CHAR(255) NOT NULL,
FatherID INT unsigned DEFAULT '0' NOT NULL,
Full_Name CHAR(255) NOT NULL,
Description TEXT,
Meta_Description TEXT,
Meta_Keywords TEXT,
Header TEXT,
Footer TEXT,
Category_Template CHAR(20),
Number_of_Links INT DEFAULT '0' NOT NULL,
Has_New_Links ENUM('No','Yes') DEFAULT 'No' NOT NULL,
Has_Changed_Links ENUM('No','Yes') DEFAULT 'No' NOT NULL,
Newest_Link DATE DEFAULT '',
Timestmp TIMESTAMP,
INDEX namndx (Full_Name),
INDEX fthrindex (FatherID),
INDEX catndx (Name),
PRIMARY KEY (ID)
)
' Reason: Invalid default value for 'Newest_Link')
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: Duplicate column name 'LinkID')
I tried creating a new database and user and install to that one, but it doesn't work either...
One thing to be specified is that my sql server is on a different box so I connect using the hostname rather then localhost, but I don't belive that this affects the matter in question.
Can anyone help?
Thanks
Help! Creating Links table ... failed