Gossamer Forum
Home : Products : Gossamer Links : Version 1.x :

Custom Import Problems

Quote Reply
Custom Import Problems
Hello everyone,

I've converted Import.pl and setup.cgi to import the data from my JokeSearch which has an extra field called Joke. I added it to SQL.mysql and etc. and here is the message that setup.cgi gives me when I try to create tables:

Creating table Links ... failed (DBSQL (8288): Fatal Error: Unable to execute query:
CREATE TABLE Links (
ID INT UNSIGNED AUTO_INCREMENT PRIMARY KEY,
Title CHAR(100) NOT NULL,
URL CHAR(150),
Add_Date DATE NOT NULL,
Mod_Date DATE NOT NULL,
CategoryID INT UNSIGNED NOT NULL,
Joke TEXT NOT NULL,
Description TEXT,
Contact_Name CHAR(50),
Contact_Email CHAR(50),
Hits SMALLINT UNSIGNED NOT NULL DEFAULT 0,
isNew ENUM ('Yes', 'No') NOT NULL DEFAULT 'No',
isChanged ENUM ('Yes', 'No') NOT NULL DEFAULT 'No',
isPopular ENUM ('Yes', 'No') NOT NULL DEFAULT 'No',
Rating DECIMAL (12, 2) NOT NULL DEFAULT 0,
Votes SMALLINT UNSIGNED NOT NULL DEFAULT 0,
ReceiveMail ENUM ('Yes', 'No') NOT NULL DEFAULT 'Yes',
Status SMALLINT NOT NULL DEFAULT 0,
Date_Checked DATETIME DEFAULT "0000-00-00 00:00:00",

INDEX urlndx (Joke),
INDEX catndx (CategoryID),
INDEX stndx (Status)
)
. Reason: BLOB column 'Joke' can't be used in key specification at setup.cgi line 289
) Loading def file from SQL ... failed (DBSQL (8288): Fatal Error: Unable to execute query: DESCRIBE Links. Reason: Table 'jokesearch.Links' doesn't exist at setup.cgi line 291
)
Creating Search Index ... ok!
Saving def file ... ok!


I don't understand at all what that error means. Help? Thanks!

Daniel
-http://www.christian-search.net
-http://www.csnhost.com
Subject Author Views Date
Thread Custom Import Problems OneDanShow 1851 Nov 29, 2000, 8:23 PM
Post Re: Custom Import Problems
pugdog 1766 Nov 30, 2000, 5:31 PM