1054 - Unknown column since update

  • Posts: 37
  • Thank you received: 1
8 years 8 months ago #250972

-- 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

Please Log in or Create an account to join the conversation.

  • Posts: 4820
  • Thank you received: 654
  • MODERATOR
8 years 8 months ago #250973

Hello,

Do you have try the "Check database" process ?



Maybe that can solve your issue.

Awaiting news from you.

Regards

Attachments:
Last edit: 8 years 8 months ago by Philip.

Please Log in or Create an account to join the conversation.

  • Posts: 37
  • Thank you received: 1
8 years 8 months ago #251031

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

Last edit: 8 years 8 months ago by DannyKunst.

Please Log in or Create an account to join the conversation.

  • Posts: 4820
  • Thank you received: 654
  • MODERATOR
8 years 8 months ago #251052

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

Please Log in or Create an account to join the conversation.

  • Posts: 37
  • Thank you received: 1
8 years 8 months ago #251122

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

Please Log in or Create an account to join the conversation.

  • Posts: 83933
  • Thank you received: 13588
  • MODERATOR
8 years 8 months ago #251125

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.

Please Log in or Create an account to join the conversation.

Time to create page: 0.067 seconds
Powered by Kunena Forum