Gossamer Forum
Quote Reply
Spider 2.1 install bug
Hello, 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
Thread Spider 2.1 install bug flaree 4813 Jul 7, 2001, 8:35 AM
Thread Re: Spider 2.1 install bug
flaree 4693 Jul 9, 2001, 7:54 AM
Thread Re: Spider 2.1 install bug
kitsune 4688 Jul 10, 2001, 12:10 PM
Thread Re: Spider 2.1 install bug
flaree 4643 Jul 10, 2001, 2:07 PM
Thread Re: Spider 2.1 install bug
kitsune 4661 Jul 10, 2001, 2:47 PM
Thread Re: Spider 2.1 install bug
flaree 4639 Jul 10, 2001, 3:19 PM
Thread Re: Spider 2.1 install bug
kitsune 4640 Jul 10, 2001, 3:29 PM
Post Re: Spider 2.1 install bug
flaree 4637 Jul 10, 2001, 3:36 PM