[Skip to main content](#vessel-content) # Product characteristics mass action SQL Error ## - **[yanliom](/forum/user/45218-yanliom "View yanliom's Profile")** - [![yanliom's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/45218-yanliom "View yanliom's Profile") Topic Author - [ Offline](/forum/user/45218-yanliom) Less More - Posts: 66 - Thank you received: 1 - - 6 years 5 months ago [\#319877](#319877) by [yanliom](/forum/user/45218-yanliom "View yanliom's Profile") *[Product characteristics mass action SQL Error](/forum/44-mass-actions/900010-product-characteristics-mass-action-sql-error#319877 "-- url of the page with the problem -- : seemybag.gr/alpha -- HikaShop version -- : 4.3.0 -- Joomla version -- : 3.9.18 -- PHP version -- : 7.4 -- Error-message(debug-mod must be tuned on) -- : Error in SQL syntax Hello, when I try to add a filter for a product Characteristic I get an SQL Error. See attached image for info.")* was created by *[yanliom](/forum/user/45218-yanliom "View yanliom's Profile")* -- url of the page with the problem -- : [ seemybag.gr/alpha](https://seemybag.gr/alpha) -- HikaShop version -- : 4.3.0 -- Joomla version -- : 3.9.18 -- PHP version -- : 7.4 -- Error-message(debug-mod must be tuned on) -- : Error in SQL syntax Hello, when I try to add a filter for a product Characteristic I get an SQL Error. See attached image for info. [ ![Capture_2020-05-27.PNG](/forum/attachment/49528) ](/forum/attachment/49528 "...2020-05-27.PNG") - [ ![Capture_2020-05-27.PNG](/forum/attachment/49528) ](/forum/attachment/49528 "...2020-05-27.PNG") [ ](/forum/attachment/49528?download=1 "...2020-05-27.PNG") Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtL21hc3MtYWN0aW9ucy85MDAwMTAtcHJvZHVjdC1jaGFyYWN0ZXJpc3RpY3MtbWFzcy1hY3Rpb24tc3FsLWVycm9yP3RtcGw9bWFya2Rvd24=) 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: 14304 - - 6 years 5 months ago [\#319882](#319882) by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") Replied by *[nicolas](/forum/user/63-nicolas "View nicolas's Profile")* on topic *[Product characteristics mass action SQL Error](/forum/44-mass-actions/900010-product-characteristics-mass-action-sql-error#319882 "-- url of the page with the problem -- : seemybag.gr/alpha -- HikaShop version -- : 4.3.0 -- Joomla version -- : 3.9.18 -- PHP version -- : 7.4 -- Error-message(debug-mod must be tuned on) -- : Error in SQL syntax Hello, when I try to add a filter for a product Characteristic I get an SQL Error. See attached image for info.")* Hi, Thank you for your feedback. We've added a patch on our end for that. Download again the install package of HikaShop on our website and install it on your website and it will add that patch. Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtL21hc3MtYWN0aW9ucy85MDAwMTAtcHJvZHVjdC1jaGFyYWN0ZXJpc3RpY3MtbWFzcy1hY3Rpb24tc3FsLWVycm9yP3RtcGw9bWFya2Rvd24=) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[yanliom](/forum/user/45218-yanliom "View yanliom's Profile")** - [![yanliom's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/45218-yanliom "View yanliom's Profile") Topic Author - [ Offline](/forum/user/45218-yanliom) Less More - Posts: 66 - Thank you received: 1 - - 6 years 5 months ago [\#319897](#319897) by [yanliom](/forum/user/45218-yanliom "View yanliom's Profile") Replied by *[yanliom](/forum/user/45218-yanliom "View yanliom's Profile")* on topic *[Product characteristics mass action SQL Error](/forum/44-mass-actions/900010-product-characteristics-mass-action-sql-error#319897 "-- url of the page with the problem -- : seemybag.gr/alpha -- HikaShop version -- : 4.3.0 -- Joomla version -- : 3.9.18 -- PHP version -- : 7.4 -- Error-message(debug-mod must be tuned on) -- : Error in SQL syntax Hello, when I try to add a filter for a product Characteristic I get an SQL Error. See attached image for info.")* Hello, thank you so much! The error was resolved. When I filter a certain Characteristic it finds the number of products x 2. I have 76 products with Wet Bag Size = Small and it finds 152 results. Is that normal? What if I change now the price? Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtL21hc3MtYWN0aW9ucy85MDAwMTAtcHJvZHVjdC1jaGFyYWN0ZXJpc3RpY3MtbWFzcy1hY3Rpb24tc3FsLWVycm9yP3RtcGw9bWFya2Rvd24=) 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: 14304 - - 6 years 5 months ago [\#319899](#319899) by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") Replied by *[nicolas](/forum/user/63-nicolas "View nicolas's Profile")* on topic *[Product characteristics mass action SQL Error](/forum/44-mass-actions/900010-product-characteristics-mass-action-sql-error#319899 "-- url of the page with the problem -- : seemybag.gr/alpha -- HikaShop version -- : 4.3.0 -- Joomla version -- : 3.9.18 -- PHP version -- : 7.4 -- Error-message(debug-mod must be tuned on) -- : Error in SQL syntax Hello, when I try to add a filter for a product Characteristic I get an SQL Error. See attached image for info.")* Hi Well, if you're sure you have 76 products with that characteristic value and it says you have 152 products with it, then there is a problem. I would recommend to first use the action "display the results" so that you can check what products it found before running an action that will modify the products. That way, you can check on which products it will do the changes before doing them. Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtL21hc3MtYWN0aW9ucy85MDAwMTAtcHJvZHVjdC1jaGFyYWN0ZXJpc3RpY3MtbWFzcy1hY3Rpb24tc3FsLWVycm9yP3RtcGw9bWFya2Rvd24=) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[yanliom](/forum/user/45218-yanliom "View yanliom's Profile")** - [![yanliom's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/45218-yanliom "View yanliom's Profile") Topic Author - [ Offline](/forum/user/45218-yanliom) Less More - Posts: 66 - Thank you received: 1 - - 6 years 5 months ago [\#320012](#320012) by [yanliom](/forum/user/45218-yanliom "View yanliom's Profile") Replied by *[yanliom](/forum/user/45218-yanliom "View yanliom's Profile")* on topic *[Product characteristics mass action SQL Error](/forum/44-mass-actions/900010-product-characteristics-mass-action-sql-error#320012 "-- url of the page with the problem -- : seemybag.gr/alpha -- HikaShop version -- : 4.3.0 -- Joomla version -- : 3.9.18 -- PHP version -- : 7.4 -- Error-message(debug-mod must be tuned on) -- : Error in SQL syntax Hello, when I try to add a filter for a product Characteristic I get an SQL Error. See attached image for info.")* Hello, I checked the results and it returns also the "parent" product along with the variant. Is that normal? Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtL21hc3MtYWN0aW9ucy85MDAwMTAtcHJvZHVjdC1jaGFyYWN0ZXJpc3RpY3MtbWFzcy1hY3Rpb24tc3FsLWVycm9yP3RtcGw9bWFya2Rvd24=) 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: 14304 - - 6 years 5 months ago [\#320095](#320095) by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") Replied by *[nicolas](/forum/user/63-nicolas "View nicolas's Profile")* on topic *[Product characteristics mass action SQL Error](/forum/44-mass-actions/900010-product-characteristics-mass-action-sql-error#320095 "-- url of the page with the problem -- : seemybag.gr/alpha -- HikaShop version -- : 4.3.0 -- Joomla version -- : 3.9.18 -- PHP version -- : 7.4 -- Error-message(debug-mod must be tuned on) -- : Error in SQL syntax Hello, when I try to add a filter for a product Characteristic I get an SQL Error. See attached image for info.")* Hi, Yes. Just add a second filter on the product type to only have the main products if you don't want the variants matching with that value Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtL21hc3MtYWN0aW9ucy85MDAwMTAtcHJvZHVjdC1jaGFyYWN0ZXJpc3RpY3MtbWFzcy1hY3Rpb24tc3FsLWVycm9yP3RtcGw9bWFya2Rvd24=) or [Create an account](/component/users/registration?Itemid=101) 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.059 seconds [Powered by](/forum/credits) [Kunena Forum](https://www.kunena.org)