problem in the administration/products area.
error 500
Unknown column 'a.brand_id' in 'field list' Unknown column 'a.brand_id' in 'on clause'
Easystore problem
10 replies
Hello Roberto Muniz,
Thank you for reaching out to our technical support forum. I’m sorry to hear about the trouble you’re experiencing. Rest assured, I will look into this issue for you and work to resolve it as quickly as possible.
Please take a full site backup with Akeeba Backup in ZIP format and share here. Follow this tutorial. I will check it on my localhost.
Best regards
I can't add it directly here. You have it ready in Akeeba Backup. If you use administrator credentials, you can download it.
Thanks for your allowance. I will take it from your site.
Hi Ofi Khan, have you been able to review the problem?
Yes, I have checked and solved it on my localhost. Here is the fixed full site backup (in the hidden content). Please install it on your server. Your issue will be fixed.
What files need to be changed? I've made a lot of changes these days and can't upload a backup.
Okay, then share your database access. Or you can try it yourself. Run these SQL queries. Use your database table prefix instead of #
ALTER TABLE `#__easystore_products` ADD `unit` VARCHAR(10) NULL DEFAULT NULL AFTER `weight`;
ALTER TABLE `#__easystore_product_skus` ADD `unit` VARCHAR(10) NULL DEFAULT NULL AFTER `weight`;
ALTER TABLE `#__easystore_products` ADD `brand_id` INT NULL DEFAULT 0 AFTER `catid`;
Please keep a site backup before using the SQL queries for your safety.
ok, solved. thanks
You are welcome 😊
I have a humble request. It would be very kind of you if you can manage some moment to give us feedback on
This will inspire us to improve.
Just checking in to see if you have feedback on the provided solution. If the answer resolved your query, you can mark it as accepted to close the post and guide others with similar questions. You’ll find a button to accept answers below each comment.
If you need further assistance, feel free to let us know!