Updating phpBB3 Beta5 to RC1 Tutorial+Script

Support for upgrading any version of your phpBB3 installation
Forum rules
READ: StarTrekGuide.com Board Rules

Support for upgrading any version of phpBB3 to the most recent version.

Updating phpBB3 Beta5 to RC1 Tutorial+Script

Postby ..::Frans::.. » 21 May 2007, 06:59

Here we go.

I created an update script from phpbb3B5 -> RC1, but before we get started, please take the time to read this posting completely.

BEFORE doing anything, PLEASE BACK UP YOUR DATABASE!!! (going to say that again and again!!!!)

Let's start with the two common errors that are popping up right now.

The first one:
General Error
SQL ERROR [ mysql ]

Table 'b5.phpbb_styles_imageset_data' doesn't exist [1146]

SQL

SELECT * FROM phpbb_styles_imageset_data WHERE imageset_id = 1 AND image_lang IN('en', '')

BACKTRACE


FILE: includes/db/mysql.php
LINE: 133
CALL: dbal_mysql->sql_error()

FILE: includes/session.php
LINE: 1395
CALL: dbal_mysql->sql_query()

FILE: index.php
LINE: 23
CALL: user->setup()


and the second one:
General Error
Could not get style data


If you are seeing the first error (similar one) then you had a running phpbb3B5 forum, uploaded the new RC1 files overwriting the old ones and tried to browse your board with this result. What you need to do FIRST is to browse to your board and run {ROOT}/install/database_update.php. DO THIS NOW before anything else!

NEXT, PLEASE BACK UP YOUR DATABASE IF YOU DIDN'T DO SO ALREADY!!!

After running the database_update.php file from your browser (could take a minute or so) you are stuck with Error # 2, and that's where we want to be. (Yes, you do have an error in the update database script, that's the problem we want to solve!)

Right, everyone now has a non-working board, with files updated to version RC1 and a non-working database (with style-errors)

Next: Download the attached zip-file, unpack it and upload the file: update_B5_to_RC1.php to the root of your board.
After this, run the file from your browser (http://{ROOT}/update_B5_to_RC1.php)

When this update script is done, DELETE the file update_B5_to_RC1.php FIRST before doing anything else!!!!!!

Now you can browse to the index of your forum. Go to the ACP, install all styles you had before, install all languages you had before and you are up and running again.

Again, all the steps leading to a succesful update:

Step 1. Start with phpbb3B5 (No other version !)
Step 2. Create a copy of {ROOT}/config.php on your desktop
Step 3. Upload all files from version RC1 overwriting all the old files
Step 4. Upload your saved copy of config.php to {ROOT} overwriting the old one
Step 5. Run {ROOT}/install/database_update.php (forget the error, may take a minute!)
Step 6. DELETE all files from your {ROOT}/cache directory except index.htm and .htaccess
Step 7. Upload included file update_B5_to_RC1.php to {ROOT}/update_B5_to_RC1.php
Step 8. Execute {ROOT}/update_B5_to_RC1.php from your browser
Step 9. DELETE {ROOT}/update_B5_to_RC1.php
Step 10. Visit your board, log in into the ACP and change nessecary settings

BE AWARE, although i gave Highway a copy of this update script, he just hasn't had the time to verify this script. USE IT AT YOUR OWN RISK!!!!!!!!

Good luck to you all and please remember:

ALWAYS BACK UP YOUR DATABASE!!!

:good:

Current Version: 0.2
Version changes:
Version 0.1:
- First working version

Version 0.2:
- Added support for ALL phpbb supported databases
- Added prefix support
- Fixed php error in script when error_checking was set to E_ALL
- Added 1 step in the tutorial (step 6)

Version 0.3:
- Added checks for variables and file (config.php)
- Script dies when not all information needed is available


@Highway: THNX for changing my username.....;)
Attachments
Update phpbb3B5 to RC1 version 3.zip
(4.45 KiB) Downloaded 882 times
Last edited by ..::Frans::.. on 22 May 2007, 04:21, edited 4 times in total.
ping...
User avatar
..::Frans::..
STG Development
STG Development
 
Posts: 1608
Joined: 28 Mar 2007, 15:37
Location: Netherlands
Favorite Team: RKC
Gender: Male
phpBB Knowledge: 9


Updating phpBB3 Beta5 to RC1 Tutorial+Script2

Postby Patricia » 21 May 2007, 08:32

..::Frans::.. wrote:Here we go.

I created an update script from phpbb3B5 -> RC1, but before we get started, please take the time to read this posting completely.

