Conversion (Help)

Get help with installation and running phpBB 3.0.x here. Please do not post bug reports, feature requests, or MOD-related questions here.
Ideas Centre
Forum rules
END OF SUPPORT: 1 January 2017 (announcement)
User avatar
JezUK1
Registered User
Posts: 735
Joined: Wed Jul 27, 2005 11:12 pm
Location: England, Somerset
Contact:

Conversion (Help)

Post by JezUK1 »

Hi all I have got to the part were it tells you this:

All pre-conversion steps have successfully been completed. You may now begin the actual conversion process. Please note that you may have to manually do and adjust several things. After conversion, especially check the permissions assigned, rebuild your search index which is not converted and also make sure files got copied correctly, for example avatars and smilies.

After I see that I press Continue Conversion and then I get this comming up I think its from my server.:
Error 500 - Internal server error
An internal server error has occured!
Please try again later.

Can anyone please help me out?
Jez

ControlThis.co.uk - Your online model shop
User avatar
JezUK1
Registered User
Posts: 735
Joined: Wed Jul 27, 2005 11:12 pm
Location: England, Somerset
Contact:

Re: Conversion (Help)

Post by JezUK1 »

Please can someone help me out with this?
Jez

ControlThis.co.uk - Your online model shop
User avatar
Noxwizard
Support Team Leader
Support Team Leader
Posts: 10551
Joined: Mon Jun 27, 2005 8:41 pm
Location: Texas, USA
Name: Patrick Webster
Contact:

Re: Conversion (Help)

Post by Noxwizard »

You might try the solution here: http://www.phpbb.com/community/viewtopi ... 5#p3454105
I don't think it's been tested, so be sure to keep an original copy of the install_convert.php file.
[Support Template] - [Read Before Posting] - [phpBB Knowledge Base]
Do not contact me for private support, please share the question in our forums.
Pricelessparrots
Registered User
Posts: 224
Joined: Sat Dec 11, 2004 1:14 pm

Re: Conversion (Help)

Post by Pricelessparrots »

Im having the same problem mate, are you on 1and1 hosting company? Am not getting very far at the moment.
No one seems to be able to help with this as it seems to be a server error.. I have managed to install ok but nit convert and get the same error as you when converting.. very frustrating..
Paul
Regards
Paul
GarlicBread
Registered User
Posts: 29
Joined: Sat Aug 09, 2003 12:01 pm

Re: Conversion (Help)

Post by GarlicBread »

Likewise ..

I've installed phpBB3.0.0 Gold and (as I only have one database), used prefix phpbb3_ as the prefix for the tables (the existing phpBB2 uses the default phpbb_ prefix). All is well and the fresh install of 3, installs and works fine.

My problem, comes when I try and use the convert tab to convert my phpBB2 installation.

