Can no longer create MySQL functions

15 views
Skip to first unread message

Frank Mena

unread,
Dec 8, 2014, 3:47:17 PM12/8/14
to appfog...@googlegroups.com
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?

Reply all
Reply to author
Forward
0 new messages