Problem with Virtuemart Search

[hitstore]

Hi to all,

I've Joomla! 2.5.9 Stable with Virtuemart 2.0.18a

I've a problem with the standard virtuemart search. Well, the problem is that I write something in the search box, the module give me no results... the address of search results page is my homepage www.xxxxxx.it with no results. Now i've tried with other free component or module, and there's always same kind of error... black results.

In the advanced search box of virtuemart seach (when I can choose category)... the box is empty... strange... how like search isn't in wrong place.

here an error log

vmError: exeSortSearchListQuery Column 'ordering' in where clause is ambiguous SQL=SELECT SQL_CALC_FOUND_ROWS l.`virtuemart_product_id` FROM `n8f3y_virtuemart_products_it_it` as l JOIN `n8f3y_virtuemart_products` AS p using (`virtuemart_product_id`) LEFT JOIN `n8f3y_virtuemart_product_categories` as pc ON p.`virtuemart_product_id` = `pc`.`virtuemart_product_id` LEFT JOIN `n8f3y_virtuemart_categories_it_it` as c ON c.`virtuemart_category_id` = `pc`.`virtuemart_category_id` LEFT JOIN `n8f3y_virtuemart_product_manufacturers` ON p.`virtuemart_product_id` = `n8f3y_virtuemart_product_manufacturers`.`virtuemart_product_id` LEFT JOIN `n8f3y_virtuemart_manufacturers_it_it` as m ON m.`virtuemart_manufacturer_id` = `n8f3y_virtuemart_product_manufacturers`.`virtuemart_manufacturer_id` LEFT JOIN `n8f3y_virtuemart_product_shoppergroups` ON p.`virtuemart_product_id` = `n8f3y_virtuemart_product_shoppergroups`.`virtuemart_product_id` LEFT OUTER JOIN `n8f3y_virtuemart_shoppergroups` as s ON s.`virtuemart_shoppergroup_id` = `n8f3y_virtuemart_product_shoppergroups`.`virtuemart_shoppergroup_id` WHERE ((`product_name` LIKE "%mouse%" OR `product_desc` LIKE "%mouse%" OR `category_name` LIKE "%mouse%" OR `mf_name` LIKE "%mouse%" OR `product_sales` LIKE "%mouse%" OR `product_height` LIKE "%mouse%" OR `product_lwh_uom` LIKE "%mouse%" OR `product_in_stock` LIKE "%mouse%" OR `product_unit` LIKE "%mouse%" OR `ordering` LIKE "%mouse%") AND p.`published`="1" AND `pc`.`virtuemart_category_id` > 0 AND ( s.`virtuemart_shoppergroup_id`= "2" OR s.`virtuemart_shoppergroup_id` IS NULL ) ) group by p.`virtuemart_product_id` ORDER BY product_name ASC LIMIT 0, 10

I'm a beginner and I'm sure that this module working fine in first my attempt... maybe I do some error.

Who can help me ? (italian support ignore me).

Sorry for my english.