Idea phpBB 3 to Kunena 3 Migration Script

Glad I could help.

And thanks for the kind words.

I'm new to this, but is there meant to be a space after DELIMITER

So DELIMITER ;

Not

DELIMITER;

Tiago wrote: With the updated script...

Code:

Erro Comando SQL: DELIMITER; DROP FUNCTION IF EXISTS armada_oldforum.fix_tags; DELIMITER $$ CREATE FUNCTION armada_oldforum.fix_tags(msg text) RETURNS text DETERMINISTIC BEGIN IF(msg LIKE '%<a%>%</a>%') THEN SET msg = armada_oldforum.fix_url(msg); END IF; IF(msg LIKE '%[code%') THEN SET msg = armada_oldforum.fix_tag(msg, 'code'); END IF; IF(msg LIKE '%[b%') THEN SET msg = armada_oldforum.fix_tag(msg, 'b'); END IF; IF(msg LIKE '%[img%') THEN SET msg = armada_oldforum.fix_tag(msg, 'img'); END IF; IF(msg LIKE '%[quote%') THEN SET msg = armada_oldforum.fix_tag(msg, 'quote'); END IF; RETURN msg; END; $$ Mensagens do MySQL : Documentação #1304 - FUNCTION fix_tags already exists

After that change the script ran to the next stage for but then I received further errors, including the fix tags mentioned above (what is the tags in phpbb.com?)

I removed the reference to tags just to see what happens then I get this (changed my info);


I too was using PhpMyAdmin which is where I must be going wrong so wont make any progress? I've never done anything 'locally' so I'm struggling to get my head round it all since I'm starting from scratch

Hi Binod! Help me please!
I did everything according to your instructions.
1. download the dump of your phpBB3 database and restore that on your workstation.
2. Create a new Joomla installation or restore your existing joomla installation locally. Also, you will have to have the Kunena component installed first.
3. Downalod Toad for MySQL freeware.
4. Connect to your database server from Toad.
4.1 Rename phpbb_database_name, joomla_database_name, jos_.
4.2 Rename phpbb_ to phpbb3_.
4.3 RETURNS text CHARSET latin1 -> RETURNS text CHARSET utf8
5. Run the script.

I see an error:
Lookup Error - MySQL Database Error: Duplicate entry '--ultima-online-inceptum' for key 'alias'
INSERT INTO lnigrouse_uogames.gtOfd_kunena_aliases(alias, type, item, state) SELECT alias, 'catid', id, 0 FROM lnigrouse_uogames.gtOfd_kunena_categories

6. Restore your phpBB3 Kunena migrated forum to your actual webserver.
Open a message in the forum is not possible. For example: uogames.ru/joo/component/kunena/-uogames...hast-obnovleniya-045 - access is denied.
Link to forum: uogames.ru/joo/forum

I attach a file with the log.

An other issue.
On my PHPBB, i have users ID, like 157,158,159,161,162,165,178, etc...
There is some 'blank', like ID 160.

The script stuck cause of that.
Any idea ?

I've successfully migrate phpbb to Kunena (5 RC5).
Now my point redirect old topics url-s from phpbb to new topic url-s (Kunena).
(htaccess of course).
Redirect for categories - is quite fast (i've 4 categories ).
Redirect all topics to main-forum-page - i think not best decision.

Do we have some rules or tools that can automate this process?
Or i should manually write rule for htaccess for every topic?