Error executing CREATE FUNCTION NX_IN_TREE

As we transition to the new Hyland Community, some post links may be temporarily disrupted as we finalize redirects. We apologize for the inconvenience and are working to resolve this as quickly as possible. Details.

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