Recent Topics

Migration during migration after some tables..



  • 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)



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


Log in to reply