phpBB2 -> phpBB3 Upgrade Script Discussion
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!
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!
-
- Registered User
- Posts: 54
- Joined: Fri Mar 03, 2006 7:10 pm
- Location: Vilnius, Lithuania
- Contact:
Re: phpBB2 -> phpBB3 Upgrade Script Discussion
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...
Re: phpBB2 -> phpBB3 Upgrade Script Discussion
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()
- EXreaction
- Registered User
- Posts: 1555
- Joined: Sat Sep 10, 2005 2:15 am
Re: phpBB2 -> phpBB3 Upgrade Script Discussion
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?
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.
Re: phpBB2 -> phpBB3 Upgrade Script Discussion
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/
Re: phpBB2 -> phpBB3 Upgrade Script Discussion
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");
?>
Re: phpBB2 -> phpBB3 Upgrade Script Discussion
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...
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...
- 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
Are they on the same server? Can they share the same database?
Re: phpBB2 -> phpBB3 Upgrade Script Discussion
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
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
- 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
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.)
Re: phpBB2 -> phpBB3 Upgrade Script Discussion
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*
ah well thanks tho *sigh*