Local conversion problem

[Eindpeng]

Hi everyone!

I have a phpBB2 board which is in desperate need of upgrading.
Since the board is big, I decided to do it locally with XAMPP.

Installed phpBB2 and imported all the data from the online board. Installed phpBB3 and was about to convert it.
I start the conversion, the browser loads alot and then comes up with this error (Im using Google chrome):

Error 101 (net::ERR_CONNECTION_RESET): Unknown error.

I thought it was a timeout problem and therefor set this up in install_converter.php

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');


var $batch_size = 6000;
var $num_wait_rows = 10;

Didnt help. What can possibly be wrong? I have not edited any files, just installed phpBB2 and phpBB3 and tried converting. Any ideas?

Thanks in advance
Johan

[D¡cky]

The best thing I can tell you is to search the Internet for that error. It may have something to do with an anti-virus program you have installed on your computer.

[Eindpeng]

I have all anti-virus and firewalls deactivated. I just tried the converter on FireFox4, and then something interesting happened. It got to the first step, but when i clicked proceed i got the "The connection was reset" error. So maybe it is a timeout error after all? My settings are very generous though, its weird.

[D¡cky]

Problems with the convertor are a Blank page, a 500 Internal Server error or sometimes a MySQL has gone away error. I have not seen "The connection was reset" error with regards to the convertor, although it could be indicating a timeout error. I am not familiar with XAMPP, but you could try editing php.ini with larger values instead of using the code in install_convert.php

[Eindpeng]

I tried putting all the values that are now in the php-file above to php.ini, still doesnt work. Seems like the problem is locally, but i cant figure out what it is!

[D¡cky]

How big is your board? How many members do you have?

Is there any output at all to the screen after starting the conversion?
The first step the convertor does is check for colliding usernames. I am wondering if that is where it is choking.

[Eindpeng]

My board is about 20 000 posts and 200 members. About 150 of them (and rising by 20 per day) are bots, maybe that could be the problem? I will clean them all out manually and try again.

UPDATE: Cleared the bots, didnt help. Looked at the database. No members have been transferred, but there are data in the database. The forums are there for example.

[D¡cky]

Your board is small by today's standards so size is not an issue.

Did any topics or posts get converted?

Is there a userconv table in the phpBB3 database?

[Eindpeng]

I would say some posts and some topics. Not all of them.

There is no userconv table in the phpBB3 database.

[D¡cky]

If you have some posts, you should have all topics. You can tell by comparing the number of rows in the phpBB3 topics table to the number of rows in the phpBB2 topics table.

[Eindpeng]

I have all the topics and 10% of the posts converted. This is so odd, Its a clean install of phpBB3 and all the timeout settings are set in php.ini. I am very thankful for the help.

[D¡cky]

You may have a very large post or a post with a long unbroken string which will cause the convertor to stop. To find the post, open install_convert.php and find var $batch_size = 2000;.
Change the batch_size to a lower number, like 20.
When the convertor stops, look at the phpBB3 database in the phpbb_posts table and make a note of the last post inserted.
Look in the phpBB2 database at the posts table.
Without doing any sorting of the table, find the last post that was inserted into phpBB.
Look at the next 20 posts and see if you can find one that is very large or has a long unbroken string.

[Eindpeng]

Thank you very much! That did the trick. I found some very long posts. Deleteing them makes the converter work. I have now converted all the posts, but now its stuck again. Is there any good way to know where it stops, so i can investigate it in the database?

EDIT: I was wrong, it was only posts being the issue. Everything imported now! Thank you very very much for great help.

[pi0tr3k]

I've got the same problem as the others have, "the connection was reset".
I followed the steps that D¡cky mentioned in his reply and everything works ...

BUT

I have a DB with +3.000.000 posts, converted 134K posts so far. Every xx rows, I have an error with that connection was reset. So I have to set the batch_size to 2 and check where it gives an error.
My question is, is there a way to filter all broken posts from my phpbb2 DB and delete them at once, so I can set my convert batch_size back to 4000 so it goes faster?

Any help will be appreciated.

Cheers.

[D¡cky]

A script could be written to find problematic posts in the phpBB2 database. A member here had mentioned writing such a script, but it was not shared with us. The script could include deleting, or editing, a problem post when it finds one.