Updating phpBB3 Beta5 to RC1 Tutorial+Script

[..::Frans::..]

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!!!



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.....

[Patricia]

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!!!




@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

[..::Frans::..]

working on it...hang on...

[..::Frans::..]

@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...

[Patricia]

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

[..::Frans::..]

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 ?

[Patricia]

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

[..::Frans::..]

can you sent me an export of your six style related tables through PM please ??

[DiegoPino]

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 !!!

[..::Frans::..]

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 !!!