Error In EasyStore Checkout – "Unknown Column In Field List"
Alexander Frenkel
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
Ziaul Kabir
Accepted AnswerHello,
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,
Ziaul Kabir
Accepted AnswerHello 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
Accepted AnswerHi 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
Accepted AnswerHello 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
Accepted AnswerHello,
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!
Ziaul Kabir
Accepted AnswerPlease, 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
Accepted AnswerHi, 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
Accepted AnswerAny news for me?