Kunena 7.0.4 Released

The Kunena team has announce the arrival of Kunena 7.0.4 [K 7.0.4] in stable which is now available for download as a native Joomla extension for J! 5.4.x/6.0.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

Question Migrating data, replies not working

More
16 years 7 months ago #28975 by jjmiller1980
I'm creating a migration tool to go from an old board I run (pnPHPBB) to Kunena. All the data SEEMS to be correct, thought I'm obviously missing something.

- I moved over all my categories with no problem and was able to set up the parent/child relationships so they show up fine

- I migrated all my users with no problem

The problem is with the post structure. It looks like all of my posts are in the forum, but none of them are showing the replies correctly. Every single topic has 0 replies. Also, if I do a search for a post, it shows up in the search results, but when you click on it to view the post, it takes you to a different post.

Here's the way I understand the structure to work, and please let me know if I'm wrong:

1. The 'id' in jos_fb_messages is the unique ID for that particular post, and it corresponds with the 'mesid' in jos_fb_messages_text.

2. The 'thread' in jos_fb_messages specifies which topic this post belongs to. So I just created a new topic named "Migrating data, replies not working", all posts in this topic should have the same 'thread'.

3. The 'catid' specifies which category the topic is stored in. For example, the topic I'm starting right now is in the "Installation, Upgrade and Migration" category.

4. The 'parent' in jos_fb_messages tells you the 'id' of the message you clicked reply on, and helps to determine where your reply shows up, with the first post always being 0. For example:

id .... parent .. thread .. catid
100 ....... 0 ........ 10 ...... 5 .... <- first post
101 .... 100 ...... 10 ...... 5 .... <- Reply to first post
102 .... 101 ...... 10 ...... 5 .... <- Reply to second post
And so on, and so on...

Now, I've set up all my rows in jos_fb_messages just like above, and it shows no replies. I also set it up so that the first post had a 'parent' of 0, and each reply under that same topic had the 'id' of the first post as a parent. Neither one works.

Is there something I'm missing here, or am I not understanding the way the tables work correctly? I'm sure it's something simple, it almost always is. Any help you can provide would be greatly appreciated.

By the way, I'm running Kunena 1.5.4 if it helps.

Please Log in or Create an account to join the conversation.

More
16 years 7 months ago #29008 by jjmiller1980
Ok, I've figured out my problem. Changed the data to look like this:

id .... parent .. thread .. catid
100 ....... 0 ........ 10 ...... 5 .... <- first post
101 .... 100 ..... 100 ...... 5 .... <- Reply to first post
102 .... 100 ..... 100 ...... 5 .... <- Reply to second post
And so on, and so on...

It's working fine now.

Please Log in or Create an account to join the conversation.

More
16 years 7 months ago #29017 by etusha
i suggest to wait for K1.6 (will be add new features and will not lose data like polls etc )
after u can do a good MIGRATING DATA

Please Log in or Create an account to join the conversation.

More
16 years 7 months ago #30264 by Matias
My migration tool works also for pnPHPBB3, but it's not ready (users are not yet imported). Just fetch it from our SVN in JoomlaCode: /trunk/kunenaimporter and look how do I migrate data..

Please Log in or Create an account to join the conversation.

Time to create page: 0.412 seconds