Solved EasyStore

Error on adding products

Asked by Patricia Lee 4 months ago Last activity 3 months ago

An error has occurred.
500 Unknown column 'a.is_taxable' in 'field list'

Everything else appears to work smoothly but when I click Products I get the above error in Easy Store Admin.

When I click the pop up that says "add your first product" it lets me. And I added one.

But still, clicking Products generates the above error.

Can you help?

The URL is https://school.tesseractcomputers.com although it does not appear in the scroller below. This URL is added to the Store Admin in my account here at JoomShaper though (and the license etc added to Easy Store)

Accepted answer

Marked as the solution

Rashida Rahman Staff

3 months ago

Hello,

I restored your backup on my local environment, and after testing, adding the following row to the easystore_products table resolved the issue.

Please check the screenshots for reference:

https://cleanshot.com/share/rKV2wmM3

https://cleanshot.com/share/1mKSwNLH

Kindly check your database and add the same row to the respective table, then let me know whether this resolves the issue on your end as well.

Best regards,

7 more replies

Rashida Rahman Staff

4 months ago

Hi there!

Sorry for your experience.

Do you currently have a full site backup available? Also, may I create an Akeeba Backup of your site so I can investigate the issue locally?

Best regards,

Patricia Lee Asked this

4 months ago

Hi there

I'm sure we can figure it out and I thank you for your help.

I have a fresh backup in Akeeba there for you. Feel free to grab that and see what you can find out.

Patricia Lee Asked this

3 months ago

Hi again

Just checking in to ensure this is not forgotten?

Rashida Rahman Staff

3 months ago

Hello,

Thanks for the follow up and for the backup. I am looking into it. I will let you know once I get a solution.

Best regards,

Rashida Rahman Staff

3 months ago

Did that help?

Patricia Lee Asked this

3 months ago

Hi Rahsida

My apologies - I did reply a few days ago but I guess I was in a bad area and it didn't post.

Yes the fix works.

I thank you very much for taking the time download the site locally to figure things out.

Rashida Rahman Staff

3 months ago

Hello,

Glad that I could help and you are always welcome:)

Have a nice day!