[Skip to main content](#vessel-content) # Profile for ibs9385 ## [![ibs9385's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/27945-ibs9385 "View ibs9385's Profile") **[ Offline](/forum/user/27945-ibs9385)** - **User Type:** User - **Register Date:** 12 Sep 2013 - **Last login:** 11 years 7 months ago - **Time Zone:** UTC +0:00 - **Local Time:** 23:19 - **Posts:** 14 - **Profile views:** 82 - **Thank you received:** 2 - **Gender:** Unknown - **Birthdate:** Unknown - Posts # ibs9385's recent posts (14 messages ) All Since last visit 4 Hours 8 Hours 12 Hours 24 Hours 48 Hours Week Month Year All Since last visit 4 Hours 8 Hours 12 Hours 24 Hours 48 Hours Week Month Year | [ ](#forumbottom) | Subject | Replies / Views | Last Post | [ ](#forumtop) | |---|---|---|---|---| | [](/forum/45-filters-search/865929-error-1052#144987) | [Error: 1052](/forum/45-filters-search/865929-error-1052#144987 "-- url of the page with the problem -- : staclio.smezzea.com/filter/product/listing -- HikaShop version -- : Business 2.2.3 -- Joomla version -- :3.2.1 -- PHP version -- : 5.3.27 -- Browser(s) name and version -- : XXXXX x.x.x -- Error-message(debug-mod must be tuned on) -- : Error_message I receive the message below when filtering variants - color & size Error: 1052 - Column 'product_vendor_id' in on clause is ambiguous SQL=SELECT DISTINCT b.* FROM k7aby_hikashop_product_category AS a LEFT JOIN k7aby_hikashop_product AS b ON a.product_id=b.product_id LEFT JOIN k7aby_hikashop_product AS c ON b.product_id=c.product_parent_id LEFT JOIN k7aby_hikashop_variant AS Filter4 ON Filter4.variant_product_id=c.product_id LEFT JOIN k7aby_hikamarket_vendor AS hikam_vendor ON product_vendor_id = hikam_vendor.vendor_id WHERE b.product_published=1 AND b.product_type = 'main' AND a.category_id IN (13,35,16,36,37,38,42) AND (b.product_access = 'all' OR b.product_access LIKE '%,3,%' OR b.product_access LIKE '%,8,%') AND Filter4.variant_characteristic_id IN (7) AND c.product_quantity!=0 AND (hikam_vendor.vendor_published IS NULL OR hikam_vendor.vendor_published = 1) ORDER BY a.ordering ASC LIMIT 0, 21 Please help. Thank you!") Category: [Filters & Search](/forum/45-filters-search "Question about filters and search fields") Topic started 12 years 8 months ago, by [ibs9385](/forum/user/27945-ibs9385 "View ibs9385's Profile") [Last Post](/forum/45-filters-search/865929-error-1052?start=20#203027 "Hi Trying to remove the : and replace with a € sign in the filter module - this is now done with a language override Search for Extension > Language overide > Constant = CURSOR_TITLE_SEPARATOR") 11 years 5 months ago by [huwhuw](/forum/user/35272-huwhuw "View huwhuw's Profile") - [1](/forum/45-filters-search/865929-error-1052?start=0 "Page:1") - [2](/forum/45-filters-search/865929-error-1052?start=20 "Page:2") | Replies:21 Views:3342 | [Last Post](/forum/45-filters-search/865929-error-1052?start=20#203027 "Hi Trying to remove the : and replace with a € sign in the filter module - this is now done with a language override Search for Extension > Language overide > Constant = CURSOR_TITLE_SEPARATOR") by [huwhuw](/forum/user/35272-huwhuw "View huwhuw's Profile") 11 years 5 months ago | | [](/forum/45-filters-search/865929-error-1052#144876) | [Error: 1052](/forum/45-filters-search/865929-error-1052#144876 "-- url of the page with the problem -- : staclio.smezzea.com/filter/product/listing -- HikaShop version -- : Business 2.2.3 -- Joomla version -- :3.2.1 -- PHP version -- : 5.3.27 -- Browser(s) name and version -- : XXXXX x.x.x -- Error-message(debug-mod must be tuned on) -- : Error_message I receive the message below when filtering variants - color & size Error: 1052 - Column 'product_vendor_id' in on clause is ambiguous SQL=SELECT DISTINCT b.* FROM k7aby_hikashop_product_category AS a LEFT JOIN k7aby_hikashop_product AS b ON a.product_id=b.product_id LEFT JOIN k7aby_hikashop_product AS c ON b.product_id=c.product_parent_id LEFT JOIN k7aby_hikashop_variant AS Filter4 ON Filter4.variant_product_id=c.product_id LEFT JOIN k7aby_hikamarket_vendor AS hikam_vendor ON product_vendor_id = hikam_vendor.vendor_id WHERE b.product_published=1 AND b.product_type = 'main' AND a.category_id IN (13,35,16,36,37,38,42) AND (b.product_access = 'all' OR b.product_access LIKE '%,3,%' OR b.product_access LIKE '%,8,%') AND Filter4.variant_characteristic_id IN (7) AND c.product_quantity!=0 AND (hikam_vendor.vendor_published IS NULL OR hikam_vendor.vendor_published = 1) ORDER BY a.ordering ASC LIMIT 0, 21 Please help. Thank you!") Category: [Filters & Search](/forum/45-filters-search "Question about filters and search fields") Topic started 12 years 8 months ago, by [ibs9385](/forum/user/27945-ibs9385 "View ibs9385's Profile") [Last Post](/forum/45-filters-search/865929-error-1052?start=20#203027 "Hi Trying to remove the : and replace with a € sign in the filter module - this is now done with a language override Search for Extension > Language overide > Constant = CURSOR_TITLE_SEPARATOR") 11 years 5 months ago by [huwhuw](/forum/user/35272-huwhuw "View huwhuw's Profile") - [1](/forum/45-filters-search/865929-error-1052?start=0 "Page:1") - [2](/forum/45-filters-search/865929-error-1052?start=20 "Page:2") | Replies:21 Views:3342 | [Last Post](/forum/45-filters-search/865929-error-1052?start=20#203027 "Hi Trying to remove the : and replace with a € sign in the filter module - this is now done with a language override Search for Extension > Language overide > Constant = CURSOR_TITLE_SEPARATOR") by [huwhuw](/forum/user/35272-huwhuw "View huwhuw's Profile") 11 years 5 months ago | | [](/forum/45-filters-search/865929-error-1052#144867) | [Error: 1052](/forum/45-filters-search/865929-error-1052#144867 "-- url of the page with the problem -- : staclio.smezzea.com/filter/product/listing -- HikaShop version -- : Business 2.2.3 -- Joomla version -- :3.2.1 -- PHP version -- : 5.3.27 -- Browser(s) name and version -- : XXXXX x.x.x -- Error-message(debug-mod must be tuned on) -- : Error_message I receive the message below when filtering variants - color & size Error: 1052 - Column 'product_vendor_id' in on clause is ambiguous SQL=SELECT DISTINCT b.* FROM k7aby_hikashop_product_category AS a LEFT JOIN k7aby_hikashop_product AS b ON a.product_id=b.product_id LEFT JOIN k7aby_hikashop_product AS c ON b.product_id=c.product_parent_id LEFT JOIN k7aby_hikashop_variant AS Filter4 ON Filter4.variant_product_id=c.product_id LEFT JOIN k7aby_hikamarket_vendor AS hikam_vendor ON product_vendor_id = hikam_vendor.vendor_id WHERE b.product_published=1 AND b.product_type = 'main' AND a.category_id IN (13,35,16,36,37,38,42) AND (b.product_access = 'all' OR b.product_access LIKE '%,3,%' OR b.product_access LIKE '%,8,%') AND Filter4.variant_characteristic_id IN (7) AND c.product_quantity!=0 AND (hikam_vendor.vendor_published IS NULL OR hikam_vendor.vendor_published = 1) ORDER BY a.ordering ASC LIMIT 0, 21 Please help. Thank you!") Category: [Filters & Search](/forum/45-filters-search "Question about filters and search fields") Topic started 12 years 8 months ago, by [ibs9385](/forum/user/27945-ibs9385 "View ibs9385's Profile") [Last Post](/forum/45-filters-search/865929-error-1052?start=20#203027 "Hi Trying to remove the : and replace with a € sign in the filter module - this is now done with a language override Search for Extension > Language overide > Constant = CURSOR_TITLE_SEPARATOR") 11 years 5 months ago by [huwhuw](/forum/user/35272-huwhuw "View huwhuw's Profile") - [1](/forum/45-filters-search/865929-error-1052?start=0 "Page:1") - [2](/forum/45-filters-search/865929-error-1052?start=20 "Page:2") | Replies:21 Views:3342 | [Last Post](/forum/45-filters-search/865929-error-1052?start=20#203027 "Hi Trying to remove the : and replace with a € sign in the filter module - this is now done with a language override Search for Extension > Language overide > Constant = CURSOR_TITLE_SEPARATOR") by [huwhuw](/forum/user/35272-huwhuw "View huwhuw's Profile") 11 years 5 months ago | | [](/forum/45-filters-search/865929-error-1052#144841) | [Error: 1052](/forum/45-filters-search/865929-error-1052#144841 "-- url of the page with the problem -- : staclio.smezzea.com/filter/product/listing -- HikaShop version -- : Business 2.2.3 -- Joomla version -- :3.2.1 -- PHP version -- : 5.3.27 -- Browser(s) name and version -- : XXXXX x.x.x -- Error-message(debug-mod must be tuned on) -- : Error_message I receive the message below when filtering variants - color & size Error: 1052 - Column 'product_vendor_id' in on clause is ambiguous SQL=SELECT DISTINCT b.* FROM k7aby_hikashop_product_category AS a LEFT JOIN k7aby_hikashop_product AS b ON a.product_id=b.product_id LEFT JOIN k7aby_hikashop_product AS c ON b.product_id=c.product_parent_id LEFT JOIN k7aby_hikashop_variant AS Filter4 ON Filter4.variant_product_id=c.product_id LEFT JOIN k7aby_hikamarket_vendor AS hikam_vendor ON product_vendor_id = hikam_vendor.vendor_id WHERE b.product_published=1 AND b.product_type = 'main' AND a.category_id IN (13,35,16,36,37,38,42) AND (b.product_access = 'all' OR b.product_access LIKE '%,3,%' OR b.product_access LIKE '%,8,%') AND Filter4.variant_characteristic_id IN (7) AND c.product_quantity!=0 AND (hikam_vendor.vendor_published IS NULL OR hikam_vendor.vendor_published = 1) ORDER BY a.ordering ASC LIMIT 0, 21 Please help. Thank you!") Category: [Filters & Search](/forum/45-filters-search "Question about filters and search fields") Topic started 12 years 8 months ago, by [ibs9385](/forum/user/27945-ibs9385 "View ibs9385's Profile") [Last Post](/forum/45-filters-search/865929-error-1052?start=20#203027 "Hi Trying to remove the : and replace with a € sign in the filter module - this is now done with a language override Search for Extension > Language overide > Constant = CURSOR_TITLE_SEPARATOR") 11 years 5 months ago by [huwhuw](/forum/user/35272-huwhuw "View huwhuw's Profile") - [1](/forum/45-filters-search/865929-error-1052?start=0 "Page:1") - [2](/forum/45-filters-search/865929-error-1052?start=20 "Page:2") | Replies:21 Views:3342 | [Last Post](/forum/45-filters-search/865929-error-1052?start=20#203027 "Hi Trying to remove the : and replace with a € sign in the filter module - this is now done with a language override Search for Extension > Language overide > Constant = CURSOR_TITLE_SEPARATOR") by [huwhuw](/forum/user/35272-huwhuw "View huwhuw's Profile") 11 years 5 months ago | | [](/forum/45-filters-search/865929-error-1052#144812) | [Error: 1052](/forum/45-filters-search/865929-error-1052#144812 "-- url of the page with the problem -- : staclio.smezzea.com/filter/product/listing -- HikaShop version -- : Business 2.2.3 -- Joomla version -- :3.2.1 -- PHP version -- : 5.3.27 -- Browser(s) name and version -- : XXXXX x.x.x -- Error-message(debug-mod must be tuned on) -- : Error_message I receive the message below when filtering variants - color & size Error: 1052 - Column 'product_vendor_id' in on clause is ambiguous SQL=SELECT DISTINCT b.* FROM k7aby_hikashop_product_category AS a LEFT JOIN k7aby_hikashop_product AS b ON a.product_id=b.product_id LEFT JOIN k7aby_hikashop_product AS c ON b.product_id=c.product_parent_id LEFT JOIN k7aby_hikashop_variant AS Filter4 ON Filter4.variant_product_id=c.product_id LEFT JOIN k7aby_hikamarket_vendor AS hikam_vendor ON product_vendor_id = hikam_vendor.vendor_id WHERE b.product_published=1 AND b.product_type = 'main' AND a.category_id IN (13,35,16,36,37,38,42) AND (b.product_access = 'all' OR b.product_access LIKE '%,3,%' OR b.product_access LIKE '%,8,%') AND Filter4.variant_characteristic_id IN (7) AND c.product_quantity!=0 AND (hikam_vendor.vendor_published IS NULL OR hikam_vendor.vendor_published = 1) ORDER BY a.ordering ASC LIMIT 0, 21 Please help. Thank you!") Category: [Filters & Search](/forum/45-filters-search "Question about filters and search fields") Topic started 12 years 8 months ago, by [ibs9385](/forum/user/27945-ibs9385 "View ibs9385's Profile") [Last Post](/forum/45-filters-search/865929-error-1052?start=20#203027 "Hi Trying to remove the : and replace with a € sign in the filter module - this is now done with a language override Search for Extension > Language overide > Constant = CURSOR_TITLE_SEPARATOR") 11 years 5 months ago by [huwhuw](/forum/user/35272-huwhuw "View huwhuw's Profile") - [1](/forum/45-filters-search/865929-error-1052?start=0 "Page:1") - [2](/forum/45-filters-search/865929-error-1052?start=20 "Page:2") | Replies:21 Views:3342 | [Last Post](/forum/45-filters-search/865929-error-1052?start=20#203027 "Hi Trying to remove the : and replace with a € sign in the filter module - this is now done with a language override Search for Extension > Language overide > Constant = CURSOR_TITLE_SEPARATOR") by [huwhuw](/forum/user/35272-huwhuw "View huwhuw's Profile") 11 years 5 months ago | | [](/forum/45-filters-search/865929-error-1052#144769) | [Error: 1052](/forum/45-filters-search/865929-error-1052#144769 "-- url of the page with the problem -- : staclio.smezzea.com/filter/product/listing -- HikaShop version -- : Business 2.2.3 -- Joomla version -- :3.2.1 -- PHP version -- : 5.3.27 -- Browser(s) name and version -- : XXXXX x.x.x -- Error-message(debug-mod must be tuned on) -- : Error_message I receive the message below when filtering variants - color & size Error: 1052 - Column 'product_vendor_id' in on clause is ambiguous SQL=SELECT DISTINCT b.* FROM k7aby_hikashop_product_category AS a LEFT JOIN k7aby_hikashop_product AS b ON a.product_id=b.product_id LEFT JOIN k7aby_hikashop_product AS c ON b.product_id=c.product_parent_id LEFT JOIN k7aby_hikashop_variant AS Filter4 ON Filter4.variant_product_id=c.product_id LEFT JOIN k7aby_hikamarket_vendor AS hikam_vendor ON product_vendor_id = hikam_vendor.vendor_id WHERE b.product_published=1 AND b.product_type = 'main' AND a.category_id IN (13,35,16,36,37,38,42) AND (b.product_access = 'all' OR b.product_access LIKE '%,3,%' OR b.product_access LIKE '%,8,%') AND Filter4.variant_characteristic_id IN (7) AND c.product_quantity!=0 AND (hikam_vendor.vendor_published IS NULL OR hikam_vendor.vendor_published = 1) ORDER BY a.ordering ASC LIMIT 0, 21 Please help. Thank you!") Category: [Filters & Search](/forum/45-filters-search "Question about filters and search fields") Topic started 12 years 8 months ago, by [ibs9385](/forum/user/27945-ibs9385 "View ibs9385's Profile") [Last Post](/forum/45-filters-search/865929-error-1052?start=20#203027 "Hi Trying to remove the : and replace with a € sign in the filter module - this is now done with a language override Search for Extension > Language overide > Constant = CURSOR_TITLE_SEPARATOR") 11 years 5 months ago by [huwhuw](/forum/user/35272-huwhuw "View huwhuw's Profile") - [1](/forum/45-filters-search/865929-error-1052?start=0 "Page:1") - [2](/forum/45-filters-search/865929-error-1052?start=20 "Page:2") | Replies:21 Views:3342 | [Last Post](/forum/45-filters-search/865929-error-1052?start=20#203027 "Hi Trying to remove the : and replace with a € sign in the filter module - this is now done with a language override Search for Extension > Language overide > Constant = CURSOR_TITLE_SEPARATOR") by [huwhuw](/forum/user/35272-huwhuw "View huwhuw's Profile") 11 years 5 months ago | | [](/forum/45-filters-search/865929-error-1052#144664) | [Error: 1052](/forum/45-filters-search/865929-error-1052#144664 "-- url of the page with the problem -- : staclio.smezzea.com/filter/product/listing -- HikaShop version -- : Business 2.2.3 -- Joomla version -- :3.2.1 -- PHP version -- : 5.3.27 -- Browser(s) name and version -- : XXXXX x.x.x -- Error-message(debug-mod must be tuned on) -- : Error_message I receive the message below when filtering variants - color & size Error: 1052 - Column 'product_vendor_id' in on clause is ambiguous SQL=SELECT DISTINCT b.* FROM k7aby_hikashop_product_category AS a LEFT JOIN k7aby_hikashop_product AS b ON a.product_id=b.product_id LEFT JOIN k7aby_hikashop_product AS c ON b.product_id=c.product_parent_id LEFT JOIN k7aby_hikashop_variant AS Filter4 ON Filter4.variant_product_id=c.product_id LEFT JOIN k7aby_hikamarket_vendor AS hikam_vendor ON product_vendor_id = hikam_vendor.vendor_id WHERE b.product_published=1 AND b.product_type = 'main' AND a.category_id IN (13,35,16,36,37,38,42) AND (b.product_access = 'all' OR b.product_access LIKE '%,3,%' OR b.product_access LIKE '%,8,%') AND Filter4.variant_characteristic_id IN (7) AND c.product_quantity!=0 AND (hikam_vendor.vendor_published IS NULL OR hikam_vendor.vendor_published = 1) ORDER BY a.ordering ASC LIMIT 0, 21 Please help. Thank you!") Category: [Filters & Search](/forum/45-filters-search "Question about filters and search fields") Topic started 12 years 8 months ago, by [ibs9385](/forum/user/27945-ibs9385 "View ibs9385's Profile") [Last Post](/forum/45-filters-search/865929-error-1052?start=20#203027 "Hi Trying to remove the : and replace with a € sign in the filter module - this is now done with a language override Search for Extension > Language overide > Constant = CURSOR_TITLE_SEPARATOR") 11 years 5 months ago by [huwhuw](/forum/user/35272-huwhuw "View huwhuw's Profile") - [1](/forum/45-filters-search/865929-error-1052?start=0 "Page:1") - [2](/forum/45-filters-search/865929-error-1052?start=20 "Page:2") | Replies:21 Views:3342 | [Last Post](/forum/45-filters-search/865929-error-1052?start=20#203027 "Hi Trying to remove the : and replace with a € sign in the filter module - this is now done with a language override Search for Extension > Language overide > Constant = CURSOR_TITLE_SEPARATOR") by [huwhuw](/forum/user/35272-huwhuw "View huwhuw's Profile") 11 years 5 months ago | | [](/forum/45-filters-search/865929-error-1052#144626) | [Error: 1052](/forum/45-filters-search/865929-error-1052#144626 "-- url of the page with the problem -- : staclio.smezzea.com/filter/product/listing -- HikaShop version -- : Business 2.2.3 -- Joomla version -- :3.2.1 -- PHP version -- : 5.3.27 -- Browser(s) name and version -- : XXXXX x.x.x -- Error-message(debug-mod must be tuned on) -- : Error_message I receive the message below when filtering variants - color & size Error: 1052 - Column 'product_vendor_id' in on clause is ambiguous SQL=SELECT DISTINCT b.* FROM k7aby_hikashop_product_category AS a LEFT JOIN k7aby_hikashop_product AS b ON a.product_id=b.product_id LEFT JOIN k7aby_hikashop_product AS c ON b.product_id=c.product_parent_id LEFT JOIN k7aby_hikashop_variant AS Filter4 ON Filter4.variant_product_id=c.product_id LEFT JOIN k7aby_hikamarket_vendor AS hikam_vendor ON product_vendor_id = hikam_vendor.vendor_id WHERE b.product_published=1 AND b.product_type = 'main' AND a.category_id IN (13,35,16,36,37,38,42) AND (b.product_access = 'all' OR b.product_access LIKE '%,3,%' OR b.product_access LIKE '%,8,%') AND Filter4.variant_characteristic_id IN (7) AND c.product_quantity!=0 AND (hikam_vendor.vendor_published IS NULL OR hikam_vendor.vendor_published = 1) ORDER BY a.ordering ASC LIMIT 0, 21 Please help. Thank you!") Category: [Filters & Search](/forum/45-filters-search "Question about filters and search fields") Topic started 12 years 8 months ago, by [ibs9385](/forum/user/27945-ibs9385 "View ibs9385's Profile") [Last Post](/forum/45-filters-search/865929-error-1052?start=20#203027 "Hi Trying to remove the : and replace with a € sign in the filter module - this is now done with a language override Search for Extension > Language overide > Constant = CURSOR_TITLE_SEPARATOR") 11 years 5 months ago by [huwhuw](/forum/user/35272-huwhuw "View huwhuw's Profile") - [1](/forum/45-filters-search/865929-error-1052?start=0 "Page:1") - [2](/forum/45-filters-search/865929-error-1052?start=20 "Page:2") | Replies:21 Views:3342 | [Last Post](/forum/45-filters-search/865929-error-1052?start=20#203027 "Hi Trying to remove the : and replace with a € sign in the filter module - this is now done with a language override Search for Extension > Language overide > Constant = CURSOR_TITLE_SEPARATOR") by [huwhuw](/forum/user/35272-huwhuw "View huwhuw's Profile") 11 years 5 months ago | | [](/forum/45-filters-search/865929-error-1052#144607) | [Error: 1052](/forum/45-filters-search/865929-error-1052#144607 "-- url of the page with the problem -- : staclio.smezzea.com/filter/product/listing -- HikaShop version -- : Business 2.2.3 -- Joomla version -- :3.2.1 -- PHP version -- : 5.3.27 -- Browser(s) name and version -- : XXXXX x.x.x -- Error-message(debug-mod must be tuned on) -- : Error_message I receive the message below when filtering variants - color & size Error: 1052 - Column 'product_vendor_id' in on clause is ambiguous SQL=SELECT DISTINCT b.* FROM k7aby_hikashop_product_category AS a LEFT JOIN k7aby_hikashop_product AS b ON a.product_id=b.product_id LEFT JOIN k7aby_hikashop_product AS c ON b.product_id=c.product_parent_id LEFT JOIN k7aby_hikashop_variant AS Filter4 ON Filter4.variant_product_id=c.product_id LEFT JOIN k7aby_hikamarket_vendor AS hikam_vendor ON product_vendor_id = hikam_vendor.vendor_id WHERE b.product_published=1 AND b.product_type = 'main' AND a.category_id IN (13,35,16,36,37,38,42) AND (b.product_access = 'all' OR b.product_access LIKE '%,3,%' OR b.product_access LIKE '%,8,%') AND Filter4.variant_characteristic_id IN (7) AND c.product_quantity!=0 AND (hikam_vendor.vendor_published IS NULL OR hikam_vendor.vendor_published = 1) ORDER BY a.ordering ASC LIMIT 0, 21 Please help. Thank you!") Category: [Filters & Search](/forum/45-filters-search "Question about filters and search fields") Topic started 12 years 8 months ago, by [ibs9385](/forum/user/27945-ibs9385 "View ibs9385's Profile") [Last Post](/forum/45-filters-search/865929-error-1052?start=20#203027 "Hi Trying to remove the : and replace with a € sign in the filter module - this is now done with a language override Search for Extension > Language overide > Constant = CURSOR_TITLE_SEPARATOR") 11 years 5 months ago by [huwhuw](/forum/user/35272-huwhuw "View huwhuw's Profile") - [1](/forum/45-filters-search/865929-error-1052?start=0 "Page:1") - [2](/forum/45-filters-search/865929-error-1052?start=20 "Page:2") | Replies:21 Views:3342 | [Last Post](/forum/45-filters-search/865929-error-1052?start=20#203027 "Hi Trying to remove the : and replace with a € sign in the filter module - this is now done with a language override Search for Extension > Language overide > Constant = CURSOR_TITLE_SEPARATOR") by [huwhuw](/forum/user/35272-huwhuw "View huwhuw's Profile") 11 years 5 months ago | | [](/forum/45-filters-search/865929-error-1052#144593) | [Error: 1052](/forum/45-filters-search/865929-error-1052#144593 "-- url of the page with the problem -- : staclio.smezzea.com/filter/product/listing -- HikaShop version -- : Business 2.2.3 -- Joomla version -- :3.2.1 -- PHP version -- : 5.3.27 -- Browser(s) name and version -- : XXXXX x.x.x -- Error-message(debug-mod must be tuned on) -- : Error_message I receive the message below when filtering variants - color & size Error: 1052 - Column 'product_vendor_id' in on clause is ambiguous SQL=SELECT DISTINCT b.* FROM k7aby_hikashop_product_category AS a LEFT JOIN k7aby_hikashop_product AS b ON a.product_id=b.product_id LEFT JOIN k7aby_hikashop_product AS c ON b.product_id=c.product_parent_id LEFT JOIN k7aby_hikashop_variant AS Filter4 ON Filter4.variant_product_id=c.product_id LEFT JOIN k7aby_hikamarket_vendor AS hikam_vendor ON product_vendor_id = hikam_vendor.vendor_id WHERE b.product_published=1 AND b.product_type = 'main' AND a.category_id IN (13,35,16,36,37,38,42) AND (b.product_access = 'all' OR b.product_access LIKE '%,3,%' OR b.product_access LIKE '%,8,%') AND Filter4.variant_characteristic_id IN (7) AND c.product_quantity!=0 AND (hikam_vendor.vendor_published IS NULL OR hikam_vendor.vendor_published = 1) ORDER BY a.ordering ASC LIMIT 0, 21 Please help. Thank you!") Category: [Filters & Search](/forum/45-filters-search "Question about filters and search fields") Topic started 12 years 8 months ago, by [ibs9385](/forum/user/27945-ibs9385 "View ibs9385's Profile") [Last Post](/forum/45-filters-search/865929-error-1052?start=20#203027 "Hi Trying to remove the : and replace with a € sign in the filter module - this is now done with a language override Search for Extension > Language overide > Constant = CURSOR_TITLE_SEPARATOR") 11 years 5 months ago by [huwhuw](/forum/user/35272-huwhuw "View huwhuw's Profile") - [1](/forum/45-filters-search/865929-error-1052?start=0 "Page:1") - [2](/forum/45-filters-search/865929-error-1052?start=20 "Page:2") | Replies:21 Views:3342 | [Last Post](/forum/45-filters-search/865929-error-1052?start=20#203027 "Hi Trying to remove the : and replace with a € sign in the filter module - this is now done with a language override Search for Extension > Language overide > Constant = CURSOR_TITLE_SEPARATOR") by [huwhuw](/forum/user/35272-huwhuw "View huwhuw's Profile") 11 years 5 months ago | [](/forum/topics/feed/mode-topics?format=feed&type=rss) Time to create page: 0.136 seconds [Powered by](/forum/credits) [Kunena Forum](https://www.kunena.org) [](#top)