Discussion of general topics related to the new version and its place in the world. Don't discuss new features, report bugs, ask for support, et cetera. Don't use this to spam for other boards or attack those boards!
Forum rules
Discussion of general topics related to the new release and its place in the world. Don't discuss new features, report bugs, ask for support, et cetera. Don't use this to spam for other boards or attack those boards!
Wernight wrote:
I finally found how to solve my "MySQL server has gone away [2006]". One post had a huge amount of text "". I didn't look for the fault in the convertion tool but here is the SQL of that post.
I get that error on my test site when posting very long posts. It seems 3.x takes longer to post than 2.x.. The same post on the same server doesn't give an error on 2.x.
when the convertor gets to the end of conversion it shows cannot connect to host? does anyone else have this it times out alot along the way and i have to do back to the install root and continue with conversion?
Many hosts have low limits on how large a database can be.
What would work great is having the user copy config.php from their phpBB2 folder, then paste it in the install/convert/ folder and phpBB3 would automatically select the data from that database(actually, that is what we did with the Beta to Beta converters we made, it works very nicely)
maybe it helps to run the converter local with xampp etc. and when conversion is done you can delete the old tables and put it on the remote server - if two databases are too much for the provider limit.
Gumfuzi wrote:
maybe it helps to run the converter local with xampp etc. and when conversion is done you can delete the old tables and put it on the remote server - if two databases are too much for the provider limit.
Yes it may help. Check the encoding also (latin1/utf-8/...).
Gumfuzi wrote:
maybe it helps to run the converter local with xampp etc. and when conversion is done you can delete the old tables and put it on the remote server - if two databases are too much for the provider limit.
If you have remote access to your database you can run the converter on your local machine using your the database at your provider. But this takes a lot of time if you have a slow internet connection. I got 384kbit and it takes 11 hours converting a board with 65k posts.
Gumfuzi wrote:
maybe it helps to run the converter local with xampp etc. and when conversion is done you can delete the old tables and put it on the remote server - if two databases are too much for the provider limit.
If you have remote access to your database you can run the converter on your local machine using your the database at your provider. But this takes a lot of time if you have a slow internet connection. I got 384kbit and it takes 11 hours converting a board with 65k posts.
Best regards,
Dave
I have just over 15k posts and it took me about 1.5 hours to get it all uploaded... but I did the conversion all on my localhost, so I downloaded the database to my computer and did the conversion.
It was much faster to do the conversion on my computer than it was to do it on the server.
My phpBB3 Mods || My Mod Queue Search Engine Friendly (SEO) URLs || Profile link on Avatar and/or Username || AJAX Chat
Display Posts Anywhere || CashMod || AJAX Quick Edit || AJAX Quick Reply
Handyman wrote:
It was much faster to do the conversion on my computer than it was to do it on the server.
Depends on the server. If you're on shared hosting, to run the conversion on one's local PC could well be faster, though if you're on dedicated hosting, less one's local PC is some beefy multi-processor Xeon/Opteron with fast HDDs... running it on the server is far better.
". I didn't look for the fault in the convertion tool but here is the SQL of that post.
If you're on shared hosting, to run the conversion on one's local PC could well be faster, though if you're on dedicated hosting, less one's local PC is some beefy multi-processor Xeon/Opteron with fast HDDs... running it on the server is far better. 
