Bagisto Forum

    Bagisto

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

    Migrating error in installation

    Installing Bagisto
    2
    2
    297
    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.
    • T
      THINKLIFE last edited by

      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;)
      
      1 Reply Last reply Reply Quote 0
      • V
        Vaishali Agarwal last edited by

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

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