Kunena 7.0.2 Released

The Kunena team has announce the arrival of Kunena 7.0.2 [K 7.0.2] in stable which is now available for download as a native Joomla extension for J! 5.3.x/5.4.x/6.0.x. This version addresses most of the issues that were discovered in K 6.2 / K 6.3 / K 6.4 and issues discovered during the last development stages of K 7.0

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.

Idea phpBB 3 to Kunena 3 Migration Script

binod
Topic Author
Offline
Junior Member

11 years 4 months ago - 11 years 2 weeks ago #160097 by binod

phpBB 3 to Kunena 3 Migration Script was created by binod

We have migrated our forum from phpBB to Kunena and would like to share the migration script with the Joomla community:

mixerp.org/erp/14-open-source-projects/1...igration-script.html

Edit : March 7, 2015

This topic has become too big to read. I am now offering assistance in my own forum instead of here:

mixerp.org/forum

Happy migration folks.

Please follow my open source projects MixERP Project and phpBB to Kunena Migration Script on Github.

Last edit: 11 years 2 weeks ago by binod.

The following user(s) said Thank You: Lazaruso, Tiago

Please Log in or Create an account to join the conversation.

Dirk
Offline
New Member

11 years 4 months ago - 11 years 4 months ago #160443 by Dirk

Replied by Dirk on topic phpBB 3 to Kunena 3 Migration Script

I tested the script and finally it worked for me,
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)

1.)
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 ...)

2.)
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.

3.)
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 ...)

4.)
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")

5.)
several bbcodes are not converted properly.
for example:

Code:

[list]
[*]item[/*]
[*]item2[/*]
[/list]

should be converted into

Code:

[ul]
[li]item[/li]
[li]item2[/li]
[/ul]

6.)
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:

Code:

[b:zts8ceo1]bold text[/b:zts8ceo1]
[color=#FF0000:zts8ceo1]colored text[/color:zts8ceo1]
[url=http://test-url.com:zts8ceo1]test-url[/url:zts8ceo1]

and so on ...
The script doesn't handle this issue correctly.

Last edit: 11 years 4 months ago by Dirk.

Please Log in or Create an account to join the conversation.

binod
Topic Author
Offline
Junior Member

11 years 4 months ago #160449 by binod

Replied by binod on topic phpBB 3 to Kunena 3 Migration Script

Hello Dirk,

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.
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:

Code:

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.

Cheers!

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.

lucifaro666
Offline
New Member

11 years 3 months ago #160630 by lucifaro666

Replied by lucifaro666 on topic phpBB 3 to Kunena 3 Migration Script

Hello from me this error:

Code:

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'

Please Log in or Create an account to join the conversation.

binod
Topic Author
Offline
Junior Member

11 years 3 months ago #160635 by binod

Replied by binod on topic phpBB 3 to Kunena 3 Migration Script

Your MySQL user does not have sufficient privilege to perform deletes. Sorry, I cannot help.

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.

Lazaruso
Offline
Junior Member

11 years 3 months ago - 11 years 2 months ago #160658 by Lazaruso

Replied by Lazaruso on topic phpBB 3 to Kunena 3 Migration Script

...

Last edit: 11 years 2 months ago by Lazaruso.

Please Log in or Create an account to join the conversation.

Time to create page: 0.274 seconds