• Categories
  • Recent
  • Tags
  • Popular
  • Users
  • Groups
  • Register
  • Login
Bagisto Forum

Bagisto

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

Migrating error in installation

Installing Bagisto
2
2
299
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 3 Jul 2020, 15:32

    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 6 Jul 2020, 14:31

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

      1 Reply Last reply Reply Quote 0
      2 out of 2
      • First post
        2/2
        Last post