Question How to Convert from IPB 3.1.2 to Kunena 1.6.3

Unfortunately I still get the same issue with the Topic links all going to the same starting topic page.

Ahh silly me - I still need to update the plugins by hand

Don't forget to upgrade the add-ons, too.

[strike]Did the upgrade fix the issue?[/strike]

Hmmm ... still looks like you have a Joomla menu issue. You need to read (carefully, obviously) Customised menus in the Wiki.

I doubt that the issue is complicated by the third-party Kunena template that you've got but you never know until you try going back to basics and test your forum with the Kunena Blue Eagle.

Ok - upgrades of plugins and modules finished, here is the latest configuration report.

Can you tell me which line you see in this report that points to a menu issue still being there? I apologize, I just don't see it.

Database collation check: The collation of your table fields are correct

Legacy mode: Disabled | Joomla! SEF: Enabled | Joomla! SEF rewrite: Enabled | FTP layer: Disabled |

This message contains confidential information

htaccess: Exists | PHP environment: Max execution time: 45 seconds | Max execution memory: 96M | Max file upload: 24M

Joomla default template details : rt_zephyr_j15 | author: RocketTheme, LLC | version: 1.5.2 | creationdate: November 16, 2010

Kunena default template details : Integrity Pro Kunena 1.6 Template | author: TemplateKunena Team | version: 1.6.2 | creationdate: 2011-01-24

Kunena version detailled: Installed version: 1.6.4 | Build: 4832 | Version name: Kerkrade | Kunena detailled configuration:

Warning: Spoiler!

[th]Kunena config settings:[/th]

board_title	333rd British Knights
board_offline	0
board_ofset	0.00
offline_message	<h2>The Forum is currently offline for maintenance.</h2> <div>Check back soon!</div>
enablerss	1
enablepdf	1
threads_per_page	20
messages_per_page	6
messages_per_page_search	15
showhistory	1
historylimit	6
shownew	1
jmambot	0
disemoticons	0
template	integrity_pro
showannouncement	1
avataroncat	0
catimagepath	category_images/
showchildcaticon	1
annmodid	62
rtewidth	450
rteheight	300
enableforumjump	1
reportmsg	1
username	1
askemail	0
showemail	0
showuserstats	1
showkarma	1
useredit	1
useredittime	0
useredittimegrace	600
editmarkup	1
allowsubscriptions	1
subscriptionschecked	1
allowfavorites	1
maxsubject	50
maxsig	300
regonly	0
changename	0
pubwrite	0
floodprotection	0
mailmod	0
mailadmin	0
captcha	0
mailfull	1
allowavatar	1
allowavatarupload	1
allowavatargallery	1
avatarquality	65
avatarsize	2048
allowimageupload	0
allowimageregupload	1
imageheight	800
imagewidth	800
imagesize	150
allowfileupload	0
allowfileregupload	1
filetypes	txt,rtf,pdf,zip,tar.gz,tgz,tar.bz2
filesize	120
showranking	1
rankimages	1
avatar_src	fb
fb_profile	fb
pm_component	no
userlist_rows	30
userlist_online	1
userlist_avatar	1
userlist_name	1
userlist_username	1
userlist_posts	1
userlist_karma	1
userlist_email	0
userlist_usertype	0
userlist_joindate	1
userlist_lastvisitdate	1
userlist_userhits	1
latestcategory	0
showstats	1
showwhoisonline	1
showgenstats	1
showpopuserstats	1
popusercount	5
showpopsubjectstats	1
popsubjectcount	5
usernamechange	0
rules_infb	1
rules_cid	1
help_infb	1
help_cid	1
showspoilertag	1
showvideotag	1
showebaytag	1
trimlongurls	1
trimlongurlsfront	40
trimlongurlsback	20
autoembedyoutube	1
autoembedebay	1
ebaylanguagecode	en-us
fbsessiontimeout	7200
highlightcode	0
rss_type	topic
rss_timelimit	month
rss_limit	100
rss_included_categories
rss_excluded_categories
rss_specification	rss2.0
rss_allow_html	1
rss_author_format	name
rss_author_in_title	1
rss_word_count	0
rss_old_titles	1
rss_cache	900
fbdefaultpage	recent
default_sort	asc
alphauserpointsnumchars	0
sef	1
sefcats	0
sefutf8	0
showimgforguest	1
showfileforguest	1
pollnboptions	4
pollallowvoteone	1
pollenabled	1
poppollscount	5
showpoppollstats	1
polltimebtvotes	00:15:00
pollnbvotesbyuser	100
pollresultsuserslist	1
maxpersotext	50
ordering_system	mesid
post_dateformat	ago
post_dateformat_hover	datetime
hide_ip	1
js_actstr_integration	0
imagetypes	jpg,jpeg,gif,png
checkmimetypes	1
imagemimetypes	image/jpeg,image/jpg,image/gif,image/png
imagequality	50
thumbheight	32
thumbwidth	32
hideuserprofileinfo	put_empty
integration_access	auto
integration_login	auto
integration_avatar	auto
integration_profile	auto
integration_private	auto
integration_activity	auto
boxghostmessage	0
userdeletetmessage	0
latestcategory_in	1
topicicons	1
onlineusers	1
debug	0
catsautosubscribed	0
showbannedreason	0
version_check	1
showthankyou	1
showpopthankyoustats	1
popthankscount	5
mod_see_deleted	0
bbcode_img_secure	text
listcat_show_moderators	1
lightbox	1
activity_limit	0
show_list_time	720
show_session_type	0
show_session_starttime	0
userlist_allowed	0
userlist_count_users	1
enable_threaded_layouts	0
category_subscriptions	post
topic_subscriptions	every
pubprofile	1

