Issue while doing Database Migration
-
I have an issue when with the downloaded bagisto package, all works well not until when I try to do database migrations I get this error
SQLSTATE[HY000]: General error: 1558 Column count of mysql.proc is wrong. Expected 21, found 20. Cre ated with MariaDB 100108, now running 100414. Please use mysql_upgrade to fix this error (SQL: DROP FUNCTION IF EXISTS `get_url_path_of_category`; 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 categories AS node, categories AS parent JOIN category_translations AS parent_translations ON parent.id = parent_tran slations.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 category_translations WHERE category_transla tions.category_id = categoryId); END IF; ELSE SET urlPath = ''; END IF;
Server version: 10.4.14-MariaDB
-
@drakeuganda
could you please mention your MARIADB version. -
I have the same issue my Maria DB version is 10.6.0-MariaDB
-
Hi @drakeuganda and @tayyabshahzad,
Use only the required version which is mentioned in the docs,
https://devdocs.bagisto.com/1.x/introduction/requirements.html#supported-database-servers