Question Kunena Upgrade 1.0.11 to 1.6.3

This topic shoudl help : www.kunena.org/forum/172-k-16-installati...erwer-with-mysql-558

xillibit wrote: This topic shoudl help : www.kunena.org/forum/172-k-16-installati...erwer-with-mysql-558

Not so much, I've already read through that thread and unfortunately there is no new information in there than what I have already posted.

I'm trying to find out where the "TYPE=MyISAM" command is being issued from during the migration attempt, so that I can go and change it to "ENGINE=MyISAM".

Thanks.

I'm posting this for anyone else that finds themselves in the position I was in.

I've completed my upgrades without any problems, it was relatively straight forward, and I'm certainly glad I didn't pay someone else to do it. I tested the upgrade on a local server, but if you don't have one you can just create a folder on your live server and install the new versions there.

• I started out with Joomla 1.0.x and Kunena 1.0.11, and needed to update both Joomla and Kunena.

• I installed a fresh copy of Joomla 1.5 with a new database.(in a seperate folder from your live joomla installation!)

• I installed Kunena 1.0.11.

• I installed the component mtwmigrator and used it to bring my old sites info over to the new site. While mtwmigrator may work to bring over the Kunena 1.0.11 database, I did not try it.

• Using phpmyadmin, I manually exported the kunena database files from the old database and saved them locally. You must check the "add drop table" when you do this. The prefix for the Kunena tables is jos_fb_*

• Using phpmyadmin, I selected the new database and manually imported the Kunena database files into the corresponding tables. Two of the tables needed to be created manually, jos_fb_config and jos_fb_config_backup.

At this point I had a working version of Joomla 1.5 running the old forum with all data.

• I uploaded Kunena 1.6.3, and selected the migrate option during the install. This successfully migrated all the 1.0.11 database files over to the new version of Kunena 1.6.3. Kudos to whoever wrote that script.

• Remove old installation and move new installation to the root folder.

That was it, I was now running Joomla 1.5 and Kunena 1.6.3 with all the data and users from the previous versions working correctly.

A few thoughts
After upgrading Kunena you lose your configuration settings, so in retrospect it may not be necessary to manually create the jos_fb_config tables.

The transition of Joomla will mess up your page layouts, you will more than likely need to find/create a new Joomla template and edit your configuration to make it all fit.

Creating a new folder on the live server and installing/migrating there was the way to go. I was able to check and make sure everything worked ok, and then simply remove the old Joomla installation and move the new installation into the root folder.

Make sure you back everything up before trying anything, just to be on the safe side.

Issues
On my local server I am running PHP version 5.5.8, and ran into an error when trying to use the migrate option in the Kunena 1.6.3 installation. This was a result of a script using the outdated "TYPE=MyISAM". The script should use "ENGINE=MyISAM". I have no idea where this script was located and was unable to update it. However my live server is running PHP V5.2.14, so I performed the upgrade on the live server and didn't have this issue. Had my live server been running PHP V5.5.8, I would have had to hunt down this script before performing the upgrade.

I found a solution.

Open file

/install/model.php

under Admin Kunena folder, find this function:

Basically, this function recreate a table from an old table's structure. So it uses old syntax.

After this row (or any similar row):

add:

Do not reload the error page on your web browser; instead, go back and click again on migrate button.
This should work.