BEFORE doing anything, PLEASE BACK UP YOUR DATABASE!!! (going to say that again and again!!!!)

Let's start with the two common errors that are popping up right now.

The first one:
General Error
SQL ERROR [ mysql ]

Table 'b5.phpbb_styles_imageset_data' doesn't exist [1146]

SQL

SELECT * FROM phpbb_styles_imageset_data WHERE imageset_id = 1 AND image_lang IN('en', '')

BACKTRACE


FILE: includes/db/mysql.php
LINE: 133
CALL: dbal_mysql->sql_error()

FILE: includes/session.php
LINE: 1395
CALL: dbal_mysql->sql_query()

FILE: index.php
LINE: 23
CALL: user->setup()


and the second one:
General Error
Could not get style data


If you are seeing the first error (similar one) then you had a running phpbb3B5 forum, uploaded the new RC1 files overwriting the old ones and tried to browse your board with this result. What you need to do FIRST is to browse to your board and run {ROOT}/install/database_update.php. DO THIS NOW before anything else!

NEXT, PLEASE BACK UP YOUR DATABASE IF YOU DIDN'T DO SO ALREADY!!!

After running the database_update.php file from your browser (could take a minute or so) you are stuck with Error # 2, and that's where we want to be. (Yes, you do have an error in the update database script, that's the problem we want to solve!)

Right, everyone now has a non-working board, with files updated to version RC1 and a non-working database (with style-errors)

Next: Download the attached zip-file, unpack it and upload the file: update_B5_to_RC1.php to the root of your board.
After this, run the file from your browser (http://{ROOT}/update_B5_to_RC1.php)

When this update script is done, DELETE the file update_B5_to_RC1.php FIRST before doing anything else!!!!!!

Now you can browse to the index of your forum. Go to the ACP, install all styles you had before, install all languages you had before and you are up and running again.

Again, all the steps leading to a succesful update:

Step 1. Start with phpbb3B5 (No other version !)
Step 2. Create a copy of {ROOT}/config.php on your desktop
Step 3. Upload all files from version RC1 overwriting all the old files
Step 4. Upload your saved copy of config.php to {ROOT} overwriting the old one
Step 5. Run {ROOT}/install/database_update.php (forget the error, may take a minute!)
Step 6. Upload included file update_B5_to_RC1.php to {ROOT}/update_B5_to_RC1.php
Step 7. Execute {ROOT}/update_B5_to_RC1.php from your browser
Step 8. DELETE {ROOT}/update_B5_to_RC1.php
Step 9. Visit your board, log in into the ACP and change nessecary settings

BE AWARE, although i gave Highway a copy of this update script, he just hasn't had the time to verify this script. USE IT AT YOUR OWN RISK!!!!!!!!

Good luck to you all and please remember:

ALWAYS BACK UP YOUR DATABASE!!!

:good:


@Highway: THNX for changing my username.....;)


Did follow your tut but got this error while running update_B5_to_RC1.php

Fatal error: Class 'dbal_mysqli' not found in C:\EasyPHP\EasyPHP 2\www\update_B5_to_RC1.php on line 310

Any help ?

Thanks,

Patricia
User avatar
Patricia    
STG Moderator
STG Moderator
 
Posts: 833
Joined: 09 Feb 2007, 08:27
Location: latitude: 51.00 - longitude: 5.87
Gender: Female

Re: PhpBB3 RC1 Released

Postby ..::Frans::.. » 21 May 2007, 08:35

working on it...hang on...;)
ping...
User avatar
..::Frans::..
STG Development
STG Development
 
Posts: 1608
Joined: 28 Mar 2007, 15:37
Location: Netherlands
Favorite Team: RKC
Gender: Male
phpBB Knowledge: 9

Re: PhpBB3 RC1 Released

Postby ..::Frans::.. » 21 May 2007, 08:40

@Patsi32: Try this:

OPEN:
Code: Select all
update_B5_to_RC1.php

FIND:
Code: Select all
include($root_path.'includes/db/mysql.php');

REPLACE WITH:
Code: Select all
//include($root_path.'includes/db/mysql.php');
include($root_path.'includes/db/mysqli.php');


Can't check it here, haven't installed the mysqli extension but should be working...;)
ping...
User avatar
..::Frans::..
STG Development
STG Development
 
Posts: 1608
Joined: 28 Mar 2007, 15:37
Location: Netherlands
Favorite Team: RKC
Gender: Male
phpBB Knowledge: 9

Re: PhpBB3 RC1 Released

