Migration during migration after some tables..

babjonii

In Connection.php line 671:

SQLSTATE[HY000]: General error: 1419 You do not have the SUPER privilege an
d binary logging is enabled (you might want to use the less safe log_bin_
trust_function_creators variable) (SQL: CREATE TRIGGER trig_cat
egory_translations_insert
BEFORE INSERT ON category_translations
FOR EACH ROW
BEGIN
DECLARE parentUrlPath varchar(255);
DECLARE urlPath varchar(255);

          -- Category with id 1 is root by default                         
          IF NEW.category_id <> 1                                          
          THEN                                                             
                                                                           
              SELECT                                                       
                  GROUP_CONCAT(parent_translations.slug SEPARATOR '/') IN

TO parentUrlPath
FROM
categories AS node,
categories AS parent
JOIN category_translations AS parent_translations ON pa
rent.id = parent_translations.category_id
WHERE
node._lft >= parent._lft
AND node._rgt <= parent._rgt
AND node.id = (SELECT parent_id FROM categories WHERE i
d = NEW.category_id)
AND parent.id <> 1
AND parent_translations.locale = NEW.locale
GROUP BY
node.id;

              IF parentUrlPath IS NULL                                     
              THEN                                                         
                  SET urlPath = NEW.slug;                                  
              ELSE                                                         
                  SET urlPath = concat(parentUrlPath, '/', NEW.slug);      
              END IF;                                                      
                                                                           
              SET NEW.url_path = urlPath;                                  
                                                                           
          END IF;                                                          
          END;)

In PDOConnection.php line 43:

SQLSTATE[HY000]: General error: 1419 You do not have the SUPER privilege an
d binary logging is enabled (you might want to use the less safe log_bin_
trust_function_creators variable)

In PDOConnection.php line 41:

SQLSTATE[HY000]: General error: 1419 You do not have the SUPER privilege an
d binary logging is enabled (you might want to use the less safe log_bin_
trust_function_creators variable)

Vaishali Agarwal

@babjonii
could you please describe your Database server (Version)?