Hi, I thought this deserved a new topic.
I have read full the discussion here
Migrate Instructions Which is Steves instructions on how to manually migrate from J1.5 to J.17 & the instructions are still relevant - So Thanks Steve for putting them up.

I'm testing moving all this over manually and and have it all working fine with no real hiccups after following Steve's Instructions.

I have one question though if anyone can help with Steps 6 & 7

6. Update k2_items created_by ID to new J1.7 Super User ID by running SQL query:
UPDATE `PREFIX_k2_items` SET created_by = NEW_ID WHERE created_by = OLD_ID

7. Update k2_items modified_by ID to new J1.7 Super User ID:
UPDATE `PREFIX_k2_items` SET modified_by = NEW_ID WHERE modified_by = OLD_ID

I'm assuming this is if all the articles where written and modified by the same person?

I have 500 articles written by about 40 Authors and modified by around 10 Admins.

How can I get all the articles/items updated to there existing authors?

I have a new J2.5.8 install with K2.6.1 and not much else.
I know I obviously need to also migrate all the Joomla users over. that's my next test.

Andy

Hi. You need to do mapping of user IDs between the two systems. For example user named "John" may have id 70 on Joomla! 1.5 while after the migration he might get a different one, let's say 500. In this case your query will be :

UPDATE `PREFIX_k2_items` SET created_by = 500 created_by = 70