Migrating error in installation
-
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 EXISTSget_url_path_of_cate gory
;
CREATE FUNCTION get_url_path_of_category(
categoryId INT,
localeCode VARCHAR(255)
)
RETURNS VARCHAR(255)
DETERMINISTIC
BEGINDECLARE 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;)
-
already reported on github https://github.com/bagisto/bagisto/issues/3406