Kunena 7.0.3 Released

The Kunena team has announce the arrival of Kunena 7.0.3 [K 7.0.3] in stable which is now available for download as a native Joomla extension for J! 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 #160666 by binod

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

I will be more than happy to merge pull requests if someone comes with some revisions and improvements. That's the reason why this script is open source on the first place.

I believe the migration script would do pretty well, had it had more test cases and enhancements. Need more contributors on this.

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.

Mangaku
Offline
New Member

11 years 4 months ago - 11 years 3 months ago #160807 by Mangaku

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

Get an issue with this:

Code:

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 ?

Last edit: 11 years 3 months ago by Mangaku.

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

binod
Topic Author
Offline
Junior Member

11 years 3 months ago #160838 by binod

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

Are you using Kunena 3?

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.

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.

Mangaku
Offline
New Member

11 years 3 months ago - 11 years 3 months ago #160877 by Mangaku

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

I'm on a PhPBB3, and want to migrate to K3.06.

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"

Code:

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'

Last edit: 11 years 3 months ago by Mangaku.

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

Mangaku
Offline
New Member

11 years 3 months ago #160878 by Mangaku

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

Ok.
I try by changing my ID from 196 to 6969696969.

requête SQL: Documentation

INSERT INTO TESTJOOMLA.testjoom_kunena_aliases(

alias,

TYPE ,
item,
state
)
SELECT alias, 'catid', id, 0
FROM TESTJOOMLA.testjoom_kunena_categories;

MySQL a répondu: Documentation

#1062 - Duplicate entry 'gÃ©nÃ©ral' for key 'alias'

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

Mangaku
Offline
New Member

11 years 3 months ago #160879 by Mangaku

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

Quite better (still get this issue)

I now have my categories, and the number of post/topics.
But NO post :x

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

Time to create page: 0.247 seconds