On simple sites without revisions, the revision id (vid) is always equal to the node id (nid). On sites with revisions, this isn't the case. CCK looks up it's node_content_xxxx records based on the 'vid', not the 'nid'.

I have a patch which sets the vid which I'll dig out and update later on (hopefull tomorrow).

CommentFileSizeAuthor
#1 flexiconvert-vid.patch1.1 KBejort

Comments

ejort’s picture

Status: Active » Needs review
StatusFileSize
new1.1 KB

This is the patch, grabs the vid from the node table and inserts into the CCK content table.

starbow’s picture

Status: Needs review » Fixed

Thanks, I have applied this patch

Anonymous’s picture

Status: Fixed » Closed (fixed)
murphyca’s picture

Hello --

I am getting (I believe) this same error:

Duplicate entry '1171' for key 1 query: flexiconvert_form_submit insert into node_content_topics (nid, vid) value ('1171', '1171') in /home/xxxxxx/public_html/upgrade/includes/database.mysql.inc on line 121

flexiconvert displays a blank page after converting. this error message was pulled from the log file. I have the latest flexiconvert 4.7.03.

Is there a way around this error?