Error in EasyStore Checkout – "Unknown column in field list" - Forum | JoomShaper
Solved EasyStore

Error in EasyStore Checkout – "Unknown column in field list"

Asked by Alexander Frenkel 1 year ago Last activity 1 year ago

Dear JoomShaper Support Team,

I am experiencing a critical issue with EasyStore. After clicking on "Checkout," I receive the following error message:
Unknown column 'ord_pro_map.cart_item' in 'field list'

As a result, the order is not processed, and the shopping cart is emptied.

Could you please assist me in resolving this issue as soon as possible? I appreciate your prompt support.

Best regards,
Alexander

Accepted answer

Marked as the solution
Ziaul Kabir Staff

Hello,

Please use this sql query on your database, Hope it will resolve your issues.

ALTER TABLE `j5ws_easystore_orders` ADD `is_tax_included_in_price` TINYINT NOT NULL DEFAULT 1 AFTER `coupon_amount`;

Hope it will resolved your issues.

If no then create a new database, then import it:
site-j5-warum.sql.zip

Thanks,

7 more replies

Ziaul Kabir Staff

Hello Alexander,

Thanks for reaching out to us.

Could you please share your cPanel or database access in the hidden content section, so I can investigate this further?

Looking forward to your response.

Thanks!

Alexander Frenkel Asked this

Hi Ziaul ,
unfortunatelly I can't provide access too db as it's on provider side.
But I made an db export. you have the link in the hidden part of this message.
Thanks and regards,
Alexander

Alexander Frenkel Asked this

Hello Joomshaper-Support, any news on this issue?
Just updated Joomla and EasyStore to the last versions but there is the same issue.
How am I supposed to use the component if the main functionality does not work?
Thanks and regards,
Alexander

Ziaul Kabir Staff

Hello,

I have restored your Akeeba backup on my local PC and didn’t encounter any issues.

Could you please provide your database again? It seems to be unavailable at the moment.

Thanks for your cooperation!

Alexander Frenkel Asked this

Hi Ziaul,
DB is available now for 7 days with a new link.

Ziaul Kabir Staff

Please, run this query on your database sql, Before this please keep you databse backup.

ALTER TABLE j5ws_easystore_order_product_map ADD `cart_item` TEXT NULL AFTER `price`;

Thanks,

Alexander Frenkel Asked this
1 year ago · edited

Hi,
did it, but checkout doesn't work properly. Checkout button stays in waiting status for long time without any reaction. After refreshing of the page the cart is empty. A lot of warnings to see in the easystore orders backend and in the order-emails (see pictures), which I'm getting for the first time.

Alexander Frenkel Asked this

Any news for me?

Ziaul Kabir Staff

I apologize for this delay.

Please allow me some time to get back to you with a solution.

Thanks!

Alexander Frenkel Asked this

Hi Ziaul,
thanks, it seems to work now. You could close thee ticket.Best regards,
Alex

Ziaul Kabir Staff

You are welcome.

Log in to reply.