×
Kunena 5.2 RC 1 Released (25 Oct 2020)

The Kunena team is thrilled to announce the first public release candidate of Kunena 5.2, a native Joomla extension for Joomla 3.9. This is a development release and should be only be used for testing; this version is not recommended for live websites at this stage.

The purpose of this release is to encourage testing by downloading, installing and identifying any problems or shortcomings that people may discover. K 5.2.0 RC1 is stable and we are aware that people will discover defects. We encourage you to use the forum to report defects, as soon as they are discovered, so that the development team can work through the problems before the release of K 5.1 as a stable product. Reporting defects does not mean that the problems can or will be fixed. The Kunena team is looking forward to hearing your feedback on how well we have achieved our design goals.

Important Migrator is now available in our Downloads page

More
9 years 1 month ago #1 by Matias
Please visit our Download page. Kunena Forum Importer is the last item in the page.

The component should still be considered as experimental, so please test your new forum carefully after migration!
The following user(s) said Thank You: DTP2
The topic has been locked.
More
9 years 1 month ago - 9 years 1 month ago #2 by ron273
OK,

Installation is flawless, but when entering the component and choosing PHPBB3 conversion, the error message is:
Error: Table 'xxxxxxxxxx.phpbb_acl_roles' doesn't exist SQL=SELECT u.user_id AS userid, ag.forum_id AS catid FROM phpbb_acl_roles AS ar INNER JOIN phpbb_acl_groups AS ag ON ar.role_id=ag.auth_role_id INNER JOIN phpbb_user_group AS ug ON ug.group_id=ag.group_id INNER JOIN phpbb_users AS u ON u.user_id=ug.user_id AND u.user_id > 0 AND u.user_type != 2 WHERE role_type='m_' LIMIT 0, 10000

This has to do with the fact that not everybody uses the standard phpbb prefix phpbb_. In my case it is phpbb3_. Somewhere there needs to be an option to enter the phpbb table prefix, or an automated detection system.

The easiest solution is to add a prefix field to the config.xml file and make all references to phpbb table prefixes point to the config variable.

Cheers,

Ronald
Last edit: 9 years 1 month ago by ron273.
The topic has been locked.
More
9 years 1 month ago #3 by Matias
Yes, it was a mistake while copy/pasting the query. I'll provide a fix soon.
The topic has been locked.
More
9 years 1 month ago - 9 years 1 month ago #4 by ron273
Matias,

When creating a fix, also check out the rest of the file.

In line 383 and 384 of models/export_phpbb3.php you are using the joomla prefix #__ to point at a phpbb table. That seems incorrect. In my opinion it should be phpbb_ or even better a dynamic prefix, configurable in the component, as mentioned.

Cheers,

Ronald
Last edit: 9 years 1 month ago by ron273.
The topic has been locked.
More
9 years 1 month ago #5 by asusnet
I have try many times to install with Joomla installation but it have mistakes.
Is missing install files....

How can install it....
The topic has been locked.
More
8 years 10 months ago - 8 years 10 months ago #6 by oasisfleeting
I downloaded this, but it didn't work with my version of agora 3.0.13
So I wrote the following script to do the migration. This script only works one topic/thread at a time. So you'll have to create your categories in kunena first. I only had about 7-8 categories in agora so I didn't write a script for that.

Anyways, in order to use this you just need to change the id for t.forum_id to match the agora category/forum then change the $cat_id variable to match your new kunena category.

Maybe someone else might need it.
<?php
//enter your database credentials here.
$host = "";
$user = "";
$pass = "";
$db = "";
 
$link = mysql_connect($host,$user,$pass) or die(mysql_error());
mysql_selectdb($db,$link) or die(mysql_error());
 
//get the total thread count so we know where to start inserting posts.
$sql = "SELECT COUNT(id) AS total FROM j17_kunena_messages";
$res = mysql_query($sql) or die(mysql_error());
$res = mysql_fetch_object($res);
$thread = $res->total+1;
 
//manually change the t.forum_id to match the agora forum id. (forums are categories in kunena)
//manually change the table prefix as well. 
//t.forum_id = agora_topics.forum_id
$sql = "
SELECT p.message, p.poster AS mes_poster, t.poster AS topic_poster, t.subject, u.id AS user_id, u.email, p.posted, t.num_views
FROM j15_agora_topics AS t
LEFT JOIN j15_agora_posts AS p ON p.topic_id = t.id
LEFT JOIN j15_users AS u ON u.username = p.poster
WHERE t.forum_id = 6
ORDER BY p.topic_id ASC
";
 
