- Posts: 4
- Thank you received: 5
Kunena 6.3.8 Released
The Kunena team has announce the arrival of Kunena 6.3.8 [K 6.3.8] in stable which is now available for download as a native Joomla extension for J! 4.4.x/5.0.x/5.1.x/5.2.x. This version addresses most of the issues that were discovered in K 6.2 / K 6.3 and issues discovered during the last development stages of K 6.3
Note: Please go to the Kunena Dashboard after an upgrade so that the Kunena database tables are also updated.
It is important to note that the Kunena team does not have a standard, recommended or supported protocol for these ideas and that posting questions in this category may not receive advice from team members.
Solved EasyDiscuss to Kunena
These are the SQL queries I ran to get as far as I am now, if anyone has any suggestions that would be awesome.
*Edited See below
Please Log in or Create an account to join the conversation.
*EDITED SEE BELOW
Please Log in or Create an account to join the conversation.
DO THIS AT YOUR OWN RISK! I AM NOT A SQL EXPERT, I DID A TON OF GOOGLING! ALWAYS BACKUP YOUR DATABASE BEFORE MAKING ANY CHANGES!
(Remember to replace xx with your DB prefix)
First we truncated all the tables in Kunena we wanted to migrate data into.
(NOTE: This removes everything from these tables!)
Now I had to change the way the TimeStamps were in Kunena to except EasyDiscuss TimeStamp
(There probably is an easier way but this is how I did it)
I went into phpMyAdmin and found the following tables
xx_kunena_topics
xx_kunena_messages
and modified these columns: first_post_time, last_post_time, time
INT Default 0
to
datetime Default 0000-00-00 00:00:00
Now we are ready to migrate Categories, Topics and Replies into Kunena
Categories
Parent Post into Topics table
Posts into Messages table
Set Replies to the right Thread
Set the Parent to the right Thread
Import the Post Content into the msg_txt table
Now this is where I went into Joomla's backend -> Kunena Forum -> Forum Tools -> Recount Statistics
Doing this you will notice all your Counts are off however it updates the last_post_time table for us so we can continue
Now remember when we modified the TimeStamp method for Kunena? This is where we change it back and convert EasyDiscuss Time to Kunena Time.
Then I went back into the Backend and do another Recount Statistics and BAM! everything works great. Like I said above, I'm not a SQL Expert so do this at your own risk, however this worked great for us.
Please Log in or Create an account to join the conversation.
- MaxOnTheHill
-
- Offline
- New Member
- Posts: 1
- Thank you received: 1
We unfortunately migrated to EasyDicuss from our old Kunena forum around 6 months ago for a hoped better UX ... but has been horrible to work with and we want to get ourselves back on Kunena. Kunena just works and I wish we'd stayed with it and just done a heap of optimisations ... so now we have to get back where the grass is greener.
Look forward to your reply ... and experiences anyone else has had with this method ... or other transfer methods from EasyDiscuss to Kunena.
** Also, if anyone provides services for an EasyDiscuss to Kunena transfer (and possibly ongoing assistance) please reach out and make contact.
Please Log in or Create an account to join the conversation.
Thank you so much for sharing your fantastic work here!
Today, I just performed a EasyDiscuss 3.2.9463 conversion to Kunena 3.0.6 per your detailed instructions and everything went flawlessly.
I would add just a few clarifications for those of us who like to cut & paste the queries:
1) Add the missing end-of-query semicolon to the truncation queries -
TRUNCATE TABLE xx_kunena_categories;
TRUNCATE TABLE xx_kunena_messages;
TRUNCATE TABLE xx_kunena_messages_text;
TRUNCATE TABLE xx_kunena_topics;
TRUNCATE TABLE xx_kunena_user_topics;
2) Add the queries for DATETIME conversions -
ALTER TABLE xx_kunena_topics MODIFY COLUMN first_post_time DATETIME NOT
NULL DEFAULT '0000-00-00 00:00:00';
ALTER TABLE xx_kunena_topics MODIFY COLUMN last_post_time DATETIME NOT
NULL DEFAULT '0000-00-00 00:00:00';
ALTER TABLE xx_kunena_messages MODIFY COLUMN time DATETIME NOT
NULL DEFAULT '0000-00-00 00:00:00';
You made a difficult task easy. Thank you for sharing it all. -- Rik
PS: By the way, I started with vBulletin 4.x and converted to EasyDiscuss (which has a good converter) about 4 months ago before ending up at Kunena via this conversion method.
Please Log in or Create an account to join the conversation.
I like to convert to kunena as well, but i am defintaly not an expert in MYSQL stuff etc.
So i was wondering if someone is out there to do it for me.
Just let me now how much u charge for it.
Please Log in or Create an account to join the conversation.
Since no one replied on my question, i started myself to convert from easy discuss > Kunena.
Thx to the posters above i was verry suprised all went well. Considering i never ever did queries in databases before (i even did not know what is was) thats a huge compliment to the posters above.
Excellent work and thaks a lot Rik and Ubelmort !
Just one note:
I had just 4 categories in Easy Discuss. After migrating they become sections wich turned to be in "no published categories" message in Kunena.
So if you like to see all the migrated posts in Kunena > Just make a new section and make the categories from easy discuss (wich become sections in Kunena) childs from the new section you created.
Bam!

Please Log in or Create an account to join the conversation.
Please Log in or Create an account to join the conversation.
Maybe is an easy fix, but I'm no expert.
Please Log in or Create an account to join the conversation.
Please Log in or Create an account to join the conversation.