Dúvidas sobre erro

Olá @Gabriel como vai, meu amigo preciso apenas tirar uma ultima dúvida com vc, fiz a instalação do Mautic e a integração com a Amazon SES e o teste de conexão deu certo, so que ele não envia emails de teste, e olhando os logs do Mautic tem alguns problemas, vc poderia por gentileza me passar algum tipo de orientação.

Só que a lista esta enorme no log praticamente do mesmo erro

[2023-02-17 12:06:01] mautic.NOTICE: RuntimeException: /home/dev_cria2023agencia/htdocs/imail.criativeinside.com.br/var/cache/prod/…/run could not be created. (uncaught exception) at /home/dev_cria2023agencia/htdocs/imail.criativeinside.com.br/app/bundles/CoreBundle/Command/ModeratedCommand.php line 97 while running console command mautic:campaigns:rebuild [] {“hostname”:“iwebcloud02”,“pid”:1300813}
[2023-02-17 12:06:01] mautic.WARNING: Command mautic:campaigns:rebuild exited with status code 1 [] {“hostname”:“iwebcloud02”,“pid”:1300813}
[2023-02-17 12:07:01] mautic.NOTICE: RuntimeException: /home/dev_cria2023agencia/htdocs/imail.criativeinside.com.br/var/cache/prod/…/run could not be created. (uncaught exception) at /home/dev_cria2023agencia/htdocs/imail.criativeinside.com.br/app/bundles/CoreBundle/Command/ModeratedCommand.php line 97 while running console command mautic:campaigns:trigger [] {“hostname”:“iwebcloud02”,“pid”:1302986}
[2023-02-17 12:07:01] mautic.WARNING: Command mautic:campaigns:trigger exited with status code 1 [] {“hostname”:“iwebcloud02”,“pid”:1302986}

Esse erro registrado no log ainda não cheguei a ver.
Mas parece ser alguma limitação no seu servidor.
Me fala mais sobre esse servidor no qual está hospedando o Mautic.

Como é para minha esposa usar na clinica tentei fazer algo fácil sendo assim usei uma vps da Hetzener no EUA o CP11 e como painel usei o CloudPanel, caso queira com total certeza aceito sua sugestão do que for melhor ser feito, so o aaPanel que não gostaria de usar ele só para instalar o MariaBD leva horas para deixar pronto, mas pra mim o que vale é a sua sugestão, o que vc falar qué melhor fazer para ser funcional vou fazer nem que seja WordOps.

Não cheguei a ver esse erro registrado no log, por isso perguntei sobre o servidor. No entanto, parece que esse erro não está relacionado ao problema de envio dos testes. Se a conexão com SES foi bem sucedida, o Mautic deveria ser capaz de enviar pelo menos um e-mail de teste. Quando você envia o teste, aparece alguma mensagem em vermelho informando algum erro?

Não confirma o envio normalmente
teste01

Se vc acha que pode ser problema no painel tem alguma alternativa que vc sugere que seja 100% funcinoal.

Não é impossível que tenha relação com o painel.
Mas pelo menos o teste deveria ser enviado corretamente.
Tenta enviar email para outros endereços como gmail por exemplo. É possível que o serviço que está utilizando para gerenciar esse email profissional esteja bloqueando o recebimento.

Envio para gmail mas sem sucesso mas ele informa que foi e na AWS ainda esta com zero envios

E aquela lista de logs enorme não para de crescer

Sinceramente não conheço essa configuração que utilizou no servidor e por isso estou as cegas.
Não sei bem como lhe orientar para corrigir isso.

De todas as configurações que já testei recomendo o WordOps.
Com ele nunca vi erros assim. Então recomendaria sim utilizar o WordOps.

Muito obrigado pela ajuda instalei com o Wordops e está rodando redondinho sou muito grato, agora quero mais um conselho para hospedar 4 sites wordpress sugere no proprio wordops dentro de um novo servidor.

