SQLSTATE[42S22]: Column not found dzring install

glutomuyo

I followed the tutorial https://webkul.com/blog/laravel-ecommerce-website/ and upon

php artisan bagisto:install

I get

In Connection.php line 793:
                                                                                                                                                                                                                                                                                                                                                         
  SQLSTATE[42S22]: Column not found: 1054 Unknown column 'products.type' in 'field list' (Connection: mysql, SQL: update `bagi_product_flat` inner join `bagi_products` on `bagi_product_flat`.`product_id` = `bagi_products`.`id` set `bagi_product_flat`.`type` = products.type, `bagi_product_flat`.`attribute_family_id` = products.attribute_famil  
  y_id)                                                                                                                                                                                                                                                                                                                                                  
                                                                                                                                                                                                                                                                                                                                                         

In Connection.php line 599:
                                                                                          
  SQLSTATE[42S22]: Column not found: 1054 Unknown column 'products.type' in 'field list'

How do I solve that? Thanks

Amitk-Webkul

Hi @glutomuyo,

Can you please share the steps that you are following for installing the Bagisto?

TafPhil

Same Problem:
Installation Steps: https://devdocs.bagisto.com/1.5.x/introduction/installation.html#install-using-gui-installer

First

composer create-project bagisto/bagisto

Then in project root folder

php artisan bagisto:install

Result:

2022_10_28_201144_add_columns_in_product_flat_table ................................................ 113ms FAIL

In Connection.php line 793:
                                                                                                                   
  SQLSTATE[42S22]: Column not found: 1054 Unknown column 'products.type' in 'field list' (Connection: mysql, SQL   
  : update `bagistoproduct_flat` inner join `bagistoproducts` on `bagistoproduct_flat`.`product_id` = `bagistopr   
  oducts`.`id` set `bagistoproduct_flat`.`type` = products.type, `bagistoproduct_flat`.`attribute_family_id` = p   
  roducts.attribute_family_id)

In Connection.php line 603:
                                                                                          
  SQLSTATE[42S22]: Column not found: 1054 Unknown column 'products.type' in 'field list'

Amitk-Webkul

Hi @TafPhil,

These are two different installation processes you followed.

One is Install Using GUI Installer
Another is Install Using Composer

Amitk-Webkul

Hi @TafPhil,

To install Bagisto using our GUI installer, follow these steps:

Download Bagisto from our website.
Extract the contents of the downloaded zip file.
Navigate to the project root directory.
Run the following command:

composer install

Configure your HTTP server to point to the public/ directory of the project.
Open your browser and access the following URL:
http://localhost/bagisto/public/

This will launch the Bagisto installer.