Using Firefox, I get as far as the "Conversion in Progress" tab .. press the "Continue Conversion" button, and the server just seems to sit there, with the hourglass spinning, before firefox eventually chucks up a window and I get prompted to download an "index.php" file (and if I do, it's 0 bytes in size).

If I use Internet Explorer, I just get a Server 500 error, and it just stops.

I have been tearing my hair out for hours now, and cannot get past this error.
User avatar
JezUK1
Registered User
Posts: 735
Joined: Wed Jul 27, 2005 11:12 pm
Location: England, Somerset
Contact:

Re: Conversion (Help)

Post by JezUK1 »

Hmmm this is driving me nuts.. Yes im with 1and1 hosting company! I have managed to install ok like youself Paul but not convert and get the same error when I try converting.. very frustrating.. ggrrr
Can anyone put some light onto this one please?
Jez

ControlThis.co.uk - Your online model shop
User avatar
KevC
Support Team Member
Support Team Member
Posts: 72343
Joined: Fri Jun 04, 2004 10:44 am
Location: Oxford, UK
Contact:

Re: Conversion (Help)

Post by KevC »

As this is a server side error you could install phpBB on your own PC using easyphp or XAMPP (1 click installs of the php, MySQL, phpmyadmin bits you need) and then do the conversion locally and restore the new database to the server.
-:|:- Support Request Template -:|:-
Image
"Step up to red alert. Sir, are you absolutely sure? It does mean changing the bulb"
Thomas_Cincy
Registered User
Posts: 3
Joined: Sat Dec 15, 2007 9:21 pm

Re: Conversion (Help)

Post by Thomas_Cincy »

User avatar
JezUK1
Registered User
Posts: 735
Joined: Wed Jul 27, 2005 11:12 pm
Location: England, Somerset
Contact:

Re: Conversion (Help)

Post by JezUK1 »

Kevin Clark wrote:As this is a server side error you could install phpBB on your own PC using easyphp or XAMPP (1 click installs of the php, MySQL, phpmyadmin bits you need) and then do the conversion locally and restore the new database to the server.
How do I do this?

I looked at the other link that I was told to look at and that did not work :(
Jez

ControlThis.co.uk - Your online model shop
User avatar
KevC
Support Team Member
Support Team Member
Posts: 72343
Joined: Fri Jun 04, 2004 10:44 am
Location: Oxford, UK
Contact:

Re: Conversion (Help)

Post by KevC »

I wrote this elsewhere a couple of days ago. It refers to easyphp1.8 http://www.easyphp.org

Easyphp has a www folder.
Whatever you put in there acts like your servers public_html folder.

So, put phpBB2 and phpBB3 into www.

Go to the big e icon and choose configuration>phpmyadmin

Make a database for phpBB2 and run the 2x installation (click the e and choose localweb and then phpBB2). By default the database username is root and there's no password.

Now you have phpBB2 installed you need to get your database for that and restore it using bigdump (just google it - very easy to use).

You will now have your 2x board running on your PC.

Now make a database for phpBB3 and run that installation for that.

Now choose the converter option and it will convert your 2x database.

Backup the new 3x database and restore it to the real server.
-:|:- Support Request Template -:|:-
Image
"Step up to red alert. Sir, are you absolutely sure? It does mean changing the bulb"
User avatar
JezUK1
Registered User
Posts: 735
Joined: Wed Jul 27, 2005 11:12 pm
Location: England, Somerset
Contact:

Re: Conversion (Help)

Post by JezUK1 »

Ok really lost on how to bk up from admin useing bigdump?!?
Jez

ControlThis.co.uk - Your online model shop
User avatar
KevC
Support Team Member
Support Team Member
Posts: 72343
Joined: Fri Jun 04, 2004 10:44 am
Location: Oxford, UK
Contact:

Re: Conversion (Help)

Post by KevC »

Bigdump is used to restore the database, not back it up.
Basically, phpmyadmin can't restore a database over about 2Mb so you use bigdump instead. It allows you to upload the .sql file to the server and restore it from there using the db info you put into the bigdump file. Then bigdump does the restore for you.
-:|:- Support Request Template -:|:-
Image
"Step up to red alert. Sir, are you absolutely sure? It does mean changing the bulb"
User avatar
JezUK1
Registered User
Posts: 735
Joined: Wed Jul 27, 2005 11:12 pm
Location: England, Somerset
Contact:

Re: Conversion (Help)

Post by JezUK1 »

Sorry I ment to mean restore not back up...ooppsss which info for the database do I use? The old forum which is on the intermet or the one which I have made on my computer?
Jez

ControlThis.co.uk - Your online model shop
User avatar
KevC
Support Team Member
Support Team Member
Posts: 72343
Joined: Fri Jun 04, 2004 10:44 am
Location: Oxford, UK
Contact:

Re: Conversion (Help)

Post by KevC »

The bigdump site has more info on how to use it.

Essentially you make a folder in the phpBB folder. Put the .sql file in it. Then put the bigdump.php file in it.
About 40 or so lines down from the top of that file is a bit where you have to enter the database info for the one you want to restore. Then point your browser at that bigdump file and you'll get a screen where you click on the database file name and it'll chug through and restore it for you.
-:|:- Support Request Template -:|:-
Image
"Step up to red alert. Sir, are you absolutely sure? It does mean changing the bulb"
User avatar
JezUK1
Registered User
Posts: 735
Joined: Wed Jul 27, 2005 11:12 pm
Location: England, Somerset
Contact:

Re: Conversion (Help)

Post by JezUK1 »

Ok cool I belive I have soted that. I have backed up the info just trying to install phpbb3 on my computer. But can you help me with this? What do I put for this

Database server hostname or DSN:
DSN stands for Data Source Name and is relevant only for ODBC installs.
Database server port:
Prefix for tables in database:
Jez

ControlThis.co.uk - Your online model shop
Locked

Return to “[3.0.x] Support Forum”