Kunena move to crowdin for the translations

Like announced in the release nots of the K6.4 RC4 release, Kunena project has moved to crowdin : crowdin.com/project/kunena-forum to manage translations from K6.4 and beyond. The RC4 release is the last version before the stable, so for all translators please update your translations on crowdin.

Transifex is keept for translations from K6.3 and the previous versions of Kunena.

Kunena 6.3.10 Released
The Kunena team has announce the arrival of Kunena 6.3.10[K 6.3.10] in stable which is now available for download as a native Joomla extension for J! 4.4.x/5.0.x/5.1.x/5.2.x. This version addresses most of the issues that were discovered in K 6.2 / K 6.3 and issues discovered during the last development stages of K 6.3
Note: Please go to the Kunena Dashboard after an upgrade so that the Kunena database tables are also updated.

Topics that are moved into this category are generally considered to be closed. Users may want to add additional information but these topics should not be resurrected in order to discuss new problems or unrelated matters.

Question Phpbb3 to Kunena / Fireboard Migration-Problem => Converter stopped without migrate users

More
14 years 1 month ago - 14 years 1 month ago #1 by proterra
Hi,

follow the description from here
docs.kunena.org/index.php/PHPBB3_to_Kunena

want to migrate from a phpbb3 Forum to Kunena, but if I start the converter it stops and only the topics and categories are migrate (with wrong umlauts) not the users.

This are the messages from the converter, after this it stops:

Importing data from phpBB
Connecting to Database... OK
Populating Categories... OK OK
Populating Messages Table... OK
Populating Messages_Text Table...

My Data:
Joomla 1.5.22 (empty without users or anyting)
Phpbb3: 3.0.6 | User: 1770 | Topics: 126038
MySQL: 5.0.51a-24+lenny4
PHP: 5 ( But with 4 it didn´t runs also)
Server time Out is 300sec enough I think, tested it with 500 with the same result

Can you help me
Last edit: 14 years 1 month ago by proterra.

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

More
14 years 1 month ago #2 by proterra
One step forward.

Can integrate all, but the code for the "//Populate Messages_Text Table" didn´t runs:

//Populate Messages_Text Table
echo "<br />Populating Messages_Text Table...\n";

$query="TRUNCATE TABLE `$joomla_db`.`{$joomla_dbprefix}fb_messages_text`";
$result = mysql_query($query) or die("<br />Invalid query:<br />$query<br />" . mysql_error());

$query="SELECT post_id, post_text FROM `$phpbb_db`.`{$phpbb_dbprefix}posts`";
$result = mysql_query($query) or die("<br />Invalid query:<br />$query<br />" . mysql_error());
$mtext = array();
$mpostid = array();
while ($row = mysql_fetch_object($result)) {
$text = addslashes($row->post_text);
$mtext[] = prep($text);
$mpostid[] = $row->post_id;
}
mysql_free_result($result);

for ($i=0; $i < count($mtext); $i++){
$query="INSERT INTO `$joomla_db`.`{$joomla_dbprefix}fb_messages_text`"
." (mesid, message) VALUES"
." (".$mpostid[$i].", \"".$mtext[$i]."\")";
$result = mysql_query($query) or die("<br />Invalid query:<br />$query<br />" . mysql_error());
}

echo "OK\n";

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

More
14 years 1 month ago #3 by proterra
solve this Problem: rename the phpbb3posts table to fb_messages_text and delete alle rows without post_id and post_text and rename them to mesid and message

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

Time to create page: 0.219 seconds