phpBB2 -> phpBB3 Upgrade Script Discussion

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!
Post Reply
ndL
Registered User
Posts: 54
Joined: Fri Mar 03, 2006 7:10 pm
Location: Vilnius, Lithuania
Contact:

Re: phpBB2 -> phpBB3 Upgrade Script Discussion

Post by ndL »

any tips how to import HUGE databases GZIP format on your localhost machine, which are about 40mb ? would like to know any tips/configs that would help, because it takes me about 2 hours to upload whole database...

xorex
Registered User
Posts: 3
Joined: Tue Jun 13, 2006 10:41 am

Re: phpBB2 -> phpBB3 Upgrade Script Discussion

Post by xorex »

I am having an issue that I can't seem to figure out exactly what the problem is... is this a converter issue, or a mysql issue? Is anyone else seeing this?
General Error
SQL ERROR [ mysqli ]

Unknown column 'range' in 'where clause' [1054]

SQL

SELECT post_id, poster_id, post_approved, post_postcount, topic_id, forum_id FROM phpbb3_posts WHERE range = 0

BACKTRACE

FILE: includes/db/mysqli.php
LINE: 116
CALL: dbal->sql_error()

FILE: includes/functions_admin.php
LINE: 606
CALL: dbal_mysqli->sql_query()

FILE: includes/functions_admin.php
LINE: 520
CALL: delete_posts()

FILE: includes/functions_admin.php
LINE: 1641
CALL: delete_topics()

FILE: install/install_convert.php
LINE: 1185
CALL: sync()

FILE: install/install_convert.php
LINE: 613
CALL: install_convert->sync_forums()

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

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

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

User avatar
EXreaction
Registered User
Posts: 1555
Joined: Sat Sep 10, 2005 2:15 am

Re: phpBB2 -> phpBB3 Upgrade Script Discussion

Post by EXreaction »

DBM wrote: Thanks for the tip, HoL.

WAMP (and php 4.4.4 add-on) installed.

Any chance of a quick idiot's guide to performing the upgrade on there? :oops:



Copy all your files off your server via FTP, and put them in the WWW directory(make sure you keep them in a folder in there, don't make the WWW the phpBB root directory). Also, I would reccomend that you make another copy of those files and put them on your desktop or something if the files get messed up by the updater.

Get a backup of your database(from phpMyAdmin) from your server and import it via phpMyAdmin on your local server.

Edit your config.php and set all the info to fit your new db on your local server.

Do the upgrade.
Then upload your new files to your server, upload your new database(with phpMyAdmin if you didn't already install the db updates on your server, though I would reccomend you use the upgrade script on your server and do everything up until the end of the DB changes, then you would not need to re-upload the files to your server).

ndL wrote: any tips how to import HUGE databases GZIP format on your localhost machine, which are about 40mb ? would like to know any tips/configs that would help, because it takes me about 2 hours to upload whole database...


It should not take as long on your local host, because the files are not limited in speed by your web connection. :)
You will need to edit your php.ini and make the upload limit larger if it can not handle 40MB files.

User avatar
naderman
Consultant
Posts: 1727
Joined: Sun Jan 11, 2004 2:11 am
Location: Karlsruhe, Germany
Contact:

Re: phpBB2 -> phpBB3 Upgrade Script Discussion

Post by naderman »

xorex wrote: I am having an issue that I can't seem to figure out exactly what the problem is... is this a converter issue, or a mysql issue? Is anyone else seeing this?


Please report problems on the bugtracker http://www.phpbb.com/bugs/

Gumfuzi
Registered User
Posts: 232
Joined: Wed Apr 26, 2006 7:04 pm

Re: phpBB2 -> phpBB3 Upgrade Script Discussion

Post by Gumfuzi »

ndL wrote: any tips how to import HUGE databases GZIP format on your localhost machine, which are about 40mb ? would like to know any tips/configs that would help, because it takes me about 2 hours to upload whole database...

maybe this helps (put in a php and run locally):

Code: Select all

<?
exec("gunzip dump.sql.gz");
exec("mysql -u LOGIN -pPASSWORD LOGIN < dump.sql");
?>
or run the commands within your DOS prompting box...

rYugen
Registered User
Posts: 5
Joined: Tue Feb 06, 2007 10:17 pm

Re: phpBB2 -> phpBB3 Upgrade Script Discussion

Post by rYugen »

for christs sake this is probably such an easy to fix problem but i just can't figure the path i have to use out....

thats my main domain: abi-2k8.de

it's straight when i login to FTP the /httpdocs/
not httpdocs/phpBB2 or something like that...

now i installed on 1 of the subdomains phpBB3

thats 1 of the subs: forum2.abi.2k8.de

it's when you log onto the FTP /subdomains/forum2/httpdocs/
straight in there...not /subdomains/forum2/httpdocs/phpBB3 ok?

so what do is the relative path on disk to my former forum from the root of my phpBB install
i don't even understand which path they want...the one from phpBB3 or the one from phpBB2 install...

anyways i got no clue...tried many...

i'd be grateful for the information i'm not able to figure out myself...

User avatar
Nicholas the Italian
Registered User
Posts: 659
Joined: Mon Nov 20, 2006 11:19 pm
Location: 46°8' N, 12°13' E
Contact:

Re: phpBB2 -> phpBB3 Upgrade Script Discussion

Post by Nicholas the Italian »

Are they on the same server? Can they share the same database?

rYugen
Registered User
Posts: 5
Joined: Tue Feb 06, 2007 10:17 pm

Re: phpBB2 -> phpBB3 Upgrade Script Discussion

Post by rYugen »

yes they can and yes they do.

help ;<

Edit: btw this is the error:
Could not find path to your former forum. Please check your settings and try again.
» Specified source path was ../../httpdocs

User avatar
Nicholas the Italian
Registered User
Posts: 659
Joined: Mon Nov 20, 2006 11:19 pm
Location: 46°8' N, 12°13' E
Contact:

Re: phpBB2 -> phpBB3 Upgrade Script Discussion

Post by Nicholas the Italian »

rYugen wrote: Edit: btw this is the error:
Could not find path to your former forum. Please check your settings and try again.
» Specified source path was ../../httpdocs

Shouldn't it be...
../../../httpdocs/
:?:
(if not, I have no idea. might be a problem with subdomains.)

rYugen
Registered User
Posts: 5
Joined: Tue Feb 06, 2007 10:17 pm

Re: phpBB2 -> phpBB3 Upgrade Script Discussion

Post by rYugen »

Well yea tried that as well got the error again....kinda sad that it's not workin...cuz subdomains are just a folder >.<...

ah well thanks tho *sigh*

Post Reply