News:

Looking for documentation? Take a look on our wiki

Main Menu

Lost connection to MySQL server during query on home page only

Started by SiEMdj, April 01, 2012, 13:17:31 PM

Previous topic - Next topic

SiEMdj

Hello everyone,
i've some problems with virtuemart 2.

I've made a site with about 3000 products, when i was theming that on localhost there was no problems. I'll put that online and i got this error:

500 - JDatabaseMySQL::query: 2013 - Lost connection to MySQL server during query SQL=SELECT * FROM `bo_virtuemart_products_it_it` as l JOIN `bo_virtuemart_products` AS p using (`virtuemart_product_id`) LEFT JOIN `bo_virtuemart_product_prices` as pp ON p.`virtuemart_product_id` = pp.`virtuemart_product_id` LEFT JOIN `bo_virtuemart_product_shoppergroups` ON p.`virtuemart_product_id` = `bo_virtuemart_product_shoppergroups`.`virtuemart_product_id` LEFT OUTER JOIN `bo_virtuemart_shoppergroups` as s ON s.`virtuemart_shoppergroup_id` = `bo_virtuemart_product_shoppergroups`.`virtuemart_shoppergroup_id` WHERE ( p.`published`="1" AND (s.`virtuemart_shoppergroup_id`= "2" OR (s.`virtuemart_shoppergroup_id`) IS NULL )) group by p.`virtuemart_product_id` ORDER BY product_sales DESC LIMIT 0, 5

All inside pages have no problems. Only home page that have 2 mod_virtuemart_product but removing them will not work.

Someone would have a solution for me?

Thanks!