News:

Support the VirtueMart project and become a member

Main Menu

mysql error 2006

Started by 2dmaster, February 19, 2016, 12:17:54 PM

Previous topic - Next topic

2dmaster

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

jenkinhill

Kelvyn
Lowestoft, Suffolk, UK

Retired from forum life November 2023

Please mention your VirtueMart, Joomla and PHP versions when asking a question in this forum