PHP-NUKE to phpBB3 Convertor 1.2

D¡cky · Post by **D¡cky** » Fri Jan 28, 2011 3:55 am

BellaChiCa,

The convertor will not work for a partial conversion. It is an all or nothing type of tool.

I suggest that you use Import Users Tool. The one at http://www.phpbb.com/community/viewtopi ... #p12928060 might be best for you. Using phpMyAdmin, select the 500 users (maybe using the registration date as criteria?) and export into a csv file.

BellaChiCa · Post by **BellaChiCa** » Fri Jan 28, 2011 1:52 pm

Dicky, thanks for your fast reply! I tried the import tool, but it does not work. I'll place my fault into the topic you gave me to keep it ontopic.

evtooms · Post by **evtooms** » Tue Feb 01, 2011 1:35 am

Hi! (and sorry for my bad English) I have a little problem with this tool : I am trying to convert a big PHP-Nuke bulletin board (~ 130k posts) but unfortunately, after c. 80k posts, I get the following error :

Code: Select all

SQL ERROR [ mysql4 ]

MySQL server has gone away [2006]

SQL

SELECT bbprivmsgs.privmsgs_id, bbprivmsgs.privmsgs_from_userid AS poster_id, bbprivmsgs.privmsgs_ip, bbprivmsgs.privmsgs_date, bbprivmsgs.privmsgs_enable_bbcode AS enable_bbcode, bbprivmsgs.privmsgs_enable_html AS enable_html, bbprivmsgs.privmsgs_enable_smilies AS enable_smilies, bbprivmsgs.privmsgs_attach_sig, bbprivmsgs.privmsgs_subject, bbprivmsgs.privmsgs_date AS post_time, bbprivmsgs_text.privmsgs_text, bbprivmsgs_text.privmsgs_bbcode_uid AS old_bbcode_uid, bbprivmsgs.privmsgs_to_userid FROM nuke_bbprivmsgs bbprivmsgs, nuke_bbprivmsgs_text bbprivmsgs_text WHERE (bbprivmsgs.privmsgs_id = bbprivmsgs_text.privmsgs_text_id) ORDER BY bbprivmsgs.privmsgs_id LIMIT 2000

BACKTRACE

FILE: includes/db/mysql.php
LINE: 175
CALL: dbal->sql_error()

FILE: includes/db/mysql.php
LINE: 222
CALL: dbal_mysql->sql_query()

FILE: includes/db/dbal.php
LINE: 170
CALL: dbal_mysql->_sql_query_limit()

FILE: install/install_convert.php
LINE: 1233
CALL: dbal->sql_query_limit()

FILE: install/install_convert.php
LINE: 203
CALL: install_convert->convert_data()

FILE: install/index.php
LINE: 409
CALL: install_convert->main()

FILE: install/index.php
LINE: 286
CALL: module->load()

I have to say that, because of the short time-out periods of the server, I had to restart the operations via the "Continue previously started conversion" every 12.000 posts. But it worked, until around the 80.000th post.

I really don't know what I should do... could you please help me finding a solution? Thanks a lot for your help and congratulations for having developped this very useful tool!

Eugene Victor Tooms (66 Exeter St, Baltimore MD)

D¡cky · Post by **D¡cky** » Tue Feb 01, 2011 5:38 pm

For the "MySQL server has gone away" error, you need to contact your hosting provider to see if they will raise the limits for you. See MySQL Server Has Gone Away for some common causes of this problem.

If your host will not raise the limits, you will need to do the conversion locally or on another server. Use EasyPHP, WampServer, or XAMPP. Some helpful tips are in this Knowledge Base article, Offline Conversions

teckynou · Post by **teckynou** » Fri Feb 04, 2011 8:32 am

HI

I'm trying to convert my PHPnuke 8.0 to PHPbb3, but I have a problem.

At step 16 (PHPbb_posts), Apache serveur crash after more than 120000 raws.When I try to continue the convertion, it crach again and again.

I'm using Easyphp 5.3.5.0 ans windows 7.

What can i do?

Thanks

D¡cky · Post by **D¡cky** » Sat Feb 05, 2011 5:39 am

You can try this:

Open phpbb3/install/install_convert.php

Find:

Code: Select all

<?php
/**
*
* @package install
* @version $Id$
* @copyright (c) 2006 phpBB Group
* @license http://opensource.org/licenses/gpl-license.php GNU Public License
*
*/

/**
*/

After add:

Code: Select all

@set_time_limit(0);
@ini_set('memory_limit', '256M');
@ini_set('upload_max_filesize', '128M');
@ini_set('post_max_size', '256M');
@ini_set('max_input_time', '-1');
@ini_set('max_execution_time', '-1');
@ini_set('expect.timeout', '-1');
@ini_set('default_socket_timeout', '-1');

teckynou · Post by **teckynou** » Sat Feb 05, 2011 10:15 am

it doesn't works

Apache log :

Code: Select all

Parent: child process exited with status 3221225725 -- Restarting.