1 curtida

Olá bom dia, vou incomodar vc creio que so mais um vez, vi 2 coisas hoje no Mautic

1 - Em recomendações agora aparece em vermelho: “Seu fuso horário padrão não é suportado pelo PHP. Verifique se há erros de digitação em sua configuração do PHP.”

2- Em logs tenho as notificações abaixo, pode me orientar em algo…

[2023-02-18 07:17:55] mautic.NOTICE: PHP Notice - SessionHandler::gc(): ps_files_cleanup_dir: opendir(/var/lib/php/sessions) failed: Permission denied (13) - in file /var/www/mautic.criativeinside.com.br/htdocs/vendor/symfony/http-foundation/Session/Storage/Handler/StrictSessionHandler.php - at line 106 {“maxlifetime”:1440} {“hostname”:“mautic.criativeinside.com.br”,“pid”:55406}
[2023-02-18 12:18:56] mautic.NOTICE: PHP Notice - Undefined index: Type - in file /var/www/mautic.criativeinside.com.br/htdocs/app/bundles/EmailBundle/Swiftmailer/Amazon/AmazonCallback.php - at line 147 {“payload”:{“notificationType”:“AmazonSnsSubscriptionSucceeded”,“message”:“You have successfully subscribed your Amazon SNS topic ‘arn:aws:sns:sa-east-1:816811751258:mautic_criativeinside_com_br’ to receive ‘Bounce’ notifications from Amazon SES for identity ‘[email protected]’.”},“type”:“AmazonSnsSubscriptionSucceeded”} {“hostname”:“mautic.criativeinside.com.br”,“pid”:2118}
[2023-02-18 12:18:56] mautic.WARNING: Received SES webhook of type ‘’ but couldn’t understand payload [] {“hostname”:“mautic.criativeinside.com.br”,“pid”:2118}
[2023-02-18 12:18:56] mautic.NOTICE: PHP Notice - Undefined index: Type - in file /var/www/mautic.criativeinside.com.br/htdocs/app/bundles/EmailBundle/Swiftmailer/Amazon/AmazonCallback.php - at line 147 {“payload”:{“notificationType”:“AmazonSnsSubscriptionSucceeded”,“message”:“You have successfully subscribed your Amazon SNS topic ‘arn:aws:sns:sa-east-1:816811751258:mautic_criativeinside_com_br’ to receive ‘Complaint’ notifications from Amazon SES for identity ‘[email protected]’.”},“type”:“AmazonSnsSubscriptionSucceeded”} {“hostname”:“mautic.criativeinside.com.br”,“pid”:2125}
[2023-02-18 12:18:56] mautic.WARNING: Received SES webhook of type ‘’ but couldn’t understand payload [] {“hostname”:“mautic.criativeinside.com.br”,“pid”:2125}
[2023-02-18 12:19:09] mautic.NOTICE: PHP Notice - Undefined index: Type - in file /var/www/mautic.criativeinside.com.br/htdocs/app/bundles/EmailBundle/Swiftmailer/Amazon/AmazonCallback.php - at line 147 {“payload”:{“notificationType”:“AmazonSnsSubscriptionSucceeded”,“message”:“You have successfully subscribed your Amazon SNS topic ‘arn:aws:sns:sa-east-1:816811751258:mautic_criativeinside_com_br’ to receive ‘Bounce’ notifications from Amazon SES for identity ‘[email protected]’.”},“type”:“AmazonSnsSubscriptionSucceeded”} {“hostname”:“mautic.criativeinside.com.br”,“pid”:2118}
[2023-02-18 12:19:09] mautic.WARNING: Received SES webhook of type ‘’ but couldn’t understand payload [] {“hostname”:“mautic.criativeinside.com.br”,“pid”:2118}
[2023-02-18 12:19:09] mautic.NOTICE: PHP Notice - Undefined index: Type - in file /var/www/mautic.criativeinside.com.br/htdocs/app/bundles/EmailBundle/Swiftmailer/Amazon/AmazonCallback.php - at line 147 {“payload”:{“notificationType”:“AmazonSnsSubscriptionSucceeded”,“message”:“You have successfully subscribed your Amazon SNS topic ‘arn:aws:sns:sa-east-1:816811751258:mautic_criativeinside_com_br’ to receive ‘Complaint’ notifications from Amazon SES for identity ‘[email protected]’.”},“type”:“AmazonSnsSubscriptionSucceeded”} {“hostname”:“mautic.criativeinside.com.br”,“pid”:2125}
[2023-02-18 12:19:09] mautic.WARNING: Received SES webhook of type ‘’ but couldn’t understand payload [] {“hostname”:“mautic.criativeinside.com.br”,“pid”:2125}
[2023-02-18 12:25:29] mautic.NOTICE: PHP Notice - Undefined index: Type - in file /var/www/mautic.criativeinside.com.br/htdocs/app/bundles/EmailBundle/Swiftmailer/Amazon/AmazonCallback.php - at line 147 {“payload”:{“notificationType”:“AmazonSnsSubscriptionSucceeded”,“message”:“You have successfully subscribed your Amazon SNS topic ‘arn:aws:sns:sa-east-1:816811751258:mautic_criativeinside_com_br’ to receive ‘Bounce’ notifications from Amazon SES for identity ‘[email protected]’.”},“type”:“AmazonSnsSubscriptionSucceeded”} {“hostname”:“mautic.criativeinside.com.br”,“pid”:14385}
[2023-02-18 12:25:29] mautic.WARNING: Received SES webhook of type ‘’ but couldn’t understand payload [] {“hostname”:“mautic.criativeinside.com.br”,“pid”:14385}
[2023-02-18 12:25:29] mautic.NOTICE: PHP Notice - Undefined index: Type - in file /var/www/mautic.criativeinside.com.br/htdocs/app/bundles/EmailBundle/Swiftmailer/Amazon/AmazonCallback.php - at line 147 {“payload”:{“notificationType”:“AmazonSnsSubscriptionSucceeded”,“message”:“You have successfully subscribed your Amazon SNS topic ‘arn:aws:sns:sa-east-1:816811751258:mautic_criativeinside_com_br’ to receive ‘Complaint’ notifications from Amazon SES for identity ‘[email protected]’.”},“type”:“AmazonSnsSubscriptionSucceeded”} {“hostname”:“mautic.criativeinside.com.br”,“pid”:14386}
[2023-02-18 12:25:29] mautic.WARNING: Received SES webhook of type ‘’ but couldn’t understand payload [] {“hostname”:“mautic.criativeinside.com.br”,“pid”:14386}
[2023-02-18 12:26:25] mautic.NOTICE: PHP Notice - Undefined index: Type - in file /var/www/mautic.criativeinside.com.br/htdocs/app/bundles/EmailBundle/Swiftmailer/Amazon/AmazonCallback.php - at line 147 {“payload”:{“notificationType”:“AmazonSnsSubscriptionSucceeded”,“message”:“You have successfully subscribed your Amazon SNS topic ‘arn:aws:sns:sa-east-1:816811751258:mautic_criativeinside_com_br’ to receive ‘Bounce’ notifications from Amazon SES for identity ‘[email protected]’.”},“type”:“AmazonSnsSubscriptionSucceeded”} {“hostname”:“mautic.criativeinside.com.br”,“pid”:14385}
[2023-02-18 12:26:25] mautic.WARNING: Received SES webhook of type ‘’ but couldn’t understand payload [] {“hostname”:“mautic.criativeinside.com.br”,“pid”:14385}
[2023-02-18 12:26:26] mautic.NOTICE: PHP Notice - Undefined index: Type - in file /var/www/mautic.criativeinside.com.br/htdocs/app/bundles/EmailBundle/Swiftmailer/Amazon/AmazonCallback.php - at line 147 {“payload”:{“notificationType”:“AmazonSnsSubscriptionSucceeded”,“message”:“You have successfully subscribed your Amazon SNS topic ‘arn:aws:sns:sa-east-1:816811751258:mautic_criativeinside_com_br’ to receive ‘Complaint’ notifications from Amazon SES for identity ‘[email protected]’.”},“type”:“AmazonSnsSubscriptionSucceeded”} {“hostname”:“mautic.criativeinside.com.br”,“pid”:14386}
[2023-02-18 12:26:26] mautic.WARNING: Received SES webhook of type ‘’ but couldn’t understand payload [] {“hostname”:“mautic.criativeinside.com.br”,“pid”:14386}
[2023-02-18 09:46:28] mautic.NOTICE: PHP Notice - Trying to access array offset on value of type bool - in file /var/www/mautic.criativeinside.com.br/htdocs/app/bundles/EmailBundle/Entity/StatRepository.php - at line 516 {“query”:"[object] (Doctrine\DBAL\Query\QueryBuilder: SELECT count(es.id) as sent, count(CASE WHEN es.is_read THEN 1 ELSE null END) as “read”, count(CASE WHEN es.is_failed THEN 1 ELSE null END) as failed FROM email_stats es LEFT JOIN emails e ON e.id = es.email_id WHERE (es.date_sent IS NULL OR (es.date_sent BETWEEN :dateFrom AND :dateTo)) AND (e.is_published = :i0ceispublished) GROUP BY es.id)",“results”:false} {“hostname”:“mautic.criativeinside.com.br”,“pid”:2170}
[2023-02-18 09:46:28] mautic.NOTICE: PHP Notice - Trying to access array offset on value of type bool - in file /var/www/mautic.criativeinside.com.br/htdocs/app/bundles/EmailBundle/Entity/StatRepository.php - at line 516 {“query”:"[object] (Doctrine\DBAL\Query\QueryBuilder: SELECT count(es.id) as sent, count(CASE WHEN es.is_read THEN 1 ELSE null END) as “read”, count(CASE WHEN es.is_failed THEN 1 ELSE null END) as failed FROM email_stats es LEFT JOIN emails e ON e.id = es.email_id WHERE (es.date_sent IS NULL OR (es.date_sent BETWEEN :dateFrom AND :dateTo)) AND (e.is_published = :i0ceispublished) GROUP BY es.id)",“results”:false} {“hostname”:“mautic.criativeinside.com.br”,“pid”:2170}
[2023-02-18 09:46:28] mautic.NOTICE: PHP Notice - Trying to access array offset on value of type bool - in file /var/www/mautic.criativeinside.com.br/htdocs/app/bundles/EmailBundle/Entity/StatRepository.php - at line 516 {“query”:"[object] (Doctrine\DBAL\Query\QueryBuilder: SELECT count(es.id) as sent, count(CASE WHEN es.is_read THEN 1 ELSE null END) as “read”, count(CASE WHEN es.is_failed THEN 1 ELSE null END) as failed FROM email_stats es LEFT JOIN emails e ON e.id = es.email_id WHERE (es.date_sent IS NULL OR (es.date_sent BETWEEN :dateFrom AND :dateTo)) AND (e.is_published = :i0ceispublished) GROUP BY es.id)",“results”:false} {“hostname”:“mautic.criativeinside.com.br”,“pid”:2170}
[2023-02-18 09:46:28] mautic.NOTICE: PHP Notice - Undefined index: read - in file /var/www/mautic.criativeinside.com.br/htdocs/app/bundles/EmailBundle/EventListener/ReportSubscriber.php - at line 484 {“event”:"[object] (Mautic\ReportBundle\Event\ReportGraphEvent: {})",“graphs”:[“mautic.email.graph.line.stats”,“mautic.email.graph.pie.ignored.read.failed”,“mautic.email.table.most.emails.read”,“mautic.email.table.most.emails.sent”,“mautic.email.table.most.emails.read.percent”,“mautic.email.table.most.emails.failed”],“qb”:"[object] (Doctrine\DBAL\Query\QueryBuilder: SELECT es.date_sent AS date_sent, es.date_read AS date_read, e.subject AS subject, es.email_address AS email_address, e.id AS e_id FROM email_stats es LEFT JOIN emails e ON e.id = es.email_id WHERE (es.date_sent IS NULL OR (es.date_sent BETWEEN :dateFrom AND :dateTo)) AND (e.is_published = :i0ceispublished) GROUP BY es.id)",“g”:“mautic.email.graph.pie.ignored.read.failed”,“options”:{“dynamicFilters”:[],“paginate”:true,“reportPage”:1,“dateFrom”:“2023-01-18 00:00:00”,“dateTo”:“2023-02-18 00:00:00”,“translator”:"[object] (Mautic\CoreBundle\Translation\Translator: {})",“chartQuery”:"[object] (Mautic\CoreBundle\Helper\Chart\ChartQuery: {“colors”:["#4E5D9D","#00B49C","#FD9572","#FDB933","#757575","#9C4E5C","#694535","#596935"]})"},“queryBuilder”:"[object] (Doctrine\DBAL\Query\QueryBuilder: SELECT count(es.id) as sent, count(CASE WHEN es.is_read THEN 1 ELSE null END) as “read”, count(CASE WHEN es.is_failed THEN 1 ELSE null END) as failed FROM email_stats es LEFT JOIN emails e ON e.id = es.email_id WHERE (es.date_sent IS NULL OR (es.date_sent BETWEEN :dateFrom AND :dateTo)) AND (e.is_published = :i0ceispublished) GROUP BY es.id)",“chartQuery”:"[object] (Mautic\CoreBundle\Helper\Chart\ChartQuery: {“colors”:["#4E5D9D","#00B49C","#FD9572","#FDB933","#757575","#9C4E5C","#694535","#596935"]})",“origQuery”:"[object] (Doctrine\DBAL\Query\QueryBuilder: SELECT es.date_sent AS date_sent, es.date_read AS date_read, e.subject AS subject, es.email_address AS email_address, e.id AS e_id FROM email_stats es LEFT JOIN emails e ON e.id = es.email_id WHERE (es.date_sent IS NULL OR (es.date_sent BETWEEN :dateFrom AND :dateTo)) AND (e.is_published = :i0ceispublished) GROUP BY es.id)",“chart”:"[object] (Mautic\CoreBundle\Helper\Chart\PieChart: {“colors”:["#4E5D9D","#00B49C","#FD9572","#FDB933","#757575","#9C4E5C","#694535","#596935"]})",“sendQuery”:"[object] (Doctrine\DBAL\Query\QueryBuilder: SELECT es.generated_sent_date AS date, COUNT() AS count FROM email_stats es LEFT JOIN emails e ON e.id = es.email_id WHERE (es.date_sent IS NULL OR (es.date_sent BETWEEN :dateFrom AND :dateTo)) AND (e.is_published = :i0ceispublished) GROUP BY es.generated_sent_date ORDER BY es.generated_sent_date ASC LIMIT 32)",“readQuery”:"[object] (Doctrine\DBAL\Query\QueryBuilder: SELECT DATE_FORMAT(es.date_read, ‘%Y-%m-%d’) AS date, COUNT() AS count FROM email_stats es LEFT JOIN emails e ON e.id = es.email_id WHERE (es.date_sent IS NULL OR (es.date_sent BETWEEN :dateFrom AND :dateTo)) AND (e.is_published = :i0ceispublished) AND (date_read IS NOT NULL) GROUP BY DATE_FORMAT(es.date_read, ‘%Y-%m-%d’) ORDER BY DATE_FORMAT(es.date_read, ‘%Y-%m-%d’) ASC LIMIT 32)",“failedQuery”:"[object] (Doctrine\DBAL\Query\QueryBuilder: SELECT es.generated_sent_date AS date, COUNT() AS count FROM email_stats es LEFT JOIN emails e ON e.id = es.email_id WHERE (es.date_sent IS NULL OR (es.date_sent BETWEEN :dateFrom AND :dateTo)) AND (e.is_published = :i0ceispublished) AND (es.is_failed = :true) GROUP BY es.generated_sent_date ORDER BY es.generated_sent_date ASC LIMIT 32)",“sends”:[0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0],“reads”:[0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0],“failes”:[0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0],“data”:{“labels”:[“Jan 18, 23”,“Jan 19, 23”,“Jan 20, 23”,“Jan 21, 23”,“Jan 22, 23”,“Jan 23, 23”,“Jan 24, 23”,“Jan 25, 23”,“Jan 26, 23”,“Jan 27, 23”,“Jan 28, 23”,“Jan 29, 23”,“Jan 30, 23”,“Jan 31, 23”,“Feb 1, 23”,“Feb 2, 23”,“Feb 3, 23”,“Feb 4, 23”,“Feb 5, 23”,“Feb 6, 23”,“Feb 7, 23”,“Feb 8, 23”,“Feb 9, 23”,“Feb 10, 23”,“Feb 11, 23”,“Feb 12, 23”,“Feb 13, 23”,“Feb 14, 23”,“Feb 15, 23”,“Feb 16, 23”,“Feb 17, 23”,“Feb 18, 23”],“datasets”:[{“label”:“E-mail enviado”,“data”:[0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0],“backgroundColor”:“rgba(78,93,157,0.1)”,“borderColor”:“rgba(78,93,157,0.8)”,“pointHoverBackgroundColor”:“rgba(78,93,157,0.75)”,“pointHoverBorderColor”:“rgba(78,93,157,1)”},{“label”:“E-mail lido”,“data”:[0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0],“backgroundColor”:“rgba(0,180,156,0.1)”,“borderColor”:“rgba(0,180,156,0.8)”,“pointHoverBackgroundColor”:“rgba(0,180,156,0.75)”,“pointHoverBorderColor”:“rgba(0,180,156,1)”},{“label”:“Email falhou”,“data”:[0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0],“backgroundColor”:“rgba(253,149,114,0.1)”,“borderColor”:“rgba(253,149,114,0.8)”,“pointHoverBackgroundColor”:“rgba(253,149,114,0.75)”,“pointHoverBorderColor”:“rgba(253,149,114,1)”}],“name”:“mautic.email.graph.line.stats”},“counts”:{“ignored”:0}} {“hostname”:“mautic.criativeinside.com.br”,“pid”:2170}
[2023-02-18 09:46:28] mautic.NOTICE: PHP Notice - Undefined index: failed - in file /var/www/mautic.criativeinside.com.br/htdocs/app/bundles/EmailBundle/EventListener/ReportSubscriber.php - at line 485 {“event”:"[object] (Mautic\ReportBundle\Event\ReportGraphEvent: {})",“graphs”:[“mautic.email.graph.line.stats”,“mautic.email.graph.pie.ignored.read.failed”,“mautic.email.table.most.emails.read”,“mautic.email.table.most.emails.sent”,“mautic.email.table.most.emails.read.percent”,“mautic.email.table.most.emails.failed”],“qb”:"[object] (Doctrine\DBAL\Query\QueryBuilder: SELECT es.date_sent AS date_sent, es.date_read AS date_read, e.subject AS subject, es.email_address AS email_address, e.id AS e_id FROM email_stats es LEFT JOIN emails e ON e.id = es.email_id WHERE (es.date_sent IS NULL OR (es.date_sent BETWEEN :dateFrom AND :dateTo)) AND (e.is_published = :i0ceispublished) GROUP BY es.id)",“g”:“mautic.email.graph.pie.ignored.read.failed”,“options”:{“dynamicFilters”:[],“paginate”:true,“reportPage”:1,“dateFrom”:“2023-01-18 00:00:00”,“dateTo”:“2023-02-18 00:00:00”,“translator”:"[object] (Mautic\CoreBundle\Translation\Translator: {})",“chartQuery”:"[object] (Mautic\CoreBundle\Helper\Chart\ChartQuery: {“colors”:["#4E5D9D","#00B49C","#FD9572","#FDB933","#757575","#9C4E5C","#694535","#596935"]})"},“queryBuilder”:"[object] (Doctrine\DBAL\Query\QueryBuilder: SELECT count(es.id) as sent, count(CASE WHEN es.is_read THEN 1 ELSE null END) as “read”, count(CASE WHEN es.is_failed THEN 1 ELSE null END) as failed FROM email_stats es LEFT JOIN emails e ON e.id = es.email_id WHERE (es.date_sent IS NULL OR (es.date_sent BETWEEN :dateFrom AND :dateTo)) AND (e.is_published = :i0ceispublished) GROUP BY es.id)",“chartQuery”:"[object] (Mautic\CoreBundle\Helper\Chart\ChartQuery: {“colors”:["#4E5D9D","#00B49C","#FD9572","#FDB933","#757575","#9C4E5C","#694535","#596935"]})",“origQuery”:"[object] (Doctrine\DBAL\Query\QueryBuilder: SELECT es.date_sent AS date_sent, es.date_read AS date_read, e.subject AS subject, es.email_address AS email_address, e.id AS e_id FROM email_stats es LEFT JOIN emails e ON e.id = es.email_id WHERE (es.date_sent IS NULL OR (es.date_sent BETWEEN :dateFrom AND :dateTo)) AND (e.is_published = :i0ceispublished) GROUP BY es.id)",“chart”:"[object] (Mautic\CoreBundle\Helper\Chart\PieChart: {“colors”:["#4E5D9D","#00B49C","#FD9572","#FDB933","#757575","#9C4E5C","#694535","#596935"]})",“sendQuery”:"[object] (Doctrine\DBAL\Query\QueryBuilder: SELECT es.generated_sent_date AS date, COUNT(
) AS count FROM email_stats es LEFT JOIN emails e ON e.id = es.email_id WHERE (es.date_sent IS NULL OR (es.date_sent BETWEEN :dateFrom AND :dateTo)) AND (e.is_published = :i0ceispublished) GROUP BY es.generated_sent_date ORDER BY es.generated_sent_date ASC LIMIT 32)",“readQuery”:"[object] (Doctrine\DBAL\Query\QueryBuilder: SELECT DATE_FORMAT(es.date_read, ‘%Y-%m-%d’) AS date, COUNT() AS count FROM email_stats es LEFT JOIN emails e ON e.id = es.email_id WHERE (es.date_sent IS NULL OR (es.date_sent BETWEEN :dateFrom AND :dateTo)) AND (e.is_published = :i0ceispublished) AND (date_read IS NOT NULL) GROUP BY DATE_FORMAT(es.date_read, ‘%Y-%m-%d’) ORDER BY DATE_FORMAT(es.date_read, ‘%Y-%m-%d’) ASC LIMIT 32)",“failedQuery”:"[object] (Doctrine\DBAL\Query\QueryBuilder: SELECT es.generated_sent_date AS date, COUNT() AS count FROM email_stats es LEFT JOIN emails e ON e.id = es.email_id WHERE (es.date_sent IS NULL OR (es.date_sent BETWEEN :dateFrom AND :dateTo)) AND (e.is_published = :i0ceispublished) AND (es.is_failed = :true) GROUP BY es.generated_sent_date ORDER BY es.generated_sent_date ASC LIMIT 32)",“sends”:[0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0],“reads”:[0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0],“failes”:[0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0],“data”:{“labels”:[“Jan 18, 23”,“Jan 19, 23”,“Jan 20, 23”,“Jan 21, 23”,“Jan 22, 23”,“Jan 23, 23”,“Jan 24, 23”,“Jan 25, 23”,“Jan 26, 23”,“Jan 27, 23”,“Jan 28, 23”,“Jan 29, 23”,“Jan 30, 23”,“Jan 31, 23”,“Feb 1, 23”,“Feb 2, 23”,“Feb 3, 23”,“Feb 4, 23”,“Feb 5, 23”,“Feb 6, 23”,“Feb 7, 23”,“Feb 8, 23”,“Feb 9, 23”,“Feb 10, 23”,“Feb 11, 23”,“Feb 12, 23”,“Feb 13, 23”,“Feb 14, 23”,“Feb 15, 23”,“Feb 16, 23”,“Feb 17, 23”,“Feb 18, 23”],“datasets”:[{“label”:“E-mail enviado”,“data”:[0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0],“backgroundColor”:“rgba(78,93,157,0.1)”,“borderColor”:“rgba(78,93,157,0.8)”,“pointHoverBackgroundColor”:“rgba(78,93,157,0.75)”,“pointHoverBorderColor”:“rgba(78,93,157,1)”},{“label”:“E-mail lido”,“data”:[0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0],“backgroundColor”:“rgba(0,180,156,0.1)”,“borderColor”:“rgba(0,180,156,0.8)”,“pointHoverBackgroundColor”:“rgba(0,180,156,0.75)”,“pointHoverBorderColor”:“rgba(0,180,156,1)”},{“label”:“Email falhou”,“data”:[0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0],“backgroundColor”:“rgba(253,149,114,0.1)”,“borderColor”:“rgba(253,149,114,0.8)”,“pointHoverBackgroundColor”:“rgba(253,149,114,0.75)”,“pointHoverBorderColor”:“rgba(253,149,114,1)”}],“name”:“mautic.email.graph.line.stats”},“counts”:{“ignored”:0}} {“hostname”:“mautic.criativeinside.com.br”,“pid”:2170}

1 - Preciso de mais informações.
Não entendi exatamente o que aconteceu. Pode enviar um print?

2 - Esse log do Mautic não registra várias atividades do Mautic, não apenas erros.
Não vi nada nesse log que atrapalhe o funcionamento correto do Mautic.

Segue

Eu estou em uma versão um pouco mais antiga do Mautic que ainda não tem essa guia de Recomendaçoes.
Não tinha visto ainda.
Mas faz um teste de uma campanha e agenda o envio de um email em um horario expecífico.
Se correr tudo bem, não precisa se preocupar com isso.

Em alguns casos o PHP e algumas bibliotecas utilizam o fuso-horário que está configurado no PHP e não o fuso-horário do servidor. Basta informar ao PHP qual é o fuso-horário que sias aplicações estão rodando para que os gráficos, estatísticas, etc fiquem atualizados.

/etc/php/7.4/cli/php.ini

date.timezone = America/Sao_Paulo

mesmo eu fazendo isso o alerta continua. parece uma incompatibilidade mesmo.

1 curtida

Sim, é exatamente isso.
O WordOps, durante a instalaçção já configura o fuso de php de acordo com o fuso do server.

se vc rodar o comando

php --info | grep “zone”

vai aparecer algo assim:

“Olson” Timezone Database Version => 0.system
Timezone Database => internal
Default timezone => America/Sao_Paulo
date.timezone => no value => no value

Depois de configurar no arquivo do php fica assim:

“Olson” Timezone Database Version => 0.system
Timezone Database => internal
Default timezone => America/Sao_Paulo
date.timezone => America/Sao_Paulo => America/Sao_Paulo

mas o aviso continuou dentro do mautic.