I have many errors in the log file and they all relate to one error. I can execute the sql statment without any errors.
2016-07-10 07:25:11.759 ***** ERROR ***** Exception-[HY000] SQLSTATE[HY000]: General error: 2006 MySQL server has gone away
2016-07-10 07:25:11.759 ***** ERROR ***** For query : select * from indicatorvalue where idle='0' and ( ( warningTargetDateTime<='2016-07-10 07:25:11' and warningSent='0') or ( alertTargetDateTime<='2016-07-10 07:25:11' and alertSent='0'))
2016-07-10 07:25:11.759 ***** ERROR ***** Strack trace :
2016-07-10 07:25:11.759 ***** ERROR ***** #0 Sql->query called at [/home/xxx/public_html/pm/model/persistence/SqlElement.php:1740]
2016-07-10 07:25:11.759 ***** ERROR ***** #1 SqlElement->getSqlElementsFromCriteria called at [/home/xxx/public_html/pm/model/Cron.php:341]
2016-07-10 07:25:11.759 ***** ERROR ***** #2 Cron->checkDates called at [/home/xxx/public_html/pm/model/Cron.php:295]
2016-07-10 07:25:11.760 ***** ERROR ***** #3 Cron->run called at [/home/xxx/public_html/pm/model/Cron.php:256]
2016-07-10 07:25:11.760 ***** ERROR ***** #4 Cron->relaunch called at [/home/xxxx/public_html/pm/tool/cronRelaunch.php:30]
2016-07-10 07:26:11.761 ***** ERROR ***** Exception-[HY000] SQLSTATE[HY000]: General error: 2006 MySQL server has gone away
2016-07-10 07:26:11.761 ***** ERROR ***** For query : select * from indicatorvalue where idle='0' and ( ( warningTargetDateTime<='2016-07-10 07:26:11' and warningSent='0') or ( alertTargetDateTime<='2016-07-10 07:26:11' and alertSent='0'))
2016-07-10 07:26:11.761 ***** ERROR ***** Strack trace :
2016-07-10 07:26:11.761 ***** ERROR ***** #0 Sql->query called at [/home/xxxx/public_html/pm/model/persistence/SqlElement.php:1740]
2016-07-10 07:26:11.761 ***** ERROR ***** #1 SqlElement->getSqlElementsFromCriteria called at [/home/xxxx/public_html/pm/model/Cron.php:341]
2016-07-10 07:26:11.761 ***** ERROR ***** #2 Cron->checkDates called at [/home/xxxx/public_html/pm/model/Cron.php:295]
2016-07-10 07:26:11.761 ***** ERROR ***** #3 Cron->run called at [/home/xxxx/public_html/pm/model/Cron.php:256]
2016-07-10 07:26:11.761 ***** ERROR ***** #4 Cron->relaunch called at [/home/xxxx/public_html/pm/tool/cronRelaunch.php:30]
2016-07-10 07:27:11.762 ***** ERROR ***** Exception-[HY000] SQLSTATE[HY000]: General error: 2006 MySQL server has gone away
Issues come from your CRON porcess.
Maybe you changed some configuration, but CRON does not take changes into account unless restarted.
Start to stop / restart CRON process (in admin screen)
I have Stopped and Started the cron again but the problem remains.
I have tried looking at the configuration but not sure where to look for what is causing the error.
If I execute the SQL statement in PHPadmin on the table it returns 0 rows but no error.
select * from indicatorvalue where idle='0' and ( ( warningTargetDateTime<='2016-07-10 07:26:11' and warningSent='0') or ( alertTargetDateTime<='2016-07-10 07:26:11' and alertSent='0'))
Hi Babynus
PHP ver on server 5.5.36
Did the following test:
Installed Xampp server on my PC. PPH 5.6.3
Copied the installed software from the server to my PC
Dumped the Mysql DB and imported to Xampp on my PC
All is working fine and the log file does not reflect any errors as above.
Any suggestions where I can start looking. Perhaps the Cron needs special access to a folder and does not have it on the web server.
En poursuivant votre navigation, vous acceptez le dépôt de cookies tiers destinés au bon fonctionnement et à la sécurisation du site (gestion de session, reCaptcha) et à une analyse statistique anonymisée des accès sur notre site (Google Analytics). Si vous vous inscrivez, les informations que vous fournirez ne seront jamais divulguées à un tiers sous quelque forme que ce soit. En savoir plus
Cookies settings
×
Functional Cookies
Ce site utilise des cookies pour assurer son bon fonctionnement et ne peuvent pas être désactivés de nos systèmes. Nous ne les utilisons pas à des fins publicitaires. Si ces cookies sont bloqués, certaines parties du site ne pourront pas fonctionner.
Session
Please login to see yours activities!
Other cookies
Ce site web utilise un certain nombre de cookies pour gérer, par exemple, les sessions utilisateurs.