- Posts: 32
- Thank you received: 1
Kunena 6.3.6 Released - Security release
The Kunena team has announce the arrival of Kunena 6.3.6 [K 6.3.6] in stable which is now available for download as a native Joomla extension for J! 4.4.x/5.0.x/5.1.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.
Merged How to move, copy or merge my old Kunena forums from one site to another
- karaokeamerica
- Topic Author
- Offline
- Junior Member
That being said, I would like to know if there is a solution for migrating an existing Forum (J1.5.23/K1.6.5) to another site of the same versions.
Thanks for any help!
Please Log in or Create an account to join the conversation.
Although a process can be developed to achieve this merger of data, it's not an easy accomplishment. Please advise if I have correctly interpreted the meaning of your word "migration" before I respond further. Thank you.
Blue Eagle vs. Crypsis reference guide
Read my blog and
Please Log in or Create an account to join the conversation.
- karaokeamerica
- Topic Author
- Offline
- Junior Member
- Posts: 32
- Thank you received: 1
Please Log in or Create an account to join the conversation.
Moving a Kunena forum from one site to another is relatively easy (if you're not interested in keeping any existing data on the target). Merging one forum into another is difficult because you need to ensure that the messages created by one site are properly owned by the users who created those messages and, if the users don't exist on the target site, you have to create user records for them on the target site. Then you have to ensure that the user-ids are correctly mapped. Further, the message ids, the categories, etc., need to be uniquely assigned so that they don't overwrite the contents on the target site.
There are 24 database tables in a "no-frills" Kunena installation which are:
jos_kunena_announcement
jos_kunena_attachments
jos_kunena_attachments_bak
jos_kunena_categories
jos_kunena_config
jos_kunena_config_backup
jos_kunena_favorites
jos_kunena_groups
jos_kunena_messages
os_kunena_messages_text
jos_kunena_moderation
jos_kunena_polls
jos_kunena_polls_options
jos_kunena_polls_users
jos_kunena_ranks
jos_kunena_sessions
jos_kunena_smileys
jos_kunena_subscriptions
jos_kunena_subscriptions_categories
jos_kunena_thankyou
jos_kunena_users
jos_kunena_users_banned
jos_kunena_version
jos_kunena_whoisonline
And, in addition to those, there are 7 tables that hold user information
jos_core_acl_aro
jos_core_acl_aro_groups
jos_core_acl_aro_map
jos_core_acl_aro_sections
jos_core_acl_groups_aro_map
jos_session
As well as these things there are also the attachments that correspond to the messages. These attachments are stored in ../media/kunena/attachments.
Basically, I've tried to include as much information as I can about what you need to know to achieve a merge of the two forums ... but I don't envy your job.
The basic, general approach is to export the database tables from your original site, edit the tables in such a way that you will not over-write things on the target site (eliminate the possibility of record duplication) and import the data into your target site.
Obviously, before you undertake this activity you need to ensure that you have make good backups of both websites beforehand and that you prevent your users updating the tables while you're carrying out the merger.
Personally, if I were thinking about doing this, I would engage a professional to do the work for me.
Blue Eagle vs. Crypsis reference guide
Read my blog and
Please Log in or Create an account to join the conversation.
- Jiminimonka
- Offline
- Elite Member
- YBAS!
I will dig around on the Joomla forums and try to get an updated list.
Please Log in or Create an account to join the conversation.
The question asked by karaokeamerica relates to J! 1.5.
Blue Eagle vs. Crypsis reference guide
Read my blog and
Please Log in or Create an account to join the conversation.
- mlewis
- Visitor
From there, even if users don't associate with the posts, they can at least continue the thread as ongoing.
Please Log in or Create an account to join the conversation.
- Jiminimonka
- Offline
- Elite Member
- YBAS!
jos_usergroups
jos_users
jos_user_profiles
jos_user_usergroup_map
and the collation is different for each database, i.e. jos_ could be jml_ or bbc_ or flb_ etc.
Please Log in or Create an account to join the conversation.
Minor correction to the terminology: the collation is the same (or it should be the same) but the table prefix name will probably be different in J! 1.7.Jiminimonka wrote: the collation is different for each database ...
Blue Eagle vs. Crypsis reference guide
Read my blog and
Please Log in or Create an account to join the conversation.
- karaokeamerica
- Topic Author
- Offline
- Junior Member
- Posts: 32
- Thank you received: 1
That last part could be very likely.....
Please Log in or Create an account to join the conversation.