Symptoms
Attempting to edit a MySQL procedure or function via PHPMyAdmin will return a failure message like the following:
CONFIG_TEXT: 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.
Cause
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.
This was reported to our developers and assigned case ID CPANEL-50133, and has been resolved as of cPanel 134.
Resolution
For any versions still impacted by this, ensure that you end your cPanel session by using the Log Out button in cPanel.
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.