Recent Topics

Migrating error in installation



  • 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;)



Log in to reply