[Beta 1 -> 3, Beta 2 ->4] phpBB3 Beta to Beta upgrade script

[Handyman]

yeah, I noticed that... I've pressed the tab enough times :/
I'm not sure what that is about, but I'm hoping it will be fixed when I install the new quick reply (after I use this upgrade script )

[tebee]

I've just started testing this on my board and it bombed out on ..../upgrade/index.php?mode=upgrade&table=posts&action=run&modules=false with a 500 Internal Server Error.

Unfortunately Apache loges are not enabled by default on the shared server I use so have no more info

But.....it did something, I now have 17,796 row in my posts table..... could it be just the shear size of my board ? (Total posts = 24510)

BTW what exactly is the difference between option 1 and option 2? - I used 1

Tom

[Handyman]

Hello Tebee,

Was it Beta 1 -> Beta 3 or Beta 2 -> Beta 4 that you used?
If you open the config file of the forum, uncomment out the debug and debug extra lines and it will give error reporting.

there is a very good possibility that could have happened because of how many posts... but it would be nice to get more information so we know what to do to fix it.

[tebee]

It was the beta1 - beta 3 version that I downloaded off source forge a couple of days ago, but seems to be almost identical to the one now on page one of this topic - though the readme.txt says upgrade from beta 2!

The apache log merely says Premature end of script so I'll try it again with debug and debug extra.

Tom

[earpit]

DONE!!
you are great as always!!

good wishes for coming future!!

[tebee]

No, no extra info from setting debug on, I've a feeling that when you hit maximumexecutiontime PHP just aborts, without any error , so I'm guessing that's the problem.

Maybe you need to stop and restart every "x" records like Bigdump .

[Handyman]

Ok... We can fix that.
Put this code on the index.php of the upgrade script.

Code: Select all

@set_time_limit(120);


If you need more time, it's in seconds... just set it to whatever you need and let me know if it works and how much time you needed to get it to work.

[DiegoPino]

i test in mi localhost and have that error:

i am upgrade beta 2 to beta 4.

1. Install Phpbb4
2. Copy the config.php file form mi old phpBB3 Beta 2 board to the upgrade directory phpbb4
3. Run the Script and select Option 1

SQL ERROR [ mysqli ]

Duplicate entry 'rand_seed_last_update' for key 1 [1062]

SQL

INSERT INTO phpbb_config (config_name, config_value, is_dynamic) VALUES ('rand_seed_last_update', '0', 1)

BACKTRACE

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

FILE: upgrade/tables/config.php
LINE: 60
CALL: dbal_mysqli->sql_query()

FILE: upgrade/index.php
LINE: 114
CALL: include('upgrade/tables/config.php')

[tebee]

[quote="Handyman"]
Ok... We can fix that.
Put this code on the index.php of the upgrade script.

Code: Select all

@set_time_limit(120);


If you need more time, it's in seconds... just set it to whatever you need and let me know if it works and how much time you needed to get it to work.
[/quote]


Nope....... Still falls over, seems to do about 16k records but not the same number each time so I think it's a timeout problem, rather than something in my files it can't handle. We must be hitting one of the limits, just not sure which.


Tom

[EXreaction]

Ok... We can fix that.
Put this code on the index.php of the upgrade script.

Code: Select all

@set_time_limit(120);


If you need more time, it's in seconds... just set it to whatever you need and let me know if it works and how much time you needed to get it to work.

Will that really change it?

I actually had a time out problem as well. I changed the max execution time to 300 seconds and it worked fine for me afterwards.

I think I am going to put that in, but set it to 600(my board was not very large and it took quite a while).

i test in mi localhost and have that error:

i am upgrade beta 2 to beta 4.

1. Install Phpbb4
2. Copy the config.php file form mi old phpBB3 Beta 2 board to the upgrade directory phpbb4
3. Run the Script and select Option 1

Duplicate entry 'rand_seed_last_update' for key 1 [1062]

SQL

INSERT INTO phpbb_config (config_name, config_value, is_dynamic) VALUES ('rand_seed_last_update', '0', 1)

That is weird. You sure you have Beta 2 and not a slightly newer version? You must have a newer version because rand_seed_last_update is not in Beta 2. In your case you will have to open upgrade/tables/config.php and comment out line 59 and 60 which are:

Code: Select all

$sql = 'INSERT INTO ' . CONFIG_TABLE . " (config_name, config_value, is_dynamic) VALUES ('rand_seed_last_update', '0', 1)";
$db->sql_query($sql);