Kunena 7.0.4 Released

The Kunena team has announce the arrival of Kunena 7.0.4 [K 7.0.4] 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

Tiago
Offline
New Member

11 years 2 months ago #162306 by Tiago

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

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 

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

binod
Topic Author
Offline
Junior Member

11 years 2 months ago #162307 by binod

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

How are you using this script? Online on phpMyAdmin or locally?

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.

Tiago
Offline
New Member

11 years 2 months ago #162309 by Tiago

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

binod wrote: How are you using this script? Online on phpMyAdmin or locally?

Online on phpMyAdmin...
Copy the code, paste on SQL and run.

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

binod
Topic Author
Offline
Junior Member

11 years 2 months ago - 11 years 2 months ago #162310 by binod

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

As I have said earlier (please read this long forum once again), phpMyAdmin would not be a great fit for this tool. So I suggest you to:

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.
5. Run the script.
6. Restore your phpBB3 Kunena migrated forum to your actual webserver.

I am giving up this topic since it has become huge, difficult to understand for a person who came here via search engines. I would want you to ask questions here, because it is the official forum of PhpBB to Kunena Migration Script.

mixerp.org/forum

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

Last edit: 11 years 2 months ago by binod.

The following user(s) said Thank You: Tiago

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

Tiago
Offline
New Member

11 years 2 months ago - 11 years 2 months ago #162315 by Tiago

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

I tryed with TOAD.
But now when I try to upload and import on the server I get this:

#1227 - Access denied; you need (at least one of) the SUPER privilege(s) for this operation

*I used the export option on the local phpMyAdmin to export the databse

Last edit: 11 years 2 months ago by Tiago.

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

Marvin McDuck
Offline
Junior Member

11 years 2 months ago #162456 by Marvin McDuck

Replied by Marvin McDuck on topic phpBB 3 to Kunena 3 Migration Script

binod wrote: Hi,

Can you provide me your database so I that I fully understand what the problem is? Since the scope of problem of this problem might be out of my domain, I cannot guarantee I will be able to solve this problem.

Binod, who is a Prince amongst Men, has looked at my problem, retraced my steps, edited my script and got it to work, noticed the same problem... And then realized :blush: it was my own stupid fault all along:

By default, Kunena's Search only displays messages less than a year old, and there were so few of them (as I'm working with an old SQL dump) that the outputs were haphazard-looking and I didn't notice the pattern. (And indeed, new messages would consistently turn up in results.)

So it's a matter for me just to edit the Search field and change the default, and/or write some warning next to the button.

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

Time to create page: 0.260 seconds