PHP-NUKE to phpBB3 Convertor 1.2

Converting from other board software? Good decision! Need help? Have a question about a convertor? Wish to offer a convertor package? Post here.
Ideas Centre
Locked
User avatar
D¡cky
Former Team Member
Posts: 11812
Joined: Tue Jan 25, 2005 8:38 pm
Location: New Hampshire, USA
Name: Richard Foote
Contact:

Re: PHP-NUKE to phpBB3 Convertor 1.2

Post by D¡cky »

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.
Have you hugged someone today?
User avatar
BellaChiCa
Registered User
Posts: 36
Joined: Sun Dec 07, 2008 1:16 am

Re: PHP-NUKE to phpBB3 Convertor 1.2

Post by BellaChiCa »

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
Registered User
Posts: 1
Joined: Tue Feb 01, 2011 1:21 am

Error with PHP-NUKE to phpBB3 Convertor 1.2

Post by evtooms »

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)
User avatar
D¡cky
Former Team Member
Posts: 11812
Joined: Tue Jan 25, 2005 8:38 pm
Location: New Hampshire, USA
Name: Richard Foote
Contact:

Re: PHP-NUKE to phpBB3 Convertor 1.2

Post by D¡cky »

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
Have you hugged someone today?
teckynou
Registered User
Posts: 4
Joined: Fri Feb 04, 2011 8:28 am

Re: PHP-NUKE to phpBB3 Convertor 1.2

Post by teckynou »

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
User avatar
D¡cky
Former Team Member
Posts: 11812
Joined: Tue Jan 25, 2005 8:38 pm
Location: New Hampshire, USA
Name: Richard Foote
Contact:

Re: PHP-NUKE to phpBB3 Convertor 1.2

Post by D¡cky »

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');
Have you hugged someone today?
teckynou
Registered User
Posts: 4
Joined: Fri Feb 04, 2011 8:28 am

Re: PHP-NUKE to phpBB3 Convertor 1.2

Post by teckynou »

it doesn't works :(

Apache log :

Code: Select all

Parent: child process exited with status 3221225725 -- Restarting.
User avatar
D¡cky
Former Team Member
Posts: 11812
Joined: Tue Jan 25, 2005 8:38 pm
Location: New Hampshire, USA
Name: Richard Foote
Contact:

Re: PHP-NUKE to phpBB3 Convertor 1.2

Post by D¡cky »

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.
Have you hugged someone today?
teckynou
Registered User
Posts: 4
Joined: Fri Feb 04, 2011 8:28 am

Re: PHP-NUKE to phpBB3 Convertor 1.2

Post by teckynou »

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
Registered User
Posts: 4
Joined: Fri Feb 04, 2011 8:28 am

Re: PHP-NUKE to phpBB3 Convertor 1.2

Post by teckynou »

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.
User avatar
D¡cky
Former Team Member
Posts: 11812
Joined: Tue Jan 25, 2005 8:38 pm
Location: New Hampshire, USA
Name: Richard Foote
Contact:

Re: PHP-NUKE to phpBB3 Convertor 1.2

Post by D¡cky »

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.
Have you hugged someone today?
pissa
Registered User
Posts: 4
Joined: Fri Feb 18, 2011 7:17 am

Re: PHP-NUKE to phpBB3 Convertor 1.2

Post by pissa »

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.
User avatar
D¡cky
Former Team Member
Posts: 11812
Joined: Tue Jan 25, 2005 8:38 pm
Location: New Hampshire, USA
Name: Richard Foote
Contact:

Re: PHP-NUKE to phpBB3 Convertor 1.2

Post by D¡cky »

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?
Have you hugged someone today?
pissa
Registered User
Posts: 4
Joined: Fri Feb 18, 2011 7:17 am

Re: PHP-NUKE to phpBB3 Convertor 1.2

Post by pissa »

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 :oops:
Where do I check?
User avatar
D¡cky
Former Team Member
Posts: 11812
Joined: Tue Jan 25, 2005 8:38 pm
Location: New Hampshire, USA
Name: Richard Foote
Contact:

Re: PHP-NUKE to phpBB3 Convertor 1.2

Post by D¡cky »

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 :oops:
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.
Have you hugged someone today?
Locked

Return to “[3.0.x] Convertors”