Error during conversion

[spello]

I am converting forum from phpBB2 by Przemo to phpBB3. During conversion I receive 500 Internal Server Error

Code: Select all

The server encountered an unexpected condition which prevented it from fulfilling the request.
 The script had an error or it did not produce any output. If there was an error, you should be able to see it in the error log.

Also, I tried to do this offline on localhost, but I've got the same.

phpBB3 folder: http://e-gorniak.com/forum/
source (phpBB2 by Przemo): http://e-gorniak.com/v1/index.php

I would like to say that I was doing it before (with the same forum) about 8 months ago (to test the conversion) and everything was fine. But now I can't convert it.

Please help.

[D¡cky]

At what point do get the error?
Is there anything in the server error log?

You do know that you have to add a field to the Przemo users table before doing the conversion? This does not have anything to do with the 500 Internal Server error, though.

[spello]

Yes, I did it.
As I said, I was converting this forum eight months ago, just for testing what it will be like - there was no problem. But now I receive this server error.

There is nothing about it in error logs.

I think that it happens when the converter ends posts' table (17th step/28)

[D¡cky]

If it is happening during the conversion of the posts table, then most likely you have a very large post or a post with a long unbroken string of characters. Check the number of rows of the phpBB2 posts table against the number of rows in the phpBB3 posts table to see if they have all been converted or not.

If the posts have not all been converted, use this tool, Post Checking Tool to find the problematic post.

[spello]

Code: Select all

Counting characters in post messages.
No posts with greater than 50000 characters have been found

Find long words -> I've changed the longest words but when I click on "continue conversion" I receive the same error.

[spello]

When I am trying to do it from the beginning, at the moment when I was receiving 500 error, I get:

Code: Select all

Błąd ogólny
SQL ERROR [ mysql4 ]

User 'egorniak_phpb8' has exceeded the 'max_questions' resource (current value: 75000) [1226]

SQL

SELECT user_lang FROM phpbb_users WHERE user_id = 4440

BACKTRACE

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

FILE: install/convertors/functions_phpbb20.php
LINE: 388
CALL: dbal_mysql->sql_query()

FILE: install/convertors/functions_phpbb20.php
LINE: 1247
CALL: phpbb_set_encoding()

FILE: 
LINE: 
CALL: phpbb_prepare_message()

FILE: install/install_convert.php
LINE: 2025
CALL: call_user_func_array()

FILE: install/install_convert.php
LINE: 1276
CALL: install_convert->process_row()

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()

So if I understood it correctly, I have to wait one hour to have 'max_questions' limits reloaded and then I'll be able to continue, yes?

I hope it'll work.

[D¡cky]

When I am trying to do it from the beginning, at the moment when I was receiving 500 error, I get:

Code: Select all

Błąd ogólny
SQL ERROR [ mysql4 ]

User 'egorniak_phpb8' has exceeded the 'max_questions' resource (current value: 75000) [1226]

SQL

SELECT user_lang FROM phpbb_users WHERE user_id = 4440

BACKTRACE

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

FILE: install/convertors/functions_phpbb20.php
LINE: 388
CALL: dbal_mysql->sql_query()

FILE: install/convertors/functions_phpbb20.php
LINE: 1247
CALL: phpbb_set_encoding()

FILE: 
LINE: 
CALL: phpbb_prepare_message()

FILE: install/install_convert.php
LINE: 2025
CALL: call_user_func_array()

FILE: install/install_convert.php
LINE: 1276
CALL: install_convert->process_row()

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()

So if I understood it correctly, I have to wait one hour to have 'max_questions' limits reloaded and then I'll be able to continue, yes?

I hope it'll work.

That is correct. That is a server setting and has nothing to do with the convertor.

Code: Select all

Counting characters in post messages.
No posts with greater than 50000 characters have been found

Find long words -> I've changed the longest words but when I click on "continue conversion" I receive the same error.

That is not an error. That is an informational message. Lower the number of characters and see what you come up with. I can't tell you the number of characters that will cause a problem. There are too many variables involved. You are checking the phpBB2 database, correct?

[spello]

It not helped. The last screen before the error is:



Where is the problem? All 200000+ posts are fine in post_check.php!

[D¡cky]

It not helped. The last screen before the error is:

Where is the problem? All 200000+ posts are fine in post_check.php!

Why do you say all posts are fine in post_check.php?
You are checking the Prezmo database, correct?
What is the message you are getting from the tool? You may have to decrease the number of characters to look for in order to find a post that has a long string of unbroken characters.

[spello]

I still have some posts in Find long words, so I will fix all of them, and then let you know about what happend.

Yes, I'm doing it on Przemo's database.

[spello]

This didn't help!

I've fixed all post so I receive: No posts with words greater than 500 characters have been found.. Moreover, I've fixed all 200000+ posts with 200 characters limit!

Where is the problem?

Screens:

[spello]

I've changed phpbb3/install/install_convert.php adding:

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

and changing:
var $batch_size = 5;
var $num_wait_rows = 5;

but after:



I've got the same error.

[D¡cky]

Ah, the problem is in Private Messages now. If you don't have too many Private Messages, you could manually look through the Przemo Private Messages text table to see if you can find any extra large posts or a long unbroken string of characters or a lot of smilies in a row.

[EDIT] You can also use the post_check tool to check the private messages. Just enter the correct field names from the Przemo private messages text table. [/EDIT]

[spello]

Yes, it worked! Thank you soo much!

However, I've found little mistake in your script.
Find:

Code: Select all

This script created by <a href ="http://www.phpbb.com/community/memberlist.php?mode=viewprofile&u=163542>Dicky</a>.<br />

Change to:

Code: Select all

This script created by <a href ="http://www.phpbb.com/community/memberlist.php?mode=viewprofile&u=163542">Dicky</a>.<br />

[D¡cky]

Thanks.