Upgrade 75 -> 80 never end with no return

[GoogleCodeExporter]

What steps will reproduce the problem?
1. Run upgrade.php in IE or Firefox
2. Wait forever (die after 1 or 2min in IE)

What is the expected output? What do you see instead?
Tables modification, upgrade.
I obtain (index.php):
Could not find all the expected tables in database. Try running the 
install script again.

Tables missing:
memberships, players_skills, races, game_data_players, game_data_stars, 
game_data_skills, mv_players, mv_teams, mv_coaches, mv_races, 
mv_es_players, mv_es_teams, mv_es_coaches, mv_es_races, match_data_es 

What version of the product are you using?
0.75, looking for upgrading to 0.8

Please provide any additional information below.
Have replaced all files (delete + import).
Have dropped all table and worked with a restore from a previous version 
before swapping between browser to launch the upgrade.pgp

Original issue reported on code.google.com by amaug...@gmail.com on 22 Mar 2010 at 1:33

[GoogleCodeExporter]

The only thing I can thing of is verify the rights for the mysql user that 
OBBLM is
running as.

What version / revision is the restored table from?

If it is post 0.75, were previous upgrades with upgrade.php successful?

Original comment by funnyfin...@hotmail.com on 24 Mar 2010 at 1:53

[GoogleCodeExporter]

Well, it's the database admin/owner.

The tables are from a 0.75 fresh install, no upgrade used.

Original comment by amaug...@gmail.com on 24 Mar 2010 at 3:58

[GoogleCodeExporter]

Could be closed, I started a fresh install without a new database.

Original comment by amaug...@gmail.com on 25 Mar 2010 at 8:28

[GoogleCodeExporter]

Do you by any chance still have a copy of the old DB I could analyse?
Is it a slow server?
Do you have a lot of data plugged into OBBLM? 
How many matches + teams approx.?

Original comment by Nimda...@gmail.com on 26 Mar 2010 at 9:51

[GoogleCodeExporter]

No?

Original comment by Nimda...@gmail.com on 9 Apr 2010 at 12:49

[GoogleCodeExporter]

Do you think this is fixed with the other updates for the upgrade you've done?

Original comment by funnyfin...@hotmail.com on 13 Apr 2010 at 1:56

[GoogleCodeExporter]

No it's not.
I fear that he had a large DB and there was too much stuff to do in the upgrade 
process in order to make it 
before the timeout. That's why I'd like to see the DB. Maybe it was just his 
host having unrealistic small timeout 
limits.

Original comment by Nimda...@gmail.com on 13 Apr 2010 at 7:11

[GoogleCodeExporter]

I'm having the same problem.

I'm using one.com as web host and it's always been a bit slow to be honest, but 
I've
found it acceptable. 

I've got 147 matches and 25 teams in the DB (I can send a backup of it if you 
want a
to see the actual content). My knowledge of php and sql is neglectable at best 
so I
haven't been able to figure out how to do the upgrade manually through sql 
querys.

Original comment by christia...@gmail.com on 24 May 2010 at 8:59

[GoogleCodeExporter]

Please do so - send me a DB dump.

Original comment by Nimda...@gmail.com on 26 May 2010 at 2:25

[GoogleCodeExporter]

I have now tested with three different DBs for people having this problem, and 
I can conclude that this is a host problem. The hosts must have a too short 
allowed execution time for PHP scripts. I can upgrade just fine here - takes 
around 2 minutes to complete on my computer.

If people are having trouble upgrading, I suggest you mail me your DB dump, and 
I can then run the upgrade for you and send the resulting (upgraded) DB back to 
you.

I will close this one for now.

Original comment by Nimda...@gmail.com on 20 Jun 2010 at 11:57

• Changed state: Invalid