Here is a very basic issue that i have and i assume it might be due to a syntax issues with MySQL sql.
Here is my procedure that i'm having trouble with
CREATE DEFINER=`test` PROCEDURE `get_users`(IN user_id INT)
select * from user where user_id = @user_id;
i think the @ symbol is your problem. this works on my MySQL-DB
CREATE DEFINER=`codemagic.net.db`@`%` PROCEDURE `get_user`(IN `user_id` INT) NOT DETERMINISTIC READS SQL DATA SQL SECURITY DEFINER select * from users where id = user_id