Migrating K2 content from Joomla! 1.5 to 1.7
Step 1. Back up J1.5 source and J1.7 destination. Use Akeeba Backup.
Step 2. Ensure J1.5 and J1.7 table prefixes match (Use Admin Tools)
Step 3. Log in phpMyAdmin
Step 4. Export J1.5 k2 tables
Step 5. Import k2 tables .sql into J1.7 database, leave k2 tables in MyISAM format
Step 6. Running SQL query:
UPDATE `PREFIX_k2_items` SET created_by = NEW_ID WHERE created_by = OLD_ID to update k2_items created_by ID to new J1.7 Super User ID.
Step 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
Step 8. All of k2 items had access set to 0 so I made them all public again:
UPDATE `PREFIX_k2_items` SET access = 1 WHERE access = 0
Step 9. Copy k2 media items from J1.5 and paste into J1.7 …/media/k2/
Step 3. Log in phpMyAdmin
Step 4. Export J1.5 k2 tables
Step 5. Import k2 tables .sql into J1.7 database, leave k2 tables in MyISAM format
Step 6. Running SQL query:
UPDATE `PREFIX_k2_items` SET created_by = NEW_ID WHERE created_by = OLD_ID to update k2_items created_by ID to new J1.7 Super User ID.
Step 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
Step 8. All of k2 items had access set to 0 so I made them all public again:
UPDATE `PREFIX_k2_items` SET access = 1 WHERE access = 0
Step 9. Copy k2 media items from J1.5 and paste into J1.7 …/media/k2/
You can also refer to jUpgrade http://redcomponent.com/jupgrade, a component which simplifies the migration of K2 from Joomla! 1.5 to 1.7.
Thanks for your reading, and if you have any questions with this blog, don’t hesitate to let us know by leaving a comment.
Welcome to LT Digital Team. We make daily blogs for Joomla! and WordPress CMS, support customers and everyone who has issues with these CMSs and solve any issues with blog instruction posts, trusted by over 1.5 million readers worldwide.
Latest posts by LT Digital Team (Content & Marketing) (see all)
- Integrating TikTok Icon in Jetpack Social Navigation Using Genericons - July 11, 2025
- Understanding the JInstaller: :install: Error – SQL Duplicate Column Name ‘catid’ - July 11, 2025
- Joomla Web Hosting: A Comprehensive Guide - April 3, 2025
Recent Comments