[Skip to main content](#vessel-content)

#   1054 - Unknown column since update

##

- **[DannyKunst](/forum/user/36785-dannykunst "View DannyKunst's Profile")**
- [![DannyKunst's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar36785.png)](/forum/user/36785-dannykunst "View DannyKunst's Profile") Topic Author
- [ Offline](/forum/user/36785-dannykunst)

Less More

- Posts: 37
- Thank you received: 1
-
-
-
-

10 years 1 month ago [\#250972](#250972) by [DannyKunst](/forum/user/36785-dannykunst "View DannyKunst's Profile")  *[1054 - Unknown column since update](/forum/25-install-update/886633-1054-unknown-column-since-update#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&#95;hikashop&#95;cart&#95;product (cart&#95;id,cart&#95;product&#95;modified,product&#95;id,cart&#95;product&#95;parent&#95;id,cart&#95;product&#95;quantity,cart&#95;product&#95;option&#95;parent&#95;id,cart&#95;product&#95;wishlist&#95;id,&#96;12153&#96;,&#96;12154&#96;) 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&#95;hikashop&#95;cart&#95;product (cart&#95;id,cart&#95;product&#95;modified,product&#95;id,cart&#95;product&#95;parent&#95;id,cart&#95;product&#95;quantity,cart&#95;product&#95;option&#95;parent&#95;id,cart&#95;product&#95;wishlist&#95;id,&#96;12153&#96;,&#96;12154&#96;) 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")* was created by *[DannyKunst](/forum/user/36785-dannykunst "View DannyKunst's Profile")*

-- 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,&#96;12153&#96;,&#96;12154&#96;) 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,&#96;12153&#96;,&#96;12154&#96;) 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](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzI1LWluc3RhbGwtdXBkYXRlLzg4NjYzMy0xMDU0LXVua25vd24tY29sdW1uLXNpbmNlLXVwZGF0ZT90bXBsPW1hcmtkb3du) or [Create an account](/component/users/registration?Itemid=101) to join the conversation.

- **[Philip](/forum/user/34318-philip "View Philip's Profile")**
- [![Philip's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/34318-philip "View Philip's Profile")
- [ Offline](/forum/user/34318-philip)

Less More

- Posts: 4820
- Thank you received: 652
-
-

10 years 1 month ago -  10 years 1 month ago [\#250973](#250973) by [Philip](/forum/user/34318-philip "View Philip's Profile")  Replied by *[Philip](/forum/user/34318-philip "View Philip's Profile")* on topic *[1054 - Unknown column since update](/forum/25-install-update/886633-1054-unknown-column-since-update#250973 "-- 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&#95;hikashop&#95;cart&#95;product (cart&#95;id,cart&#95;product&#95;modified,product&#95;id,cart&#95;product&#95;parent&#95;id,cart&#95;product&#95;quantity,cart&#95;product&#95;option&#95;parent&#95;id,cart&#95;product&#95;wishlist&#95;id,&#96;12153&#96;,&#96;12154&#96;) 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&#95;hikashop&#95;cart&#95;product (cart&#95;id,cart&#95;product&#95;modified,product&#95;id,cart&#95;product&#95;parent&#95;id,cart&#95;product&#95;quantity,cart&#95;product&#95;option&#95;parent&#95;id,cart&#95;product&#95;wishlist&#95;id,&#96;12153&#96;,&#96;12154&#96;) 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 ?

[ ![checkdatabase.png](/forum/attachment/33695) ](/forum/attachment/33695 "checkdatabase.png")

Maybe that can solve your issue.

Awaiting news from you.

Regards

- [ ![checkdatabase.png](/forum/attachment/33695) ](/forum/attachment/33695 "checkdatabase.png") [ ](/forum/attachment/33695?download=1 "checkdatabase.png")

Last edit: 10 years 1 month ago by [Philip](/forum/user/34318-philip "View Philip's Profile").

Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzI1LWluc3RhbGwtdXBkYXRlLzg4NjYzMy0xMDU0LXVua25vd24tY29sdW1uLXNpbmNlLXVwZGF0ZT90bXBsPW1hcmtkb3du) or [Create an account](/component/users/registration?Itemid=101) to join the conversation.

- **[DannyKunst](/forum/user/36785-dannykunst "View DannyKunst's Profile")**
- [![DannyKunst's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar36785.png)](/forum/user/36785-dannykunst "View DannyKunst's Profile") Topic Author
- [ Offline](/forum/user/36785-dannykunst)

Less More

- Posts: 37
- Thank you received: 1
-
-
-
-

10 years 1 month ago -  10 years 1 month ago [\#251031](#251031) by [DannyKunst](/forum/user/36785-dannykunst "View DannyKunst's Profile")  Replied by *[DannyKunst](/forum/user/36785-dannykunst "View DannyKunst's Profile")* on topic *[1054 - Unknown column since update](/forum/25-install-update/886633-1054-unknown-column-since-update#251031 "-- 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&#95;hikashop&#95;cart&#95;product (cart&#95;id,cart&#95;product&#95;modified,product&#95;id,cart&#95;product&#95;parent&#95;id,cart&#95;product&#95;quantity,cart&#95;product&#95;option&#95;parent&#95;id,cart&#95;product&#95;wishlist&#95;id,&#96;12153&#96;,&#96;12154&#96;) 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&#95;hikashop&#95;cart&#95;product (cart&#95;id,cart&#95;product&#95;modified,product&#95;id,cart&#95;product&#95;parent&#95;id,cart&#95;product&#95;quantity,cart&#95;product&#95;option&#95;parent&#95;id,cart&#95;product&#95;wishlist&#95;id,&#96;12153&#96;,&#96;12154&#96;) 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,

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: 10 years 1 month ago by [DannyKunst](/forum/user/36785-dannykunst "View DannyKunst's Profile").

Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzI1LWluc3RhbGwtdXBkYXRlLzg4NjYzMy0xMDU0LXVua25vd24tY29sdW1uLXNpbmNlLXVwZGF0ZT90bXBsPW1hcmtkb3du) or [Create an account](/component/users/registration?Itemid=101) to join the conversation.

- **[Philip](/forum/user/34318-philip "View Philip's Profile")**
- [![Philip's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/34318-philip "View Philip's Profile")
- [ Offline](/forum/user/34318-philip)

Less More

- Posts: 4820
- Thank you received: 652
-
-

10 years 1 month ago [\#251052](#251052) by [Philip](/forum/user/34318-philip "View Philip's Profile")  Replied by *[Philip](/forum/user/34318-philip "View Philip's Profile")* on topic *[1054 - Unknown column since update](/forum/25-install-update/886633-1054-unknown-column-since-update#251052 "-- 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&#95;hikashop&#95;cart&#95;product (cart&#95;id,cart&#95;product&#95;modified,product&#95;id,cart&#95;product&#95;parent&#95;id,cart&#95;product&#95;quantity,cart&#95;product&#95;option&#95;parent&#95;id,cart&#95;product&#95;wishlist&#95;id,&#96;12153&#96;,&#96;12154&#96;) 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&#95;hikashop&#95;cart&#95;product (cart&#95;id,cart&#95;product&#95;modified,product&#95;id,cart&#95;product&#95;parent&#95;id,cart&#95;product&#95;quantity,cart&#95;product&#95;option&#95;parent&#95;id,cart&#95;product&#95;wishlist&#95;id,&#96;12153&#96;,&#96;12154&#96;) 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,

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](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzI1LWluc3RhbGwtdXBkYXRlLzg4NjYzMy0xMDU0LXVua25vd24tY29sdW1uLXNpbmNlLXVwZGF0ZT90bXBsPW1hcmtkb3du) or [Create an account](/component/users/registration?Itemid=101) to join the conversation.

- **[DannyKunst](/forum/user/36785-dannykunst "View DannyKunst's Profile")**
- [![DannyKunst's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar36785.png)](/forum/user/36785-dannykunst "View DannyKunst's Profile") Topic Author
- [ Offline](/forum/user/36785-dannykunst)

Less More

- Posts: 37
- Thank you received: 1
-
-
-
-

10 years 1 month ago [\#251122](#251122) by [DannyKunst](/forum/user/36785-dannykunst "View DannyKunst's Profile")  Replied by *[DannyKunst](/forum/user/36785-dannykunst "View DannyKunst's Profile")* on topic *[1054 - Unknown column since update](/forum/25-install-update/886633-1054-unknown-column-since-update#251122 "-- 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&#95;hikashop&#95;cart&#95;product (cart&#95;id,cart&#95;product&#95;modified,product&#95;id,cart&#95;product&#95;parent&#95;id,cart&#95;product&#95;quantity,cart&#95;product&#95;option&#95;parent&#95;id,cart&#95;product&#95;wishlist&#95;id,&#96;12153&#96;,&#96;12154&#96;) 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&#95;hikashop&#95;cart&#95;product (cart&#95;id,cart&#95;product&#95;modified,product&#95;id,cart&#95;product&#95;parent&#95;id,cart&#95;product&#95;quantity,cart&#95;product&#95;option&#95;parent&#95;id,cart&#95;product&#95;wishlist&#95;id,&#96;12153&#96;,&#96;12154&#96;) 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")*

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 &amp; shopping cart in the user menu also responsive in the update?

Kind regards,

Danny Kunst

Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzI1LWluc3RhbGwtdXBkYXRlLzg4NjYzMy0xMDU0LXVua25vd24tY29sdW1uLXNpbmNlLXVwZGF0ZT90bXBsPW1hcmtkb3du) or [Create an account](/component/users/registration?Itemid=101) to join the conversation.

- **[nicolas](/forum/user/63-nicolas "View nicolas's Profile")**
- [![nicolas's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar63.png?1793428657)](/forum/user/63-nicolas "View nicolas's Profile")
- [ Offline](/forum/user/63-nicolas)

Less More

- Posts: 86541
- Thank you received: 14304
-
-

10 years 1 month ago [\#251125](#251125) by [nicolas](/forum/user/63-nicolas "View nicolas's Profile")  Replied by *[nicolas](/forum/user/63-nicolas "View nicolas's Profile")* on topic *[1054 - Unknown column since update](/forum/25-install-update/886633-1054-unknown-column-since-update#251125 "-- 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&#95;hikashop&#95;cart&#95;product (cart&#95;id,cart&#95;product&#95;modified,product&#95;id,cart&#95;product&#95;parent&#95;id,cart&#95;product&#95;quantity,cart&#95;product&#95;option&#95;parent&#95;id,cart&#95;product&#95;wishlist&#95;id,&#96;12153&#96;,&#96;12154&#96;) 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&#95;hikashop&#95;cart&#95;product (cart&#95;id,cart&#95;product&#95;modified,product&#95;id,cart&#95;product&#95;parent&#95;id,cart&#95;product&#95;quantity,cart&#95;product&#95;option&#95;parent&#95;id,cart&#95;product&#95;wishlist&#95;id,&#96;12153&#96;,&#96;12154&#96;) 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")*

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](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzI1LWluc3RhbGwtdXBkYXRlLzg4NjYzMy0xMDU0LXVua25vd24tY29sdW1uLXNpbmNlLXVwZGF0ZT90bXBsPW1hcmtkb3du) or [Create an account](/component/users/registration?Itemid=101) to join the conversation.

Board Categories HikaShop Install &amp; Update Product &amp; Category Display Content Creation Sales and Orders Orders management Reports &amp; Statistics Customers Checkout Payment Methods Shipping Methods Import &amp; Export (CSV, XLS…) Specific Features Affilation Taxes Wishlist Vote Carousel &amp; Slider Mass Actions Filters &amp; Search Discount &amp; Coupon Feature Request Integrations Showcase General Talk about HikaShop Development HikaShop 3.0 Beta Translation Commercial Jobs HikaShop Components HikaMarket Market: Feature requests Market: How to? Market: Bug Report HikaSerial General talk about HikaSerial Serial: Bug Report Serial: How to? Support en Français de HikaSerial (French Support) HikaSubscription HikaAuction Auction: Feature requests Auction: How to? Auction: Bug report Hikashop around the world Support en Français (French Support) Russian FAQ. Курс выживания с Hikashop. Частые вопросы и о Расширения Hikashop Наши сайты на Hikashop 日本語版サポート(Japanese Support) Thai German Archives Bug Report How to?

[](/forum/topics/feed/mode-topics?format=feed&type=rss)

Time to create page: 0.066 seconds

[Powered by](/forum/credits) [Kunena Forum](https://www.kunena.org)
