Problem with MySQL upgrade from 5.00.91 to 5.01.58

Status
Not open for further replies.

vtrub

New Member
Prime Account
Messages
5
Reaction score
0
Points
1
My web site www.searchauto.ca is down for more than a week now, it returns error:

"Query Error: Column count of mysql.proc is wrong. Expected 20, found 16. Created with MySQL 50091, now running 50158. Please use mysql_upgrade to fix this error."

The similar post
"http://x10hosting.com/forums/free-hosting/164430-stored-procedures-mysql.html"

was closed without response.

Please advice what should I do.
Thanks.
 

Bryon

I Fix Things
Messages
8,149
Reaction score
101
Points
48
Try removing your stored procedure and recreating it.
 

vtrub

New Member
Prime Account
Messages
5
Reaction score
0
Points
1
Thank you, but it's not working. I've tried to drop stored procedure:

drop PROCEDURE get_all_dealer;

Response:
#1558 - Column count of mysql.proc is wrong. Expected 20, found 16. Created with MySQL 50091, now running 50158. Please use mysql_upgrade to fix this error.

I've tried:
Select * From Information_Schema.routines

Same response.
 
Status
Not open for further replies.
Top