PROCEDURE does not exist.

Hello, I have been searching all over for an answer to this problem and I'm hoping someone here can help me...

I can create a stored procedure using either phpmyadmin or MySQL Workbench. In either case the procedure shows up in the schema.

I can see it when I look at: information_schema ROUTINES with phpmyadmin

when I CALL the procedure in MySQL Workbench the procedure runs and I get a result set.

When I CALL the procedure in phpmyadmin or via php code on the website I get...

"PROCEDURE billiards211.GetHcpAndAvgScrByDivID does not exist"

I can't figure out why I can run the procedure in workbench but not in phpmyadmin or from my php code on the website.

I have attached the SQL for you to look at.

Any help?

EDIT*

Just to be clear... The problem is CALLING any procedure from phpmyadmin or php code. I can see any procedure in the schema and I can call them from workbench. I just cant call them from phpmyadmin or php code without the error.





*

i had once a similiar problem and is that phpmyadmin and php directly manage table and fields names with less than 24 characters long i see you got GetRankHcpAndAvgScrByDivID try taking it down to 12 characters i really dont remeber if it was 12 or 24 but i do remeber i had once time ago a similiar problem and in mysql forums they told me to make names shorter and things runned well after that.

Let us know

Sades