Stored procedure not returning results in myPHPAdmin
I am trying to migrate our website into InMotion from another host, and am now at the point of putting in a stored procedure that was copied from the other host (who has an older version of MySQL). I was able to created the stored procedure after removing the "definer" part. However, now when I call the stored procedure from a myPHPAdmin SQL window, absolutely nothing is returned. No error message, nothing at all. ???
Thank you for your question about stored procedure not working. In order for us to assist you, we will need some additional information.
How are you "calling in" the stored procedure in PHPMyAdmin? Can you provide an example?
Anything that will help us replicate and test the problem, will help us narrow down the cause.
If you have any further questions, feel free to post them below.
Thank you,
John-Paul