[Skip to main content](#vessel-content) # cannot delete products in order ## - **[islandbabyvi](/forum/user/16427-islandbabyvi "View islandbabyvi's Profile")** - [![islandbabyvi's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/16427-islandbabyvi "View islandbabyvi's Profile") Topic Author - [ Offline](/forum/user/16427-islandbabyvi) Less More - Posts: 6 - Thank you received: 0 - - 12 years 10 months ago [\#135374](#135374) by [islandbabyvi](/forum/user/16427-islandbabyvi "View islandbabyvi's Profile") *[cannot delete products in order](/forum/25-install-update/864124-cannot-delete-products-in-order#135374 "Good Day, We have installed Hikashop Business 2.2.2 When we try to delete a product from an order, it says "Are you sure that you want to delete that product from the order?" We press OK, then it says "loading..." next to the product, it refreshes, but the product is still there. Likewise, I can not add a product to an existing order, it doesn't show. I looked in the jos_hikashop_order_product table and it seems that the order_product_id is saving as 0. The structure of order_product_id is as follows: Type: INT Length/Value: 10 Collation: Blank Attributes: Blank Null: not null Default: Blank Extra: Blank Comments: Blank Thank you. UPDATE: I am assuming that Extra should be auto_increment, and at some point it has changed. There are over 300 products with 0 id. To rectify this I renamed the field order_product_id to order_product_id_bu2 then created a new field order_product_id and set the structure to exactly the same as above but with Extra as auto_increment. This did the trick. But... I remember the same thing happened about a year ago on the same field in the same table. Do you have any ideas if why the field is losing its structure? Many Thanks")* was created by *[islandbabyvi](/forum/user/16427-islandbabyvi "View islandbabyvi's Profile")* Good Day, We have installed Hikashop Business 2.2.2 When we try to delete a product from an order, it says "Are you sure that you want to delete that product from the order?" We press OK, then it says "loading..." next to the product, it refreshes, but the product is still there. Likewise, I can not add a product to an existing order, it doesn't show. I looked in the jos_hikashop_order_product table and it seems that the order_product_id is saving as 0. The structure of order_product_id is as follows: Type: INT Length/Value: 10 Collation: Blank Attributes: Blank Null: not null Default: Blank Extra: Blank Comments: Blank Thank you. UPDATE: I am assuming that Extra should be auto_increment, and at some point it has changed. There are over 300 products with 0 id. To rectify this I renamed the field order_product_id to order_product_id_bu2 then created a new field order_product_id and set the structure to exactly the same as above but with Extra as auto_increment. This did the trick. But... I remember the same thing happened about a year ago on the same field in the same table. Do you have any ideas if why the field is losing its structure? Many Thanks Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzI1LWluc3RhbGwtdXBkYXRlLzg2NDEyNC1jYW5ub3QtZGVsZXRlLXByb2R1Y3RzLWluLW9yZGVyP3RtcGw9bWFya2Rvd24=) or [Create an account](/register) to join the conversation. - **[Mohamed Thelji](/forum/user/6861-mohamed-thelji "View Mohamed Thelji's Profile")** - [![Mohamed Thelji's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar6861.png)](/forum/user/6861-mohamed-thelji "View Mohamed Thelji's Profile") - [ Offline](/forum/user/6861-mohamed-thelji) Less More - Posts: 12953 - Thank you received: 1778 - - - 12 years 10 months ago [\#135443](#135443) by [Mohamed Thelji](/forum/user/6861-mohamed-thelji "View Mohamed Thelji's Profile") Replied by *[Mohamed Thelji](/forum/user/6861-mohamed-thelji "View Mohamed Thelji's Profile")* on topic *[cannot delete products in order](/forum/25-install-update/864124-cannot-delete-products-in-order#135443 "Good Day, We have installed Hikashop Business 2.2.2 When we try to delete a product from an order, it says "Are you sure that you want to delete that product from the order?" We press OK, then it says "loading..." next to the product, it refreshes, but the product is still there. Likewise, I can not add a product to an existing order, it doesn't show. I looked in the jos_hikashop_order_product table and it seems that the order_product_id is saving as 0. The structure of order_product_id is as follows: Type: INT Length/Value: 10 Collation: Blank Attributes: Blank Null: not null Default: Blank Extra: Blank Comments: Blank Thank you. UPDATE: I am assuming that Extra should be auto_increment, and at some point it has changed. There are over 300 products with 0 id. To rectify this I renamed the field order_product_id to order_product_id_bu2 then created a new field order_product_id and set the structure to exactly the same as above but with Extra as auto_increment. This did the trick. But... I remember the same thing happened about a year ago on the same field in the same table. Do you have any ideas if why the field is losing its structure? Many Thanks")* Hi, It seems to be working fine on my end, can you : - Active the joomla debug mode ("*Administration->Global configuration->System->Debug System/Language*") - Set the "error reporting" option of the joomla configuration to "maximum" - test it again so that we can see if it display an error message. Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzI1LWluc3RhbGwtdXBkYXRlLzg2NDEyNC1jYW5ub3QtZGVsZXRlLXByb2R1Y3RzLWluLW9yZGVyP3RtcGw9bWFya2Rvd24=) or [Create an account](/register) to join the conversation. Board Categories HikaShop Install & Update Product & Category Display Content Creation Sales and Orders Orders management Reports & Statistics Customers Checkout Payment Methods Shipping Methods Import & Export (CSV, XLS…) Specific Features Affilation Taxes Wishlist Vote Carousel & Slider Mass Actions Filters & Search Discount & 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.073 seconds [Powered by](/forum/credits) [Kunena Forum](https://www.kunena.org) [](#top)