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