- Posts: 12
- Thank you received: 0
Kunena 5.1.18 Released (30 Jun 2020)
The Kunena team has announce the arrival of Kunena 5.1.18 [K 5.1.18] which is now available for download as a native Joomla extension for J! 3.9.x. This version addresses most of the issues that were discovered in K 5.1 and issues discovered during the development stages of K 5.1.
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
I try by changing my ID from 196 to 6969696969.
requête SQL: Documentation
INSERT INTO TESTJOOMLA.testjoom_kunena_aliases(
SELECT alias, 'catid', id, 0
MySQL a répondu: Documentation
#1062 - Duplicate entry 'gÃ©nÃ©ral' for key 'alias'
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.
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
REPLACE(REPLACE(LCASE(forum_name),' ','-'), '&','and') AS alias
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:
I try it, but still the same issue.
I tryed your little function before, but get an issue:
#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 24
- Not Allowed: to create new topic.
- Not Allowed: to reply.
- Not Allowed: to edit your message.