1054 - Unknown column since update

-- HikaShop version -- : 2.6.4
-- Joomla version -- : 3.6.0
-- Error-message(debug-mod must be tuned on) -- : 1054 - Unknown column '12153' in 'field list' SQL=INSERT INTO lv8ip_hikashop_cart_product (cart_id,cart_product_modified,product_id,cart_product_parent_id,cart_product_quantity,cart_product_option_parent_id,cart_product_wishlist_id,`12153`,`12154`) VALUES (6414,1475060138,15,0,1,0,904,'1,1','0')

Hello,

Since the update we have the following error:

1054 - Unknown column '12153' in 'field list' SQL=INSERT INTO lv8ip_hikashop_cart_product (cart_id,cart_product_modified,product_id,cart_product_parent_id,cart_product_quantity,cart_product_option_parent_id,cart_product_wishlist_id,`12153`,`12154`) VALUES (6414,1475060138,15,0,1,0,904,'1,1','0')

This error is coming up, when customers are making the order from their wishlists.
Please help me solve this problem!

Kind regards,

Danny Kunst

Hello,

Do you have try the "Check database" process ?



Maybe that can solve your issue.

Awaiting news from you.

Regards

Hello,

Yes we did this already.. with no effect.
We have installed the old version of Hikashop (2.6.3.) and it works fine... it has to be in the update!

Kind regards,

Danny Kunst

Hello,

Thanks for your return, it leads me to create a patch that we hope may solve your issue.
So, can you try to update your HikaShop version.

Awaiting news from you.

regards

Hi Philip,

Thanks for you're answer...

I can try this.. there is one problem, the wishlist is the most important thing on our web-shop.
We use the wishlist as an order list, in this list are the products that our customers have in their assortment.

So before we update Hikashop i must make sure that there are no problems.

Is the whishlits & shopping cart in the user menu also responsive in the update?

Kind regards,

Danny Kunst

Hi,

If the wishlist/shopping was like you want on the previous version, then it won't change with this new version.
We just added the patch to fix the error with the MySQL query.