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
(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?
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?