Easystore Problem - Question | JoomShaper
Black Friday sale is live with flat 50% OFF. Sale ends soon! Grab your deal now!

Easystore Problem

RM

Roberto Muniz

EasyStore 1 month ago

problem in the administration/products area. error 500 Unknown column 'a.brand_id' in 'field list' Unknown column 'a.brand_id' in 'on clause'

0
9 Answers
Ofi Khan
Ofi Khan
Accepted Answer
Support Agent 1 month ago #207690

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

0
RM
Roberto Muniz
Accepted Answer
1 month ago #207711

I can't add it directly here. You have it ready in Akeeba Backup. If you use administrator credentials, you can download it.

0
Ofi Khan
Ofi Khan
Accepted Answer
Support Agent 1 month ago #207733

Thanks for your allowance. I will take it from your site.

0
RM
Roberto Muniz
Accepted Answer
1 month ago #207997

Hi Ofi Khan, have you been able to review the problem?

0
Ofi Khan
Ofi Khan
Accepted Answer
Support Agent 1 month ago #208057

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.

0
RM
Roberto Muniz
Accepted Answer
1 month ago #208066

What files need to be changed? I've made a lot of changes these days and can't upload a backup.

0
Ofi Khan
Ofi Khan
Accepted Answer
Support Agent 1 month ago #208092

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.

0
RM
Roberto Muniz
Accepted Answer
1 month ago #208198

ok, solved. thanks

0
Ofi Khan
Ofi Khan
Accepted Answer
Support Agent 1 month ago #208472

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 

  1. Joomla Extension Directory
  2. TrustPilot

This will inspire us to improve.

0