- Posts: 33
- Thank you received: 7
Blue Eagle 5 v1.6.2 has been Released for Kunena 5.2 (20 Jan 2021)
The Kunena team has announce the arrival of Kunena template Blue Eagle 5 v1.6.2 which is now available for download. This version addresses most of the issues that were discovered in development.
Blue Eagle 1.6.x requires Kunena 5.2.x to work with
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 edit your message.