Question Move K1.7 from J1.5.23 to J.1.7

Denis, I don't know if it will help you (perhaps you're already beyond this), but here's how I finally got things working (hopefully I'm remembering this correctly) in my upgrade from Joomla 1.5.23 to Joomla 1.7:

1. Make sure you are running Kunena 1.7 on your Joomla 1.523 site
2. Using phpMyAdmin or some other tool, export all your kunena_* tables from your Joomla 1.523 site database to somewhere on your desktop
3. Migrate your Joomla 1.523 site to a new Joomla 1.7 site using jUpgrade (a component). jUpgrade does all the work, downloading and installing a new Joomla 1.7 version of your site in a subdirectory of your 1.523 site, so you can test it before trashing your 1.523 site. In my case, it did not install Kunena on the Joomla 1.7 site.
4. Install Kunena 1.7 on your new Joomla 1.7 site (the site that is in a subdirectory of your 1.523 site). This will be a virgin Kunena install, with only the default starting info.
5. With the file you made in step 2 (the Kunena database tables), open a text editor on your computer and perform a find and replace to change the table prefixes to whatever your Joomla 1.7 site is using. In my case, I changed all instances of jos_ in the Kunena tables to j17_. Save the file with the changes.
6. Using phpMyAdmin, Drop (i.e. delete) the kunena_* tables in the Joomla 1.7 site's database.
7. Using phpMyAdmin, import the file you made in step 5 (the new database tables)
8. I haven't done this yet, but my next step will be to move my Joomla 1.5.23 site to a subdirectory (to keep until I'm sure I don't need it), and move the 1.7 site to the site root.

That was it. After all day pounding my head against the desk, I got things working. If that doen't solve your problem, maybe it will save somebody else the frustration I had today.

I am running Kunena 1.6.1 on our current site; is that easy to upgrade to 1.7 before migrating into the Joomla 1.7 site? One more question: where exactly do I find the kunena database tables-I use FileZilla for most upload stuff. This all quite nerve-racking for a novice, you know! I appreciate your step-by-step once I get to that point...just what I need. Thanks much! DJ

I think I went from an early version of Kunena straight to 1.7, so I'm not sure about 1.61. I think they've made it easier with every version, though. The newer versions give you a big button to press. Simple as that.

For your database tables, you need an app that handles databases. Most hosting providers offer something like cPanel or something similar. Within cPanel are a suite of different options and apps. One of them is phpMyAdmin, and it is a database tool. In phpMyAdmin, you find the name of your database in the left margin, click it, and then a list of your tables shows up in the main window. You want to select all the ones that have "kunena" anywhere in the name (use SHIFT-click to select multiple ones at once), and then use the Export option at the bottom of the list to save them locally on your PC.

Before you do anything - backup! I actually exported a complete copy of my database, and imported those tables into a virgin database, and made my changes on the copy without messing with my original database. You can backup by either using the Backup feature in cPanel, or by exporting all of your tables using phpMyAdmin.

I am itching to update to joomla 1.7 from J1.5.23 and I have looked into the migration options.
One thing that seems crucial is to maintain the same ids. It seem JUpgrade does not do so...I have come across another extension, called SP Upgrade which claims to do exactly that and it's reviews are stellar...unfortunately, though, it is commercial...but it may be the way for me to go...

Using that extension what you need to do is
- Make a clean J1.7 installation
- install the extension, configure it and run it
- Clean install all your extensions, compatible version for J1.7
- Test, test, test.
- Then I guess copy old site to subfolder, and copy j17 site to root

Regarding the database for Kunena, seems like what -logically needs to be done is
- export kunena database entries from old site
- Install Kunena on new site
- Drop the newly created database entries for Kunena
- Import the database entries from previous site.

Haven't gone through the process yet, I haven't made my final decision to go with J1.7 that early (really don't want to run into serious bugs and beta test practically)

There's extension called JUpgrade that's supposed to move Kunena and all its data into Joomla 1.7, but latest version (1.2.1) of it has a bug that causes it to ignore Kunena. I've already contacted the author and provided him a few fixes, but the new version isn't out yet.

In the mean time I suggest that you downgrade back to K1.6.5 and use JUpgrade after that.

Thank you to all. I must add this--I used SPUpgrade even though my work is all volunteer and I am so very thankful I did. I did need to do a substantial amount of work, but most things were right where they were supposed to be and it even (in this case) upgraded the template with one miner problem. etkritikonspoudon, please post how you make out if you do it--I am almost done the one site with the exception of Kunena and JQuarks and then we'll be ready to move it to replace the current site. Thanks again, Everybody! DJ