Error executing CREATE FUNCTION NX_IN_TREE

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

0 votes

0 answers

789 views

ANSWER

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

  1. Version of Nuxeo
  2. Database being used
  3. Relevant server.log startup errors (if any)
  4. Operating system(s)
  5. Are Nuxeo and Database on separate servers
07/05/2013