Postby Patricia » 21 May 2007, 08:52

..::Frans::.. wrote:Try this:

OPEN:
Code: Select all
update_B5_to_RC1.php

FIND:
Code: Select all
include($root_path.'includes/db/mysql.php');

REPLACE WITH:
Code: Select all
//include($root_path.'includes/db/mysql.php');
include($root_path.'includes/db/mysqli.php');


Can't check it here, haven't installed the mysqli extension but should be working...;)



That worked, got alot of success lines, but at the end it says

Notice: Undefined offset: 100 in C:\EasyPHP\EasyPHP 2\www\update_B5_to_RC1.php on line 330

Ignored the message but still get the

General Error Could not get style data message after trying to access the board.

Thanks for your help, really appreciated

Patricia
User avatar
Patricia    
STG Moderator
STG Moderator
 
Posts: 833
Joined: 09 Feb 2007, 08:27
Location: latitude: 51.00 - longitude: 5.87
Gender: Female

Re: PhpBB3 RC1 Released

Postby ..::Frans::.. » 21 May 2007, 08:55

Yes, the offset error is known (strange error from php, still wondering why.....) Will fix that in the next version.....

I just can't understand why you can't login to your board. Are you the Site admin ?
ping...
User avatar
..::Frans::..
STG Development
STG Development
 
Posts: 1608
Joined: 28 Mar 2007, 15:37
Location: Netherlands
Favorite Team: RKC
Gender: Male
phpBB Knowledge: 9

Re: PhpBB3 RC1 Released

Postby Patricia » 21 May 2007, 08:59

..::Frans::.. wrote:Yes, the offset error is known (strange error from php, still wondering why.....) Will fix that in the next version.....

I just can't understand why you can't login to your board. Are you the Site admin ?



Yes I am Admin, restarted Easyphp, but still get the Could not get style data error :scratch:
User avatar
Patricia    
STG Moderator
STG Moderator
 
Posts: 833
Joined: 09 Feb 2007, 08:27
Location: latitude: 51.00 - longitude: 5.87
Gender: Female

Re: PhpBB3 RC1 Released

Postby ..::Frans::.. » 21 May 2007, 09:03

can you sent me an export of your six style related tables through PM please ??
ping...
User avatar
..::Frans::..
STG Development
STG Development
 
Posts: 1608
Joined: 28 Mar 2007, 15:37
Location: Netherlands
Favorite Team: RKC
Gender: Male
phpBB Knowledge: 9

Re: PhpBB3 RC1 Released

Postby DiegoPino » 21 May 2007, 09:08

Thanks So much ..::Frans::..

Work for my perfect,

when i run update_B5_to_RC1.php , the db update like...

==============================================================
Update script for updating tables from phpbb3B5 -> phpbb3RC1
Version 0.1 - ..::Frans::..
USE AT YOUR OWN RISK!!!

A L W A Y S do a COMPLETE backup of your database before using this script!

AGAIN: USE AT YOUR OWN RISK!!!
and please, remove this file immediatly after updating!
==============================================================


[Succesful] line: 1 - Updating config table, setting override_user_style to 1

[Succesful] line: 2 - Updating users table, setting Site Admins user_style to 1

[Succesful] line: 3 - Updating users table, setting Site Admins language to english

[Succesful] line: 4 - Dropping Styles Table

[Succesful] line: 5 - Creating new Styles Table

[Succesful] line: 6 - Inserting some data into Styles Table


Thanks So MUch!!!

Muchas Gracias por tu Aporte !!!

:hello:
Edicion de Winning Eleven & Pro Evolution Soccer | Since 2002
Long Live Rastafari.. long live Bob Marley !!!
We11.net | ForosPes.com
DiegoPino
Cadet IV
Cadet IV
 
Posts: 59
Joined: 11 Aug 2006, 10:46
Gender: Male

Re: PhpBB3 RC1 Released

Postby ..::Frans::.. » 21 May 2007, 09:11

DiegoPino wrote:Thanks So much ..::Frans::..

Work for my perfect,

when i run update_B5_to_RC1.php , the db update like...

Thanks So MUch!!!

Muchas Gracias por tu Aporte !!!

:hello:


:yahoo:
ping...
User avatar
..::Frans::..
STG Development
STG Development
 
Posts: 1608
Joined: 28 Mar 2007, 15:37
Location: Netherlands
Favorite Team: RKC
Gender: Male
phpBB Knowledge: 9

Next

Return to phpBB3 upgrade support

Who is online

Users browsing this forum: No registered users and 9 guests

cron