Hi All,

Has anyone got a good solution for Migrating Items from 1.5 to 1.7?
Maybe also the categories as well?

I have almost 2000 items and want to try and salvage them in a move if possible, cannot really manually do it.

Looked on the ext directory and have not had no luck as of yet, any opinion or advice would be appreciated

Paul

Just an update,

I found this old post about it, I tried Jupgrade and cannot get it to fully work just starts to work and does nothing. Seems from what i am reading it does not work for all.

community.getk2.org/forum/topics/how-to-migrate-from-joomla-1-5-k2-2-4-to-joomla-1-7-k2-2-5?commentId=3536014%3AComment%3A418950

Paul

Anyone got any advice or opinions?

There must be so many of us using k2 on 1.5, who want to make the move if not now but in the next 6 months.
Surely there must be some direction on this?

P

Hi Paul,

Did you follow the guide exactly ? Have you looked at the guide here

I'm still using Joomla 1.5 on some of my large sites, those smaller sites was upgraded using the advanced "ctrl + c" and "ctrl + v" method :D

lol yes followed to the dot, the install 1.7 just sticks on that point, the loader bar does nothing but looks like it is installing. Checked online and this is a common error amongst some.

Tried creating a jupgrade folder on the server first, adding a zipped joomla install in the root, still the same sticking point

Would love to do the ol classic paste method, but had 2000 items doh!

P

So the options for J1.7.3 import of J1.5.25 K2 tables:

• Kannan's 'advanced technique'
• freakedout's Content Uploader @ €70 (not)

Does J2XML support K2 item import?

Am I missing a trick?

Thanks

Sometimes mootools needs to be disabled before running jupgrade.
After the upgrade sometimes you need to use phpmyadmin to set the access level on all the k2 items and categories to get them to show

The new version of jUpgrade v1.2.4 is out. Read here . Supports Akeeba Backup now :D

According to them, you must enable 'System - Mootools Upgrade' plugin that is included in Joomla 1.5.19 and greater. You can check out the FAQ

Hi, Steve, Kannan's 'advanced technique'
Not seen this one, have you got a link? will search now

freakedout's Content Uploader @ €70 (not)
Not for 1.7 as says on the site, yes too expensive really

Does J2XML support K2 item import?
This seems to work well for articles 1.5 - 1.7 i tested it, not K2 as of the moment

William, I will try with it turned off, but in the instructions it says turn it on.

After all the previous talk about whether k2 was going forward a while on a personal thought,
If I was Joomlaworks, I would have created a couple of unique modules or plugins that the k2 community would like to see including a tool for this migration with the new 1.7 k2 release. They would then be the first to do it as i am sure there are others trying. For these extensions I would be happy to pay a small fee for as they are coming from the developers and im sure many more would, thus putting some coinage back into JW;s pocket for the excellent free k2 and in turn push k2 even further as development money would come in and more people would start on 1.7 with it.
Just my pennies worth and a thought...but who am i ;-)

Paul

Thanks Kannan, i got it exactly backwards....its been several weeks since i did it. It just sat there, then when motools sys upgrade was enabled all went well. There were still some issues about the permissions when i last tried it

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.