PHP Bulletin Board Home
News About Home
Features of phpBB Test drive phpBB Downloads Support for phpBB The phpBB Community Styles for customising phpBB 3rd party modifications to phpBB

Support Home | Knowledge Base Home | Submit Article | Search Articles | Browse Articles
 Upgrade to phpBB 2 from 1.4.x 
Description: How to upgrade a 1.4.x phpBB board to phpBB 2.
Author: sirco
Date: Tue Oct 29, 2002 5:25 pm
Type: HowTo
Keywords: upgrade, update, 1.4.x, phpBB1, phpBB 1
Category: Installing/upgrading/converting
It seems that some people encountered problems with upgrading ::
After it works on my Board, and it took a while... I decided to write down the whole Stuff.. so here it is...

-----------------------------------------------------------------------
HOW TO UPGRADE a 1.4.x Forum TO 2.0.2 Version

THE VERY FIRST :: BACKUP YOUR FORUM
GOTO PHPmyADMIN , AND Choose DUMP the Whole tables, which are:
access | banlist | catagories | config | disallow | forum_access | forum_mods | forums | headermetafooter | posts | posts.topics | priv_msgs | ranks | themes | topics | users | words


FIRST: some people have had some problems with Upgrading from 1.4.4 directly to 2.0.2
Some do suggest to Upgrade First from 1.4.4 to 2.0.0 , and THEN from 2.0.0 ==> 2.0.2
==> GET THE 2.0.0 HERE :: http://umn.dl.sourceforge.net/sourceforge/phpbb/phpBB-2.0.0.zip



::HOWTO Finaly:::

=> Upload the whole 2.0.0
=> CHMOD the empty config.php to 777
=> go to the path where you uploaded the 2.0.0 in the browser
(it should start if you just just call index.php : if there is no working config.php in the dir)
otherwise it should be possible to start with upgrade.php : then on the upcoming screen you should type in all the SQL access Data...

=> After doing that the conversion should start...

more or Less it sneakes through some OK Replies... maybe some errors ... if there are essential Errors, check back on the Forum...


some Remarks:
=> Upgrade should also work from 1.2.x (some posters at www.phpbb.com state, that it uses the same table structure as 1.4.4 )

=> the config.php should be the empty config.php CHModded to 777 otherwise Upgrade would probably not work - at least I had problems with that

=> The Download method [Download config.php : Which you get automaticaly asked if you have NOT CHModded the config.php seems not really to work (actually it didn't when I tried it several times : the Process of Upgrading seems to be highly automatised)


Sometimes there comes up an error called
:: phpBB : Critical Error
:: Could not obtain ban information


than Just do the following modifications...
----------------------------Solution ----------------------------------------------
you will need to edit your config.php to remove this line: Code:
define('PHPBB_INSTALLED', true);

Next, you need to edit your db/schemas/mysql_schema.php file. Find this code:Code:

CREATE TABLE phpbb_groups (
group_id mediumint(Cool NOT NULL,

and replace it with this:Code:

CREATE TABLE phpbb_groups (
group_id mediumint NOT NULL AUTO_INCREMENT,


Now run the installer as normal (using the upgrade option) and everything should run through

fine, resulting in a perfect upgrade.
[dont forget to chmod the config.php to 777 : the download method might not work]
-----------------------by Kier Darby---------------------------------------------
source of this info::: http://www.phpbb.com/phpBB/viewtopic.php?t=22346.

Then continue Do following ::
---------------------------------------------------------------------------------
Goto phpMyadmin , and perform the command

ALTER TABLE users ADD COLUMN user_timezone float DEFAULT '0' NOT NULL
-----------------------by psoTFX-------------------------------------------------
source of this info::: http://www.phpbb.com/phpBB/viewtopic.php?t=10263:

IF YOU HAVE USED HACKS , (OR DAVILSPHPBB) You will need to Downgrade your tables first to 1.4.4
A list how the tables should look like is in the install.php of version 1.4.4...
There are the commands which create them in the SQL Database. There you can see the structure...


If you are a DavilsphpBB user then you will find a HowTo here ==>
http://www.phpbb.de/viewtopic.php?t=9307



----------Update to 2.0.2--------------------------------------------------------
:::: OKEY SO THE UPGRADE TO 2.0.0 is done now... :::
=> Check if the Forum 2.0.0 Works ... Then
=> make A BACKUP of your working 2.0.0 Forum
=> meanwhile - Read Chapter 6.0 of INSTALL.html [in /docs]
basicly you just
=> download your old config.php form your working 2.0.0 Forum
=> Upload it to the 2.0.2 Directory (replacing the empty one which is already in there)

=> run the update_to_202.php

And it "Should" WORK...

Then this one Appears: "Hopefully"
-------------------------------------
Information
Database type :: mysql
Previous version :: 2.0.0
Updated version :: 2.0.2

Updating database schema
Progress :: .. Done
Result :: No errors

Updating data
Progress :: .. Done
Result :: No errors

Update completed
---------------------------------------------------------------------------------

=> DOUBLE Check all the Admin Infos in the Admin paneel [Login as ADMIN] if they are still okey...
actually it might loose some of the Board configuration e.g. Forum name maybe etc.

=> [remember to delete the | install.php | upgrade.php | update_to_202.php | Files after the Installation]

=> DONE have FUN Smile



:Sirco

[if there is anything missing here .. just complete it :: I hope this is a more or less straight Manual for Upgrading a 1.4.x Forum to 2.0.2]

[thanks to all the people which helped me during my upgrade process , which took me 2 full days(Fenris Wolf|Techie-Micheal(on IRC))]

Username: Password:
News | Features | Demo | Downloads | Support | Community | Styles | Mods | Links | Merchandise | About | Home
 © Copyright 2002 The phpBB Group.