VirtueMart Forum

VirtueMart 2 + 3 + 4 => General Questions => Topic started by: 2dmaster on February 19, 2016, 12:17:54 PM

Title: mysql error 2006
Post by: 2dmaster on February 19, 2016, 12:17:54 PM
2006
MYSQL SERVER HAS GONE AWAY SQL=SELECT DISTINCT A.VIRTUEMART_CATEGORY_ID AS ID, A.CATEGORY_DESCRIPTION AS DESCRIPTION, M.FILE_URL AS CATEGORYIMG, A.CATEGORY_NAME AS NAME, F.CATEGORY_PARENT_ID AS PARENT, 'CAT' AS TYP, (SELECT COUNT(*) FROM #___VIRTUEMART_PRODUCT_CATEGORIES AS AX LEFT JOIN #___VIRTUEMART_PRODUCTS AS BP ON AX.VIRTUEMART_PRODUCT_ID = BP.VIRTUEMART_PRODUCT_ID WHERE AX.VIRTUEMART_CATEGORY_ID = A.VIRTUEMART_CATEGORY_ID AND BP.PUBLISHED='1' ) AS PRODUCTNUM FROM #___VIRTUEMART_CATEGORIES_RU_RU AS A LEFT JOIN #___VIRTUEMART_CATEGORY_CATEGORIES AS F ON A.VIRTUEMART_CATEGORY_ID = F.CATEGORY_CHILD_ID LEFT JOIN #___VIRTUEMART_CATEGORIES AS B ON A.VIRTUEMART_CATEGORY_ID = B.VIRTUEMART_CATEGORY_ID LEFT JOIN #___VIRTUEMART_CATEGORY_MEDIAS AS CM ON A.VIRTUEMART_CATEGORY_ID = CM.VIRTUEMART_CATEGORY_ID LEFT JOIN #___VIRTUEMART_MEDIAS AS M ON CM.VIRTUEMART_MEDIA_ID = M.VIRTUEMART_MEDIA_ID WHERE B.PUBLISHED='1' AND A.VIRTUEMART_CATEGORY_ID = F.CATEGORY_CHILD_ID ORDER BY A.CATEGORY_NAME ASC
Title: Re: mysql error 2006
Post by: jenkinhill on February 19, 2016, 12:31:35 PM
QuoteMYSQL SERVER HAS GONE AWAY

Host issues?

http://dev.mysql.com/doc/refman/5.7/en/gone-away.html