The Kunena team has announce the arrival of Kunena 7.0.9 [K 7.0.9] in stable which is now available for download as a native Joomla extension for J! 5.4.x/6.0.x./6.1.x. This version addresses most of the issues that were discovered in K 6.2 / K 6.3 / K 6.4 and issues discovered during the last development stages of K 7.0
This section is for questions directly related to the procedure for installing Kunena for the first time or upgrading from an older version of Kunena.
Use this category:
to ask how to install or upgrade; or
if you encountered problems during the installation or upgrade procedure.
Use a different category to ask questions about problems that you may be having after you successfully installed or upgraded the currently supported version. If you are unsure what is the current supported version of Kunena, please go to the
download
page.
Solved
Kunena upgrade from 1.7 to 5.x with step 3.0.7 breaks
Ok, then try the following:
1. Create a new Joomla 3.6.4 test installation
2. To import only the Kunena tables from your old instllation
3. Install/Upgrade right up to Kunena 5.0
When it works you have a forum without your users now.
Next steps:
1. Remove all kunena_tables on your migrated page
2. Install Kunena 5.0 new
3. Remove again all kunena_tables and import the kunena_tables from your new test installation
4. Go in backend to Kunena -> Tools and synchronisize all users and statistics
When the Joomla user tables are correct should be all ok now.
Important! Always create a backup before you make any changes to your website!
thanks for your fast reply ... I thought in the same direction create new joomla install kunena plain (v2), than import the database tables from that version I used to update above (v1 / with J-Users) (were it seems that the database update was done before update breaks)
than deinstal kunena in (v1) and remove kunena tables. install a plain kunena 5.0 in (v1) and import kunena tables from (v2)
will let you now if I tried in the next days ...
Tank you very much for your time and support!
Okay I'm back again with a 95% success ...
I set up a new plain Joomla system (v2), installed Kunena 4.0.12 (I used before for the first system (v1) were update breaks).
Than I imported my users and Kunena tables to Joomla (v2) from (v1) synced users and than forum "works" with admin access
only "base" statistics are not shown at the bottom (total messages, subjects, sections and so on) The statistic page with most popular threads, users etc. seems to work.
I tried Kunena tools "recount statistics" and it breaks with an SQL-Error: Illegal mix of collations (utf8_general_ci,IMPLICIT) and (utf8_general_mysql500_ci,IMPLICIT) for operation '=' SQL=UPDATE #__kunena_aliases AS a INNER JOIN #__kunena_categories AS c ON a.alias = c.alias SET a.item = c.id WHERE a.type='catid'
Updated to Kunena 5.0.3 runs without error.
Recount statistics brings same error ... so I changed collations for alias #__kunena_categories to utf8_general_ci and it goes proper. But no effect to "base" statistics
Than I looked in the Kunena tables and found that all tables that already exist in v 1.7 have different collation (utf8_general_mysql500_ci) compared to original new/plain Kunena v4 / v5 (utf8_general_ci) for varchar and text cells.
Maybe that is the reason why installation/update from 1.7 to 4/5 breaks? Because installation breaks at recount statistic and it also didn't worked with the Kunena tool too.
For the "base" statistic not showing, I wouldn't suppose that it has any belonging to that problem!? Because it is "only" counting some IDs anywhere?
ok try first, to change the database collation. You can use admin tools to do that. Then install kunena. Maybe there are some tables have the wrong collation.
Sorry don't now which admin tool you mean didn't found in Kunena? ... before I'll do it by hand for each table ... thanks!!!
You think this should also fix the "base" statistics issue?
best regards!
Topic Author