D¡cky · Post by **D¡cky** » Sat Feb 05, 2011 4:05 pm

Does the convertor stop in the same place every time? Check the phpBB3 posts table and see what the last entry is. It may be that you have a very large post or a post with a long unbroken string of characters. If this is the case, the post will be in the next batch of posts to be inserted.

teckynou · Post by **teckynou** » Mon Feb 07, 2011 10:29 am

The converter does not stop at exactly the same place

When I start a new convertion, the last post_id is about 150230 +/- 20.
When i try to resume an aborted conversion, it never increment.

does it mean that there is a "bad" post in the 2000 next post_id ?

teckynou · Post by **teckynou** » Mon Feb 07, 2011 11:09 am

I change some settings in the install_convert.php file :

Code: Select all

var $batch_size = 1; //2000
var $num_wait_rows = 1; //20

Then, I resume the conversion, and wait for the crash.

I check the last post_id in phpbb_posts, and then, the next post_text (with post_id+1) in the nuke_bbpost_text table.

Here is what I have :

Code: Select all

[quote:6144a1375b=""]

 01-02-2008 a 19:20, nico91 :

Pour ce qui l&acute;on louper comme moi j&acute;ai regarder les redif et il passe cette nuit à 1h40 sur fance 2  ;-) 

[/quote:6144a1375b]

J ai loupé le reportage  :-| tanpis 

<form action="https://www.paypal.com/cgi-bin/webscr" method="post">

<input type="hidden" name="cmd" value="_s-xclick">

<input type="image" src="https://www.paypal.com/fr_FR/FR/i/btn/btn_donate_LG.gif" border="0" name="submit" alt="Effectuez vos paiements via PayPal : une solution rapide, gratuite et sécurisée">

<img alt="" border="0" src="https://www.paypal.com/fr_FR/i/scr/pixel.gif" width="1" height="1">

<input type="hidden" name="encrypted" value="-----BEGIN PKCS7-----MIIHPwYJKoZIhvcNAQcEoIIHMDCCBywCAQExggEwMIIBLAIBADCBlDCBjjELMAkGA1UEBhMCVVMxCzAJBgNVBAgTAkNBMRYwFAYDVQQHEw1Nb3VudGFpbiBWaWV3MRQwEgYDVQQKEwtQYXlQYWwgSW5jLjETMBEGA1UECxQKbGl2ZV9jZXJ0czERMA8GA1UEAxQIbGl2ZV9hcGkxHDAaBgkqhkiG9w0BCQEWDXJlQHBheXBhbC5jb20CAQAwDQYJKoZIhvcNAQEBBQAEgYBgByYQxpZSBLyhb8jeiNXaL84uBIlObmkCe83fHgB3hecmublejnNAa95W7m02gPpYmESecCRLcC9N7jAKW/m32cGLWM6YDFjA4BV4AYQad3YX6lQBteEkL55WVk7hj39E9/v1z5tG4QZU38OZtFVp+lhEssHnL3s8Q57vwNapPjELMAkGBSsOAwIaBQAwgbwGCSqGSIb3DQEHATAUBggqhkiG9w0DBwQIHpzlph3lkVSAgZgFObuM2W+5kyPy2O0akAMy6gvzUPtrFBHJt6PGg5n7tWXn6a0pObdTU03ZZKdi37U0Cn8Yhk74WeO483aCEeGEwXeS0sngxpvVVxeG3/t6mI7QzGK7L3BD5uHIkxwlavM6RhI1V11N23Ru8KXNm7gHSN0LNbsoEmjzdpUojy+6lTxWJ0fAYZhNM4L1ehaa5iiwKhjIXJFWwaCCA4cwggODMIIC7KADAgECAgEAMA0GCSqGSIb3DQEBBQUAMIGOMQswCQYDVQQGEwJVUzELMAkGA1UECBMCQ0ExFjAUBgNVBAcTDU1vdW50YWluIFZpZXcxFDASBgNVBAoTC1BheVBhbCBJbmMuMRMwEQYDVQQLFApsaXZlX2NlcnRzMREwDwYDVQQDFAhsaXZlX2FwaTEcMBoGCSqGSIb3DQEJARYNcmVAcGF5cGFsLmNvbTAeFw0wNDAyMTMxMDEzMTVaFw0zNTAyMTMxMDEzMTVaMIGOMQswCQYDVQQGEwJVUzELMAkGA1UECBMCQ0ExFjAUBgNVBAcTDU1vdW50YWluIFZpZXcxFDASBgNVBAoTC1BheVBhbCBJbmMuMRMwEQYDVQQLFApsaXZlX2NlcnRzMREwDwYDVQQDFAhsaXZlX2FwaTEcMBoGCSqGSIb3DQEJARYNcmVAcGF5cGFsLmNvbTCBnzANBgkqhkiG9w0BAQEFAAOBjQAwgYkCgYEAwUdO3fxEzEtcnI7ZKZL412XvZPugoni7i7D7prCe0AtaHTc97CYgm7NsAtJyxNLixmhLV8pyIEaiHXWAh8fPKW+R017+EmXrr9EaquPmsVvTywAAE1PMNOKqo2kl4Gxiz9zZqIajOm1fZGWcGS0f5JQ2kBqNbvbg2/Za+GJ/qwUCAwEAAaOB7jCB6zAdBgNVHQ4EFgQUlp98u8ZvF71ZP1LXChvsENZklGswgbsGA1UdIwSBszCBsIAUlp98u8ZvF71ZP1LXChvsENZklGuhgZSkgZEwgY4xCzAJBgNVBAYTAlVTMQswCQYDVQQIEwJDQTEWMBQGA1UEBxMNTW91bnRhaW4gVmlldzEUMBIGA1UEChMLUGF5UGFsIEluYy4xEzARBgNVBAsUCmxpdmVfY2VydHMxETAPBgNVBAMUCGxpdmVfYXBpMRwwGgYJKoZIhvcNAQkBFg1yZUBwYXlwYWwuY29tggEAMAwGA1UdEwQFMAMBAf8wDQYJKoZIhvcNAQEFBQADgYEAgV86VpqAWuXvX6Oro4qJ1tYVIT5DgWpE692Ag422H7yRIr/9j/iKG4Thia/Oflx4TdL+IFJBAyPK9v6zZNZtBgPBynXb048hsP16l2vi0k5Q2JKiPDsEfBhGI+HnxLXEaUWAcVfCsQFvd2A1sxRr67ip5y2wwBelUecP3AjJ+YcxggGaMIIBlgIBATCBlDCBjjELMAkGA1UEBhMCVVMxCzAJBgNVBAgTAkNBMRYwFAYDVQQHEw1Nb3VudGFpbiBWaWV3MRQwEgYDVQQKEwtQYXlQYWwgSW5jLjETMBEGA1UECxQKbGl2ZV9jZXJ0czERMA8GA1UEAxQIbGl2ZV9hcGkxHDAaBgkqhkiG9w0BCQEWDXJlQHBheXBhbC5jb20CAQAwCQYFKw4DAhoFAKBdMBgGCSqGSIb3DQEJAzELBgkqhkiG9w0BBwEwHAYJKoZIhvcNAQkFMQ8XDTA4MDIwMjAyMDEzNlowIwYJKoZIhvcNAQkEMRYEFP45UB2jqBrpCfFXZJ/EXO5UXLm0MA0GCSqGSIb3DQEBAQUABIGAV7EYqXt3EQi/yrQFi70N6mrgacODdyMGXVbTqehGBD8E45OnhyWXmU+kbOUH4PejqA0Jt5421qVkoUjWOrAapdasUDmyK2MTHZ9mgiDAVFYgf+4JXLOEVjXQO64KAdnGYNyykV+3l04T8EaFmI/AUZowZkB6yOYOXfGbm/mJ6EA=-----END PKCS7-----

