Awaiting feedback 3.5.2 to 3.5.3 SQLSTATE[HY000]: General error: 1548 Cannot

[dotch]

Help needed! I'm on a VPS. I've uploaded the affected files. When I try to update the database from 3.5.2 to 3.5.3 using the link in the Admin Dashboard, I get:

The update process failed. Here is the error returned:

SQLSTATE[HY000]: General error: 1548 Cannot load from mysql.proc. The table is probably corrupted

I already did yum update
when I try to update MySQL with # mysql_upgrade or with
mysql_upgrade -u root -p , I get

Looking for 'mysql' as: mysql
Looking for 'mysqlcheck' as: mysqlcheck
FATAL ERROR: Upgrade failed

What do do? Thanks for any help!

 

[Rodolfo]

Just run a mysql repair table command.

 

[dotch]

I tried that from within phpMyAdmin and from the command line (difficult for me) but everything seems to be fine. Now what? My Database server version = 5.5.40

I'm stuck with Chevereto version 3.5.3 (3.5.2 DB).

Can I roll back to Chevereto version 3.5.2? Since all previous updates went smoothly and didn't cause any problems I did not backup this time (stupid, I know)...

 

[dotch]

Ah, found a way to upgrade MySQL (on CentOS/Plesk):

mysql_upgrade -uadmin -p`< /etc/psa/.psa.shadow ` -f

service mysqld restart

Now I could update the database to 3.5.3! Problem solved!

http://bugs.mysql.com/bug.php?id=50183