Symptoms
Attempting to edit a MySQL procedure or function via PHPMyAdmin will return a failure message like the following:
Error in processing request: No routine with name `$PROCEDURE_NAME` found
in database `$DATABASE_NAME`.
You might be lacking the necessary privileges to edit this routine.
Description
MySQL procedures and functions that were created via the PHPMyAdmin interface in cPanel allow you to edit them via the same interface due to the "Definer" permissions. However, in some cases, it has been observed that the "Definer" is not updated back to the cPanel user and it remains as the temporary PHPMyAdmin user which will prevent you from being able to edit the procedure when you log into the next session.
For reference, the case number is CPSPECTRE-159. Follow this article to receive an email notification when a solution is published in the product.
Workaround
One workaround you can attempt is to manually log out of the cPanel session by making use of the "Logout" button. This should clear the session and revert the definer. Otherwise, you may contact us for further review.
Comments
1 comment
Update: We would like to thank you for your interest in this article/case and encourage your submissions as they are valuable to the ever-expanding development of cPanel & WHM. At this time, this particular issue has not been selected for action from our Development Team, as it may require more development resources than we can allot, or alters the direction cPanel envisions for the product. Submissions persist in our Issue Tracking System in the event the impact of the related issue grows or product direction changes. If you feel that this defect requires direct action, we strongly encourage you to submit a Feature Request to allow the cPanel Community to vote and support your cause.
Thank you again for helping us make cPanel & WHM the hosting platform of choice.
Article is closed for comments.