Import error: WARNING: Unable to insert validated link `Jessie' (SQL query: `INSERT INTO lsql_Links (ID, LinkOwner, isValidated, Contact_Name, Contact_Email, Title, URL, Add_Date, Mod_Date, Description, Hits, isNew, isChanged, isPopular, Rating, Votes, Status, Date_Checked, Region, Password, Package, Priority, Link_Type) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)'): Duplicate entry '3360' for key 1


>>>>>>>>

Can anyone tell me what the error above means? I have looked in the backup file from the database and there doesn't seem to be a duplicate listing for the link.

I am importing data from LinkSQL 1.13 into LinkSQL 2.2.0.

Thanks

Regan.

Hi.

>>>Duplicate entry '3360' <<<

Looks like you already have a link with the ID 3360?

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 Andy

That's what I thought it was saying... but I'm buggered if I can find a duplicate link with id 3360 - only one shows up even when I query mysql directly.

What I'm doing is...

select * from Links where ID = '3360';

Which only shows one result.

Should I be doing something else?

Regan.

What about "Categories" and "CatLinks"?

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 Andy

Figured out this problem is being caused by the other probelm I've just mentioned in this post - click here

There is a clash of ID's because the script isn't using my original ID numbers even though I'm telling it to.

Regan