Kunena 7.0.7 Released

The Kunena team has announce the arrival of Kunena 7.0.7 [K 7.0.7] in stable which is now available for download as a native Joomla extension for J! 5.4.x/6.0.x./6.1.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

Mangaku
Offline
New Member

11 years 7 months ago #160932 by Mangaku

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

Ok.
I'm on Joomla 3.2.7.
I have to update my php before going to 3.3.6.

Will try tonight, and give a feedback here !

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

binod
Topic Author
Offline
Junior Member

11 years 7 months ago - 11 years 7 months ago #160933 by binod

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

I just download Joomla 3.2.7 and found this:

Code:

CREATE TABLE IF NOT EXISTS `#__users` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(255) NOT NULL DEFAULT '',
  `username` varchar(150) NOT NULL DEFAULT '',
  `email` varchar(100) NOT NULL DEFAULT '',
  `password` varchar(100) NOT NULL DEFAULT '',
  `block` tinyint(4) NOT NULL DEFAULT 0,
  `sendEmail` tinyint(4) DEFAULT 0,
  `registerDate` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `lastvisitDate` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `activation` varchar(100) NOT NULL DEFAULT '',
  `params` text NOT NULL,
  `lastResetTime` datetime NOT NULL DEFAULT '0000-00-00 00:00:00' COMMENT 'Date of last password reset',
  `resetCount` int(11) NOT NULL DEFAULT 0 COMMENT 'Count of password resets since lastResetTime',
  `otpKey` varchar(1000) NOT NULL DEFAULT '' COMMENT 'Two factor authentication encrypted keys',
  `otep` varchar(1000) NOT NULL DEFAULT '' COMMENT 'One time emergency passwords',
  PRIMARY KEY (`id`),
  KEY `idx_name` (`name`),
  KEY `idx_block` (`block`),
  KEY `username` (`username`),
  KEY `email` (`email`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

This means there is no column "requireReset". Could you please exclude that column from insert and check if the rest of script works? I would like to add that into checklist for new users.

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

Last edit: 11 years 7 months ago by binod.

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

Mangaku
Offline
New Member

11 years 7 months ago - 11 years 7 months ago #160934 by Mangaku

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

A new one

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, /*1 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

#1062 - Duplicate entry '207' for key 'PRIMARY' 

Was expecting cause of my Name/nickname/mail.
I change all of them with one never used on my old PHPBB.
Still the same issue.

Last edit: 11 years 7 months ago by Mangaku.

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

binod
Topic Author
Offline
Junior Member

11 years 7 months ago - 11 years 7 months ago #160941 by binod

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

Since MySQL does not auto-rollback changes, you've got the old entries in your joomla database.

This means, you can do:

Code:

DELETE FROM joomla_database_name.jos_user_usergroup_map;
DELETE FROM joomla_database_name.jos_users;

instead of

Code:

CREATE TEMPORARY TABLE IF NOT EXISTS joomla_database_name.jos_users_backup AS (SELECT * FROM joomla_database_name.jos_users);
DELETE FROM joomla_database_name.jos_user_usergroup_map WHERE user_id NOT IN(SELECT id FROM  joomla_database_name.jos_users_backup);
DELETE FROM joomla_database_name.jos_users WHERE id NOT IN(SELECT id FROM  joomla_database_name.jos_users_backup);
DROP TABLE joomla_database_name.jos_users_backup;

Remember, if you do that, you are lost without a joomla administrator access to your backend. But if you could come this far, creating a new joomla administrator or upgrading your forum account (which gets migrated along with) to administrator would not be a big deal though.

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

Last edit: 11 years 7 months ago by binod.

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

Mangaku
Offline
New Member

11 years 7 months ago #160943 by Mangaku

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

So i tried...
I upgrade my PHP.
I'm now on the last joomla, and last kunena.

I change:

DELETE FROM joomla_database_name.jos_user_usergroup_map;
DELETE FROM joomla_database_name.jos_users;

Now:

requête SQL: Documentation

INSERT INTO TESTJOOMLA.testjoom_kunena_categories ( id, parent_id, name, alias, icon_id, locked, accesstype, access, pub_access, pub_recurse, admin_access, admin_recurse, ordering, published, checked_out, checked_out_time, review, allow_anonymous, post_anonymous, hits, description, headerdesc, class_sfx, allow_polls, topic_ordering, numTopics, numPosts, last_topic_id, last_post_id, last_post_time, params ) SELECT forum_id, parent_id, REPLACE(forum_name, '&', '&'), CopieForumSG.get_forum_alias(forum_id) AS alias, 1 as icon_id, 0 as locked, 'joomla.level' AS accesstype, 1 as access, 1 as pub_access, 1 as pub_recurse, 8 as admin_access, 1 as admin_recurse, left_id as ordering, 1 as published, 0 as checked_out, '0000-00-00 00:00:00' as checked_out_time, 0 as review, 0 as allow_anonymous, 0 as post_anonymous, 0 as hits, forum_desc, '' as[...]

MySQL a répondu: Documentation

#1270 - Illegal mix of collations (latin1_swedish_ci,IMPLICIT), (utf8_general_ci,COERCIBLE), (utf8_general_ci,COERCIBLE) for operation 'concat'

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

binod
Topic Author
Offline
Junior Member

11 years 7 months ago - 11 years 7 months ago #160944 by binod

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

Does this help?

www.interworks.com/blogs/bbausili/2010/0...llegal-mix-collation

Edit:
And this as well:
airbladesoftware.com/notes/fixing-mysql-...l-mix-of-collations/

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

Last edit: 11 years 7 months ago by binod.

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

Time to create page: 0.290 seconds