Kunena 6.3.7 Released

The Kunena team has announce the arrival of Kunena 6.3.7 [K 6.3.7] 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
13 years 10 months ago - 13 years 10 months 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: 13 years 10 months ago by proterra.

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

More
13 years 10 months 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
13 years 10 months 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.318 seconds