Monthly Archives: September 2013

Zend Server 5 to 6 mysql 5.1 to 5.5 fix

By | MySQL, Software Development, Zend, Zend Server | No Comments

I recently upgraded a Zend Server installation from version 5 to version 6, a side effect of this was that MySQL server was upgraded from version 5.1 to version 5.5.

I was then receiving the error message:

“Error Code: 1548 Cannot load from mysql.proc. The table is probably corrupted”

After rebuilding the databases and trying the mysql_upgrade -u root -p command, i discovered this is just a try to fix the core issue.

The true cause of the issue is that the table definition of mysql.proc is different

To fix the mysql.proc table just run the following command :

alter table mysql.proc modify comment text;