Drupal 5.19 update to Drupal 6.13 removed term_node s above tid 39

I tried to update it again from Drupal 5.19 to Drupal 6.13 with no Drupal core modules disabled

I got this error message in the log:
Failed: ALTER TABLE {term_node} ADD PRIMARY KEY (tid, vid)

But vid is added to the database and again highest tid is still 39 :/

The vocabulary is still available with all the taxonomy(ies) still in the database but nodes are connected to the original taxonomy in Drupal 5.19.

vocab is
/admin/content/taxonomy/edit/vocabulary/1

After trying to add the missing via datamanipulation I think it's somehow related to nodes with no taxonomy 'tid' but I can figure out why :/

I changed vid to correspond to the nid, but what happens is that Drupal counts and then shows the counted nid instead of the nid associated tid.

Somehow Drupal counts to nid=7700 and shows nid=7700 tid, but the actual is nid=7754

The result is that nodes that have tid in Drupal 5.19 does not have it in Drupal 6.13

I have disabled cache on the update site btw.

How to solve this term_node update problem:

Drop term_node table

Import the old term_node table from Drupal 5.x

Then manually add

vid after nid in phpmyadmin

with the following

field name
vid

datatype
INT

length
10

Collation
choose nothing

Attributes
unsigned

Null value
not null

standard value
don't write anything yet

Extra
choose nothing

Choose index in 4th button from the right of the comment field

Don't write any comment

and hit execute

I chose no standard value when setting up just in case.

The problem connected to this is that there are deleted nodes in term_node from Drupal 5.x

Find all empty nodes
SELECT DISTINCT nid FROM `term_node` t WHERE (SELECT count( * ) FROM node n WHERE t.nid = n.nid) = 0

Via this comment:
http://drupal.org/node/345080#comment-1214589

I could not delete these nodes in phpmyadmin because of an error message 1054.

Export the found empty nodes in term_nodes to sql and download them.

Enter a text editor and change all found nodes by search and replacing

(
with
DELETE FROM `term_node` WHERE `nid` =

and
) with
;

This is the result from empty nodes search:

(463),
(464),
(1935),
(1936),
(1937),
(1938),
etc.

to this end result:

DELETE FROM `term_node` WHERE `nid` = 463;
DELETE FROM `term_node` WHERE `nid` = 1935;
DELETE FROM `term_node` WHERE `nid` = 1936;
DELETE FROM `term_node` WHERE `nid` = 1937;
DELETE FROM `term_node` WHERE `nid` = 1938;
etc.

Copy paste into phpmyadmin and they are finally gone !

Then use this mysql to update vid column:

UPDATE term_node t SET vid = (SELECT vid FROM node n WHERE t.nid = n.nid)

Via this comment:
http://drupal.org/node/345080#comment-1205079

And you almost there....

change vid and enter 0 as standard value

Then delete the old Drupal 5.x primary key for term_node
ALTER TABLE `term_node` DROP PRIMARY KEY

Then do this mysql command:

ALTER TABLE term_node ADD PRIMARY KEY (tid, vid)

And you all done :/

And now somebody add this to the update process from Drupal 5.19 to Drupal 6.13 !

Please :/

Thanks, you guys.

Aaaand it's still a bug !

I can confirm that this problem still exist in Drupal 6.20 :/