Author Topic: mysql error 2006  (Read 926 times)

2dmaster

  • Jr. Member
  • **
  • Posts: 94
mysql error 2006
« 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

jenkinhill

  • UK Web Developer & Consultant
  • Global Moderator
  • Super Hero
  • *
  • Posts: 27433
  • Always on vacation
    • Jenkin Hill Internet
Re: mysql error 2006
« Reply #1 on: February 19, 2016, 12:31:35 pm »
Quote
MYSQL SERVER HAS GONE AWAY

Host issues?

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

Jenkin Hill Internet,
Lowestoft, Suffolk, UK

Unsolicited PMs/emails will be ignored.

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

Currently using VM 3.4.3.10057 on Joomla 3.9.8 PHP 7.0.33
Testing VM .3.6.0.10075 on Joomla 3.9.8