MySQL Forums
Forum List  »  Newbie

Incorrect definition of table mysql.proc:
Posted by: Sandy Spence
Date: November 30, 2011 09:28AM

Hi forum,

We have a new installation of version 5.5.16, the system has not been upgraded from a previous version. We were getting this error:

[ERROR] Incorrect definition of table mysql.proc: expected column 'comment' at position 15 to have type text, found type char(64).

I searched high and low for an answer to why and all the feedback I read was related to an upgrade. I eventually ran the following sql statement

alter table proc change comment comment text

and this appears to have fixed/stopped the error.

My question is: are there any knock on implications should I have run something else to fix the error.

Any help/advice would be appreciated.

Regards,

Sandy Spence

Options: ReplyQuote


Subject
Written By
Posted
Incorrect definition of table mysql.proc:
November 30, 2011 09:28AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.