PHP Classes

Duplicate Key on Import

Recommend this page to a friend!

      Target CMS  >  All threads  >  Duplicate Key on Import  >  (Un) Subscribe thread alerts  
Subject:Duplicate Key on Import
Summary:following the install instructions - Import yields error msg
Messages:3
Author:david mcbride
Date:2010-07-26 16:43:17
Update:2010-07-26 17:14:17
 

  1. Duplicate Key on Import   Reply   Report abuse  
Picture of david mcbride david mcbride - 2010-07-26 16:43:17
Error: Duplicate entry '16' for key 1

  2. Re: Duplicate Key on Import   Reply   Report abuse  
Picture of Graham Trott Graham Trott - 2010-07-26 17:14:17 - In reply to message 2 from david mcbride
Hi David

I regret to say I can't replicate the bug. When the system imports its data it creates a new record for each item then changes the unique key to match what was in the import file. If the import data contains a second record with the same key the change will fail because the field is no longer unique. However, this shouldn't happen and there is no second record 16 in the data I have here.

Can you tell me anything about your system that might help me figure what's going on? Such as; the OS and its version number; similarly for PHP and MySQL. The other thing to do is to add diagnostics into the importer to see exactly where it fails; if you are willing to try this out I'll send you the appropriate modified file.

I appreciate any help you are able to give me. If you can spare the time please contact me at [email protected] or through the website.

Graham
Target CMS

  3. Re: Duplicate Key on Import   Reply   Report abuse  
Picture of david mcbride david mcbride - 2010-07-26 16:43:29
Error: Duplicate entry '16' for key 1