1. Back up J1.5 source and J1.7 destination. Use Akeeba Backup.
2. Ensure J1.5 and J1.7 table prefixes match. Use Admin Tools.
3. Log into phpMyAdmin
4. Export J1.5 k2 tables only
5. Import k2 tables .sql into J1.7 database, leave k2 tables in MyISAM format

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

8. All of my k2 items had access set to 0 so I made them all public again:
UPDATE `PREFIX_k2_items` SET access = 1 WHERE access = 0

9. Copy k2 media items from J1.5 and paste into J1.7 .../media/k2/

B)

Hi Steve,

Seems my last reply has gone, weird

Ok not had a chance to try this as on another project first, but its on the list!

2 quick points

1 on step 4 Export J1.5 k2 tables only , this includes categories as well? There are no issues with transferring from 1.5 to 1.7 with categories?

2 Have you tested this method with a SEO component like Shf404 in 1.7?

Thanks Paul

Steve Adams wrote: 1. Back up J1.5 source and J1.7 destination. Use Akeeba Backup.
2. Ensure J1.5 and J1.7 table prefixes match. Use Admin Tools.
3. Log into phpMyAdmin
4. Export J1.5 k2 tables only
5. Import k2 tables .sql into J1.7 database, leave k2 tables in MyISAM format

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

8. All of my k2 items had access set to 0 so I made them all public again:
UPDATE `PREFIX_k2_items` SET access = 1 WHERE access = 0

9. Copy k2 media items from J1.5 and paste into J1.7 .../media/k2/

B)

I did the above migrated from J1.5 to J1.7 using K2.5.4, all articles\categories show up in the back end but I'm unable to get them to display on the site... Checked and all the articles are published, I know I must just be missing something stupid.

This realy dont work. what we are missing here.

Any solution would be nice.

I did use Jupgrade but it's not working ider. Same isue when tring to view article from menu item.

Thank you.

Ok guys naw I know that you need to do all of the above and reapeat last step for categories to.
Then it's working.

UPDATE `j17_k2_categories` SET access = 1 WHERE access = 0

Hi All,

Just starting to try this procedure on one of my sites, having some issues as I have not altered the database like this before learning curve.

Ok so I have imported all the exported sql into the k2 tables and I am stuck on number 6

I am trying to execute a query is that correct? i use the set up and it creates the below query

SELECT `jos_k2_items`.`created_by`
FROM jos_k2_items
WHERE (
`jos_k2_items`.`created_by`
SET created_by =NEWIDNUMBER WHERE created_by =OLDIDNUMBER
)

When I submit i get the following error message:
#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'SET created_by = 42 WHERE created_by = 64)' at line 3



When I try to run this query (i have added the prefix and the number created by id of old and new.
I have to use the UPDATE `PREFIX_k2_items` SET created_by = NEW_ID WHERE created_by = OLD_ID

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


Not even got to step 7 yet lol
Paul

Steve's methods work for me.
Using this there is may be no reason to use jupgrade, just get a clean install of 1.7 and move everything with phpmyadmin.
Even with jupgrade, it seems to me that templates have to be redone anyhow

Ok, worked it out, was in the wrong part of the database in the php admin,

Thanks All for the input, will crack on now

Paul

Just an update

I have started to transfer over my site to check this option out.
Testing the new j17 site, all looking good until i turn on the Sh404sef and the URLS are not found on any k2 item, or items in categories do not show up,, hmm trying to work out why

I am documenting this so others can perhaps read a thing or two if they are trying

Paul

I remember that I had some user right problems on some pages of the site and I repeat the steps 6 and 7 and change back from user42 to user 62 and from there on it is OK.

Maybe you have same problem.