Unable to upgrade from OBBLM 0.90 to 0.91

[GoogleCodeExporter]

What steps will reproduce the problem?
1. Update OBBLM 0.90 install using files from tag obblm-0.91_upgrade on free 
host www.000webhost.com.
2. Per instructions try to run Upgrade.php after files have been updated to 
bring MySQL tables up to date.

What is the expected output? What do you see instead?

It should have added whatever new columns were needed for 0.91 and fixed up any 
data issues.  Instead the following error posted:

MySQL error (errno 1558):
Column count of mysql.proc is wrong. Expected 20, found 16. Created with MySQL 
50091, now running 50157. Please use mysql_upgrade to fix this error.

The function/procedure SQL code that failed was:
CREATE FUNCTION getPlayerStatus....(more follows, it is from class_sqlcore.php)

What version of the product are you using?

0.91

Please provide any additional information below.

Very similar to issue 529 which was closed as being a hosting problem and not 
related to OBBLM.  This problem started occuring after 000webhost upgraded from 
MySQL 5.0 to 5.1 and they may have never run mysql_upgrade properly (and aren't 
doing much given how long my ticket has been open to them).  Exporting data, 
creating new tables, and importing data again does not fix the issue either so 
I'm not sure if this hosting is just unusable at this point or what.

Original issue reported on code.google.com by evilsti...@gmail.com on 22 Jul 2011 at 5:08

[GoogleCodeExporter]

Well, in that case there is a good and a bad side to the story...

The good thing is your data is 100% intact and can be migrated to another 
database (e.g. another webhost) without loosing anything.
The bad thing is that I can't really see how I'd fix it in your case without 
running mysql_upgrade. As in the other thread it seems to not be an obblm issue.

One idea you could try is exporting/backuping your database and then wipe your 
entire mysql DB including mysql funcs/procedures. Then re-create the DB, import 
the data via the backup you made, and then run the upgrade.php from obblm as 
you otherwise would have done.

---

What that error means is that your version of mysql is expecting 20 column's in 
the mysql.proc table, but there are only 16 because your database is operating 
off of a different version than the mysql program.

Original comment by Nimda...@gmail.com on 23 Jul 2011 at 7:04

[GoogleCodeExporter]

Original comment by Nimda...@gmail.com on 15 Dec 2011 at 12:32

• Changed state: Done