lost connection to mysql Ready to throw in the towel with version 1.7.4.2

[ps2k11]

Just about had enough with this buggy software. wasting over 2 weeks now fixing bugs and just came up with another one

[PrestaShopDatabaseException]

Lost connection to MySQL server during query
 

					SELECT  p.`id_manufacturer`, COUNT(DISTINCT p.`id_product`) as nb_products
					FROM `product` p USE INDEX (product_manufacturer)
					 INNER JOIN product_shop product_shop
        ON (product_shop.id_product = p.id_product AND product_shop.id_shop = 1)
					LEFT JOIN `manufacturer` as m ON (m.`id_manufacturer`= p.`id_manufacturer`)
					WHERE p.`id_manufacturer` != 0 AND product_shop.`visibility` NOT IN ("none")
					 AND product_shop.`active` = 1 
					 AND EXISTS (
						SELECT 1
						FROM `category_group` cg
						LEFT JOIN `category_product` cp ON (cp.`id_category` = cg.`id_category`)
						WHERE p.`id_product` = cp.`id_product` AND cg.`id_group` 
					)
					GROUP BY p.`id_manufacturer`

at line 746 in file classes/db/Db.php

 

741.         if ($webservice_call && $errno) {
742.             $dbg = debug_backtrace();
743.             WebserviceRequest::getInstance()->setError(500, '[SQL Error] '.$this->getMsgError().'. From '.(isset($dbg[3]['class']) ? $dbg[3]['class'] : '').'->'.$dbg[3]['function'].'() Query was : '.$sql, 97);
744.         } elseif (_PS_DEBUG_SQL_ && $errno && !defined('PS_INSTALLATION_IN_PROGRESS')) {
745.             if ($sql) {
746.                 throw new PrestaShopDatabaseException($this->getMsgError().'<br /><br /><pre>'.$sql.'</pre>');
747.             }
748. 
749.             throw new PrestaShopDatabaseException($this->getMsgError());
750.         }
751.     }

 

[ps2k11]

problem went away by itself

this is certainly one scary version to use live

should get an apology from developers like 'sorry we messed this one up'