Hi,

When I use the import feature in Link SQL 2 to import the links from "Links 2.0" all goes ok, but I receive the following errors!

Importing Subscribe users (newsletter receivers) ...
0 Subscribed users imported.

Importing Categories ...
68 Categories imported.

Importing Category Relations ...
16 Category Relations imported.

Importing Links ...
Import error: WARNING: Unable to insert link `non' (SQL query: `INSERT INTO lsql_Links (ID, LinkOwner, isValidated, Add_Date, Mod_Date, Contact_Name, Contact_Email, Title, URL, Description, Hits, isNew, isPopular, Rating, Votes, Gwidth, Comments, isPick, Graphic, recip, isBest, Gheight, Key, DateAdded) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)'): You have an error in your SQL syntax near 'Key, DateAdded) VALUES (1, 'starbird2k2@yahoo.com', 'Yes', '2002-06-10', '2' at line 1
Import error: WARNING: Unable to insert link `non' (SQL query: `INSERT INTO lsql_Links (ID, LinkOwner, isValidated, Add_Date, Mod_Date, Contact_Name, Contact_Email, Title, URL, Description, Hits, isNew, isPopular, Rating, Votes, Gwidth, Comments, isPick, Graphic, recip, isBest, Gheight, Key, DateAdded) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)'): You have an error in your SQL syntax near 'Key, DateAdded) VALUES (1, 'starbird2k2@yahoo.com', 'Yes', '2002-06-10', '2' at line 1
Import error: WARNING: Unable to insert link `non' (SQL query: `INSERT INTO lsql_Links (ID, LinkOwner, isValidated, Add_Date, Mod_Date, Contact_Name, Contact_Email, Title, URL, Description, Hits, isNew, isPopular, Rating, Votes, Gwidth, Comments, isPick, Graphic, recip, isBest, Gheight, Key, DateAdded) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)'): You have an error in your SQL syntax near 'Key, DateAdded) VALUES (1, 'starbird2k2@yahoo.com', 'Yes', '2002-06-10', '2' at line 1
Import error: WARNING: Unable to insert link `non' (SQL query: `INSERT INTO lsql_Links (ID, LinkOwner, isValidated, Add_Date, Mod_Date, Contact_Name, Contact_Email, Title, URL, Description, Hits, isNew, isPopular, Rating, Votes, Gwidth, Comments, isPick, Graphic, recip, isBest, Gheight, Key, DateAdded) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)'): You have an error in your SQL syntax near 'Key, DateAdded) VALUES (1, 'starbird2k2@yahoo.com', 'Yes', '2002-06-10', '2' at line 1

Please I need help urgently!, how I fix this ????

"Key" is probably a reserved SQL word. You'll need to change the field name.

As Paul said, 'Key' is a reserved word. See http://www.mysql.com/.../Reserved_words.html Try changing it to something like LinkKey or something.

Cheers

Andy (mod)
andy@ultranerds.co.uk

---

Want to give me something back for my help? Please see my Amazon Wish List
GLinks ULTRA Package | GLinks ULTRA Package PRO
Links SQL Plugins | Website Design and SEO | UltraNerds | ULTRAGLobals Plugin | Pre-Made Template Sets | FREE GLinks Plugins!

Hi Guys,

Thanks for the help, I changed the field Key to Kwords and its work nice, but still I have to fix some errors myself for some extra fields! :)