Gossamer Forum
Home : Products : Gossamer Links : Discussions :

Import Links2.0 Error

Quote Reply
Import Links2.0 Error
Hello, I receive this error when I try to import my links2.0 database. The subscribers are imported but not in the right areas. My databases are comma delimited would that be the problem?
Thanks
Shane

Importing Categories ...
Import error: CRITICAL ERROR OCCURED: Unable to insert category `Stock' (SQL query: `INSERT INTO Category (ID, Name, FatherID, Full_Name, Description, Meta_Description, Meta_Keywords, Header, Footer, Meta Name) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?)'): You have an error in your SQL syntax near 'Name) VALUES (1, 'Stock', 0, 'Stock', '', 'Finance search site ranking links by ' at line 1 at /cgi-bin/links/admin/Links/Import/L2S2.pm line 322

Quote Reply
Re: Import Links2.0 Error In reply to
That could be the problem. But I think it's choking on the actual query.

'Name) VALUES (1, 'Stock', 0, 'Stock', '', 'Finance search site ranking links by '

You have "Stock" listed twice. Also, it's hitting the problem in your query right before "Name".

`INSERT INTO Category (ID, Name, FatherID, Full_Name, Description, Meta_Description, Meta_Keywords, Header, Footer, Meta Name) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?)'


There is the problem! --> "Meta Name" you probably mean "Meta_Name"


PUGDOGŪ
PUGDOGŪ Enterprises, Inc.
FAQ: http://pugdog.com/FAQ