Page 1 of 1

phpBB2 > phpBB3 conversion issue

Posted: Thu May 15, 2008 4:56 am
by ModemGuru
So I was having an issue where I would get a 500 internal server error when converting a phpBB2 MySQL database to phpBB3. After poking around on the forums I followed the instructions at:

http://www.phpbb.com/kb/article/offline-conversions/

Same issue though. Once I get to:

Code: Select all

http://127.0.0.1/phpBB3/install/index.php?mode=convert&sub=in_progress&tag=phpbb20&current_table=15&skip_rows=68934&language=en

it dies. I think it has something to do with the private messages table. Any thoughts as to what could be causing this? I can skip this table (enter the URL and set current_table=16 instead of 15) and it imports the rest of the way. It shows a count of private messages, but the messages themselves are not imported.

Thanks,
Brad

Re: phpBB2 > phpBB3 conversion issue

Posted: Thu May 15, 2008 5:20 am
by ModemGuru

Re: phpBB2 > phpBB3 conversion issue

Posted: Thu May 15, 2008 2:04 pm
by ModemGuru
In case it gets asked for:

Your board's URL: localhost (doing it offline)
Version of phpBB3: latest
Was this a fresh install or a(n) update/upgrade/conversion (please be specific)? conversion
Was this an install through your host? negative
MODs you have installed: none
When the problem started: conversion

Additionally, you may wish to provide the following (where applicable)
Template(s) used: default
Language(s) used: english
Version of PHP used: Whatever comes with Easyphp 1.18
Database and version used: MySQL / whatever comes with Easyphp 1.18

Re: phpBB2 > phpBB3 conversion issue

Posted: Thu May 15, 2008 5:30 pm
by ModemGuru
I just realized that I may have posted this in the wrong forum. Should I have posted it in the converter ( http://www.phpbb.com/community/viewforum.php?f=65 ) forum?

Re: phpBB2 > phpBB3 conversion issue

Posted: Mon May 19, 2008 3:50 pm
by ModemGuru
Anybody? :(

Re: phpBB2 > phpBB3 conversion issue

Posted: Wed May 21, 2008 1:54 pm
by ModemGuru
*bump*

Would it help if a Mod moved this to the conversion forum?

Re: phpBB2 > phpBB3 conversion issue

Posted: Thu May 22, 2008 2:24 pm
by ModemGuru
*24 hour bump*

Re: phpBB2 > phpBB3 conversion issue

Posted: Thu May 22, 2008 4:05 pm
by Noxwizard
Increase or disable the limits on your PHP Memory Limit and Max Execution Time in the php.ini.

Re: phpBB2 > phpBB3 conversion issue

Posted: Thu May 22, 2008 7:17 pm
by ModemGuru
I decided to try using XAMPP for the process as it is what I typically use for testing. I upped the memory limit from 32M to 1024M and upped the timeout from 60 to 9999.

I am receiving the following during upgrade:

Code: Select all

General Error
SQL ERROR [ mysql4 ]

MySQL server has gone away [2006]

SQL

UPDATE phpbb_config SET config_value = 'a:3:{s:4:\"step\";s:41:\"&current_table=15&skip_rows=69895\";s:12:\"table_prefix\";s:6:\"phpbb_\";s:3:\"tag\";s:7:\"phpbb20\";}' WHERE config_name = 'convert_progress'

BACKTRACE

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

FILE: includes/functions.php
LINE: 148
CALL: dbal_mysql->sql_query()

FILE: install/install_convert.php
LINE: 1539
CALL: set_config()

FILE: install/install_convert.php
LINE: 1417
CALL: install_convert->save_convert_progress()

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

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

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

Re: phpBB2 > phpBB3 conversion issue

Posted: Thu May 22, 2008 9:36 pm
by Noxwizard
You may need to adjust the MySQL timeout as well. There are also a few settings in /install/install_convert.php that you can tweak:

Code: Select all

// Batch size, can be adjusted by the conversion file
// For big boards a value of 6000 seems to be optimal
var $batch_size = 2000;
// Number of rows to be inserted at once (extended insert) if supported
// For installations having enough memory a value of 60 may be good.
var $num_wait_rows = 20;

Re: phpBB2 > phpBB3 conversion issue

Posted: Wed Mar 09, 2011 12:26 am
by bobber
ModemGuru wrote:So I was having an issue where I would get a 500 internal server error when converting a phpBB2 MySQL database to phpBB3. After poking around on the forums I followed the instructions at:

http://www.phpbb.com/kb/article/offline-conversions/

Same issue though. Once I get to:

Code: Select all

http://127.0.0.1/phpBB3/install/index.php?mode=convert&sub=in_progress&tag=phpbb20&current_table=15&skip_rows=68934&language=en

it dies. I think it has something to do with the private messages table. Any thoughts as to what could be causing this? I can skip this table (enter the URL and set current_table=16 instead of 15) and it imports the rest of the way. It shows a count of private messages, but the messages themselves are not imported.

Thanks,
Brad
THIS IS IT!!! THIS IS MY PROBLEM AS WELL. ooops, sorry for yelling but I'm ver tired. Has this been resolved? Is there any advise other than uping memory limits....done all that....bought the T-shirt....sang the song....but nothing....it still doesnt work for me and get's stuck at intermittent areas.

Re: phpBB2 > phpBB3 conversion issue

Posted: Tue Jun 28, 2011 1:53 pm
by spello
I have the same problem! And I did everything! Could someone help me, please?
On my server and on localhost I receive 500 server error. And I don't know why.

Re: phpBB2 > phpBB3 conversion issue

Posted: Tue Jun 28, 2011 1:58 pm
by Lumpy Burgertushie
spello wrote:I have the same problem! And I did everything! Could someone help me, please?
On my server and on localhost I receive 500 server error. And I don't know why.
this topic is three years old and the files that relate to it have probably changed etc.

please start a new topic and describe your problem in detail also;
Please fill out the Support Request Template Generator and post it back here to enable us to assist you better.

thanks,
robert

Re: phpBB2 > phpBB3 conversion issue

Posted: Tue Jun 28, 2011 2:09 pm
by spello