Bagisto Forum

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

    instalization errors

    Installing Bagisto
    2
    2
    211
    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.
    • F
      furkanaksoy last edited by

      When I run the php artisan migrate command I get this error.

      I am using xampp localhost.
      php version 7.2.32
      mysql version 8.0.21
      macOS Catalina 10.15.7

      furkan-mbp:bagisto mac$ php artisan migrate
Migrating: 2014_10_12_000000_create_users_table
Migrated:  2014_10_12_000000_create_users_table (0.03 seconds)
Migrating: 2014_10_12_100000_create_admin_password_resets_table
Migrated:  2014_10_12_100000_create_admin_password_resets_table (0.03 seconds)
Migrating: 2014_10_12_100000_create_password_resets_table
Migrated:  2014_10_12_100000_create_password_resets_table (0.03 seconds)
Migrating: 2018_06_12_111907_create_admins_table
Migrated:  2018_06_12_111907_create_admins_table (0.03 seconds)
Migrating: 2018_06_13_055341_create_roles_table
Migrated:  2018_06_13_055341_create_roles_table (0.02 seconds)
Migrating: 2018_07_05_130148_create_attributes_table
Migrated:  2018_07_05_130148_create_attributes_table (0.03 seconds)
Migrating: 2018_07_05_132854_create_attribute_translations_table
Migrated:  2018_07_05_132854_create_attribute_translations_table (0.06 seconds)
Migrating: 2018_07_05_135150_create_attribute_families_table
Migrated:  2018_07_05_135150_create_attribute_families_table (0.01 seconds)
Migrating: 2018_07_05_135152_create_attribute_groups_table
Migrated:  2018_07_05_135152_create_attribute_groups_table (0.16 seconds)
Migrating: 2018_07_05_140832_create_attribute_options_table
Migrated:  2018_07_05_140832_create_attribute_options_table (0.04 seconds)
Migrating: 2018_07_05_140856_create_attribute_option_translations_table
Migrated:  2018_07_05_140856_create_attribute_option_translations_table (0.06 seconds)
Migrating: 2018_07_05_142820_create_categories_table
Migrated:  2018_07_05_142820_create_categories_table (0.03 seconds)
Migrating: 2018_07_10_055143_create_locales_table
Migrated:  2018_07_10_055143_create_locales_table (0.03 seconds)
Migrating: 2018_07_20_054426_create_countries_table
Migrated:  2018_07_20_054426_create_countries_table (0.01 seconds)
Migrating: 2018_07_20_054502_create_currencies_table
Migrated:  2018_07_20_054502_create_currencies_table (0.01 seconds)
Migrating: 2018_07_20_054542_create_currency_exchange_rates_table
Migrated:  2018_07_20_054542_create_currency_exchange_rates_table (0.06 seconds)
Migrating: 2018_07_20_064849_create_channels_table
Migrated:  2018_07_20_064849_create_channels_table (0.3 seconds)
Migrating: 2018_07_21_142836_create_category_translations_table
Migrated:  2018_07_21_142836_create_category_translations_table (0.06 seconds)
Migrating: 2018_07_23_110040_create_inventory_sources_table
Migrated:  2018_07_23_110040_create_inventory_sources_table (0.03 seconds)
Migrating: 2018_07_24_082635_create_customer_groups_table
Migrated:  2018_07_24_082635_create_customer_groups_table (0.01 seconds)
Migrating: 2018_07_24_082930_create_customers_table
Migrated:  2018_07_24_082930_create_customers_table (0.09 seconds)
Migrating: 2018_07_24_083025_create_customer_addresses_table
Migrated:  2018_07_24_083025_create_customer_addresses_table (0.05 seconds)
Migrating: 2018_07_27_065727_create_products_table
Migrated:  2018_07_27_065727_create_products_table (0.48 seconds)
Migrating: 2018_07_27_070011_create_product_attribute_values_table
Migrated:  2018_07_27_070011_create_product_attribute_values_table (0.1 seconds)
Migrating: 2018_07_27_092623_create_product_reviews_table
Migrated:  2018_07_27_092623_create_product_reviews_table (0.08 seconds)
Migrating: 2018_07_27_113941_create_product_images_table
Migrated:  2018_07_27_113941_create_product_images_table (0.04 seconds)
Migrating: 2018_07_27_113956_create_product_inventories_table
Migrated:  2018_07_27_113956_create_product_inventories_table (0.08 seconds)
Migrating: 2018_08_03_114203_create_sliders_table
Migrated:  2018_08_03_114203_create_sliders_table (0.04 seconds)
Migrating: 2018_08_30_064755_create_tax_categories_table
Migrated:  2018_08_30_064755_create_tax_categories_table (0.07 seconds)
Migrating: 2018_08_30_065042_create_tax_rates_table
Migrated:  2018_08_30_065042_create_tax_rates_table (0.03 seconds)
Migrating: 2018_08_30_065840_create_tax_mappings_table
Migrated:  2018_08_30_065840_create_tax_mappings_table (0.1 seconds)
Migrating: 2018_09_05_150444_create_cart_table
Migrated:  2018_09_05_150444_create_cart_table (0.08 seconds)
Migrating: 2018_09_05_150915_create_cart_items_table
Migrated:  2018_09_05_150915_create_cart_items_table (0.15 seconds)
Migrating: 2018_09_11_064045_customer_password_resets
Migrated:  2018_09_11_064045_customer_password_resets (0.03 seconds)
Migrating: 2018_09_19_092845_create_cart_address
Migrated:  2018_09_19_092845_create_cart_address (0.08 seconds)
Migrating: 2018_09_19_093453_create_cart_payment
Migrated:  2018_09_19_093453_create_cart_payment (0.05 seconds)
Migrating: 2018_09_19_093508_create_cart_shipping_rates_table
Migrated:  2018_09_19_093508_create_cart_shipping_rates_table (0.05 seconds)
Migrating: 2018_09_20_060658_create_core_config_table
Migrated:  2018_09_20_060658_create_core_config_table (0.04 seconds)
Migrating: 2018_09_27_113154_create_orders_table
Migrated:  2018_09_27_113154_create_orders_table (0.09 seconds)
Migrating: 2018_09_27_113207_create_order_items_table
Migrated:  2018_09_27_113207_create_order_items_table (0.08 seconds)
Migrating: 2018_09_27_113405_create_order_address_table
Migrated:  2018_09_27_113405_create_order_address_table (0.08 seconds)
Migrating: 2018_09_27_115022_create_shipments_table
Migrated:  2018_09_27_115022_create_shipments_table (0.08 seconds)
Migrating: 2018_09_27_115029_create_shipment_items_table
Migrated:  2018_09_27_115029_create_shipment_items_table (0.05 seconds)
Migrating: 2018_09_27_115135_create_invoices_table
Migrated:  2018_09_27_115135_create_invoices_table (0.08 seconds)
Migrating: 2018_09_27_115144_create_invoice_items_table
Migrated:  2018_09_27_115144_create_invoice_items_table (0.07 seconds)
Migrating: 2018_10_01_095504_create_order_payment_table
Migrated:  2018_10_01_095504_create_order_payment_table (0.04 seconds)
Migrating: 2018_10_03_025230_create_wishlist_table
Migrated:  2018_10_03_025230_create_wishlist_table (0.11 seconds)
Migrating: 2018_10_12_101803_create_country_translations_table
Migrated:  2018_10_12_101803_create_country_translations_table (0.05 seconds)
Migrating: 2018_10_12_101913_create_country_states_table
Migrated:  2018_10_12_101913_create_country_states_table (0.04 seconds)
Migrating: 2018_10_12_101923_create_country_state_translations_table
Migrated:  2018_10_12_101923_create_country_state_translations_table (0.04 seconds)
Migrating: 2018_11_15_153257_alter_order_table
Migrated:  2018_11_15_153257_alter_order_table (0.01 seconds)
Migrating: 2018_11_15_163729_alter_invoice_table
Migrated:  2018_11_15_163729_alter_invoice_table (0.01 seconds)
Migrating: 2018_11_16_173504_create_subscribers_list_table
Migrated:  2018_11_16_173504_create_subscribers_list_table (0.05 seconds)
Migrating: 2018_11_17_165758_add_is_verified_column_in_customers_table
Migrated:  2018_11_17_165758_add_is_verified_column_in_customers_table (0.03 seconds)
Migrating: 2018_11_21_144411_create_cart_item_inventories_table
Migrated:  2018_11_21_144411_create_cart_item_inventories_table (0.01 seconds)
Migrating: 2018_11_26_110500_change_gender_column_in_customers_table
Migrated:  2018_11_26_110500_change_gender_column_in_customers_table (0.01 seconds)
Migrating: 2018_11_27_174449_change_content_column_in_sliders_table
Migrated:  2018_11_27_174449_change_content_column_in_sliders_table (0.04 seconds)
Migrating: 2018_12_05_132625_drop_foreign_key_core_config_table
Migrated:  2018_12_05_132625_drop_foreign_key_core_config_table (0.04 seconds)
Migrating: 2018_12_05_132629_alter_core_config_table
Migrated:  2018_12_05_132629_alter_core_config_table (0.05 seconds)
Migrating: 2018_12_06_185202_create_product_flat_table
Migrated:  2018_12_06_185202_create_product_flat_table (0.07 seconds)
Migrating: 2018_12_21_101307_alter_channels_table
Migrated:  2018_12_21_101307_alter_channels_table (0.09 seconds)
Migrating: 2018_12_24_123812_create_channel_inventory_sources_table
Migrated:  2018_12_24_123812_create_channel_inventory_sources_table (0.1 seconds)
Migrating: 2018_12_24_184402_alter_shipments_table
Migrated:  2018_12_24_184402_alter_shipments_table (0.05 seconds)
Migrating: 2018_12_26_165327_create_product_ordered_inventories_table
Migrated:  2018_12_26_165327_create_product_ordered_inventories_table (0.1 seconds)
Migrating: 2018_12_31_161114_alter_channels_category_table
Migrated:  2018_12_31_161114_alter_channels_category_table (0.04 seconds)
Migrating: 2019_01_11_122452_add_vendor_id_column_in_product_inventories_table
Migrated:  2019_01_11_122452_add_vendor_id_column_in_product_inventories_table (0.03 seconds)
Migrating: 2019_01_25_124522_add_updated_at_column_in_product_flat_table
Migrated:  2019_01_25_124522_add_updated_at_column_in_product_flat_table (0.1 seconds)
Migrating: 2019_01_29_123053_add_min_price_and_max_price_column_in_product_flat_table
Migrated:  2019_01_29_123053_add_min_price_and_max_price_column_in_product_flat_table (0.05 seconds)
Migrating: 2019_01_31_164117_update_value_column_type_to_text_in_core_config_table
Migrated:  2019_01_31_164117_update_value_column_type_to_text_in_core_config_table (0.03 seconds)
Migrating: 2019_02_21_145238_alter_product_reviews_table
Migrated:  2019_02_21_145238_alter_product_reviews_table (0.02 seconds)
Migrating: 2019_02_21_152709_add_swatch_type_column_in_attributes_table
Migrated:  2019_02_21_152709_add_swatch_type_column_in_attributes_table (0.01 seconds)
Migrating: 2019_02_21_153035_alter_customer_id_in_product_reviews_table
Migrated:  2019_02_21_153035_alter_customer_id_in_product_reviews_table (0.03 seconds)
Migrating: 2019_02_21_153851_add_swatch_value_columns_in_attribute_options_table
Migrated:  2019_02_21_153851_add_swatch_value_columns_in_attribute_options_table (0.01 seconds)
Migrating: 2019_03_15_123337_add_display_mode_column_in_categories_table
Migrated:  2019_03_15_123337_add_display_mode_column_in_categories_table (0.01 seconds)
Migrating: 2019_03_28_103658_add_notes_column_in_customers_table
Migrated:  2019_03_28_103658_add_notes_column_in_customers_table (0.01 seconds)
Migrating: 2019_04_24_155820_alter_product_flat_table
Migrated:  2019_04_24_155820_alter_product_flat_table (0.03 seconds)
Migrating: 2019_05_13_024320_remove_tables
Migrated:  2019_05_13_024320_remove_tables (0 seconds)
Migrating: 2019_05_13_024321_create_cart_rules_table
Migrated:  2019_05_13_024321_create_cart_rules_table (0.01 seconds)
Migrating: 2019_05_13_024322_create_cart_rule_channels_table
Migrated:  2019_05_13_024322_create_cart_rule_channels_table (0.12 seconds)
Migrating: 2019_05_13_024323_create_cart_rule_customer_groups_table
Migrated:  2019_05_13_024323_create_cart_rule_customer_groups_table (0.1 seconds)
Migrating: 2019_05_13_024324_create_cart_rule_translations_table
Migrated:  2019_05_13_024324_create_cart_rule_translations_table (0.08 seconds)
Migrating: 2019_05_13_024325_create_cart_rule_customers_table
Migrated:  2019_05_13_024325_create_cart_rule_customers_table (0.08 seconds)
Migrating: 2019_05_13_024326_create_cart_rule_coupons_table
Migrated:  2019_05_13_024326_create_cart_rule_coupons_table (0.05 seconds)
Migrating: 2019_05_13_024327_create_cart_rule_coupon_usage_table
Migrated:  2019_05_13_024327_create_cart_rule_coupon_usage_table (0.08 seconds)
Migrating: 2019_05_22_165833_update_zipcode_column_type_to_varchar_in_cart_address_table
Migrated:  2019_05_22_165833_update_zipcode_column_type_to_varchar_in_cart_address_table (0.03 seconds)
Migrating: 2019_05_23_113407_add_remaining_column_in_product_flat_table
Migrated:  2019_05_23_113407_add_remaining_column_in_product_flat_table (0.02 seconds)
Migrating: 2019_05_23_155520_add_discount_columns_in_invoice_items_table
Migrated:  2019_05_23_155520_add_discount_columns_in_invoice_items_table (0.01 seconds)
Migrating: 2019_05_23_184029_rename_discount_columns_in_cart_table
Migrated:  2019_05_23_184029_rename_discount_columns_in_cart_table (0.04 seconds)
Migrating: 2019_06_04_114009_add_phone_column_in_customers_table
Migrated:  2019_06_04_114009_add_phone_column_in_customers_table (0.03 seconds)
Migrating: 2019_06_06_195905_update_custom_price_to_nullable_in_cart_items
Migrated:  2019_06_06_195905_update_custom_price_to_nullable_in_cart_items (0.03 seconds)
Migrating: 2019_06_15_183412_add_code_column_in_customer_groups_table
Migrated:  2019_06_15_183412_add_code_column_in_customer_groups_table (0.03 seconds)
Migrating: 2019_06_17_180258_create_product_downloadable_samples_table
Migrated:  2019_06_17_180258_create_product_downloadable_samples_table (0.05 seconds)
Migrating: 2019_06_17_180314_create_product_downloadable_sample_translations_table
Migrated:  2019_06_17_180314_create_product_downloadable_sample_translations_table (0.05 seconds)
Migrating: 2019_06_17_180325_create_product_downloadable_links_table
Migrated:  2019_06_17_180325_create_product_downloadable_links_table (0.05 seconds)
Migrating: 2019_06_17_180346_create_product_downloadable_link_translations_table
Migrated:  2019_06_17_180346_create_product_downloadable_link_translations_table (0.05 seconds)
Migrating: 2019_06_19_162817_remove_unique_in_phone_column_in_customers_table
Migrated:  2019_06_19_162817_remove_unique_in_phone_column_in_customers_table (0.01 seconds)
Migrating: 2019_06_21_130512_update_weight_column_deafult_value_in_cart_items_table
Migrated:  2019_06_21_130512_update_weight_column_deafult_value_in_cart_items_table (0.02 seconds)
Migrating: 2019_06_21_202249_create_downloadable_link_purchased_table
Migrated:  2019_06_21_202249_create_downloadable_link_purchased_table (0.11 seconds)
Migrating: 2019_07_02_180307_create_booking_products_table
Migrated:  2019_07_02_180307_create_booking_products_table (0.05 seconds)
Migrating: 2019_07_05_114157_add_symbol_column_in_currencies_table
Migrated:  2019_07_05_114157_add_symbol_column_in_currencies_table (0.01 seconds)
Migrating: 2019_07_05_154415_create_booking_product_default_slots_table
Migrated:  2019_07_05_154415_create_booking_product_default_slots_table (0.05 seconds)
Migrating: 2019_07_05_154429_create_booking_product_appointment_slots_table
Migrated:  2019_07_05_154429_create_booking_product_appointment_slots_table (0.05 seconds)
Migrating: 2019_07_05_154440_create_booking_product_event_tickets_table
Migrated:  2019_07_05_154440_create_booking_product_event_tickets_table (0.06 seconds)
Migrating: 2019_07_05_154451_create_booking_product_rental_slots_table
Migrated:  2019_07_05_154451_create_booking_product_rental_slots_table (0.05 seconds)
Migrating: 2019_07_05_154502_create_booking_product_table_slots_table
Migrated:  2019_07_05_154502_create_booking_product_table_slots_table (0.05 seconds)
Migrating: 2019_07_11_151210_add_locale_id_in_category_translations
Migrated:  2019_07_11_151210_add_locale_id_in_category_translations (0.05 seconds)
Migrating: 2019_07_23_033128_alter_locales_table
Migrated:  2019_07_23_033128_alter_locales_table (0.01 seconds)
Migrating: 2019_07_23_174708_create_velocity_contents_table
Migrated:  2019_07_23_174708_create_velocity_contents_table (0.01 seconds)
Migrating: 2019_07_23_175212_create_velocity_contents_translations_table
Migrated:  2019_07_23_175212_create_velocity_contents_translations_table (0.04 seconds)
Migrating: 2019_07_29_142734_add_use_in_flat_column_in_attributes_table
Migrated:  2019_07_29_142734_add_use_in_flat_column_in_attributes_table (0.01 seconds)
Migrating: 2019_07_30_153530_create_cms_pages_table
Migrated:  2019_07_30_153530_create_cms_pages_table (0.08 seconds)
Migrating: 2019_07_31_143339_create_category_filterable_attributes_table
Migrated:  2019_07_31_143339_create_category_filterable_attributes_table (0.08 seconds)
Migrating: 2019_08_02_105320_create_product_grouped_products_table
Migrated:  2019_08_02_105320_create_product_grouped_products_table (0.08 seconds)
Migrating: 2019_08_12_184925_add_additional_cloumn_in_wishlist_table
Migrated:  2019_08_12_184925_add_additional_cloumn_in_wishlist_table (0.01 seconds)
Migrating: 2019_08_20_170510_create_product_bundle_options_table
Migrated:  2019_08_20_170510_create_product_bundle_options_table (0.04 seconds)
Migrating: 2019_08_20_170520_create_product_bundle_option_translations_table
Migrated:  2019_08_20_170520_create_product_bundle_option_translations_table (0.06 seconds)
Migrating: 2019_08_20_170528_create_product_bundle_option_products_table
Migrated:  2019_08_20_170528_create_product_bundle_option_products_table (0.08 seconds)
Migrating: 2019_08_21_123707_add_seo_column_in_channels_table
Migrated:  2019_08_21_123707_add_seo_column_in_channels_table (0.01 seconds)
Migrating: 2019_09_11_184511_create_refunds_table
Migrated:  2019_09_11_184511_create_refunds_table (0.05 seconds)
Migrating: 2019_09_11_184519_create_refund_items_table
Migrated:  2019_09_11_184519_create_refund_items_table (0.11 seconds)
Migrating: 2019_09_26_163950_remove_channel_id_from_customers_table
Migrated:  2019_09_26_163950_remove_channel_id_from_customers_table (0.03 seconds)
Migrating: 2019_10_03_105451_change_rate_column_in_currency_exchange_rates_table
Migrated:  2019_10_03_105451_change_rate_column_in_currency_exchange_rates_table (0.03 seconds)
Migrating: 2019_10_21_105136_order_brands
Migrated:  2019_10_21_105136_order_brands (0.17 seconds)
Migrating: 2019_10_24_173358_change_postcode_column_type_in_order_address_table
Migrated:  2019_10_24_173358_change_postcode_column_type_in_order_address_table (0.03 seconds)
Migrating: 2019_10_24_173437_change_postcode_column_type_in_cart_address_table
Migrated:  2019_10_24_173437_change_postcode_column_type_in_cart_address_table (0.02 seconds)
Migrating: 2019_10_24_173507_change_postcode_column_type_in_customer_addresses_table
Migrated:  2019_10_24_173507_change_postcode_column_type_in_customer_addresses_table (0.04 seconds)
Migrating: 2019_11_21_194541_add_column_url_path_to_category_translations
Migrated:  2019_11_21_194541_add_column_url_path_to_category_translations (0.02 seconds)
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 MariaDB 100108, now running 100413. Please use mysql_upgrade to fix this error (SQL:             DROP FUNCTION IF EX  
  ISTS `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.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_translations.category_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 MariaDB 100108, now running 100413. 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 MariaDB 100108, now running 100413. Please use mysql_upgrade to fix this error
      1 Reply Last reply Reply Quote 0
      • V
        Vaishali Agarwal last edited by

        @furkanaksoy said in instalization errors:

        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 EX
        ISTS get_url_path_of_category;

        follow this link https://github.com/bagisto/bagisto/issues/3406

        if this will not work for you then kindly update.

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