- Posts: 33
- Thank you received: 7
Kunena 5.1.7 Released - Security Release (20 Nov 2018)
The Kunena team has announce the arrival of Kunena 5.1.7 [K 5.1.7] 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. This is a Security release.
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
Edit : March 7, 2015
This topic has become too big to read. I am now offering assistance in my own forum instead of here:
Happy migration folks.
so: Thanks for sharing it with us
I ran into some major issues with your script:
(describing it here for others to be warned)
(tested with phpBB 3.0.11 ==> Kunena 3.0.6)
category names with "/" or german umlauts in it,
will be converted to invalid* category-aliases in joomla/kunena
*(not working with SEF/SEO and so on ...)
in phpBB you can have category and its subcategory with the same name.
The script then tries to generate the same category-alias in joomla/kunena twice and stops with errors.
If you have guest-posts in phpBB, then it would be better to convert the user-ID into a '0' within all the kunena-tables that contains the 'user-id'.
(it is not needed to import the "guest" (user-id=0) into the joomla usertable nor into the kunena-usertable at all ...)
all the attachments-filenames* of phpBB (without extension) are converted into filenames with a *.jpg -extension,
no matter if they are of another mime-type (e.g. *.png) ..
*(regarding the table "kunena_attachments" / column "filenames")
several bbcodes are not converted properly.
[list] [*]item[/*] [*]item2[/*] [/list]
[ul] [li]item[/li] [li]item2[/li] [/ul]
phpBB sometimes uses some kind of "hashes" behind the bbcodes,
I don't know why and what it is, but when you look into the database of the phpbb you can see for example:
[b:zts8ceo1]bold text[/b:zts8ceo1] [color=#FF0000:zts8ceo1]colored text[/color:zts8ceo1] [url=https://test-url.com:zts8ceo1]test-url[/url:zts8ceo1]
The script doesn't handle this issue correctly.
Thank you for trying this out. This script worked in our case but not for you properly because we had a limited scope to test onto. Moreover, I am glad that this could of some assistance to you.
- Right, but can be fixed easily.
- Right since we did not have guest posts enabled in our phpBB forum.
- Right because phpBB does not say which extension an attachment has.
- Right, can be fixed.
- Right and wrong.
If you inspect the script properly, you will find something like this:
UPDATE joomla_database_name.jos_kunena_messages_text SET message = phpbb_database_name.fix_tag(message, 'b') WHERE message LIKE '%[b%';
As of now, for this to work, you have to manually:
- Add any new tags you find
- Re-run the query several times
- Test and re-run
This script worked superfine on our "limited scenario", but there certainly are some issues. Still, I think there are more opportunities than the issues.
I would therefore request the community to improve quality the script by contributing to it.
Errore Query SQL: DELIMITER; DELETE FROM db_name.jos_kunena_messages_text; Messaggio di MySQL: Documentazione #1142 - DELETE command denied to user 'user_forum'@'localhost' for table 'jos_kunena_messages_text'
I believe the migration script would do pretty well, had it had more test cases and enhancements. Need more contributors on this.
Erreur requête SQL: Documentation INSERT INTO TESTJOOMLA.testjoom_users( id, name, username, email, PASSWORD , block, sendEmail, registerDate, lastVisitDate, activation, requireReset, params ) SELECT user_id AS id, username AS name, username, user_email AS email, user_password AS PASSWORD , /*lets not store blank passwords.*/0 AS block, 0 AS sendEmail, FROM_UNIXTIME( user_regdate ) AS registerDate, FROM_UNIXTIME( user_lastvisit ) AS lastVisitDate, 1 AS activation, 0 AS requireReset, /*The phpBB password cannot be converted to joomla password.*/ '' AS params FROM CopieForumSG.phpbb_users WHERE user_posts >0; MySQL a répondu: Documentation #1054 - UNKNOWN COLUMN 'requireReset' IN 'field list'
Any idea ?
Since this script was used to migrate phpBB 3 forum to Kunena 3 (Joomla! 3.x), I'm afraid your environment could be different.
Meanwhile, you could remove the column "requireReset" from the insert list and check to see if there are any further errors.
To be sure:
phpbb_database_name = the database name from my "old" PhPBB board.
joomla_database_name = my new joomla database name
jos_ = the prefixe in my news joomla database name
Btw, i try with leaving "RequireReset"
requête SQL: Documentation INSERT INTO TESTJOOMLA.testjoom_users( id, name, username, email, PASSWORD , block, sendEmail, registerDate, lastVisitDate, activation, params ) SELECT user_id AS id, username AS name, username, user_email AS email, user_password AS PASSWORD , /*lets not store blank passwords.*/0 AS block, 0 AS sendEmail, FROM_UNIXTIME( user_regdate ) AS registerDate, FROM_UNIXTIME( user_lastvisit ) AS lastVisitDate, 1 AS activation, '' AS params FROM CopieForumSG.phpbb_users WHERE user_posts >0; MySQL a répondu: Documentation #1062 - Duplicate entry '196' FOR KEY 'PRIMARY'
- Not Allowed: to create new topic.
- Not Allowed: to reply.
- Not Allowed: to add attachements.
- Not Allowed: to edit your message.