//manually change the cat_id to match the category id from kunena
//cat_id == kunena_messages table
$cat_id = 10;
$parent_id = 0;
$subject = '';
$i = $thread;
$res = mysql_query($sql) or die(mysql_error());
while($row = mysql_fetch_object($res))
{        
        if($row->subject != $subject && $i != 0)
        {
            $thread = $i;
            $parent_id = 0;            
        }
 
        $sql = "INSERT INTO j17_kunena_messages VALUES (0, ".$parent_id.", ".$thread.", ".$cat_id.", '".$row->poster."', ".$row->user_id.", '".$row->email."', '".mysql_escape_string($row->subject)."', ".$row->posted.", 0, 0, 0, 0, 0, ".$row->num_views.", 0, NULL, NULL, NULL)";
 
        echo $sql;
        mysql_query($sql) or die(mysql_error());
        $id = mysql_insert_id();
        //if($parent_id == 0)
        $sql = "INSERT INTO j17_kunena_messages_text VALUES (".$id.", '".mysql_escape_string($row->message)."')";
 
        echo "<pre>";
        print_r($row);
        echo "</pre>";
 
        mysql_query($sql) or die(mysql_error());
        echo $sql . "<br/>";
    if($parent_id == 0)
        $parent_id = $id;    
    $subject = $row->subject;
    $i++;
}
 
echo $thread;
mysql_close();
?>

Don't forget to recount your kunena categories after you're finished.
Last edit: 8 years 10 months ago by oasisfleeting.
The topic has been locked.
More
8 years 10 months ago #7 by oasisfleeting
You'll want this script to reset the kunena tables to a fresh install in case you mess up.
DROP TABLE j17_kunena_messages;
DELETE FROM j17_kunena_messages_text;
 
CREATE TABLE IF NOT EXISTS `j17_kunena_messages` (
  `id` INT(11) NOT NULL AUTO_INCREMENT,
  `parent` INT(11) DEFAULT '0',
  `thread` INT(11) DEFAULT '0',
  `catid` INT(11) NOT NULL DEFAULT '0',
  `name` tinytext,
  `userid` INT(11) NOT NULL DEFAULT '0',
  `email` tinytext,
  `subject` tinytext,
  `time` INT(11) NOT NULL DEFAULT '0',
  `ip` VARCHAR(15) DEFAULT NULL,
  `topic_emoticon` INT(11) NOT NULL DEFAULT '0',
  `locked` tinyint(4) NOT NULL DEFAULT '0',
  `hold` tinyint(4) NOT NULL DEFAULT '0',
  `ordering` INT(11) DEFAULT '0',
  `hits` INT(11) DEFAULT '0',
  `moved` tinyint(4) DEFAULT '0',
  `modified_by` INT(7) DEFAULT NULL,
  `modified_time` INT(11) DEFAULT NULL,
  `modified_reason` tinytext,
  PRIMARY KEY  (`id`),
  KEY `thread` (`thread`),
  KEY `ip` (`ip`),
  KEY `userid` (`userid`),
  KEY `time` (`time`),
  KEY `locked` (`locked`),
  KEY `hold_time` (`hold`,`time`),
  KEY `parent_hits` (`parent`,`hits`),
  KEY `catid_parent` (`catid`,`parent`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=0 ;
The topic has been locked.
More
8 years 5 months ago #8 by Elnablo

Matias wrote: Please visit our Download page. Kunena Forum Importer is the last item in the page.

The component should still be considered as experimental, so please test your new forum carefully after migration!


Hi Matias,
when will the version for RC1 be ready? Really looking forward to it!
The topic has been locked.
More
8 years 5 months ago #9 by xillibit
We need to make changes to Kunena Importer component to make it to work under Joomla! 2.5

I don't provide support by PM, because this can be useful for someone else.
The topic has been locked.
More
8 years 4 months ago #10 by Elnablo
Do you have a timeline for the conversion?
The topic has been locked.
  • Not Allowed: to create new topic.
  • Not Allowed: to reply.
  • Not Allowed: to edit your message.
Time to create page: 0.123 seconds