Gossamer Forum
Home : Products : Gossamer Links : Discussions :

spider 2.1 install problems

Quote Reply
spider 2.1 install problems
Maybe I posted this message in the wrong forum first,
since I got no replies.. Anyway, I got the following error message when installing spider 2.1 to Links SQL 2.04:

Unable to install plugin: 'Could not create table Links because (Failed to execute query: ' CREATE TABLE Links_Spider_Links ( ID INT unsigned NOT NULL AUTO_INCREMENT, Host INT unsigned NOT NULL, URL CHAR(255) NOT NULL, Data TEXT, Digest CHAR(255) NOT NULL, Title CHAR(255), Headers TEXT, Status INT unsigned NOT NULL, Description CHAR(255), Keywords CHAR(255), Last_Update INT, Last_Visited INT, INDEX urlndx (URL), PRIMARY KEY (ID) ) ' Reason: parse error near 'Data TEXT, Digest CHAR(255) NOT NULL, Title CHAR(255), Headers TE' at line 6) Could not create table Validate because (Failed to execute query: ' CREATE TABLE Links_Spider_Validate ( ID INT unsigned NOT NULL AUTO_INCREMENT, Host INT unsigned NOT NULL, URL CHAR(255) NOT NULL, Data TEXT, Digest CHAR(255) NOT NULL, Title CHAR(255), Headers TEXT, Description CHAR(255), Keywords CHAR(255), Last_Update INT, Last_Visited INT, INDEX urlndx (URL), PRIMARY KEY (ID) ) ' Reason: parse error near 'Data TEXT, Digest CHAR(255) NOT NULL, Title CHAR(255), Headers TE' at line 6) '

Aren't word such as "Data" reserved?
Is this where the problem lies?

Any ideas how to fix this?

Thanks for help in advance.


Subject Author Views Date
Post spider 2.1 install problems flaree 1000 Jul 8, 2001, 4:27 PM