Gossamer Forum
Home : Products : Gossamer Links : Discussions :

Getting Errors on Importing from Links2 to LinksSQL

Quote Reply
Getting Errors on Importing from Links2 to LinksSQL
I am getting error from importing my backup db (Links2) to (LinksSQL) ...
I've used this thread to remove ^M but with no success, as I do not see ^M in links.db or validate.db.
I also tried to ftp links.db to my local windows pc, then ftp it back in ascii mode, but the import is still complaining about ^M.
I've maually deleted ^M from categories.db and the file was successfully imported; however, with links.db the error (shown below) is coming up when I attempt to import it, and when I vi the file, I do not see the ^M... any suggestion...
Thanks much...
Mark

Code:


Importing Links ...
Import error: WARNING: Unable to insert link `marry' (SQL query: `INSERT INTO glinks_Links (ID, LinkOwner, isValidated, Add_Date, Mod_Date, Contact_Name, Contact_Email, Title, URL, Description, Hits, isNew, isPopular, Rating, Votes, Country, Graphic, Subscription, District, Gheight, Gwidth, Media Type, Frequency, City, Supports, Comment, Related to Media, Supports_4, Supports_5, Language_1, Language_2, Priority, Language_3) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)'): You have an error in your SQL syntax near 'Type, Frequency, City, Supports, Comment, Related to M' at line 1
Import error: WARNING: Unable to insert link `steve' (SQL query: `INSERT INTO glinks_Links (ID, LinkOwner, isValidated, Add_Date, Mod_Date, Contact_Name, Contact_Email, Title, URL, Description, Hits, isNew, isPopular, Rating, Votes, Country, Graphic, Subscription, District, Gheight, Gwidth, Media Type, Frequency, City, Supports, Comment, Related to Media, Supports_4, Supports_5, Language_1, Language_2, Priority, Language_3) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)'): You have an error in your SQL syntax near 'Type, Frequency, City, Supports, Comment, Related to M' at line 1
Import error: WARNING: Unable to insert link `laura' (SQL query: `INSERT INTO glinks_Links (ID, LinkOwner, isValidated, Add_Date, Mod_Date, Contact_Name, Contact_Email, Title, URL, Description, Hits, isNew, isPopular, Rating, Votes, Country, Graphic, Subscription, District, Gheight, Gwidth, Media Type, Frequency, City, Supports, Comment, Related to Media, Supports_4, Supports_5, Language_1, Language_2, Priority, Language_3) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)'): You have an error in your SQL syntax near 'Type, Frequency, City, Supports, Comment, Related to M' at line 1
Import error: WARNING: Unable to insert link `romio' (SQL query: `INSERT INTO glinks_Links (ID, LinkOwner, isValidated, Add_Date, Mod_Date, Contact_Name, Contact_Email, Title, URL, Description, Hits, isNew, isPopular, Rating, Votes, Country, Graphic, Subscription, District, Gheight, Gwidth, Media Type, Frequency, City, Supports, Comment, Related to Media, Supports_4, Supports_5, Language_1, Language_2, Priority, Language_3) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)'): You have an error in your SQL syntax near 'Type, Frequency, City, Supports, Comment, Related to M' at line 1
Import error: WARNING: Unable to insert link `nancy' (SQL query: `INSERT INTO glinks_Links (ID, LinkOwner, isValidated, Add_Date, Mod_Date, Contact_Name, Contact_Email, Title, URL, Description, Hits, isNew, isPopular, Rating, Votes, Country, Graphic, Subscription, District, Gheight, Gwidth, Media Type, Frequency, City, Supports, Comment, Related to Media, Supports_4, Supports_5, Language_1, Language_2, Priority, Language_3) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)'): You have an error in your SQL syntax near 'Type, Frequency, City, Supports, Comment, Related to M' at line 1
Subject Author Views Date
Thread Getting Errors on Importing from Links2 to LinksSQL Mark2 3736 Jul 10, 2009, 7:54 PM
Thread Re: [Mark2] Getting Errors on Importing from Links2 to LinksSQL
Andy 3674 Jul 10, 2009, 10:45 PM
Thread Re: [Andy] Getting Errors on Importing from Links2 to LinksSQL
Mark2 3560 Aug 23, 2009, 6:49 PM
Post Re: [Mark2] Getting Errors on Importing from Links2 to LinksSQL
Andy 3560 Aug 24, 2009, 12:20 AM