Topic: phpmyadmin stored procedure creation issue (Page 1 of 1) Pages that link to <a href="http://ozoneasylum.com/backlink?for=32073" title="Pages that link to Topic: phpmyadmin stored procedure creation issue (Page 1 of 1)" rel="nofollow" >Topic: phpmyadmin stored procedure creation issue <span class="small">(Page 1 of 1)</span>\

 
Boudga
Maniac (V) Mad Scientist

From: Jacks raging bile duct....
Insane since: Mar 2000

IP logged posted posted 12-14-2010 22:29 Edit Quote

PMA goes through the motions and reports that my CREATE PROCEDURE executed ok yet the stored procedure is not stored anywhere.

How can I resolve this?

Tyberius Prime
Maniac (V) Mad Scientist with Finglongers

From: Germany
Insane since: Sep 2001

IP logged posted posted 12-15-2010 16:29 Edit Quote

Well, you got a 'proc' table and everything?
What do you get if you execute the query directly in php
(or even better: on a mysql shell interface)

I must admit, I haven't worked with stored procedures in mysql...

Boudga
Maniac (V) Mad Scientist

From: Jacks raging bile duct....
Insane since: Mar 2000

IP logged posted posted 12-27-2010 16:42 Edit Quote

i figured out the problem...i was assigning a delimiter and phpmyadmin was trying to assign a different one.



Post Reply
 
Your User Name:
Your Password:
Login Options: Remember Me On This Computer
 
Your Text:
Loading...
Options: Show Signature
Enable Slimies
Enable Linkwords

« BackwardsOnwards »

Show Forum Drop Down Menu