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

#   Error: 1052

##

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

Less More

- Posts: 14
- Thank you received: 2
-
-

12 years 9 months ago [\#144309](#144309) by [ibs9385](/forum/user/27945-ibs9385 "View ibs9385's Profile")  *[Error: 1052](/forum/45-filters-search/865929-error-1052#144309 "-- 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&#95;message  I receive the message below when filtering variants - color &amp; size  Error: 1052 - Column 'product&#95;vendor&#95;id' in on clause is ambiguous SQL=SELECT DISTINCT b.&#42; FROM k7aby&#95;hikashop&#95;product&#95;category AS a LEFT JOIN k7aby&#95;hikashop&#95;product AS b ON a.product&#95;id=b.product&#95;id LEFT JOIN k7aby&#95;hikashop&#95;product AS c ON b.product&#95;id=c.product&#95;parent&#95;id LEFT JOIN k7aby&#95;hikashop&#95;variant AS Filter4 ON Filter4.variant&#95;product&#95;id=c.product&#95;id LEFT JOIN k7aby&#95;hikamarket&#95;vendor AS hikam&#95;vendor ON product&#95;vendor&#95;id = hikam&#95;vendor.vendor&#95;id WHERE b.product&#95;published=1 AND b.product&#95;type = 'main' AND a.category&#95;id IN (13,35,16,36,37,38,42) AND (b.product&#95;access = 'all' OR b.product&#95;access LIKE '%,3,%' OR b.product&#95;access LIKE '%,8,%') AND Filter4.variant&#95;characteristic&#95;id IN (7) AND c.product&#95;quantity!=0 AND (hikam&#95;vendor.vendor&#95;published IS NULL OR hikam&#95;vendor.vendor&#95;published = 1) ORDER BY a.ordering ASC LIMIT 0, 21  Please help.  Thank you!")* was created by *[ibs9385](/forum/user/27945-ibs9385 "View ibs9385's Profile")*

-- url of the page with the problem -- : [ staclio.smezzea.com/filter/product/listing](http://staclio.smezzea.com/filter/product/listing)
-- HikaShop version -- : Business 2.2.3
-- Joomla version -- ![:3](/smile3.gif ":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 &amp; 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!

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

- **[Eliot](/forum/user/1824-eliot "View Eliot's Profile")**
- [![Eliot's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar1824.png)](/forum/user/1824-eliot "View Eliot's Profile")
- [ Offline](/forum/user/1824-eliot)

Less More

- Posts: 2334
- Thank you received: 403
-
-

12 years 9 months ago [\#144335](#144335) by [Eliot](/forum/user/1824-eliot "View Eliot's Profile")  Replied by *[Eliot](/forum/user/1824-eliot "View Eliot's Profile")* on topic *[Error: 1052](/forum/45-filters-search/865929-error-1052#144335 "-- 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&#95;message  I receive the message below when filtering variants - color &amp; size  Error: 1052 - Column 'product&#95;vendor&#95;id' in on clause is ambiguous SQL=SELECT DISTINCT b.&#42; FROM k7aby&#95;hikashop&#95;product&#95;category AS a LEFT JOIN k7aby&#95;hikashop&#95;product AS b ON a.product&#95;id=b.product&#95;id LEFT JOIN k7aby&#95;hikashop&#95;product AS c ON b.product&#95;id=c.product&#95;parent&#95;id LEFT JOIN k7aby&#95;hikashop&#95;variant AS Filter4 ON Filter4.variant&#95;product&#95;id=c.product&#95;id LEFT JOIN k7aby&#95;hikamarket&#95;vendor AS hikam&#95;vendor ON product&#95;vendor&#95;id = hikam&#95;vendor.vendor&#95;id WHERE b.product&#95;published=1 AND b.product&#95;type = 'main' AND a.category&#95;id IN (13,35,16,36,37,38,42) AND (b.product&#95;access = 'all' OR b.product&#95;access LIKE '%,3,%' OR b.product&#95;access LIKE '%,8,%') AND Filter4.variant&#95;characteristic&#95;id IN (7) AND c.product&#95;quantity!=0 AND (hikam&#95;vendor.vendor&#95;published IS NULL OR hikam&#95;vendor.vendor&#95;published = 1) ORDER BY a.ordering ASC LIMIT 0, 21  Please help.  Thank you!")*

Hi there,

We just released the 2.3.0 version. Download it via your subscription page on our site and give it a try!
It might solve the problem and avoid us some useless debugging ![;)](/media/kunena/emoticons/24.png ";)")

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

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

Less More

- Posts: 14
- Thank you received: 2
-
-

12 years 9 months ago [\#144381](#144381) by [ibs9385](/forum/user/27945-ibs9385 "View ibs9385's Profile")  Replied by *[ibs9385](/forum/user/27945-ibs9385 "View ibs9385's Profile")* on topic *[Error: 1052](/forum/45-filters-search/865929-error-1052#144381 "-- 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&#95;message  I receive the message below when filtering variants - color &amp; size  Error: 1052 - Column 'product&#95;vendor&#95;id' in on clause is ambiguous SQL=SELECT DISTINCT b.&#42; FROM k7aby&#95;hikashop&#95;product&#95;category AS a LEFT JOIN k7aby&#95;hikashop&#95;product AS b ON a.product&#95;id=b.product&#95;id LEFT JOIN k7aby&#95;hikashop&#95;product AS c ON b.product&#95;id=c.product&#95;parent&#95;id LEFT JOIN k7aby&#95;hikashop&#95;variant AS Filter4 ON Filter4.variant&#95;product&#95;id=c.product&#95;id LEFT JOIN k7aby&#95;hikamarket&#95;vendor AS hikam&#95;vendor ON product&#95;vendor&#95;id = hikam&#95;vendor.vendor&#95;id WHERE b.product&#95;published=1 AND b.product&#95;type = 'main' AND a.category&#95;id IN (13,35,16,36,37,38,42) AND (b.product&#95;access = 'all' OR b.product&#95;access LIKE '%,3,%' OR b.product&#95;access LIKE '%,8,%') AND Filter4.variant&#95;characteristic&#95;id IN (7) AND c.product&#95;quantity!=0 AND (hikam&#95;vendor.vendor&#95;published IS NULL OR hikam&#95;vendor.vendor&#95;published = 1) ORDER BY a.ordering ASC LIMIT 0, 21  Please help.  Thank you!")*

Thank you for your quick reply!

Unfortunately, it didn't solve the Error:1052 issue.

However, it did solve a few others :woohoo: Thank you!

Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzQ1LWZpbHRlcnMtc2VhcmNoLzg2NTkyOS1lcnJvci0xMDUyP3RtcGw9bWFya2Rvd24=) 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: 26401
- Thank you received: 4081
-
- [](http://obsi.dev)
-

12 years 9 months ago [\#144479](#144479) by [Jerome](/forum/user/80-jerome "View Jerome's Profile")  Replied by *[Jerome](/forum/user/80-jerome "View Jerome's Profile")* on topic *[Error: 1052](/forum/45-filters-search/865929-error-1052#144479 "-- 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&#95;message  I receive the message below when filtering variants - color &amp; size  Error: 1052 - Column 'product&#95;vendor&#95;id' in on clause is ambiguous SQL=SELECT DISTINCT b.&#42; FROM k7aby&#95;hikashop&#95;product&#95;category AS a LEFT JOIN k7aby&#95;hikashop&#95;product AS b ON a.product&#95;id=b.product&#95;id LEFT JOIN k7aby&#95;hikashop&#95;product AS c ON b.product&#95;id=c.product&#95;parent&#95;id LEFT JOIN k7aby&#95;hikashop&#95;variant AS Filter4 ON Filter4.variant&#95;product&#95;id=c.product&#95;id LEFT JOIN k7aby&#95;hikamarket&#95;vendor AS hikam&#95;vendor ON product&#95;vendor&#95;id = hikam&#95;vendor.vendor&#95;id WHERE b.product&#95;published=1 AND b.product&#95;type = 'main' AND a.category&#95;id IN (13,35,16,36,37,38,42) AND (b.product&#95;access = 'all' OR b.product&#95;access LIKE '%,3,%' OR b.product&#95;access LIKE '%,8,%') AND Filter4.variant&#95;characteristic&#95;id IN (7) AND c.product&#95;quantity!=0 AND (hikam&#95;vendor.vendor&#95;published IS NULL OR hikam&#95;vendor.vendor&#95;published = 1) ORDER BY a.ordering ASC LIMIT 0, 21  Please help.  Thank you!")*

Hi,

Which version (number) of HikaMarket are you using ?

Regards,

---

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

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

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

Less More

- Posts: 14
- Thank you received: 2
-
-

12 years 9 months ago [\#144593](#144593) by [ibs9385](/forum/user/27945-ibs9385 "View ibs9385's Profile")  Replied by *[ibs9385](/forum/user/27945-ibs9385 "View ibs9385's Profile")* on topic *[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&#95;message  I receive the message below when filtering variants - color &amp; size  Error: 1052 - Column 'product&#95;vendor&#95;id' in on clause is ambiguous SQL=SELECT DISTINCT b.&#42; FROM k7aby&#95;hikashop&#95;product&#95;category AS a LEFT JOIN k7aby&#95;hikashop&#95;product AS b ON a.product&#95;id=b.product&#95;id LEFT JOIN k7aby&#95;hikashop&#95;product AS c ON b.product&#95;id=c.product&#95;parent&#95;id LEFT JOIN k7aby&#95;hikashop&#95;variant AS Filter4 ON Filter4.variant&#95;product&#95;id=c.product&#95;id LEFT JOIN k7aby&#95;hikamarket&#95;vendor AS hikam&#95;vendor ON product&#95;vendor&#95;id = hikam&#95;vendor.vendor&#95;id WHERE b.product&#95;published=1 AND b.product&#95;type = 'main' AND a.category&#95;id IN (13,35,16,36,37,38,42) AND (b.product&#95;access = 'all' OR b.product&#95;access LIKE '%,3,%' OR b.product&#95;access LIKE '%,8,%') AND Filter4.variant&#95;characteristic&#95;id IN (7) AND c.product&#95;quantity!=0 AND (hikam&#95;vendor.vendor&#95;published IS NULL OR hikam&#95;vendor.vendor&#95;published = 1) ORDER BY a.ordering ASC LIMIT 0, 21  Please help.  Thank you!")*

HikaMarket Frontedition 1.3.2

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

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

Less More

- Posts: 14
- Thank you received: 2
-
-

12 years 9 months ago [\#144607](#144607) by [ibs9385](/forum/user/27945-ibs9385 "View ibs9385's Profile")  Replied by *[ibs9385](/forum/user/27945-ibs9385 "View ibs9385's Profile")* on topic *[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&#95;message  I receive the message below when filtering variants - color &amp; size  Error: 1052 - Column 'product&#95;vendor&#95;id' in on clause is ambiguous SQL=SELECT DISTINCT b.&#42; FROM k7aby&#95;hikashop&#95;product&#95;category AS a LEFT JOIN k7aby&#95;hikashop&#95;product AS b ON a.product&#95;id=b.product&#95;id LEFT JOIN k7aby&#95;hikashop&#95;product AS c ON b.product&#95;id=c.product&#95;parent&#95;id LEFT JOIN k7aby&#95;hikashop&#95;variant AS Filter4 ON Filter4.variant&#95;product&#95;id=c.product&#95;id LEFT JOIN k7aby&#95;hikamarket&#95;vendor AS hikam&#95;vendor ON product&#95;vendor&#95;id = hikam&#95;vendor.vendor&#95;id WHERE b.product&#95;published=1 AND b.product&#95;type = 'main' AND a.category&#95;id IN (13,35,16,36,37,38,42) AND (b.product&#95;access = 'all' OR b.product&#95;access LIKE '%,3,%' OR b.product&#95;access LIKE '%,8,%') AND Filter4.variant&#95;characteristic&#95;id IN (7) AND c.product&#95;quantity!=0 AND (hikam&#95;vendor.vendor&#95;published IS NULL OR hikam&#95;vendor.vendor&#95;published = 1) ORDER BY a.ordering ASC LIMIT 0, 21  Please help.  Thank you!")*

I disabled HikaMarket Component &amp; HikaMarket - HikaShop Integration plugin. The filters seem to work now.

Also, where can I found the filter layout file? The format changed with the update to HikaShop 2.3.0. Need to remove the spacing between the filter title and selector. CSS isn't enough.

Thanks!

Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzQ1LWZpbHRlcnMtc2VhcmNoLzg2NTkyOS1lcnJvci0xMDUyP3RtcGw9bWFya2Rvd24=) 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: 26401
- Thank you received: 4081
-
- [](http://obsi.dev)
-

12 years 9 months ago [\#144615](#144615) by [Jerome](/forum/user/80-jerome "View Jerome's Profile")  Replied by *[Jerome](/forum/user/80-jerome "View Jerome's Profile")* on topic *[Error: 1052](/forum/45-filters-search/865929-error-1052#144615 "-- 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&#95;message  I receive the message below when filtering variants - color &amp; size  Error: 1052 - Column 'product&#95;vendor&#95;id' in on clause is ambiguous SQL=SELECT DISTINCT b.&#42; FROM k7aby&#95;hikashop&#95;product&#95;category AS a LEFT JOIN k7aby&#95;hikashop&#95;product AS b ON a.product&#95;id=b.product&#95;id LEFT JOIN k7aby&#95;hikashop&#95;product AS c ON b.product&#95;id=c.product&#95;parent&#95;id LEFT JOIN k7aby&#95;hikashop&#95;variant AS Filter4 ON Filter4.variant&#95;product&#95;id=c.product&#95;id LEFT JOIN k7aby&#95;hikamarket&#95;vendor AS hikam&#95;vendor ON product&#95;vendor&#95;id = hikam&#95;vendor.vendor&#95;id WHERE b.product&#95;published=1 AND b.product&#95;type = 'main' AND a.category&#95;id IN (13,35,16,36,37,38,42) AND (b.product&#95;access = 'all' OR b.product&#95;access LIKE '%,3,%' OR b.product&#95;access LIKE '%,8,%') AND Filter4.variant&#95;characteristic&#95;id IN (7) AND c.product&#95;quantity!=0 AND (hikam&#95;vendor.vendor&#95;published IS NULL OR hikam&#95;vendor.vendor&#95;published = 1) ORDER BY a.ordering ASC LIMIT 0, 21  Please help.  Thank you!")*

Hi,

Please replace in the plugin "plugins/hikashop/market/market.php" Code:

public function onBeforeProductListingLoad(&amp;$filters, &amp;$order, &amp;$view, &amp;$select, &amp;$select2, &amp;$ON_a, &amp;$ON_b, &amp;$ON_c) { $app = JFactory::getApplication(); if($app-&gt;isAdmin() &#124;&#124; !$this-&gt;init())

By Code:

public function onBeforeProductListingLoad(&amp;$filters, &amp;$order, &amp;$view, &amp;$select, &amp;$select2, &amp;$ON_a, &amp;$ON_b, &amp;$ON_c) { $app = JFactory::getApplication(); if($app-&gt;isAdmin() &#124;&#124; !$this-&gt;init() &#124;&#124; !hikamarket::level(1))

It should fix your problem.

I will update the HikaMarket Frontedition packages as soon as possible.

Sorry for the inconvenient.

Regards,

---

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

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

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

Less More

- Posts: 14
- Thank you received: 2
-
-

12 years 9 months ago [\#144626](#144626) by [ibs9385](/forum/user/27945-ibs9385 "View ibs9385's Profile")  Replied by *[ibs9385](/forum/user/27945-ibs9385 "View ibs9385's Profile")* on topic *[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&#95;message  I receive the message below when filtering variants - color &amp; size  Error: 1052 - Column 'product&#95;vendor&#95;id' in on clause is ambiguous SQL=SELECT DISTINCT b.&#42; FROM k7aby&#95;hikashop&#95;product&#95;category AS a LEFT JOIN k7aby&#95;hikashop&#95;product AS b ON a.product&#95;id=b.product&#95;id LEFT JOIN k7aby&#95;hikashop&#95;product AS c ON b.product&#95;id=c.product&#95;parent&#95;id LEFT JOIN k7aby&#95;hikashop&#95;variant AS Filter4 ON Filter4.variant&#95;product&#95;id=c.product&#95;id LEFT JOIN k7aby&#95;hikamarket&#95;vendor AS hikam&#95;vendor ON product&#95;vendor&#95;id = hikam&#95;vendor.vendor&#95;id WHERE b.product&#95;published=1 AND b.product&#95;type = 'main' AND a.category&#95;id IN (13,35,16,36,37,38,42) AND (b.product&#95;access = 'all' OR b.product&#95;access LIKE '%,3,%' OR b.product&#95;access LIKE '%,8,%') AND Filter4.variant&#95;characteristic&#95;id IN (7) AND c.product&#95;quantity!=0 AND (hikam&#95;vendor.vendor&#95;published IS NULL OR hikam&#95;vendor.vendor&#95;published = 1) ORDER BY a.ordering ASC LIMIT 0, 21  Please help.  Thank you!")*

That did the trick! Thanks!!

Where can I find the file to change the Filter format? I need to remove the &lt;br&gt; between the Title and DropDown.

Also, having an issue with the WISHLIST feature

Hide wishlist button for guest users - NO

When user not logged in: Click on the ADD TO WISHLIST - the popup displays: Product successfully added to the CART.
However, it is not added to the Cart or the Wishlist (desired). The optimum solution would force LOGIN/REGISTER page in order to save the Wishlist.

Thanks again for all your help!

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

- **[Eliot](/forum/user/1824-eliot "View Eliot's Profile")**
- [![Eliot's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar1824.png)](/forum/user/1824-eliot "View Eliot's Profile")
- [ Offline](/forum/user/1824-eliot)

Less More

- Posts: 2334
- Thank you received: 403
-
-

12 years 9 months ago [\#144628](#144628) by [Eliot](/forum/user/1824-eliot "View Eliot's Profile")  Replied by *[Eliot](/forum/user/1824-eliot "View Eliot's Profile")* on topic *[Error: 1052](/forum/45-filters-search/865929-error-1052#144628 "-- 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&#95;message  I receive the message below when filtering variants - color &amp; size  Error: 1052 - Column 'product&#95;vendor&#95;id' in on clause is ambiguous SQL=SELECT DISTINCT b.&#42; FROM k7aby&#95;hikashop&#95;product&#95;category AS a LEFT JOIN k7aby&#95;hikashop&#95;product AS b ON a.product&#95;id=b.product&#95;id LEFT JOIN k7aby&#95;hikashop&#95;product AS c ON b.product&#95;id=c.product&#95;parent&#95;id LEFT JOIN k7aby&#95;hikashop&#95;variant AS Filter4 ON Filter4.variant&#95;product&#95;id=c.product&#95;id LEFT JOIN k7aby&#95;hikamarket&#95;vendor AS hikam&#95;vendor ON product&#95;vendor&#95;id = hikam&#95;vendor.vendor&#95;id WHERE b.product&#95;published=1 AND b.product&#95;type = 'main' AND a.category&#95;id IN (13,35,16,36,37,38,42) AND (b.product&#95;access = 'all' OR b.product&#95;access LIKE '%,3,%' OR b.product&#95;access LIKE '%,8,%') AND Filter4.variant&#95;characteristic&#95;id IN (7) AND c.product&#95;quantity!=0 AND (hikam&#95;vendor.vendor&#95;published IS NULL OR hikam&#95;vendor.vendor&#95;published = 1) ORDER BY a.ordering ASC LIMIT 0, 21  Please help.  Thank you!")*

Hi there,

Instead of removing the &lt;br/&gt;, you might want to change the title position thanks to the "Filter button position" option in the main configuration (System&gt;Configuration&gt;Features&gt;Filters).
About the Wishlist thing, this message shouldn't be displayed. We just fixed something about it so you can take a look at this topic: [ www.hikashop.com/forum/wishlist/865753-n...ge-wrong.html#144611](http://www.hikashop.com/forum/wishlist/865753-not-logged-in-wishlist-message-wrong.html#144611)
However, guest users cannot create wishlist and then save it. The button is simply displayed an suggest to users they can use it.

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

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

Less More

- Posts: 14
- Thank you received: 2
-
-

12 years 9 months ago [\#144664](#144664) by [ibs9385](/forum/user/27945-ibs9385 "View ibs9385's Profile")  Replied by *[ibs9385](/forum/user/27945-ibs9385 "View ibs9385's Profile")* on topic *[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&#95;message  I receive the message below when filtering variants - color &amp; size  Error: 1052 - Column 'product&#95;vendor&#95;id' in on clause is ambiguous SQL=SELECT DISTINCT b.&#42; FROM k7aby&#95;hikashop&#95;product&#95;category AS a LEFT JOIN k7aby&#95;hikashop&#95;product AS b ON a.product&#95;id=b.product&#95;id LEFT JOIN k7aby&#95;hikashop&#95;product AS c ON b.product&#95;id=c.product&#95;parent&#95;id LEFT JOIN k7aby&#95;hikashop&#95;variant AS Filter4 ON Filter4.variant&#95;product&#95;id=c.product&#95;id LEFT JOIN k7aby&#95;hikamarket&#95;vendor AS hikam&#95;vendor ON product&#95;vendor&#95;id = hikam&#95;vendor.vendor&#95;id WHERE b.product&#95;published=1 AND b.product&#95;type = 'main' AND a.category&#95;id IN (13,35,16,36,37,38,42) AND (b.product&#95;access = 'all' OR b.product&#95;access LIKE '%,3,%' OR b.product&#95;access LIKE '%,8,%') AND Filter4.variant&#95;characteristic&#95;id IN (7) AND c.product&#95;quantity!=0 AND (hikam&#95;vendor.vendor&#95;published IS NULL OR hikam&#95;vendor.vendor&#95;published = 1) ORDER BY a.ordering ASC LIMIT 0, 21  Please help.  Thank you!")*

Hello,

I managed to adjust the filter labels so they work with my template. However, the settings are difficult to understand. I ended up changing them per filter in the display &gt; filters. I had to use the 'left' option in order to get rid of the extra space, but the label is above the selector??

Also, I still need to get rid of or change the ":" in the price filter
[ ![h3b0f396.png](/forum/attachment/15419) ](/forum/attachment/15419 "h3b0f396.png")

Notice the : before the 0 - 500 ?? I need that to either disappear or change to $.

I tried the wishlist change you mentioned. It freezes the page!

- [ ![h3b0f396.png](/forum/attachment/15419) ](/forum/attachment/15419 "h3b0f396.png") [ ](/forum/attachment/15419?download=1 "h3b0f396.png")

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

- **[Eliot](/forum/user/1824-eliot "View Eliot's Profile")**
- [![Eliot's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar1824.png)](/forum/user/1824-eliot "View Eliot's Profile")
- [ Offline](/forum/user/1824-eliot)

Less More

- Posts: 2334
- Thank you received: 403
-
-

12 years 9 months ago [\#144708](#144708) by [Eliot](/forum/user/1824-eliot "View Eliot's Profile")  Replied by *[Eliot](/forum/user/1824-eliot "View Eliot's Profile")* on topic *[Error: 1052](/forum/45-filters-search/865929-error-1052#144708 "-- 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&#95;message  I receive the message below when filtering variants - color &amp; size  Error: 1052 - Column 'product&#95;vendor&#95;id' in on clause is ambiguous SQL=SELECT DISTINCT b.&#42; FROM k7aby&#95;hikashop&#95;product&#95;category AS a LEFT JOIN k7aby&#95;hikashop&#95;product AS b ON a.product&#95;id=b.product&#95;id LEFT JOIN k7aby&#95;hikashop&#95;product AS c ON b.product&#95;id=c.product&#95;parent&#95;id LEFT JOIN k7aby&#95;hikashop&#95;variant AS Filter4 ON Filter4.variant&#95;product&#95;id=c.product&#95;id LEFT JOIN k7aby&#95;hikamarket&#95;vendor AS hikam&#95;vendor ON product&#95;vendor&#95;id = hikam&#95;vendor.vendor&#95;id WHERE b.product&#95;published=1 AND b.product&#95;type = 'main' AND a.category&#95;id IN (13,35,16,36,37,38,42) AND (b.product&#95;access = 'all' OR b.product&#95;access LIKE '%,3,%' OR b.product&#95;access LIKE '%,8,%') AND Filter4.variant&#95;characteristic&#95;id IN (7) AND c.product&#95;quantity!=0 AND (hikam&#95;vendor.vendor&#95;published IS NULL OR hikam&#95;vendor.vendor&#95;published = 1) ORDER BY a.ordering ASC LIMIT 0, 21  Please help.  Thank you!")*

Hi,

I don't think it should display like this with the option set to left so the issue probably come from your template.
Could you give me a link so I can take a look at the code.

Also, here is what we do with the title in the filter.php file (administration/components/com_hikashop/classes): Code:

function titlePosition($filter, $html='', $list=false, $opt=''){ $name=$this-&gt;trans($filter-&gt;filter_name); if($list &amp;&amp; $filter-&gt;filter_options['title_position']='inside'){ $position='top'; } else{ $position=$filter-&gt;filter_options['title_position']; } switch ($position){ case 'bottom': $html=$html.'&lt;br/&gt;'.$name.' '.$opt; break; case 'top': $html=$name.' '.$opt.'&lt;br/&gt;'.$html; break; case 'left': $html=$name.' '.$opt.' '.$html; break; case 'right': $html=$html.' '.$name.' '.$opt; break; } return $html; }

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

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

Less More

- Posts: 14
- Thank you received: 2
-
-

12 years 9 months ago [\#144769](#144769) by [ibs9385](/forum/user/27945-ibs9385 "View ibs9385's Profile")  Replied by *[ibs9385](/forum/user/27945-ibs9385 "View ibs9385's Profile")* on topic *[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&#95;message  I receive the message below when filtering variants - color &amp; size  Error: 1052 - Column 'product&#95;vendor&#95;id' in on clause is ambiguous SQL=SELECT DISTINCT b.&#42; FROM k7aby&#95;hikashop&#95;product&#95;category AS a LEFT JOIN k7aby&#95;hikashop&#95;product AS b ON a.product&#95;id=b.product&#95;id LEFT JOIN k7aby&#95;hikashop&#95;product AS c ON b.product&#95;id=c.product&#95;parent&#95;id LEFT JOIN k7aby&#95;hikashop&#95;variant AS Filter4 ON Filter4.variant&#95;product&#95;id=c.product&#95;id LEFT JOIN k7aby&#95;hikamarket&#95;vendor AS hikam&#95;vendor ON product&#95;vendor&#95;id = hikam&#95;vendor.vendor&#95;id WHERE b.product&#95;published=1 AND b.product&#95;type = 'main' AND a.category&#95;id IN (13,35,16,36,37,38,42) AND (b.product&#95;access = 'all' OR b.product&#95;access LIKE '%,3,%' OR b.product&#95;access LIKE '%,8,%') AND Filter4.variant&#95;characteristic&#95;id IN (7) AND c.product&#95;quantity!=0 AND (hikam&#95;vendor.vendor&#95;published IS NULL OR hikam&#95;vendor.vendor&#95;published = 1) ORDER BY a.ordering ASC LIMIT 0, 21  Please help.  Thank you!")*

staclio.smezzea.com/store

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

- **[Eliot](/forum/user/1824-eliot "View Eliot's Profile")**
- [![Eliot's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar1824.png)](/forum/user/1824-eliot "View Eliot's Profile")
- [ Offline](/forum/user/1824-eliot)

Less More

- Posts: 2334
- Thank you received: 403
-
-

12 years 9 months ago [\#144794](#144794) by [Eliot](/forum/user/1824-eliot "View Eliot's Profile")  Replied by *[Eliot](/forum/user/1824-eliot "View Eliot's Profile")* on topic *[Error: 1052](/forum/45-filters-search/865929-error-1052#144794 "-- 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&#95;message  I receive the message below when filtering variants - color &amp; size  Error: 1052 - Column 'product&#95;vendor&#95;id' in on clause is ambiguous SQL=SELECT DISTINCT b.&#42; FROM k7aby&#95;hikashop&#95;product&#95;category AS a LEFT JOIN k7aby&#95;hikashop&#95;product AS b ON a.product&#95;id=b.product&#95;id LEFT JOIN k7aby&#95;hikashop&#95;product AS c ON b.product&#95;id=c.product&#95;parent&#95;id LEFT JOIN k7aby&#95;hikashop&#95;variant AS Filter4 ON Filter4.variant&#95;product&#95;id=c.product&#95;id LEFT JOIN k7aby&#95;hikamarket&#95;vendor AS hikam&#95;vendor ON product&#95;vendor&#95;id = hikam&#95;vendor.vendor&#95;id WHERE b.product&#95;published=1 AND b.product&#95;type = 'main' AND a.category&#95;id IN (13,35,16,36,37,38,42) AND (b.product&#95;access = 'all' OR b.product&#95;access LIKE '%,3,%' OR b.product&#95;access LIKE '%,8,%') AND Filter4.variant&#95;characteristic&#95;id IN (7) AND c.product&#95;quantity!=0 AND (hikam&#95;vendor.vendor&#95;published IS NULL OR hikam&#95;vendor.vendor&#95;published = 1) ORDER BY a.ordering ASC LIMIT 0, 21  Please help.  Thank you!")*

Just change the width of your filters (it's set to 235 which cause it to go to the next line).
Also, very nice site! let us know when it's finished and we'll add it to our gallery if it's ok with you ![:)](/media/kunena/emoticons/3.png ":)")

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

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

Less More

- Posts: 14
- Thank you received: 2
-
-

12 years 9 months ago [\#144812](#144812) by [ibs9385](/forum/user/27945-ibs9385 "View ibs9385's Profile")  Replied by *[ibs9385](/forum/user/27945-ibs9385 "View ibs9385's Profile")* on topic *[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&#95;message  I receive the message below when filtering variants - color &amp; size  Error: 1052 - Column 'product&#95;vendor&#95;id' in on clause is ambiguous SQL=SELECT DISTINCT b.&#42; FROM k7aby&#95;hikashop&#95;product&#95;category AS a LEFT JOIN k7aby&#95;hikashop&#95;product AS b ON a.product&#95;id=b.product&#95;id LEFT JOIN k7aby&#95;hikashop&#95;product AS c ON b.product&#95;id=c.product&#95;parent&#95;id LEFT JOIN k7aby&#95;hikashop&#95;variant AS Filter4 ON Filter4.variant&#95;product&#95;id=c.product&#95;id LEFT JOIN k7aby&#95;hikamarket&#95;vendor AS hikam&#95;vendor ON product&#95;vendor&#95;id = hikam&#95;vendor.vendor&#95;id WHERE b.product&#95;published=1 AND b.product&#95;type = 'main' AND a.category&#95;id IN (13,35,16,36,37,38,42) AND (b.product&#95;access = 'all' OR b.product&#95;access LIKE '%,3,%' OR b.product&#95;access LIKE '%,8,%') AND Filter4.variant&#95;characteristic&#95;id IN (7) AND c.product&#95;quantity!=0 AND (hikam&#95;vendor.vendor&#95;published IS NULL OR hikam&#95;vendor.vendor&#95;published = 1) ORDER BY a.ordering ASC LIMIT 0, 21  Please help.  Thank you!")*

Thank you very much!

Sorry, but I still can't find where to either delete or change to $ - Please see attached [circled in green]
[ ![h1795a95.png](/forum/attachment/15435) ](/forum/attachment/15435 "h1795a95.png")

Also, I noticed just on the product page, the filter slider is missing.
Firebug:
TypeError: hkjQuery(...).prop is not a function
hkjQuery("#slider_Price_module_249").prop('slide',null).slider({

Product Page: staclio.smezzea.com/store/products/product/oakley-o9883

Thanks again for all your help. Just trying to finish the details ![B)](/media/kunena/emoticons/9.png "B)")

- [ ![h1795a95.png](/forum/attachment/15435) ](/forum/attachment/15435 "h1795a95.png") [ ](/forum/attachment/15435?download=1 "h1795a95.png")

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

- **[Eliot](/forum/user/1824-eliot "View Eliot's Profile")**
- [![Eliot's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar1824.png)](/forum/user/1824-eliot "View Eliot's Profile")
- [ Offline](/forum/user/1824-eliot)

Less More

- Posts: 2334
- Thank you received: 403
-
-

12 years 9 months ago [\#144819](#144819) by [Eliot](/forum/user/1824-eliot "View Eliot's Profile")  Replied by *[Eliot](/forum/user/1824-eliot "View Eliot's Profile")* on topic *[Error: 1052](/forum/45-filters-search/865929-error-1052#144819 "-- 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&#95;message  I receive the message below when filtering variants - color &amp; size  Error: 1052 - Column 'product&#95;vendor&#95;id' in on clause is ambiguous SQL=SELECT DISTINCT b.&#42; FROM k7aby&#95;hikashop&#95;product&#95;category AS a LEFT JOIN k7aby&#95;hikashop&#95;product AS b ON a.product&#95;id=b.product&#95;id LEFT JOIN k7aby&#95;hikashop&#95;product AS c ON b.product&#95;id=c.product&#95;parent&#95;id LEFT JOIN k7aby&#95;hikashop&#95;variant AS Filter4 ON Filter4.variant&#95;product&#95;id=c.product&#95;id LEFT JOIN k7aby&#95;hikamarket&#95;vendor AS hikam&#95;vendor ON product&#95;vendor&#95;id = hikam&#95;vendor.vendor&#95;id WHERE b.product&#95;published=1 AND b.product&#95;type = 'main' AND a.category&#95;id IN (13,35,16,36,37,38,42) AND (b.product&#95;access = 'all' OR b.product&#95;access LIKE '%,3,%' OR b.product&#95;access LIKE '%,8,%') AND Filter4.variant&#95;characteristic&#95;id IN (7) AND c.product&#95;quantity!=0 AND (hikam&#95;vendor.vendor&#95;published IS NULL OR hikam&#95;vendor.vendor&#95;published = 1) ORDER BY a.ordering ASC LIMIT 0, 21  Please help.  Thank you!")*

Strange error.
Could you try to create exactly the same filter and use this new one instead, it might be an id issue.

About the ':' thing, here is the code in the filter class than you can edit: Code:

switch($position){ case 'top_left': $html=$name.': '.$input.$html; break; case 'top_right': $html='&lt;div style="'.$width.' text-align:right"&gt;'.$name.': '.$input.''.$html.'&lt;/div&gt;'; break; case 'top_center': $html='&lt;div style="'.$width.' text-align:center";"&gt;'.$name.': '.$input.' '.$html.'&lt;/div&gt;'; break; case 'bottom_left': $html=$html.$name.': '.$input; break; case 'bottom_right': $html='&lt;div style="'.$width.' text-align:right"&gt;'.$html.$name.': '.$input.'&lt;/div&gt;'; break; case 'bottom_center': $html='&lt;div style="'.$width.' text-align:center";"&gt;'.$html.$name.': '.$input.'&lt;/div&gt;'; break; }

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

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

Less More

- Posts: 14
- Thank you received: 2
-
-

12 years 9 months ago -  12 years 9 months ago [\#144841](#144841) by [ibs9385](/forum/user/27945-ibs9385 "View ibs9385's Profile")  Replied by *[ibs9385](/forum/user/27945-ibs9385 "View ibs9385's Profile")* on topic *[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&#95;message  I receive the message below when filtering variants - color &amp; size  Error: 1052 - Column 'product&#95;vendor&#95;id' in on clause is ambiguous SQL=SELECT DISTINCT b.&#42; FROM k7aby&#95;hikashop&#95;product&#95;category AS a LEFT JOIN k7aby&#95;hikashop&#95;product AS b ON a.product&#95;id=b.product&#95;id LEFT JOIN k7aby&#95;hikashop&#95;product AS c ON b.product&#95;id=c.product&#95;parent&#95;id LEFT JOIN k7aby&#95;hikashop&#95;variant AS Filter4 ON Filter4.variant&#95;product&#95;id=c.product&#95;id LEFT JOIN k7aby&#95;hikamarket&#95;vendor AS hikam&#95;vendor ON product&#95;vendor&#95;id = hikam&#95;vendor.vendor&#95;id WHERE b.product&#95;published=1 AND b.product&#95;type = 'main' AND a.category&#95;id IN (13,35,16,36,37,38,42) AND (b.product&#95;access = 'all' OR b.product&#95;access LIKE '%,3,%' OR b.product&#95;access LIKE '%,8,%') AND Filter4.variant&#95;characteristic&#95;id IN (7) AND c.product&#95;quantity!=0 AND (hikam&#95;vendor.vendor&#95;published IS NULL OR hikam&#95;vendor.vendor&#95;published = 1) ORDER BY a.ordering ASC LIMIT 0, 21  Please help.  Thank you!")*

OK then. Got the ":" thing all worked out - THANK YOU!

Unfortunately, the price range slider is still missing just on the product page. I deleted and recreated both the price range filter in displays &gt; filters &amp; modules &gt; Hikashop filter module - but still no luck.

Last edit: 12 years 9 months ago by [ibs9385](/forum/user/27945-ibs9385 "View ibs9385's Profile").

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

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

Less More

- Posts: 14
- Thank you received: 2
-
-

12 years 9 months ago [\#144867](#144867) by [ibs9385](/forum/user/27945-ibs9385 "View ibs9385's Profile")  Replied by *[ibs9385](/forum/user/27945-ibs9385 "View ibs9385's Profile")* on topic *[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&#95;message  I receive the message below when filtering variants - color &amp; size  Error: 1052 - Column 'product&#95;vendor&#95;id' in on clause is ambiguous SQL=SELECT DISTINCT b.&#42; FROM k7aby&#95;hikashop&#95;product&#95;category AS a LEFT JOIN k7aby&#95;hikashop&#95;product AS b ON a.product&#95;id=b.product&#95;id LEFT JOIN k7aby&#95;hikashop&#95;product AS c ON b.product&#95;id=c.product&#95;parent&#95;id LEFT JOIN k7aby&#95;hikashop&#95;variant AS Filter4 ON Filter4.variant&#95;product&#95;id=c.product&#95;id LEFT JOIN k7aby&#95;hikamarket&#95;vendor AS hikam&#95;vendor ON product&#95;vendor&#95;id = hikam&#95;vendor.vendor&#95;id WHERE b.product&#95;published=1 AND b.product&#95;type = 'main' AND a.category&#95;id IN (13,35,16,36,37,38,42) AND (b.product&#95;access = 'all' OR b.product&#95;access LIKE '%,3,%' OR b.product&#95;access LIKE '%,8,%') AND Filter4.variant&#95;characteristic&#95;id IN (7) AND c.product&#95;quantity!=0 AND (hikam&#95;vendor.vendor&#95;published IS NULL OR hikam&#95;vendor.vendor&#95;published = 1) ORDER BY a.ordering ASC LIMIT 0, 21  Please help.  Thank you!")*

ArtZoom causing the js Conflict !

Switched to Magic Zoom Plus .js conflict resolved, BUT [always something ![:P](/media/kunena/emoticons/14.png ":P") ) now badges don't work. To be more specific.....Magic Zoom doesn't work on products that have a badge. Remove badge, now zoom works. Any suggestions?

Thanks!!!!

Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzQ1LWZpbHRlcnMtc2VhcmNoLzg2NTkyOS1lcnJvci0xMDUyP3RtcGw9bWFya2Rvd24=) 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: 26401
- Thank you received: 4081
-
- [](http://obsi.dev)
-

12 years 9 months ago [\#144874](#144874) by [Jerome](/forum/user/80-jerome "View Jerome's Profile")  Replied by *[Jerome](/forum/user/80-jerome "View Jerome's Profile")* on topic *[Error: 1052](/forum/45-filters-search/865929-error-1052#144874 "-- 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&#95;message  I receive the message below when filtering variants - color &amp; size  Error: 1052 - Column 'product&#95;vendor&#95;id' in on clause is ambiguous SQL=SELECT DISTINCT b.&#42; FROM k7aby&#95;hikashop&#95;product&#95;category AS a LEFT JOIN k7aby&#95;hikashop&#95;product AS b ON a.product&#95;id=b.product&#95;id LEFT JOIN k7aby&#95;hikashop&#95;product AS c ON b.product&#95;id=c.product&#95;parent&#95;id LEFT JOIN k7aby&#95;hikashop&#95;variant AS Filter4 ON Filter4.variant&#95;product&#95;id=c.product&#95;id LEFT JOIN k7aby&#95;hikamarket&#95;vendor AS hikam&#95;vendor ON product&#95;vendor&#95;id = hikam&#95;vendor.vendor&#95;id WHERE b.product&#95;published=1 AND b.product&#95;type = 'main' AND a.category&#95;id IN (13,35,16,36,37,38,42) AND (b.product&#95;access = 'all' OR b.product&#95;access LIKE '%,3,%' OR b.product&#95;access LIKE '%,8,%') AND Filter4.variant&#95;characteristic&#95;id IN (7) AND c.product&#95;quantity!=0 AND (hikam&#95;vendor.vendor&#95;published IS NULL OR hikam&#95;vendor.vendor&#95;published = 1) ORDER BY a.ordering ASC LIMIT 0, 21  Please help.  Thank you!")*

Hi,

I think the best is to show what is the JS problem introduced by ArtZoom and fix it.
I suppose that it's a destroy of jQuery (so the jQuery ui previously loaded is.. unloaded by the second load of jQuery).
At this moment, you have to change a little the JS of ArtZoom for the jQuery loading (in order to not load jQuery if already defined).

Regards,

---

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

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

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

Less More

- Posts: 14
- Thank you received: 2
-
-

12 years 9 months ago [\#144876](#144876) by [ibs9385](/forum/user/27945-ibs9385 "View ibs9385's Profile")  Replied by *[ibs9385](/forum/user/27945-ibs9385 "View ibs9385's Profile")* on topic *[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&#95;message  I receive the message below when filtering variants - color &amp; size  Error: 1052 - Column 'product&#95;vendor&#95;id' in on clause is ambiguous SQL=SELECT DISTINCT b.&#42; FROM k7aby&#95;hikashop&#95;product&#95;category AS a LEFT JOIN k7aby&#95;hikashop&#95;product AS b ON a.product&#95;id=b.product&#95;id LEFT JOIN k7aby&#95;hikashop&#95;product AS c ON b.product&#95;id=c.product&#95;parent&#95;id LEFT JOIN k7aby&#95;hikashop&#95;variant AS Filter4 ON Filter4.variant&#95;product&#95;id=c.product&#95;id LEFT JOIN k7aby&#95;hikamarket&#95;vendor AS hikam&#95;vendor ON product&#95;vendor&#95;id = hikam&#95;vendor.vendor&#95;id WHERE b.product&#95;published=1 AND b.product&#95;type = 'main' AND a.category&#95;id IN (13,35,16,36,37,38,42) AND (b.product&#95;access = 'all' OR b.product&#95;access LIKE '%,3,%' OR b.product&#95;access LIKE '%,8,%') AND Filter4.variant&#95;characteristic&#95;id IN (7) AND c.product&#95;quantity!=0 AND (hikam&#95;vendor.vendor&#95;published IS NULL OR hikam&#95;vendor.vendor&#95;published = 1) ORDER BY a.ordering ASC LIMIT 0, 21  Please help.  Thank you!")*

I reinstalled Art Zoom

staclio.smezzea.com/store/product-page

Same error message:
Line 606
TypeError: hkjQuery(...).prop is not a function
hkjQuery("#slider_Price_Range_module_404").prop('slide',null).slider({

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

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

Less More

- Posts: 14
- Thank you received: 2
-
-

12 years 9 months ago [\#144987](#144987) by [ibs9385](/forum/user/27945-ibs9385 "View ibs9385's Profile")  Replied by *[ibs9385](/forum/user/27945-ibs9385 "View ibs9385's Profile")* on topic *[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&#95;message  I receive the message below when filtering variants - color &amp; size  Error: 1052 - Column 'product&#95;vendor&#95;id' in on clause is ambiguous SQL=SELECT DISTINCT b.&#42; FROM k7aby&#95;hikashop&#95;product&#95;category AS a LEFT JOIN k7aby&#95;hikashop&#95;product AS b ON a.product&#95;id=b.product&#95;id LEFT JOIN k7aby&#95;hikashop&#95;product AS c ON b.product&#95;id=c.product&#95;parent&#95;id LEFT JOIN k7aby&#95;hikashop&#95;variant AS Filter4 ON Filter4.variant&#95;product&#95;id=c.product&#95;id LEFT JOIN k7aby&#95;hikamarket&#95;vendor AS hikam&#95;vendor ON product&#95;vendor&#95;id = hikam&#95;vendor.vendor&#95;id WHERE b.product&#95;published=1 AND b.product&#95;type = 'main' AND a.category&#95;id IN (13,35,16,36,37,38,42) AND (b.product&#95;access = 'all' OR b.product&#95;access LIKE '%,3,%' OR b.product&#95;access LIKE '%,8,%') AND Filter4.variant&#95;characteristic&#95;id IN (7) AND c.product&#95;quantity!=0 AND (hikam&#95;vendor.vendor&#95;published IS NULL OR hikam&#95;vendor.vendor&#95;published = 1) ORDER BY a.ordering ASC LIMIT 0, 21  Please help.  Thank you!")*

.js issue has been resolved with Art ZoomIn.

Flypage for HikaShop has been updated.

Thanks for all your help!!!

The following user(s) said Thank You: [Mohamed Thelji](/forum/user/6861-mohamed-thelji "View Mohamed Thelji's Profile")

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

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