Hendrik Posted May 2, 2011 Share Posted May 2, 2011 Hi Support, It makes me wonder, why can't i alter my stored procedures while i can drop and create them? Best Regards, Hendrik Link to comment Share on other sites More sharing options...
Guest Geoff Posted May 2, 2011 Share Posted May 2, 2011 What is the query that you are using? Link to comment Share on other sites More sharing options...
Hendrik Posted May 3, 2011 Author Share Posted May 3, 2011 I use mysql workbench to execute the changes. I can delete and create routines easily through the tool, but that is a bit annoying when it comes down to small changes which i wanna test out. Previously my database resided in another web-server and there i didn't have any problems with changing the routines. I won't give the full routine as i don't want to publish it, but when i even add a comment to the routine it fails and therefore i think it is unnecessary to view my routine in full content That is what mysql workbench tries to execute. //mysql workbench added code start USE `tazan_ngsis`; DROP procedure IF EXISTS `insertVisitor`; DELIMITER $$ USE `tazan_ngsis`$$ //mysql workbench added code end //my routine start CREATE DEFINER=`tazan_ngsis`@`%` PROCEDURE `insertVisitor`(IN shortUrl TEXT) BEGIN //changed code here END //my routine end After i execute my code i get an error message with this information //mysql workbench added code start ERROR 1370: alter routine command denied to user 'tazan_ngsis'@'%' for routine 'tazan_ngsis.insertVisitor' SQL Statement: DROP procedure IF EXISTS `insertVisitor` ERROR: Error when running failback script. Details follow. ERROR 1304: PROCEDURE insertVisitor already exists //mysql workbench added code end SQL Statement: //changed code here Link to comment Share on other sites More sharing options...
Guest Geoff Posted May 3, 2011 Share Posted May 3, 2011 @Hendrik Please post your username/domain/server. Thanks. Possibly related: http://bugs.mysql.com/bug.php?id=9467 Link to comment Share on other sites More sharing options...
Hendrik Posted May 4, 2011 Author Share Posted May 4, 2011 @Hendrik Please post your username/domain/server. Thanks. Possibly related: http://bugs.mysql.com/bug.php?id=9467 username: tazan domain: ngs.is server: johnny Link to comment Share on other sites More sharing options...
Guest Geoff Posted May 4, 2011 Share Posted May 4, 2011 This support request is being escalated to our root admin. Link to comment Share on other sites More sharing options...
Ashoat Posted May 8, 2011 Share Posted May 8, 2011 I did some research, and all I know is that cPanel doesn't support it. I couldn't find a rationale, but I imagine it is security-related and could possible have something to do with what Geoff linked to. Sorry, but we can't offer ALTER PROCEDURE support at this point Link to comment Share on other sites More sharing options...
Guest Geoff Posted May 8, 2011 Share Posted May 8, 2011 I think we might be able to enable it, but everything happens for a reason in computers, and enabling it might open a security hole or something else bad. Link to comment Share on other sites More sharing options...
Ashoat Posted May 8, 2011 Share Posted May 8, 2011 We wouldn't be able to enable it because there needs to be a check mark for it in cPanel's grant privileges dialog. Link to comment Share on other sites More sharing options...
Hendrik Posted May 10, 2011 Author Share Posted May 10, 2011 that is okey thanks for your concern guys Link to comment Share on other sites More sharing options...
Ashoat Posted May 14, 2011 Share Posted May 14, 2011 No problem, thanks for understanding Closing... Link to comment Share on other sites More sharing options...
Recommended Posts