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

#   Moving items from Wishlist to Cart products SQL error

##

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

Less More

- Posts: 158
- Thank you received: 6
-
-

10 years 1 week ago [\#254460](#254460) by [artisanwebandprint](/forum/user/6555-artisanwebandprint "View artisanwebandprint's Profile")  *[Moving items from Wishlist to Cart products SQL error](/forum/41-wishlist/887314-moving-items-from-wishlist-to-cart-products-sql-error#254460 "-- url of the page with the problem -- :   www.tashatudorandfamily.com/my-account/cart/showcart  -- HikaShop version -- : 3.6.4 -- Joomla version -- : 3.6.4 -- PHP version -- : 5.6 -- Browser(s) name and version -- : all -- Error-message(debug-mod must be tuned on) -- : 1054 Unknown column '2814' in 'field list' SQL=INSERT INTO #&#95;&#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;2814&#96;,&#96;2816&#96;,&#96;2817&#96;,&#96;2917&#96;,&#96;2918&#96;) VALUES (1721,1478274695,473,3061,5,0,1582,'5,1','1,1','3,1','2,1','1,1')  Hello,  I have a wishlist setup for a customer and I checked each item I wanted to move to the cart. When I clicked the button to move them I got this message: 1054 Unknown column '2814' in 'field list' SQL=INSERT INTO #&#95;&#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;2814&#96;,&#96;2816&#96;,&#96;2817&#96;,&#96;2917&#96;,&#96;2918&#96;) VALUES (1721,1478274695,473,3061,5,0,1582,'5,1','1,1','3,1','2,1','1,1')  Please advise.  Thanks,  Dawn")* was created by *[artisanwebandprint](/forum/user/6555-artisanwebandprint "View artisanwebandprint's Profile")*

-- url of the page with the problem -- : [ www.tashatudorandfamily.com/my-account/cart/showcart](https://www.tashatudorandfamily.com/my-account/cart/showcart)
-- HikaShop version -- : 3.6.4
-- Joomla version -- : 3.6.4
-- PHP version -- : 5.6
-- Browser(s) name and version -- : all
-- Error-message(debug-mod must be tuned on) -- : 1054 Unknown column '2814' in 'field list' SQL=INSERT INTO #__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;2814&#96;,&#96;2816&#96;,&#96;2817&#96;,&#96;2917&#96;,&#96;2918&#96;) VALUES (1721,1478274695,473,3061,5,0,1582,'5,1','1,1','3,1','2,1','1,1')

Hello,

I have a wishlist setup for a customer and I checked each item I wanted to move to the cart. When I clicked the button to move them I got this message:
1054 Unknown column '2814' in 'field list' SQL=INSERT INTO #__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;2814&#96;,&#96;2816&#96;,&#96;2817&#96;,&#96;2917&#96;,&#96;2918&#96;) VALUES (1721,1478274695,473,3061,5,0,1582,'5,1','1,1','3,1','2,1','1,1')

Please advise.

Thanks,

Dawn

Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtL3dpc2hsaXN0Lzg4NzMxNC1tb3ZpbmctaXRlbXMtZnJvbS13aXNobGlzdC10by1jYXJ0LXByb2R1Y3RzLXNxbC1lcnJvcj90bXBsPW1hcmtkb3du) 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: 86556
- Thank you received: 14305
-
-

10 years 1 week ago [\#254497](#254497) by [nicolas](/forum/user/63-nicolas "View nicolas's Profile")  Replied by *[nicolas](/forum/user/63-nicolas "View nicolas's Profile")* on topic *[Moving items from Wishlist to Cart products SQL error](/forum/41-wishlist/887314-moving-items-from-wishlist-to-cart-products-sql-error#254497 "-- url of the page with the problem -- :   www.tashatudorandfamily.com/my-account/cart/showcart  -- HikaShop version -- : 3.6.4 -- Joomla version -- : 3.6.4 -- PHP version -- : 5.6 -- Browser(s) name and version -- : all -- Error-message(debug-mod must be tuned on) -- : 1054 Unknown column '2814' in 'field list' SQL=INSERT INTO #&#95;&#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;2814&#96;,&#96;2816&#96;,&#96;2817&#96;,&#96;2917&#96;,&#96;2918&#96;) VALUES (1721,1478274695,473,3061,5,0,1582,'5,1','1,1','3,1','2,1','1,1')  Hello,  I have a wishlist setup for a customer and I checked each item I wanted to move to the cart. When I clicked the button to move them I got this message: 1054 Unknown column '2814' in 'field list' SQL=INSERT INTO #&#95;&#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;2814&#96;,&#96;2816&#96;,&#96;2817&#96;,&#96;2917&#96;,&#96;2918&#96;) VALUES (1721,1478274695,473,3061,5,0,1582,'5,1','1,1','3,1','2,1','1,1')  Please advise.  Thanks,  Dawn")*

Hi,

Download the install package on our website and install it on yours. It should add a patch to avoid that.

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

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

Less More

- Posts: 158
- Thank you received: 6
-
-

10 years 1 week ago [\#254670](#254670) by [artisanwebandprint](/forum/user/6555-artisanwebandprint "View artisanwebandprint's Profile")  Replied by *[artisanwebandprint](/forum/user/6555-artisanwebandprint "View artisanwebandprint's Profile")* on topic *[Moving items from Wishlist to Cart products SQL error](/forum/41-wishlist/887314-moving-items-from-wishlist-to-cart-products-sql-error#254670 "-- url of the page with the problem -- :   www.tashatudorandfamily.com/my-account/cart/showcart  -- HikaShop version -- : 3.6.4 -- Joomla version -- : 3.6.4 -- PHP version -- : 5.6 -- Browser(s) name and version -- : all -- Error-message(debug-mod must be tuned on) -- : 1054 Unknown column '2814' in 'field list' SQL=INSERT INTO #&#95;&#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;2814&#96;,&#96;2816&#96;,&#96;2817&#96;,&#96;2917&#96;,&#96;2918&#96;) VALUES (1721,1478274695,473,3061,5,0,1582,'5,1','1,1','3,1','2,1','1,1')  Hello,  I have a wishlist setup for a customer and I checked each item I wanted to move to the cart. When I clicked the button to move them I got this message: 1054 Unknown column '2814' in 'field list' SQL=INSERT INTO #&#95;&#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;2814&#96;,&#96;2816&#96;,&#96;2817&#96;,&#96;2917&#96;,&#96;2918&#96;) VALUES (1721,1478274695,473,3061,5,0,1582,'5,1','1,1','3,1','2,1','1,1')  Please advise.  Thanks,  Dawn")*

Hello,

I updated the package as you recommended and tried to move everything in the wishlist to the basket. I click the Add to for each product, then click Add to Basket at the bottom of the wishlist. The page refreshes, but nothing is added to the cart. The wishlist is still intact. There is no error message.

Thanks,

Dawn

Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtL3dpc2hsaXN0Lzg4NzMxNC1tb3ZpbmctaXRlbXMtZnJvbS13aXNobGlzdC10by1jYXJ0LXByb2R1Y3RzLXNxbC1lcnJvcj90bXBsPW1hcmtkb3du) 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: 86556
- Thank you received: 14305
-
-

10 years 1 week ago [\#254693](#254693) by [nicolas](/forum/user/63-nicolas "View nicolas's Profile")  Replied by *[nicolas](/forum/user/63-nicolas "View nicolas's Profile")* on topic *[Moving items from Wishlist to Cart products SQL error](/forum/41-wishlist/887314-moving-items-from-wishlist-to-cart-products-sql-error#254693 "-- url of the page with the problem -- :   www.tashatudorandfamily.com/my-account/cart/showcart  -- HikaShop version -- : 3.6.4 -- Joomla version -- : 3.6.4 -- PHP version -- : 5.6 -- Browser(s) name and version -- : all -- Error-message(debug-mod must be tuned on) -- : 1054 Unknown column '2814' in 'field list' SQL=INSERT INTO #&#95;&#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;2814&#96;,&#96;2816&#96;,&#96;2817&#96;,&#96;2917&#96;,&#96;2918&#96;) VALUES (1721,1478274695,473,3061,5,0,1582,'5,1','1,1','3,1','2,1','1,1')  Hello,  I have a wishlist setup for a customer and I checked each item I wanted to move to the cart. When I clicked the button to move them I got this message: 1054 Unknown column '2814' in 'field list' SQL=INSERT INTO #&#95;&#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;2814&#96;,&#96;2816&#96;,&#96;2817&#96;,&#96;2917&#96;,&#96;2918&#96;) VALUES (1721,1478274695,473,3061,5,0,1582,'5,1','1,1','3,1','2,1','1,1')  Please advise.  Thanks,  Dawn")*

Hi,

Then could you provide a test user account and the steps to reproduce the problem so that we can analyze the situation ?

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

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

Less More

- Posts: 158
- Thank you received: 6
-
-

9 years 11 months ago [\#255531](#255531) by [artisanwebandprint](/forum/user/6555-artisanwebandprint "View artisanwebandprint's Profile")  Replied by *[artisanwebandprint](/forum/user/6555-artisanwebandprint "View artisanwebandprint's Profile")* on topic *[Moving items from Wishlist to Cart products SQL error](/forum/41-wishlist/887314-moving-items-from-wishlist-to-cart-products-sql-error#255531 "-- url of the page with the problem -- :   www.tashatudorandfamily.com/my-account/cart/showcart  -- HikaShop version -- : 3.6.4 -- Joomla version -- : 3.6.4 -- PHP version -- : 5.6 -- Browser(s) name and version -- : all -- Error-message(debug-mod must be tuned on) -- : 1054 Unknown column '2814' in 'field list' SQL=INSERT INTO #&#95;&#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;2814&#96;,&#96;2816&#96;,&#96;2817&#96;,&#96;2917&#96;,&#96;2918&#96;) VALUES (1721,1478274695,473,3061,5,0,1582,'5,1','1,1','3,1','2,1','1,1')  Hello,  I have a wishlist setup for a customer and I checked each item I wanted to move to the cart. When I clicked the button to move them I got this message: 1054 Unknown column '2814' in 'field list' SQL=INSERT INTO #&#95;&#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;2814&#96;,&#96;2816&#96;,&#96;2817&#96;,&#96;2917&#96;,&#96;2918&#96;) VALUES (1721,1478274695,473,3061,5,0,1582,'5,1','1,1','3,1','2,1','1,1')  Please advise.  Thanks,  Dawn")*

Hello,

I have given you super admin login via private message.

Go to users and click to Login as Suzanne Raab. Go to her wishlist and try to move it to the cart.

Please let me know how it goes.

Thanks,

Dawn

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

- **[Jerome](/forum/user/80-jerome "View Jerome's Profile")**
- [![Jerome's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar80.png)](/forum/user/80-jerome "View Jerome's Profile")
- [ Offline](/forum/user/80-jerome)
- HikaShop core developer

Less More

- Posts: 26400
- Thank you received: 4080
-
- [](http://obsi.dev)
-

9 years 11 months ago [\#255533](#255533) by [Jerome](/forum/user/80-jerome "View Jerome's Profile")  Replied by *[Jerome](/forum/user/80-jerome "View Jerome's Profile")* on topic *[Moving items from Wishlist to Cart products SQL error](/forum/41-wishlist/887314-moving-items-from-wishlist-to-cart-products-sql-error#255533 "-- url of the page with the problem -- :   www.tashatudorandfamily.com/my-account/cart/showcart  -- HikaShop version -- : 3.6.4 -- Joomla version -- : 3.6.4 -- PHP version -- : 5.6 -- Browser(s) name and version -- : all -- Error-message(debug-mod must be tuned on) -- : 1054 Unknown column '2814' in 'field list' SQL=INSERT INTO #&#95;&#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;2814&#96;,&#96;2816&#96;,&#96;2817&#96;,&#96;2917&#96;,&#96;2918&#96;) VALUES (1721,1478274695,473,3061,5,0,1582,'5,1','1,1','3,1','2,1','1,1')  Hello,  I have a wishlist setup for a customer and I checked each item I wanted to move to the cart. When I clicked the button to move them I got this message: 1054 Unknown column '2814' in 'field list' SQL=INSERT INTO #&#95;&#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;2814&#96;,&#96;2816&#96;,&#96;2817&#96;,&#96;2917&#96;,&#96;2918&#96;) VALUES (1721,1478274695,473,3061,5,0,1582,'5,1','1,1','3,1','2,1','1,1')  Please advise.  Thanks,  Dawn")*

Hi,

Please, never use private message to contact the support team.
You can use the "contact us" form but private message are not useful at all ; that's mostly why we do not receive any email notification for private message and why we have inbox with hundreds of unread messages.

Thank you for your understanding.

---

Jerome - Obsidev.com
HikaMarket &amp; HikaSerial developer / HikaShop core dev team.

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

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

Less More

- Posts: 158
- Thank you received: 6
-
-

9 years 11 months ago [\#255617](#255617) by [artisanwebandprint](/forum/user/6555-artisanwebandprint "View artisanwebandprint's Profile")  Replied by *[artisanwebandprint](/forum/user/6555-artisanwebandprint "View artisanwebandprint's Profile")* on topic *[Moving items from Wishlist to Cart products SQL error](/forum/41-wishlist/887314-moving-items-from-wishlist-to-cart-products-sql-error#255617 "-- url of the page with the problem -- :   www.tashatudorandfamily.com/my-account/cart/showcart  -- HikaShop version -- : 3.6.4 -- Joomla version -- : 3.6.4 -- PHP version -- : 5.6 -- Browser(s) name and version -- : all -- Error-message(debug-mod must be tuned on) -- : 1054 Unknown column '2814' in 'field list' SQL=INSERT INTO #&#95;&#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;2814&#96;,&#96;2816&#96;,&#96;2817&#96;,&#96;2917&#96;,&#96;2918&#96;) VALUES (1721,1478274695,473,3061,5,0,1582,'5,1','1,1','3,1','2,1','1,1')  Hello,  I have a wishlist setup for a customer and I checked each item I wanted to move to the cart. When I clicked the button to move them I got this message: 1054 Unknown column '2814' in 'field list' SQL=INSERT INTO #&#95;&#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;2814&#96;,&#96;2816&#96;,&#96;2817&#96;,&#96;2917&#96;,&#96;2918&#96;) VALUES (1721,1478274695,473,3061,5,0,1582,'5,1','1,1','3,1','2,1','1,1')  Please advise.  Thanks,  Dawn")*

Dear Jerome,

Thank you for letting me know. Just to confirm, you have a secure contact form that is only reviewed by trusted employees? I was sending super administrator login for an international ecommerce site, so security is a big concern for me.

Thanks,

Dawn

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

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

Less More

- Posts: 158
- Thank you received: 6
-
-

9 years 11 months ago [\#255619](#255619) by [artisanwebandprint](/forum/user/6555-artisanwebandprint "View artisanwebandprint's Profile")  Replied by *[artisanwebandprint](/forum/user/6555-artisanwebandprint "View artisanwebandprint's Profile")* on topic *[Moving items from Wishlist to Cart products SQL error](/forum/41-wishlist/887314-moving-items-from-wishlist-to-cart-products-sql-error#255619 "-- url of the page with the problem -- :   www.tashatudorandfamily.com/my-account/cart/showcart  -- HikaShop version -- : 3.6.4 -- Joomla version -- : 3.6.4 -- PHP version -- : 5.6 -- Browser(s) name and version -- : all -- Error-message(debug-mod must be tuned on) -- : 1054 Unknown column '2814' in 'field list' SQL=INSERT INTO #&#95;&#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;2814&#96;,&#96;2816&#96;,&#96;2817&#96;,&#96;2917&#96;,&#96;2918&#96;) VALUES (1721,1478274695,473,3061,5,0,1582,'5,1','1,1','3,1','2,1','1,1')  Hello,  I have a wishlist setup for a customer and I checked each item I wanted to move to the cart. When I clicked the button to move them I got this message: 1054 Unknown column '2814' in 'field list' SQL=INSERT INTO #&#95;&#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;2814&#96;,&#96;2816&#96;,&#96;2817&#96;,&#96;2917&#96;,&#96;2918&#96;) VALUES (1721,1478274695,473,3061,5,0,1582,'5,1','1,1','3,1','2,1','1,1')  Please advise.  Thanks,  Dawn")*

Hello,

The problem is now solved with moving the items from the Wishlist to the Cart and back again. I'm guessing the patch solved it as I cannot connect it to anything else. With the patch the "Status" returned again in the Wishlist only and CSS display:none breaks the table so I'll open a new ticket for that issue.

Warm Regards,

Dawn

Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtL3dpc2hsaXN0Lzg4NzMxNC1tb3ZpbmctaXRlbXMtZnJvbS13aXNobGlzdC10by1jYXJ0LXByb2R1Y3RzLXNxbC1lcnJvcj90bXBsPW1hcmtkb3du) 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.062 seconds

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