Database Error
-
I ma using bagisto SAAS tenant E-commerce Package. every thing install perfectly bagisto with SAAS but i facing database error. Column not found: 1054 Unknown column 'attribute_option_translations.company_id' . i debug this error in database and in migration but i cannot find company_id as a foreign key.
full error :
"SQLSTATE[42S22]: Column not found: 1054 Unknown column 'attribute_option_translations.company_id' in 'where clause' (SQL: select * fromattribute_option_translations
whereattribute_option_translations
.company_id
= 1 andlocale
= en) (View: /var/www/html/resources/themes/velocity/views/guest/compare/compare-products.blade.php) (View: /var/www/html/resources/themes/velocity/views/guest/compare/compare-products.blade.php)"
-
Hi there,
Can you please share the steps which you are following for installing the Saas extension?
If possible Please share a screenshot or short video of the error. it will help to find the exact issue.
-
@Amitk-Webkul
i follow these https://webkul.com/blog/laravel-ecommerce-multi-tenant-saas-module/ steps and install SAAS.
Let me share some images.after installation. i created a store it will open properly. i test them all it working properly except when i click on compare menu then it will show the error. other menus are working properly.
Compare:
.
wishlist:
Database table:
-
Hi @rasheedahmad,
Which version of Bagisto are you using?
-
@Amitk-Webkul
i am using Bagisto 1.2.0 version -
Hello,
I understand the frustration you're facing with the database error in your Bagisto SAAS Tenant E-commerce Package installation. The error message you've provided points to an issue with the attribute_option_translations table and the missing company_id column.
Database errors can be perplexing, but I'm here to help you navigate through this:
Migrations and Schema: While you've already reviewed the migrations, double-check the entire schema creation process for the attribute_option_translations table. Ensure there are no typos or overlooked references.
Package Version: Verify that you're using the correct and up-to-date version of the Bagisto SAAS Tenant E-commerce Package. Sometimes, issues can arise due to version mismatches.
Check Dependencies: Confirm that all necessary dependencies for the package are properly installed. Sometimes, missing dependencies can lead to unexpected errors.
Customization and Overrides: If you've made any customizations or overrides in your project, especially related to this table or its associations, inspect those changes carefully.
Seek Official Support: Don't hesitate to reach out to Bagisto's official support channels. The package's developers or the community might have insights into this specific issue and its resolution.
Database Integrity: Ensure that the database is properly synced and migrated. Running the necessary migration commands might help resolve such inconsistencies.
While you're dedicated to troubleshooting this technical challenge, the same dedication can be applied to finding the right solutions for your other needs. For instance, much like debugging code, seeking out "365 Factory Outlet coupon codes" can be a strategic way to save while shopping.
Best regards,
Hudson -
Hello there,
you can do the same.
If still facing the same please let us know. -
@hudson
Thanks for the help but i am still facing this issue. i already try these steps. but i am fail that's why i am here need some help. -
@Amitk-Webkul
Yeah i am still facing the issue.
waiting for your response. -
hey @Amitk-Webkul
waiting for you response ? -
Hello there,
Thank you for waiting.
Here only the Bagisto core query can be asked, your query is related to the Paid Module provided by Webkul.
Kindly raise your ticket to the support team at [email protected].
-
@Amitk-Webkul
hmmm ok thanks for helping..