News:

Support the VirtueMart project and become a member

Main Menu

Sql error search function

Started by Thobbmaster, June 25, 2015, 20:36:22 PM

Previous topic - Next topic

Thobbmaster

Hello!
Have problems with the search function in VirtueMart 3.0.9 after I search, I get a 404 error, followed by the following:


The SELECT would examine more than MAX_JOIN_SIZE rows; check your WHERE and use SET SQL_BIG_SELECTS=1 or SET MAX_JOIN_SIZE=# if the SELECT is okay SQL=SELECT SQL_CALC_FOUND_ROWS p.`virtuemart_product_id` FROM `jos_virtuemart_products` as p INNER JOIN `jos_virtuemart_products_sv_se` as l using (`virtuemart_product_id`) LEFT JOIN `jos_virtuemart_product_shoppergroups` as ps ON p.`virtuemart_product_id` = `ps`.`virtuemart_product_id` LEFT JOIN `jos_virtuemart_product_categories` as pc ON p.`virtuemart_product_id` = `pc`.`virtuemart_product_id` LEFT JOIN `jos_virtuemart_categories_sv_se` as cl ON cl.`virtuemart_category_id` = `pc`.`virtuemart_category_id` LEFT JOIN `jos_virtuemart_product_manufacturers` ON p.`virtuemart_product_id` = `jos_virtuemart_product_manufacturers`.`virtuemart_product_id` LEFT JOIN `jos_virtuemart_manufacturers_sv_se` as m ON m.`virtuemart_manufacturer_id` = `jos_virtuemart_product_manufacturers`.`virtuemart_manufacturer_id` LEFT JOIN `jos_virtuemart_product_prices` as pp ON p.`virtuemart_product_id` = pp.`virtuemart_product_id` WHERE ((`l`.product_name LIKE "%kolv%" OR `p`.created_on LIKE "%kolv%" OR `p`.product_sku LIKE "%kolv%" OR `product_mpn` LIKE "%kolv%" OR `l`.product_s_desc LIKE "%kolv%" OR `l`.product_desc LIKE "%kolv%" OR `l`.slug LIKE "%kolv%" OR `category_name` LIKE "%kolv%" OR `category_description` LIKE "%kolv%" OR `mf_name` LIKE "%kolv%" OR `product_price` LIKE "%kolv%" OR `p`.product_special LIKE "%kolv%" OR `p`.product_sales LIKE "%kolv%" OR `p`.product_availability LIKE "%kolv%" OR `p`.product_available_date LIKE "%kolv%" OR `p`.product_height LIKE "%kolv%" OR `p`.product_width LIKE "%kolv%" OR `p`.product_length LIKE "%kolv%" OR `p`.product_lwh_uom LIKE "%kolv%" OR `p`.product_weight LIKE "%kolv%" OR `p`.product_weight_uom LIKE "%kolv%" OR `p`.product_in_stock LIKE "%kolv%" OR `p`.low_stock_notification LIKE "%kolv%" OR `p`.modified_on LIKE "%kolv%" OR `p`.product_unit LIKE "%kolv%" OR `p`.product_packaging LIKE "%kolv%" OR `p`.virtuemart_product_id LIKE "%kolv%") AND ((p.`product_parent_id` = "0" AND `pc`.`virtuemart_category_id` > "0") OR p.`product_parent_id` > "0") AND ((p.`product_parent_id` > "0" AND `pc`.`virtuemart_category_id` > "0") OR p.`product_parent_id` = "0") AND ( `ps`.`virtuemart_shoppergroup_id`= "2" OR `ps`.`virtuemart_shoppergroup_id` IS NULL ) AND p.`published`="1" ) group by p.`virtuemart_product_id` ORDER BY product_name ASC LIMIT 0, 20

Uses Joomla 3.4.1 why is that and how can I correct this? have searched but could not find any answer to this yet.

jjk

Did you select all options in VM configuration > Product Order Settings > Available Search fields? If yes, try disable those you which are not required. Usually 5 or 6 search options are sufficient.
Non-English Shops: Are your language files up to date?
http://virtuemart.net/community/translations

Thobbmaster

thanks, it worked after I took away some of the search fields: D