[Skip to main content](#vessel-content) # HELP not able to add products to Cart ## - **[crowcreekc](/forum/user/6451-crowcreekc "View crowcreekc's Profile")** - [![crowcreekc's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/6451-crowcreekc "View crowcreekc's Profile") Topic Author - [ Offline](/forum/user/6451-crowcreekc) Less More - Posts: 33 - Thank you received: 0 - - 13 years 8 months ago - 13 years 8 months ago [\#90132](#90132) by [crowcreekc](/forum/user/6451-crowcreekc "View crowcreekc's Profile") *[HELP not able to add products to Cart](/forum/3-bug-report/78375-help-not-able-to-add-products-to-cart#90132 "Customer's started to complain that they could not add a specific items to the Cart. When I turned on Debug, it flagged the custom Field I had added. It was a custom field added to the Item table and...")* was created by *[crowcreekc](/forum/user/6451-crowcreekc "View crowcreekc's Profile")* Customer's started to complain that they could not add a specific items to the Cart. When I turned on Debug, it flagged the custom Field I had added. It was a custom field added to the Item table and to a specific category of products. When I turned on Debug it stated that the column did not exist. When I look in the database the column was there but labled different in hikashop_cart_product. So I modified it. Once doing this, no items can be added to the cart, so I deleted the field via Administrator and recreated. Have the same issue, but now debug is giving me the following error. JDatabaseMySQLi::query: 1054 - Unknown column 'a.category_id' in 'field list' SQL=SELECT DISTINCT b.product_id,a.category_id, a.category_id FROM j25_hikashop_product_related AS a LEFT JOIN j25_hikashop_product AS b ON a.product_related_id=b.product_id WHERE b.product_published=1 AND a.product_related_type='related' AND a.product_id=689 AND b.product_type = 'main' AND (b.product_access = 'all' OR b.product_access LIKE '%,1,%') ORDER BY a.product_related_ordering ASC Help! I need to get this working without rebuilding the site. I have added the admin details in the attached document Last edit: 13 years 8 months ago by [crowcreekc](/forum/user/6451-crowcreekc "View crowcreekc's Profile"). Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzMtYnVnLXJlcG9ydC83ODM3NS1oZWxwLW5vdC1hYmxlLXRvLWFkZC1wcm9kdWN0cy10by1jYXJ0P3RtcGw9bWFya2Rvd24=) or [Create an account](/register) to join the conversation. - **[crowcreekc](/forum/user/6451-crowcreekc "View crowcreekc's Profile")** - [![crowcreekc's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/6451-crowcreekc "View crowcreekc's Profile") Topic Author - [ Offline](/forum/user/6451-crowcreekc) Less More - Posts: 33 - Thank you received: 0 - - 13 years 8 months ago [\#90133](#90133) by [crowcreekc](/forum/user/6451-crowcreekc "View crowcreekc's Profile") Replied by *[crowcreekc](/forum/user/6451-crowcreekc "View crowcreekc's Profile")* on topic *[HELP not able to add products to Cart](/forum/3-bug-report/78375-help-not-able-to-add-products-to-cart#90133 "Customer's started to complain that they could not add a specific items to the Cart. When I turned on Debug, it flagged the custom Field I had added. It was a custom field added to the Item table and...")* Ok, went into the cPanel and then PHP MyAdmin and had to Re-Optimize every Hikashop table. Now working. Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzMtYnVnLXJlcG9ydC83ODM3NS1oZWxwLW5vdC1hYmxlLXRvLWFkZC1wcm9kdWN0cy10by1jYXJ0P3RtcGw9bWFya2Rvd24=) 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.070 seconds [Powered by](/forum/credits) [Kunena Forum](https://www.kunena.org) [](#top)