- Posts: 12
- Thank you received: 0
Kunena 6.3.7 Released
The Kunena team has announce the arrival of Kunena 6.3.7 [K 6.3.7] 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.
This is for users to help other users, to discuss topics that relate to migrating from other web-based forums and converting the data into a form that will operate with Kunena.
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.
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.
Idea phpBB 3 to Kunena 3 Migration Script
9 years 11 months ago #16
by binod
Please follow my open source projects MixERP Project and phpBB to Kunena Migration Script on Github.
Replied by binod on topic phpBB 3 to Kunena 3 Migration Script
Okay, I downloaded and migrated your script. Took a couple of minutes. Your forum was big, but my server was able to process it within minutes. 
Investigating on why the script was giving you errors, I realized that our existing forum did not have multiple categories with same name. That was the reason why it did not work in your case.
PhpBB does not "need" an alias or does not "have a clue about" it. So, I created a simple function to create it from the category name.
The previous code(bug) was changed from
to this
. The rest of the script works fine. I have already pushed the changeset to github repository and "confirm" that it works. You can get it from this url:
github.com/mixerp
Investigating on why the script was giving you errors, I realized that our existing forum did not have multiple categories with same name. That was the reason why it did not work in your case.
PhpBB does not "need" an alias or does not "have a clue about" it. So, I created a simple function to create it from the category name.
Code:
DELIMITER $$
CREATE FUNCTION phpbb_database_name.get_forum_alias(id int)
RETURNS text
DETERMINISTIC
BEGIN
DECLARE alias text;
DECLARE p_id int;
SELECT
phpbb_database_name.get_alias(phpbb_database_name.HTML_UnEncode(forum_name)),
parent_id
INTO
alias,
p_id
FROM phpbb_database_name.phpbb_forums
WHERE forum_id = id;
IF(p_id <> 0) THEN
SELECT
concat(alias, '-', phpbb_database_name.get_alias(phpbb_database_name.HTML_UnEncode(forum_name)))
INTO
alias
FROM phpbb_database_name.phpbb_forums
WHERE forum_id = p_id;
END IF;
RETURN alias;
END;
$$
DELIMITER ;
The previous code(bug) was changed from
Code:
REPLACE(REPLACE(LCASE(forum_name),' ','-'), '&','and') AS alias
to this
Code:
phpbb_database_name.get_forum_alias(forum_id) AS alias
. The rest of the script works fine. I have already pushed the changeset to github repository and "confirm" that it works. You can get it from this url:
github.com/mixerp
Please follow my open source projects MixERP Project and phpBB to Kunena Migration Script on Github.
Please Log in or Create an account to join the conversation.
Time to create page: 0.772 seconds