Error executing CREATE FUNCTION NX_IN_TREE

[bharat4212_]

Hi All,

Using nuxeo 5.6,its working fine. When i am changing my both machine's ip nuxeo-web and nuxeo db,On starting the nuxeo service getting error of repository not found and not able to login and also getting error of org.nuxeo.ecm.core.storage.StorageException:

java.sql.SQLException: Error executing: CREATE FUNCTION NX_IN_TREE(id varchar(36), baseid varchar(36))
RETURNS BOOLEAN
LANGUAGE SQL
READS SQL DATA
BEGIN
  DECLARE curid varchar(36) DEFAULT id;
  IF baseid IS NULL OR id IS NULL OR baseid = id THEN
    RETURN FALSE;
  END IF;
  LOOP
    SELECT parentid INTO curid FROM hierarchy WHERE hierarchy.id = curid;
    IF curid IS NULL THEN
      RETURN FALSE;
    ELSEIF curid = baseid THEN
      RETURN TRUE;
    END IF;
  END LOOP;
END : 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)
                                                                                                                             10986,9       94%

also, Please tell me asap

[bruce_Grant]

In order to be able to help with a question like this really need to know some basic information