SQLSTATE[42S22]: Column not found dzring install
-
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
-
Hi @glutomuyo,
Can you please share the steps that you are following for installing the Bagisto?
-
Same Problem:
Installation Steps: https://devdocs.bagisto.com/1.5.x/introduction/installation.html#install-using-gui-installerFirst
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'
-
Hi @TafPhil,
These are two different installation processes you followed.
-
One is Install Using GUI Installer
-
Another is Install Using Composer
-
-
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:
This will launch the Bagisto installer.
-