Recent Topics

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.


Log in to reply