Error #1558
I am using a QNAP TS250+ NAS with MariaDB10 which I have used for just Tables.
Now, for university work, I need to design Routines (Stored Procedures).
When I do this I get error #1558 which gives :-
MySQL said: #1558 - Column count of mysql.proc is wrong. Expected 21, found 20. Created with MariaDB 50557, now running 100508. Please use mariadb-upgrade to fix this error
It seems this is an ubgrade issue but I'm already using the highest upgrade available.
Can anyone help me?
Answer Answered by Ian Gilfillan in this comment.
You aren't clear about which version you're using (you say MariaDB 10, but there's MariaDB 10.3, which is end-of-life, MariaDB 10.11, the latest long-term release, MariaDB 11.3, the latest short-term release, etc. The 21st column in mysql.proc was added in MariaDB 10.3. This error likely means you haven't upgraded properly from an earlier version, as mariadb-upgrade usually takes care of this. See Upgrading Between Major MariaDB Versions.