Third-party components: Jomsocial 2.0.4

Third-party SEF components: None

Plugins: System - Mootools Upgrade: Disabled | System - Mootools12: Disabled | Kunena Search 1.6.4 | My Kunena Forum Posts 1.6.4

Modules: Kunena Latest 1.6.4 | Kunena Stats 1.6.4 | Kunena Login 1.6.4 | Kunena Search 1.6.4

See PM

It turns out that my initial analysis of the problem was off-base. The problem is due to the conversion from IPB to Kunena which failed to properly map the parent id of the posted messages (table __kunena_messages). The messages in the converted database had parent=0 (which, effectively, "orphans" them) and therefore there's no way to view them later.

Good luck, Dan. It would be really great to hear how you managed to solve this problem and, if possible, post your solution on how to convert from IPB to Kunena for the benefit of others who may be in this situation.

Success! Once Sozzled and I talked through this and I was able to identify how to better rebuild the post/thread tree it is working. I do promise to share my scripts for this. Keep in mind I am on a much earlier version of IPB but with some tweaks I hope I can help those on later versions.

I am working now to fix problems where the signatures are messed up, or where people had embedded html in their posts. Also, I have only focused on users, posts/topics, and forum/category transfers. There is still the realm of private messages, etc. Stay tuned to this thread and I will share the more finalized and cleaned up scripts.

Thank you again Sozzled!

Dan

I did not post everything here as I still don't consider it "finished". However, I do have a solution to help people get very far with the conversion. I will be attaching 10 scripts here. These scripts assume you have your old database backed up and your new kunena install and database is ready. Also, you need to get your old database setup on the same server (or at least the tables that the scripts reference) so you can pull from it while inserting into your new database. I did not handle private messages. My users did not care. I was able to preserve the history of the forum and that is what counted. I did not handle signatures very well as some of the links to images end up showing up as bad links. Still, this is a minor inconvenience and each user can setup their signature again, or can just edit what is there. If you choose, you can spot the section in the scripts and just not move over the signature column at all. Or, wipe out the signature column entries after these scripts are run.

Anyway, I hope this helps some people. Of course, you will need to do a replace all to put in your new database name, new database prefix, old database name, and database prefix.

replace olddb. with [your old db name].
replace oldprefix_ with [your old db prefix]_
replace newdb. with [your new db name].
replace newprefix_ with [your new prefix]_

Good luck! I will continue to receive email notices of posts to this forum and will help if there are questions.

Dan

Here is the first set of files - I had to rename the extensions from *.sql to *.txt in order to attach them.

Here are the rest of the files