https://bugzilla.wikimedia.org/show_bug.cgi?id=57558
--- Comment #2 from [email protected] --- The database i'm refering to is named p50380g50790__wanderwiki and is associated with project wanderwiki on the tool server. I connect to it using my account on the tool lab : joffreyq and doing the following: - become wanderwiki - mysql --defaults-file="${HOME}"/replica.my.cnf -h tools-db p50380g50790__wanderwiki After this if i run the following command : DELIMITER $$ CREATE FUNCTION `new_function` () RETURNS INTEGER BEGIN RETURN 1; END I have this error: "ERROR 1418: This function has none of DETERMINISTIC, NO SQL, or READS SQL DATA in its declaration and binary logging is enabled (you *might* want to use the less safe log_bin_trust_function_creators variable)" So i tried the following command: CREATE FUNCTION `new_function` () RETURNS INTEGER DETERMINISTIC NO SQL BEGIN RETURN 1; END And had this error: "ERROR 1419: 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)" -- You are receiving this mail because: You are the assignee for the bug. You are on the CC list for the bug. _______________________________________________ Wikibugs-l mailing list [email protected] https://lists.wikimedia.org/mailman/listinfo/wikibugs-l
