Bagisto Forum

    Bagisto

    • Register
    • Login
    • Search
    • Categories
    • Recent
    • Tags
    • Popular
    • Users
    • Groups

    php artisan migrate issue

    Installing Bagisto
    2
    2
    209
    Loading More Posts
    • Oldest to Newest
    • Newest to Oldest
    • Most Votes
    Reply
    • Reply as topic
    Log in to reply
    This topic has been deleted. Only users with topic management privileges can see it.
    • J
      jemish last edited by

      Hi, i got error while running migrate error.
      php artisan migrate
      Migrating: 2019_11_21_194608_add_stored_function_to_get_url_path_of_category

      In Connection.php line 671:

      SQLSTATE[HY000]: General error: 1558 Column count of mysql.proc is wrong. Expected 21, found 20. Created with M
      ariaDB 100108, now running 100414. Please use mysql_upgrade to fix this error (SQL: DROP FUNCTION I
      F 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_translations.ca  
      

      tegory_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_translations.categ  
      

      ory_id = categoryId);
      END IF;
      ELSE
      SET urlPath = '';
      END IF;

                     RETURN urlPath;                                                                                 
                END;)                                                                                                
      

      In PDOConnection.php line 43:

      SQLSTATE[HY000]: General error: 1558 Column count of mysql.proc is wrong. Expected 21, found 20. Created with M
      ariaDB 100108, now running 100414. Please use mysql_upgrade to fix this error

      In PDOConnection.php line 41:

      SQLSTATE[HY000]: General error: 1558 Column count of mysql.proc is wrong. Expected 21, found 20. Created with M
      ariaDB 100108, now running 100414. Please use mysql_upgrade to fix this error

      1 Reply Last reply Reply Quote 0
      • devansh-webkul
        devansh-webkul last edited by

        Hi @jemish,

        Which version of MySQL/MariaDB are you using?

        1 Reply Last reply Reply Quote 0
        • First post
          Last post