Gossamer Forum
Home : Products : Gossamer Links : Discussions :

Can't import from Links 2.x format - "Unknown column 'Rating' in 'field list'"

Quote Reply
Can't import from Links 2.x format - "Unknown column 'Rating' in 'field list'"
This has become intractable ...
I'm trying to import Links 2.0 tables (links.db and categories.db).

The categories go in OK, no problem.

The links refuse. The reason seems to be that I don't have columns
for Rating or Votes. They are features which not relevant to our project, so I removed them from the default links table.

Here is a line from the error message
Code:
Import error: WARNING: Unable to insert link `owner'
(SQL query: `INSERT INTO art_Links (ID, LinkOwner, isValidated, Add_Date, Mod_Date,
Contact_Name, Contact_Email, Title, URL, Description, Hits, isNew, isPopular,
Rating, Votes, <My_New_Columns>)
VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)'):
Unknown column 'Rating' in 'field list'

I get a line like that for every link!

<My_New_Columns> represents the whole set of non-standard columns in the Links 2.0 file.

It seems to be demanding Rating and Votes even though they are
not in the Links SQL table, and they are not defined in the table to
be imported.

Is this a bug? Or am I doing something wrong?

Are these columns hard-wired?
If they are, how can I remove them?

Last edited by:

YoYoYoYo: Sep 21, 2001, 11:17 AM
Subject Author Views Date
Thread Can't import from Links 2.x format - "Unknown column 'Rating' in 'field list'" YoYoYoYo 2317 Sep 21, 2001, 11:14 AM
Thread Re: [YoYoYoYo] Can't import from Links 2.x format - "Unknown column 'Rating' in 'field list'"
Paul 2198 Sep 21, 2001, 11:57 AM
Thread Re: [RedRum] Can't import from Links 2.x format - "Unknown column 'Rating' in 'field list'"
YoYoYoYo 2188 Sep 21, 2001, 10:26 PM
Post Re: [YoYoYoYo] Can't import from Links 2.x format - "Unknown column 'Rating' in 'field list'"
pugdog 2180 Sep 22, 2001, 9:18 AM
Thread Re: [YoYoYoYo] Can't import from Links 2.x format - "Unknown column 'Rating' in 'field list'"
Alex 2168 Sep 22, 2001, 1:05 PM
Post Re: [Alex] Can't import from Links 2.x format - "Unknown column 'Rating' in 'field list'"
YoYoYoYo 2178 Sep 23, 2001, 11:50 AM