Migrating error in installation

THINKLIFE · 3 Jul 2020, 15:32

When i tried ti run php artisan migrate i these errors
In Connection.php line 669:

SQLSTATE[HY000]: General error: 1558 Column count of mysql.proc is wrong. Expected 21, found 20. Created with MariaDB 100108,
now running 100413. Please use mysql_upgrade to fix this error (SQL: DROP FUNCTION IF EXISTS get_url_path_of_cate gory;
CREATE FUNCTION get_url_path_of_category(
categoryId INT,
localeCode VARCHAR(255)
)
RETURNS VARCHAR(255)
DETERMINISTIC
BEGIN

              DECLARE urlPath VARCHAR(255);                                                                                   
              -- Category with id 1 is root by default                                                                        
              IF categoryId <> 1                                                                                              
              THEN                                                                                                            
                  SELECT                                                                                                      
                      GROUP_CONCAT(parent_translations.slug SEPARATOR '/') INTO urlPath                                       
                  FROM                                                                                                        
                      dbcategories AS node,                                                                                   
                      dbcategories AS parent                                                                                  
                      JOIN dbcategory_translations AS parent_translations ON parent.id = parent_translations.category_id      
                  WHERE                                                                                                       
                      node._lft >= parent._lft                                                                                
                      AND node._rgt <= parent._rgt                                                                            
                      AND node.id = categoryId                                                                                
                      AND parent.id <> 1                                                                                      
                      AND parent_translations.locale = localeCode                                                             
                  GROUP BY                                                                                                    
                      node.id;                                                                                                
                                                                                                                              
                  IF urlPath IS NULL                                                                                          
                  THEN                                                                                                        
                      SET urlPath = (SELECT slug FROM dbcategory_translations WHERE dbcategory_translations.category_id = ca

tegoryId);
END IF;
ELSE
SET urlPath = '';
END IF;

               RETURN urlPath;                                                                                                
          END;)

Vaishali Agarwal · 6 Jul 2020, 14:31

already reported on github https://github.com/bagisto/bagisto/issues/3406