I guess I can be nice and post my working migration. This migration only migrates, Categories, Topics and Replies as this is all we really cared to migrate. The major issue we had were the TimeStamps as EasyDiscuss uses DATETIME and Kunena uses INT, so we need to modify Kunena's method temporarily.
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!)
Code:
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'
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
Code:
INSERT INTO xx_kunena_categories (id,name,description,alias,published,parent_id)
SELECT id,title,description,alias,published,parent_id FROM xx_discuss_category
Parent Post into Topics table
Code:
INSERT INTO xx_kunena_topics (id,first_post_id,subject,first_post_time,first_post_message,ordering,hits,locked,first_post_userid,first_post_guest_name,category_id)
SELECT id,id,title,created,content,ordering,hits,islock,user_id,poster_name,category_id FROM xx_discuss_posts WHERE parent_id = 0
Posts into Messages table
Code:
INSERT INTO xx_kunena_messages (id,subject,time,ordering,hits,locked,userid,parent,name,email,catid,ip)
SELECT id,title,created,ordering,hits,islock,user_id,parent_id,poster_name,poster_email,category_id,ip FROM xx_discuss_posts
Set Replies to the right Thread
Code:
UPDATE xx_kunena_messages AS msg
SET msg.thread = msg.parent
Set the Parent to the right Thread
Code:
UPDATE xx_kunena_messages AS msg
SET msg.thread = msg.id WHERE msg.parent = 0
Import the Post Content into the msg_txt table
Code:
INSERT INTO xx_kunena_messages_text (mesid,message)
SELECT id,content FROM xx_discuss_posts
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.
Code:
ALTER TABLE xx_kunena_topics
ADD new_first_post_time int NOT NULL DEFAULT 0
Code:
UPDATE xx_kunena_topics
SET new_first_post_time = UNIX_TIMESTAMP(first_post_time)
Code:
ALTER TABLE xx_kunena_topics
DROP COLUMN first_post_time
Code:
ALTER TABLE xx_kunena_topics
CHANGE new_first_post_time first_post_time INT( 11 ) NOT NULL DEFAULT '0'
Code:
ALTER TABLE xx_kunena_topics
ADD new_last_post_time int NOT NULL DEFAULT 0
Code:
UPDATE xx_kunena_topics
SET new_last_post_time = UNIX_TIMESTAMP(last_post_time)
Code:
ALTER TABLE xx_kunena_topics
DROP COLUMN last_post_time
Code:
ALTER TABLE xx_kunena_topics
CHANGE new_last_post_time last_post_time INT( 11 ) NOT NULL DEFAULT '0'
Code:
ALTER TABLE xx_kunena_messages
ADD new_time int NOT NULL DEFAULT 0
Code:
UPDATE xx_kunena_messages
SET new_time = UNIX_TIMESTAMP(time)
Code:
ALTER TABLE xx_kunena_messages
DROP COLUMN time
Code:
ALTER TABLE xx_kunena_messages
CHANGE new_time time INT( 11 ) NOT NULL DEFAULT '0'
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.
