[SOLVED] Cron Stop

Hello,

My cron stop with this trouble :
i can't find solution or what happen ?

2023-12-11 13:56:42.488 ***** ERROR ***** [V11.0.2] Exception-[42S22] SQLSTATE[42S22]: Column not found: 1054 Unknown column 'paused' in 'where clause'
2023-12-11 13:56:42.489 ***** ERROR ***** [V11.0.2] For query : select * from meeting where (exists (select 'x' from assignment x where x.refType='Meeting' and x.refId=meeting.id and x.idResource=13)) and idle=0 and done=0 and paused=0 and idProject not in (0, 364) LIMIT 201
2023-12-11 13:56:42.489 ***** ERROR ***** [V11.0.2] Strack trace :
2023-12-11 13:56:42.489 ***** ERROR ***** [V11.0.2] #0 Sql->query called at [/var/www/projeqtor/model/persistence/SqlElement.php:2965]
2023-12-11 13:56:42.489 ***** ERROR ***** [V11.0.2] #1 SqlElement->getSqlElementsFromCriteria called at [/var/www/projeqtor/view/today.php:1461]
2023-12-11 13:56:42.489 ***** ERROR ***** [V11.0.2] #2 showActivitiesList called at [/var/www/projeqtor/view/today.php:1345]
2023-12-11 13:56:42.489 ***** ERROR ***** [V11.0.2] #3 showAssignedTasks called at [/var/www/projeqtor/view/today.php:234]
2023-12-11 13:56:42.494 ***** ERROR ***** [V11.0.2] Exception-[42S22] SQLSTATE[42S22]: Column not found: 1054 Unknown column 'paused' in 'where clause'
2023-12-11 13:56:42.494 ***** ERROR ***** [V11.0.2] For query : select * from testsession where (exists (select 'x' from assignment x where x.refType='TestSession' and x.refId=testsession.id and x.idResource=13)) and idle=0 and done=0 and paused=0 and idProject not in (0, 364) LIMIT 201
2023-12-11 13:56:42.494 ***** ERROR ***** [V11.0.2] Strack trace :
2023-12-11 13:56:42.494 ***** ERROR ***** [V11.0.2] #0 Sql->query called at [/var/www/projeqtor/model/persistence/SqlElement.php:2965]
2023-12-11 13:56:42.494 ***** ERROR ***** [V11.0.2] #1 SqlElement->getSqlElementsFromCriteria called at [/var/www/projeqtor/view/today.php:1467]
2023-12-11 13:56:42.494 ***** ERROR ***** [V11.0.2] #2 showActivitiesList called at [/var/www/projeqtor/view/today.php:1345]
2023-12-11 13:56:42.495 ***** ERROR ***** [V11.0.2] #3 showAssignedTasks called at [/var/www/projeqtor/view/today.php:234]

i also have this one :

2023-12-11 08:43:41.658 ***** ERROR ***** [V11.0.2] Error sending mail
2023-12-11 08:43:41.659 ***** ERROR ***** [V11.0.2] SMTP Server : SSL0.OVH.NET
2023-12-11 08:43:41.659 ***** ERROR ***** [V11.0.2] SMTP Port : 465
2023-12-11 08:43:41.659 ***** ERROR ***** [V11.0.2] Mail stored in Database : #9520
2023-12-11 08:43:41.659 ***** ERROR ***** [V11.0.2] PHPMail error : You must provide at least one recipient email address.
2023-12-11 08:43:41.659 ***** ERROR ***** [V11.0.2] PHPMail debug :
2023-12-11 08:43:41.843 ***** ERROR ***** [V11.0.2] Error sending mail
2023-12-11 08:43:41.843 ***** ERROR ***** [V11.0.2] SMTP Server : SSL0.OVH.NET
2023-12-11 08:43:41.843 ***** ERROR ***** [V11.0.2] SMTP Port : 465
2023-12-11 08:43:41.843 ***** ERROR ***** [V11.0.2] Mail stored in Database : #9521
2023-12-11 08:43:41.843 ***** ERROR ***** [V11.0.2] PHPMail error : You must provide at least one recipient email address.
2023-12-11 08:43:41.843 ***** ERROR ***** [V11.0.2] PHPMail debug :

so i don't know witch one is sptopping the cron and what to do ?

Thanks
LR

Thanks, i delete all my repport on today but still have the trouble.
I desactivate also mail to manager cause sometime activities have "non manager" but my trouble still present :

