Idea 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'

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/

Thank you! Your script really helped me migrate an old Snitz Forum to Kunena.

First, I've migrated Snitz to phpBB2, there is a converter somewhere.

Then I migrated phpBB2 to phpBB3 - it did that, but some of the fields were missing. I don't know if that happened on purpose or it was a migration error. The phpBB3 forum worked so I guess if you migrate, that happens.

By modifying some of the statements to point to the phpBB2 database I was able to process all messages! www.i-war2.com/forum lives again for another 15 years (I hope). :lol:

I just have to replace all HTML tags with bbcode now. The old Snitz forums were ASP based, horrible stuff - they wrote all HTML stuff directly into the message. And sometimes even the signature.

@schmatzler, I was glad it worked for you.

I had a new test case and added support for missing column today, which is updated to the GitHub repository.

Cheers.

I tried everything but still couldn't get it to work. I was hoping for a copy of the database I sent to you. That was the main reason why I trusted you with my database in the first place.

Who are you "Lazaruso"? When did you send me your database script? I think it was "Mangaku" who sent me the database.

I am surprised by your tone. Sorry, I will not be able to help you.