phpBB2 > phpBB3 conversion issue

Get help with installation and running phpBB 3.0.x here. Please do not post bug reports, feature requests, or MOD-related questions here.
Scam Warning
Forum rules
END OF SUPPORT: 1 January 2017 (announcement)
Locked
ModemGuru
Registered User
Posts: 24
Joined: Wed Oct 13, 2004 5:40 pm

phpBB2 > phpBB3 conversion issue

Post by ModemGuru » Thu May 15, 2008 4:56 am

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


ModemGuru
Registered User
Posts: 24
Joined: Wed Oct 13, 2004 5:40 pm

Re: phpBB2 > phpBB3 conversion issue

Post by ModemGuru » Thu May 15, 2008 2:04 pm

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

ModemGuru
Registered User
Posts: 24
Joined: Wed Oct 13, 2004 5:40 pm

Re: phpBB2 > phpBB3 conversion issue

Post by ModemGuru » Thu May 15, 2008 5:30 pm

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?

ModemGuru
Registered User
Posts: 24
Joined: Wed Oct 13, 2004 5:40 pm

Re: phpBB2 > phpBB3 conversion issue

Post by ModemGuru » Mon May 19, 2008 3:50 pm

Anybody? :(

ModemGuru
Registered User
Posts: 24
Joined: Wed Oct 13, 2004 5:40 pm

Re: phpBB2 > phpBB3 conversion issue

Post by ModemGuru » Wed May 21, 2008 1:54 pm

*bump*

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

ModemGuru
Registered User
Posts: 24
Joined: Wed Oct 13, 2004 5:40 pm

Re: phpBB2 > phpBB3 conversion issue

Post by ModemGuru » Thu May 22, 2008 2:24 pm

*24 hour bump*

User avatar
Noxwizard
Support Team Leader
Support Team Leader
Posts: 10346
Joined: Mon Jun 27, 2005 8:41 pm
Location: Texas, USA
Name: Patrick Webster
Contact:

Re: phpBB2 > phpBB3 conversion issue

Post by Noxwizard » Thu May 22, 2008 4:05 pm

Increase or disable the limits on your PHP Memory Limit and Max Execution Time in the php.ini.
[Support Template] - [Read Before Posting] - [phpBB Knowledge Base]
Do not contact me for private support, please share the question in our forums.

ModemGuru
Registered User
Posts: 24
Joined: Wed Oct 13, 2004 5:40 pm

Re: phpBB2 > phpBB3 conversion issue

Post by ModemGuru » Thu May 22, 2008 7:17 pm

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

User avatar
Noxwizard
Support Team Leader
Support Team Leader
Posts: 10346
Joined: Mon Jun 27, 2005 8:41 pm
Location: Texas, USA
Name: Patrick Webster
Contact:

Re: phpBB2 > phpBB3 conversion issue

Post by Noxwizard » Thu May 22, 2008 9:36 pm

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;
[Support Template] - [Read Before Posting] - [phpBB Knowledge Base]
Do not contact me for private support, please share the question in our forums.

bobber
Registered User
Posts: 104
Joined: Thu Apr 21, 2005 1:05 pm
Contact:

Re: phpBB2 > phpBB3 conversion issue

Post by bobber » Wed Mar 09, 2011 12:26 am

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.

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

Re: phpBB2 > phpBB3 conversion issue

Post by spello » Tue Jun 28, 2011 1:53 pm

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.

User avatar
Lumpy Burgertushie
Registered User
Posts: 66811
Joined: Mon May 02, 2005 3:11 am
Contact:

Re: phpBB2 > phpBB3 conversion issue

Post by Lumpy Burgertushie » Tue Jun 28, 2011 1:58 pm

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
I'm baaaaaccckkkk. still doing work on donation basis. PM your needs.

Premium phpBB 3.2 Styles by PlanetStyles.net

If a tree falls in the forest and nobody is there, does it make a sound?

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

Re: phpBB2 > phpBB3 conversion issue

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


Locked

Return to “[3.0.x] Support Forum”