Error during conversion

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
spello
Registered User
Posts: 121
Joined: Sat May 28, 2011 11:12 am
Contact:

Error during conversion

Post by spello » Tue Jun 28, 2011 2:07 pm

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.
Last edited by spello on Tue Jun 28, 2011 8:53 pm, edited 1 time in total.

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: Error during conversion

Post by D¡cky » Tue Jun 28, 2011 4:26 pm

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

spello
Registered User
Posts: 121
Joined: Sat May 28, 2011 11:12 am
Contact:

Re: Error during conversion

Post by spello » Tue Jun 28, 2011 5:05 pm

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)
Last edited by spello on Tue Jun 28, 2011 8:53 pm, edited 2 times in total.

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: Error during conversion

Post by D¡cky » Tue Jun 28, 2011 5:44 pm

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

spello
Registered User
Posts: 121
Joined: Sat May 28, 2011 11:12 am
Contact:

Re: Error during conversion

Post by spello » Tue Jun 28, 2011 8:32 pm

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
Registered User
Posts: 121
Joined: Sat May 28, 2011 11:12 am
Contact:

Re: Error during conversion

Post by spello » Tue Jun 28, 2011 9:20 pm

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.

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: Error during conversion

Post by D¡cky » Tue Jun 28, 2011 9:40 pm

spello wrote: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.
spello wrote:

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?
Have you hugged someone today?

spello
Registered User
Posts: 121
Joined: Sat May 28, 2011 11:12 am
Contact:

Re: Error during conversion

Post by spello » Wed Jun 29, 2011 8:47 am

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

Image

Where is the problem? All 200000+ posts are fine in post_check.php!
Last edited by spello on Mon Jul 04, 2011 9:45 am, edited 2 times in total.

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: Error during conversion

Post by D¡cky » Wed Jun 29, 2011 4:30 pm

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

spello
Registered User
Posts: 121
Joined: Sat May 28, 2011 11:12 am
Contact:

Re: Error during conversion

Post by spello » Wed Jun 29, 2011 6:00 pm

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
Registered User
Posts: 121
Joined: Sat May 28, 2011 11:12 am
Contact:

Re: Error during conversion

Post by spello » Mon Jul 04, 2011 9:39 am

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:

Image

Image

spello
Registered User
Posts: 121
Joined: Sat May 28, 2011 11:12 am
Contact:

Re: Error during conversion

Post by spello » Mon Jul 04, 2011 10:12 am

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:

Image

I've got the same error.

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: Error during conversion

Post by D¡cky » Mon Jul 04, 2011 7:37 pm

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]
Have you hugged someone today?

spello
Registered User
Posts: 121
Joined: Sat May 28, 2011 11:12 am
Contact:

Re: Error during conversion

Post by spello » Sat Jul 09, 2011 7:57 pm

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 />

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: Error during conversion

Post by D¡cky » Sat Jul 09, 2011 10:19 pm

Thanks.
Have you hugged someone today?

Locked

Return to “[3.0.x] Convertors”