I have been using AppFog for a while with no problems loading a mysql script that includes stored procedures and functions.
When I tried to update my database, I am now getting the following error:
Error : You do not have the SUPER privilege and binary logging is enabled (you *might* want to use the less safe log_bin_trust_function_creators variable)
Here is an example of a function that I could create previously:
delimiter ;;
CREATE FUNCTION `nextSyncValue`() RETURNS int(11)
READS SQL DATA
BEGIN
DECLARE next INTEGER;
UPDATE syncvalue
SET LastValue = LastValue + 1
WHERE SyncValue_ID = 1;
SELECT LastValue
INTO next
FROM syncvalue
WHERE SyncValue_ID = 1;
RETURN next;
END
;;
Why can I no longer create MySQL functions but still create stored procedures?