Error: 1052

-- 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!

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

Thank you for your quick reply!

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

However, it did solve a few others Thank you!

HikaMarket Frontedition 1.3.2

I disabled HikaMarket Component & 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!

That did the trick! Thanks!!

Where can I find the file to change the Filter format? I need to remove the <br> 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!

Hi there,

Instead of removing the <br/>, you might want to change the title position thanks to the "Filter button position" option in the main configuration (System>Configuration>Features>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
However, guest users cannot create wishlist and then save it. The button is simply displayed an suggest to users they can use it.

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 > 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

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):

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

staclio.smezzea.com/store

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

Thank you very much!

Sorry, but I still can't find where to either delete or change to $ - Please see attached [circled in green]

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:

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

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 > filters & modules > Hikashop filter module - but still no luck.

ArtZoom causing the js Conflict !

Switched to Magic Zoom Plus .js conflict resolved, BUT [always something ) 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!!!!

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({

.js issue has been resolved with Art ZoomIn.

Flypage for HikaShop has been updated.

Thanks for all your help!!!