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.