2023-12-13 00:49:54.775 ***** ERROR ***** [V11.0.3] CRON abnormally stopped
2023-12-13 00:49:54.775 ***** ERROR ***** [V11.0.3] === Trace Stack for last error ===
2023-12-13 00:49:54.775 ***** ERROR ***** [V11.0.3] => /var/www/projeqtor/model/Cron.php at line 319 calling debugPrintTraceStack()
2023-12-13 00:49:54.775 ***** ERROR ***** [V11.0.3] => /var/www/projeqtor/tool/cronRun.php at line 35 calling Cron:abort()
2023-12-13 00:49:54.775 ***** ERROR ***** [V11.0.3] => calling cronAbort()
2023-12-13 00:49:54.776 ***** ERROR ***** [V11.0.3] ===
2023-12-13 00:49:54.777 ***** ERROR ***** [V11.0.3] Exception-[HY000] SQLSTATE[HY000]: General error: 2006 MySQL server has gone away
2023-12-13 00:49:54.778 ***** ERROR ***** [V11.0.3] For query : select id as id, name as name from status where (idle=0 ) order by status.sortOrder, status.name
2023-12-13 00:49:54.778 ***** ERROR ***** [V11.0.3] Strack trace :
2023-12-13 00:49:54.778 ***** ERROR ***** [V11.0.3] #0 Sql->query called at [/var/www/projeqtor/model/persistence/SqlList.php:149]
2023-12-13 00:49:54.778 ***** ERROR ***** [V11.0.3] #1 SqlList->fetchList called at [/var/www/projeqtor/model/persistence/SqlList.php:63]
2023-12-13 00:49:54.778 ***** ERROR ***** [V11.0.3] #2 SqlList->getList called at [/var/www/projeqtor/model/persistence/SqlList.php:446]
2023-12-13 00:49:54.778 ***** ERROR ***** [V11.0.3] #3 SqlList->getStatusList called at [/var/www/projeqtor/model/persistence/SqlElement.php:9048]
2023-12-13 00:49:54.778 ***** ERROR ***** [V11.0.3] #4 SqlElement->getFirstStatus called at [/var/www/projeqtor/model/persistence/SqlElement.php:8326]
2023-12-13 00:49:54.778 ***** ERROR ***** [V11.0.3] #5 SqlElement->getExtraRequiredFields called at [/var/www/projeqtor/model/persistence/SqlElement.php:4979]
2023-12-13 00:49:54.779 ***** ERROR ***** [V11.0.3] #6 SqlElement->control called at [/var/www/projeqtor/model/persistence/SqlElement.php:1252]
2023-12-13 00:49:54.779 ***** ERROR ***** [V11.0.3] #7 SqlElement->saveSqlElement called at [/var/www/projeqtor/model/persistence/SqlElement.php:855]
2023-12-13 00:49:54.779 ***** ERROR ***** [V11.0.3] #8 SqlElement->save called at [/var/www/projeqtor/model/Mail.php:131]
2023-12-13 00:49:54.779 ***** ERROR ***** [V11.0.3] #9 Mail->save called at [/var/www/projeqtor/tool/projeqtor.php:2494]
2023-12-13 00:49:54.779 ***** ERROR ***** [V11.0.3] #10 sendMail_phpmailer called at [/var/www/projeqtor/tool/projeqtor.php:2435]
2023-12-13 00:49:54.779 ***** ERROR ***** [V11.0.3] #11 sendMail called at [/var/www/projeqtor/model/Cron.php:329]
2023-12-13 00:49:54.779 ***** ERROR ***** [V11.0.3] #12 Cron->abort called at [/var/www/projeqtor/tool/cronRun.php:35]
2023-12-13 00:49:54.779 ***** ERROR ***** [V11.0.3] #13 cronAbort called at
2023-12-13 00:49:54.780 ***** ERROR ***** [V11.0.3] Exception-[HY000] SQLSTATE[HY000]: General error: 2006 MySQL server has gone away
2023-12-13 00:49:54.780 ***** ERROR ***** [V11.0.3] For query : desc mail
2023-12-13 00:49:54.780 ***** ERROR ***** [V11.0.3] Strack trace :
2023-12-13 00:49:54.780 ***** ERROR ***** [V11.0.3] #0 Sql->query called at [/var/www/projeqtor/model/persistence/SqlElement.php:4170]
2023-12-13 00:49:54.780 ***** ERROR ***** [V11.0.3] #1 SqlElement->getFormatList called at [/var/www/projeqtor/model/persistence/SqlElement.php:3671]
2023-12-13 00:49:54.780 ***** ERROR ***** [V11.0.3] #2 SqlElement->getDataType called at [/var/www/projeqtor/model/persistence/SqlElement.php:5043]
2023-12-13 00:49:54.780 ***** ERROR ***** [V11.0.3] #3 SqlElement->control called at [/var/www/projeqtor/model/persistence/SqlElement.php:1252]
2023-12-13 00:49:54.780 ***** ERROR ***** [V11.0.3] #4 SqlElement->saveSqlElement called at [/var/www/projeqtor/model/persistence/SqlElement.php:855]
2023-12-13 00:49:54.780 ***** ERROR ***** [V11.0.3] #5 SqlElement->save called at [/var/www/projeqtor/model/Mail.php:131]
2023-12-13 00:49:54.780 ***** ERROR ***** [V11.0.3] #6 Mail->save called at [/var/www/projeqtor/tool/projeqtor.php:2494]
2023-12-13 00:49:54.780 ***** ERROR ***** [V11.0.3] #7 sendMail_phpmailer called at [/var/www/projeqtor/tool/projeqtor.php:2435]
2023-12-13 00:49:54.781 ***** ERROR ***** [V11.0.3] #8 sendMail called at [/var/www/projeqtor/model/Cron.php:329]
2023-12-13 00:49:54.781 ***** ERROR ***** [V11.0.3] #9 Cron->abort called at [/var/www/projeqtor/tool/cronRun.php:35]
2023-12-13 00:49:54.781 ***** ERROR ***** [V11.0.3] #10 cronAbort called at
2023-12-13 00:49:54.781 ***** ERROR ***** [V11.0.3] Exception-[HY000] SQLSTATE[HY000]: General error: 2006 MySQL server has gone away
2023-12-13 00:49:54.781 ***** ERROR ***** [V11.0.3] For query : select * from checklistable where checklistable.name='Mail'
2023-12-13 00:49:54.781 ***** ERROR ***** [V11.0.3] Strack trace :
2023-12-13 00:49:54.781 ***** ERROR ***** [V11.0.3] #0 Sql->query called at [/var/www/projeqtor/model/persistence/SqlElement.php:2969]
2023-12-13 00:49:54.781 ***** ERROR ***** [V11.0.3] #1 SqlElement->getSqlElementsFromCriteria called at [/var/www/projeqtor/model/persistence/SqlElement.php:3289]
2023-12-13 00:49:54.781 ***** ERROR ***** [V11.0.3] #2 SqlElement->getSingleSqlElementFromCriteria called at [/var/www/projeqtor/model/persistence/SqlElement.php:5410]
2023-12-13 00:49:54.782 ***** ERROR ***** [V11.0.3] #3 SqlElement->control called at [/var/www/projeqtor/model/persistence/SqlElement.php:1252]
2023-12-13 00:49:54.782 ***** ERROR ***** [V11.0.3] #4 SqlElement->saveSqlElement called at [/var/www/projeqtor/model/persistence/SqlElement.php:855]
2023-12-13 00:49:54.782 ***** ERROR ***** [V11.0.3] #5 SqlElement->save called at [/var/www/projeqtor/model/Mail.php:131]
2023-12-13 00:49:54.782 ***** ERROR ***** [V11.0.3] #6 Mail->save called at [/var/www/projeqtor/tool/projeqtor.php:2494]
2023-12-13 00:49:54.782 ***** ERROR ***** [V11.0.3] #7 sendMail_phpmailer called at [/var/www/projeqtor/tool/projeqtor.php:2435]
2023-12-13 00:49:54.782 ***** ERROR ***** [V11.0.3] #8 sendMail called at [/var/www/projeqtor/model/Cron.php:329]
2023-12-13 00:49:54.782 ***** ERROR ***** [V11.0.3] #9 Cron->abort called at [/var/www/projeqtor/tool/cronRun.php:35]
2023-12-13 00:49:54.782 ***** ERROR ***** [V11.0.3] #10 cronAbort called at
2023-12-13 00:49:54.783 ***** ERROR ***** [V11.0.3] Exception-[HY000] SQLSTATE[HY000]: General error: 2006 MySQL server has gone away
2023-12-13 00:49:54.783 ***** ERROR ***** [V11.0.3] For query : insert into mail ( mailDateTime , mailTo , mailStatus , idle , mailTitle , mailBody ) values ('2023-12-13 00:49', 'Cette adresse e-mail est protégée contre les robots spammeurs. Vous devez activer le JavaScript pour la visualiser.', 'WAIT', '0', '[ABC-Gestion des projets] Cron abnormally stopped', 'Cron was stopped for an undefined reason (abort).<br/>Please check log file at 2023-12-13 00:49:54 for more information.')
2023-12-13 00:49:54.783 ***** ERROR ***** [V11.0.3] Strack trace :
2023-12-13 00:49:54.783 ***** ERROR ***** [V11.0.3] #0 Sql->query called at [/var/www/projeqtor/model/persistence/SqlElement.php:1559]
2023-12-13 00:49:54.783 ***** ERROR ***** [V11.0.3] #1 SqlElement->insertSqlElement called at [/var/www/projeqtor/model/persistence/SqlElement.php:1316]
2023-12-13 00:49:54.783 ***** ERROR ***** [V11.0.3] #2 SqlElement->saveSqlElement called at [/var/www/projeqtor/model/persistence/SqlElement.php:855]
2023-12-13 00:49:54.783 ***** ERROR ***** [V11.0.3] #3 SqlElement->save called at [/var/www/projeqtor/model/Mail.php:131]
2023-12-13 00:49:54.783 ***** ERROR ***** [V11.0.3] #4 Mail->save called at [/var/www/projeqtor/tool/projeqtor.php:2494]
2023-12-13 00:49:54.783 ***** ERROR ***** [V11.0.3] #5 sendMail_phpmailer called at [/var/www/projeqtor/tool/projeqtor.php:2435]
2023-12-13 00:49:54.783 ***** ERROR ***** [V11.0.3] #6 sendMail called at [/var/www/projeqtor/model/Cron.php:329]
2023-12-13 00:49:54.783 ***** ERROR ***** [V11.0.3] #7 Cron->abort called at [/var/www/projeqtor/tool/cronRun.php:35]
2023-12-13 00:49:54.783 ***** ERROR ***** [V11.0.3] #8 cronAbort called at
2023-12-13 00:49:54.784 ***** ERROR ***** [V11.0.3] Error storing email in table : SQLSTATE[HY000]: General error: 2006 MySQL server has gone away<input type="hidden" id="lastSaveId" value="" /><input type="hidden" id="lastOperation" value="insert" /><input type="hidden" id="lastOperationStatus" value="ERROR" />
2023-12-13 00:49:55.434 ***** ERROR ***** [V11.0.3] Exception-[HY000] SQLSTATE[HY000]: General error: 2006 MySQL server has gone away
2023-12-13 00:49:55.435 ***** ERROR ***** [V11.0.3] For query : insert into mail ( mailDateTime , mailTo , mailStatus , idle , mailTitle , mailBody ) values ('2023-12-13 00:49', 'XXXXXXXXXXXX', 'OK', '0', '[ABC-Gestion des projets] Cron abnormally stopped', 'Cron was stopped for an undefined reason (abort).<br/>Please check log file at 2023-12-13 00:49:54 for more information.')
2023-12-13 00:49:55.435 ***** ERROR ***** [V11.0.3] Strack trace :
2023-12-13 00:49:55.435 ***** ERROR ***** [V11.0.3] #0 Sql->query called at [/var/www/projeqtor/model/persistence/SqlElement.php:1559]
2023-12-13 00:49:55.435 ***** ERROR ***** [V11.0.3] #1 SqlElement->insertSqlElement called at [/var/www/projeqtor/model/persistence/SqlElement.php:1316]
2023-12-13 00:49:55.435 ***** ERROR ***** [V11.0.3] #2 SqlElement->saveSqlElement called at [/var/www/projeqtor/model/persistence/SqlElement.php:855]
2023-12-13 00:49:55.435 ***** ERROR ***** [V11.0.3] #3 SqlElement->save called at [/var/www/projeqtor/model/Mail.php:131]
2023-12-13 00:49:55.435 ***** ERROR ***** [V11.0.3] #4 Mail->save called at [/var/www/projeqtor/tool/projeqtor.php:2637]
2023-12-13 00:49:55.435 ***** ERROR ***** [V11.0.3] #5 sendMail_phpmailer called at [/var/www/projeqtor/tool/projeqtor.php:2435]
2023-12-13 00:49:55.435 ***** ERROR ***** [V11.0.3] #6 sendMail called at [/var/www/projeqtor/model/Cron.php:329]
2023-12-13 00:49:55.435 ***** ERROR ***** [V11.0.3] #7 Cron->abort called at [/var/www/projeqtor/tool/cronRun.php:35]
2023-12-13 00:49:55.435 ***** ERROR ***** [V11.0.3] #8 cronAbort called at

Seems to be more this red message in imputation page ...

ERROR : Narrowing occurred during type inference of ZEND_FETCH_DIM_W. Please file a bug report on github.com/php/php-src/issues
in ImputationLine.php
at line 482

LR

023-12-27 00:03:24.581 ***** ERROR ***** [V11.0.3] CRON abnormally stopped
2023-12-27 00:03:24.582 ***** ERROR ***** [V11.0.3] === Trace Stack for last error ===
2023-12-27 00:03:24.582 ***** ERROR ***** [V11.0.3] => /var/www/projeqtor/model/Cron.php at line 319 calling debugPrintTraceStack()
2023-12-27 00:03:24.582 ***** ERROR ***** [V11.0.3] => /var/www/projeqtor/tool/cronRun.php at line 35 calling Cron:abort()
2023-12-27 00:03:24.582 ***** ERROR ***** [V11.0.3] => calling cronAbort()

My cron stopping every max 15min and i've got no message in 90% of case ... exept this morning ... no planned repport ( all deleted ), i desactivate mail...

Thanks for your support.
LR