">

</form>

Faite un don  :-]

I'll remove this f**king HTML code, And resume the conversion.

D¡cky · Post by **D¡cky** » Mon Feb 07, 2011 4:51 pm

teckynou wrote:I'll remove this f**king HTML code, And resume the conversion.

Yep, it is the long unbroken string of 2533 characters BEGIN PKCS7 and END PKCS7 that is causing the problem.

pissa · Post by **pissa** » Fri Feb 18, 2011 7:27 am

I'm trying to convert an exisiting phpbb2 board on my phpnuke8.0 based site into a phpbb3 board
and this seems like the way to go.
I installed phpBB3 without any errors.
Then I selected this converter and it verified all the information is correct and started the actual conversion
before coming to a halt with this error:

Fatal error: Call to a member function sql_return_on_error() on a non-object in modules\phpBB3\install\convertors\functions_nuke.php on line 1755

What could be wrong here?
I'm on php5.

D¡cky · Post by **D¡cky** » Fri Feb 18, 2011 4:51 pm

pissa wrote:Fatal error: Call to a member function sql_return_on_error() on a non-object in modules\phpBB3\install\convertors\functions_nuke.php on line 1755

Have you changed phpBB to use XCache or Eaccelerator?

pissa · Post by **pissa** » Fri Feb 18, 2011 6:32 pm

D¡cky wrote:
pissa wrote:Fatal error: Call to a member function sql_return_on_error() on a non-object in modules\phpBB3\install\convertors\functions_nuke.php on line 1755
Have you changed phpBB to use XCache or Eaccelerator?

Dicky: I'm not even sure what that means

Where do I check?

D¡cky · Post by **D¡cky** » Sat Feb 19, 2011 4:55 am

pissa wrote:
D¡cky wrote:
pissa wrote:Fatal error: Call to a member function sql_return_on_error() on a non-object in modules\phpBB3\install\convertors\functions_nuke.php on line 1755
Have you changed phpBB to use XCache or Eaccelerator?
Dicky: I'm not even sure what that means
Where do I check?

I am not sure. Start by looking at the phpbB3 config.php file and see what $acm_type is set to.

advertisements