Content Import: User warnings duplicate entry
| Project: | Joomla to Drupal |
| Version: | 5.x-2.1 |
| Component: | Code |
| Category: | bug report |
| Priority: | normal |
| Assigned: | Unassigned |
| Status: | active |
Jump to:
Hello,
I am trying the 2.1 version of Joomla to Drupal and am able to import Sections/Categories and Users. However I am unable to import content. I receive the following warning:
• user warning: Duplicate entry '24' for key 2 query: INSERT INTO node (nid,vid,type,title,uid,status, created,changed,comment,promote,moderate,sticky) values (24,24,'story','Opening of the Dolores Huerta Labor Institute Inspires Next Generation','5', '0', '1180999720','1208340637','0','1', '0','0') in /Applications/MAMP/htdocs/drupal57Base/includes/database.mysql.inc on line 172.
PLease note that I originally did not have the story content type, but created it again for this purpose. After the failed import it lists 71 Contents imported but I cannot find them in my DB. Did it import? If so, where?
Any other ideas what I can do to import the content? Help is greatly appreciated.
#1
Please click on this link:
- Update Drupal sequences (use this tool if you receive "Duplicates items" when you create new Drupal Content, Vocabulary or Term)
After that click this link again:
- Import Joomla Contents and Static Contents
#2
Thank you drupal-id,
I set the import feature to replace duplicate entries (caution!) and then re-imported the (+ static) contents. It worked, BUT only when the standard content type story was present!
So it seems that this work without a hitch if the 'story' content type is present. In my previous installation I have replaced 'story' by a custom CCK-induced content type.
Is there a way the user could select into what content type joomla content should be imported to drupal? Does this require a field to field check?
Thanks.
#3
I have a similar but different situation to the above example:
1. I imported around 968 nodes --> as story content from joomla
2. the categories imported first, but did not tag to content
---> when I went to add new category / taxonomy terms, I had the duplicate entry error with sequencing problem
---> so I just deleted and recreated the taxonomy terms
---> that means I will have to retag all the content, but ok (category sequencing problem solved)
3. bigger problem, now with 968 nodes (story) from import, when I go to create a new node:
# user warning: Duplicate entry '2-2' for key 1 query: INSERT INTO node (nid, vid, title, type, uid, status, created, changed, comment, promote, sticky) VALUES (2, 2, 'post test', 'story', 1, 1, 1227252705, 1227252980, 2, 1, 0) in /x/y/z/includes/database.mysql.inc on line 174.
# user warning: Duplicate entry '2' for key 1 query: INSERT INTO node_revisions (nid, vid, title, body, teaser, timestamp, uid, format, log) VALUES (2, 2, 'post test', etc.....
The node does not save, it kicks back what is apparently the original node numbered as "2", tags that with whatever vocab I enter for the new node
---> big problem!!! how to reset the sequence numbering system here?
Note: I don't see any link "Update Drupal sequences"
#4
For reference: I went into phpmyAdmin, edited the sequence table manually:
where node_nid was set to "2", I changed it to "1000"
where node_revisions_vid was set to "2", I changed it to "1000"
seems to have fixed the problem - thanks for the module, very helpful