Erros nos logs do Mautic versão 4.2.1

MTC Fácil Banco de dados
1

Bom dia pessoal, migrei o meu Mautic com a Ajuda do Léo, porém estou com mensagens de erro nos logs, está aparecendo várias linhas dessa, alguém pode me ajudar?

Segue as mensagens que tenho em logs:

2022-04-12 09:45:18] mautic.NOTICE: PHP Notice - Trying to access array offset on value of type bool - in file /var/www/html/app/bundles/PageBundle/Entity/HitRepository.php - at line 276 {“options”:{“leadId”:“50370”,“0”:“https://dtnetwork.com.br/%",“second_to_last”:“116314”},“sq”:"[object] (Doctrine\DBAL\Query\QueryBuilder: SELECT h.date_hit latest_hit FROM page_hits h WHERE (h.lead_id = 50370) AND (h.id <> 116314))”,“result”:false} []
[2022-04-12 09:45:18] mautic.NOTICE: PHP Notice - Trying to access array offset on value of type bool - in file /var/www/html/app/bundles/PageBundle/Entity/HitRepository.php - at line 276 {“options”:{“leadId”:“50370”,“0”:“https://dtnetwork.com.br/%",“second_to_last”:“116314”},“sq”:"[object] (Doctrine\DBAL\Query\QueryBuilder: SELECT h.date_hit latest_hit FROM page_hits h WHERE (h.lead_id = 50370) AND (h.id <> 116314))”,“result”:false} []
[2022-04-12 09:46:32] mautic.NOTICE: PHP Notice - Trying to access array offset on value of type bool - in file /var/www/html/app/bundles/PageBundle/Entity/HitRepository.php - at line 276 {“options”:{“leadId”:“50371”,“0”:“https://dtnetwork.com.br/%",“second_to_last”:“116315”},“sq”:"[object] (Doctrine\DBAL\Query\QueryBuilder: SELECT h.date_hit latest_hit FROM page_hits h WHERE (h.lead_id = 50371) AND (h.id <> 116315))”,“result”:false} []
[2022-04-12 09:46:32] mautic.NOTICE: PHP Notice - Trying to access array offset on value of type bool - in file /var/www/html/app/bundles/PageBundle/Entity/HitRepository.php - at line 276 {“options”:{“leadId”:“50371”,“0”:“https://dtnetwork.com.br/%",“second_to_last”:“116315”},“sq”:"[object] (Doctrine\DBAL\Query\QueryBuilder: SELECT h.date_hit latest_hit FROM page_hits h WHERE (h.lead_id = 50371) AND (h.id <> 116315))”,“result”:false} []

2

A cada resposta aqui da comunidade como posso fazer para receber um e-mail ou notificação sem precisar ficar entrando? Só achei por webpush, seria legal se a plataforma permitisse o envio de e-mail, não sei se ela tem isso, obrigado

3

Manda email sim. mas tem um limite de tempo minimo pro email sair. Vou conferir e ajustar pra um valor mais eficiente.

Isso ta parecendo erro de banco de dados.

SELECT h.date_hit latest_hit FROM page_hits h WHERE (h.lead_id = 50370) AND (h.id <> 116314))”,“result”:false} []

Ele tenta fazer essa consulta. Mas o resultado e inesperado… confere se nao restou nenhum ajuste no banco depois que atualizou. O mtc-db-update deveria resolver.

Pra tirar.uma outra duvida. Confere quantos registro existem na tabela “page_hits”. Por que e nela qye wle esta com difuculdade de ler.

1 curtida
4

O problema é algo nos segmentos de data, mesmo com a sintaxe em inglês ainda continuou, eu desativei esses segmentos.

Porém o log se mantém:
[2022-04-12 22:10:19] mautic.NOTICE: PHP Notice - Trying to access array offset on value of type bool - in file /var/www/html/app/bundles/PageBundle/Entity/HitRepository.php - at line 276 {“options”:{“leadId”:“50622”,“0”:“https://dtnetwork.com.br/%",“second_to_last”:“116714”},“sq”:"[object] (Doctrine\DBAL\Query\QueryBuilder: SELECT h.date_hit latest_hit FROM page_hits h WHERE (h.lead_id = 50622) AND (h.id <> 116714))”,“result”:false} []

será que devo me preocupar ou posso deixar assim?

5

É um bug do 4. Visits specific URL point action issues · Issue #10316 · mautic/mautic · GitHub

Deixa eu ver se ja solucionaram.

6

Tem uma solução aqui, mas ainda não foi aprovada, quer experimentar?

pra aplicar primeiro vc roda:
apt install git
((esse aqui foi vacilo meu, não incluir o git))
depois:
mtc-patch-apply 10374

1 curtida
7

opa blz, vou fazer um backup e já testo

8

o problema parece ter sanado ou mudado, agora tenho outras mensagens, se não impactar no uso/funcionalidade tranquilo:

[2022-04-12 20:05:20] mautic.NOTICE: PHP Notice - Trying to access array offset on value of type null - in file /var/www/html/app/bundles/DynamicContentBundle/Views/SubscribedEvents/Timeline/index.html.php - at line 11 {“mauticTemplateVars”:{“app”:"[object] (Symfony\Bundle\FrameworkBundle\Templating\GlobalVariables: {})",“event”:{“event”:“dynamic.content.sent”,“eventId”:“dynamic.content.sent355”,“eventLabel”:{“label”:“Formulário Site”,“href”:"/s/dwc/view/2"},“eventType”:“Conteúdo Dinâmico Enviado”,“timestamp”:“2021-09-10 15:54:40”,“extra”:{“stat”:{“dynamic_content_id”:“2”,“id”:“355”,“dateSent”:“2021-09-10 15:54:40”,“name”:“Formulário Site”,“sentDetails”:[]},“type”:“sent”},“contentTemplate”:“MauticDynamicContentBundle:SubscribedEvents\Timeline:index.html.php”,“icon”:“fa-envelope”,“contactId”:“16688”},“lead”:"[object] (Mautic\LeadBundle\Entity\Lead: Mautic\LeadBundle\Entity\Lead with ID #16688)",“mauticContent”:“lead”,“mauticTemplate”:“MauticDynamicContentBundle:SubscribedEvents\Timeline:index.html.php”,“view”:"[object] (Mautic\CoreBundle\Templating\Engine\PhpEngine: {})"},“app”:"[object] (Symfony\Bundle\FrameworkBundle\Templating\GlobalVariables: {})",“event”:{“event”:“dynamic.content.sent”,“eventId”:“dynamic.content.sent355”,“eventLabel”:{“label”:“Formulário Site”,“href”:"/s/dwc/view/2"},“eventType”:“Conteúdo Dinâmico Enviado”,“timestamp”:“2021-09-10 15:54:40”,“extra”:{“stat”:{“dynamic_content_id”:“2”,“id”:“355”,“dateSent”:“2021-09-10 15:54:40”,“name”:“Formulário Site”,“sentDetails”:[]},“type”:“sent”},“contentTemplate”:“MauticDynamicContentBundle:SubscribedEvents\Timeline:index.html.php”,“icon”:“fa-envelope”,“contactId”:“16688”},“lead”:"[object] (Mautic\LeadBundle\Entity\Lead: Mautic\LeadBundle\Entity\Lead with ID #16688)",“mauticContent”:“lead”,“mauticTemplate”:“MauticDynamicContentBundle:SubscribedEvents\Timeline:index.html.php”,“view”:"[object] (Mautic\CoreBundle\Templating\Engine\PhpEngine: {})"} []
[2022-04-12 20:05:20] mautic.NOTICE: PHP Notice - Undefined offset: 1 - in file /var/www/html/app/bundles/LeadBundle/Views/Auditlog/details.html.php - at line 62 {“mauticTemplateVars”:{“app”:"[object] (Symfony\Bundle\FrameworkBundle\Templating\GlobalVariables: {})",“event”:{“eventType”:“update”,“eventLabel”:“System”,“timestamp”:“2022-04-11 19:00:03”,“details”:{“tags”:{“added”:[“Cliente”],“removed”:[“Oportunidade”]}},“contentTemplate”:“MauticLeadBundle:Auditlog:details.html.php”},“lead”:"[object] (Mautic\LeadBundle\Entity\Lead: Mautic\LeadBundle\Entity\Lead with ID #16688)",“mauticContent”:“lead”,“mauticTemplate”:“MauticLeadBundle:Auditlog:details.html.php”,“view”:"[object] (Mautic\CoreBundle\Templating\Engine\PhpEngine: {})"},“app”:"[object] (Symfony\Bundle\FrameworkBundle\Templating\GlobalVariables: {})",“event”:{“eventType”:“update”,“eventLabel”:“System”,“timestamp”:“2022-04-11 19:00:03”,“details”:{“tags”:{“added”:[“Cliente”],“removed”:[“Oportunidade”]}},“contentTemplate”:“MauticLeadBundle:Auditlog:details.html.php”},“lead”:"[object] (Mautic\LeadBundle\Entity\Lead: Mautic\LeadBundle\Entity\Lead with ID #16688)",“mauticContent”:“lead”,“mauticTemplate”:“MauticLeadBundle:Auditlog:details.html.php”,“view”:"[object] (Mautic\CoreBundle\Templating\Engine\PhpEngine: {})",“details”:{“tags”:{“added”:[“Cliente”],“removed”:[“Oportunidade”]}},“type”:“update”,“text”:"

9

Agora é algum bizil com esse contato ai. Ele está saudável?

1 curtida
10

uai, sou eu rs

image
image1639×152 12.3 KB

11

Eu removi o meu usuário e acabei de converter em um formulário do Mautic no meu site, vou monitorar se o erro volta, como sempre faço testes com meu usuário pode ser algo nele sim.

Aviso aqui depois, obrigado

12

Bom dia, a minha preocupação é algo não estar funcionando corretamente e eu perder dinheiro, furar minha estratégia etc… Por isso estou colocando esses erros e pedindo ajuda.

Estou recebendo esses erros no meu Mautic 4.2.1:

[2022-04-12 21:15:58] mautic.NOTICE: PHP Notice - Undefined index: log - in file /var/www/html/app/bundles/DynamicContentBundle/Views/SubscribedEvents/Timeline/index.html.php - at line 11 {“mauticTemplateVars”:{“app”:"[object] (Symfony\Bundle\FrameworkBundle\Templating\GlobalVariables: {})",“event”:{“event”:“dynamic.content.sent”,“eventId”:“dynamic.content.sent595”,“eventLabel”:{“label”:“obrigado-por-solicitar-demonstracao-chat-corp”,“href”:"/s/dwc/view/4"},“eventType”:“Conteúdo Dinâmico Enviado”,“timestamp”:“2022-02-01 20:19:58”,“extra”:{“stat”:{“dynamic_content_id”:“4”,“id”:“595”,“dateSent”:“2022-02-01 20:19:58”,“name”:“obrigado-por-solicitar-demonstracao-chat-corp”,“sentDetails”:[]},“type”:“sent”},“contentTemplate”:“MauticDynamicContentBundle:SubscribedEvents\Timeline:index.html.php”,“icon”:“fa-envelope”,“contactId”:“16688”},“lead”:"[object] (Mautic\LeadBundle\Entity\Lead: Mautic\LeadBundle\Entity\Lead with ID #16688)",“mauticContent”:“lead”,“mauticTemplate”:“MauticDynamicContentBundle:SubscribedEvents\Timeline:index.html.php”,“view”:"[object] (Mautic\CoreBundle\Templating\Engine\PhpEngine: {})"},“app”:"[object] (Symfony\Bundle\FrameworkBundle\Templating\GlobalVariables: {})",“event”:{“event”:“dynamic.content.sent”,“eventId”:“dynamic.content.sent595”,“eventLabel”:{“label”:“obrigado-por-solicitar-demonstracao-chat-corp”,“href”:"/s/dwc/view/4"},“eventType”:“Conteúdo Dinâmico Enviado”,“timestamp”:“2022-02-01 20:19:58”,“extra”:{“stat”:{“dynamic_content_id”:“4”,“id”:“595”,“dateSent”:“2022-02-01 20:19:58”,“name”:“obrigado-por-solicitar-demonstracao-chat-corp”,“sentDetails”:[]},“type”:“sent”},“contentTemplate”:“MauticDynamicContentBundle:SubscribedEvents\Timeline:index.html.php”,“icon”:“fa-envelope”,“contactId”:“16688”},“lead”:"[object] (Mautic\LeadBundle\Entity\Lead: Mautic\LeadBundle\Entity\Lead with ID #16688)",“mauticContent”:“lead”,“mauticTemplate”:“MauticDynamicContentBundle:SubscribedEvents\Timeline:index.html.php”,“view”:"[object] (Mautic\CoreBundle\Templating\Engine\PhpEngine: {})"} []

[2022-04-12 21:15:58] mautic.NOTICE: PHP Notice - Trying to access array offset on value of type null - in file /var/www/html/app/bundles/DynamicContentBundle/Views/SubscribedEvents/Timeline/index.html.php - at line 11 {“mauticTemplateVars”:{“app”:"[object] (Symfony\Bundle\FrameworkBundle\Templating\GlobalVariables: {})",“event”:{“event”:“dynamic.content.sent”,“eventId”:“dynamic.content.sent595”,“eventLabel”:{“label”:“obrigado-por-solicitar-demonstracao-chat-corp”,“href”:"/s/dwc/view/4"},“eventType”:“Conteúdo Dinâmico Enviado”,“timestamp”:“2022-02-01 20:19:58”,“extra”:{“stat”:{“dynamic_content_id”:“4”,“id”:“595”,“dateSent”:“2022-02-01 20:19:58”,“name”:“obrigado-por-solicitar-demonstracao-chat-corp”,“sentDetails”:[]},“type”:“sent”},“contentTemplate”:“MauticDynamicContentBundle:SubscribedEvents\Timeline:index.html.php”,“icon”:“fa-envelope”,“contactId”:“16688”},“lead”:"[object] (Mautic\LeadBundle\Entity\Lead: Mautic\LeadBundle\Entity\Lead with ID #16688)",“mauticContent”:“lead”,“mauticTemplate”:“MauticDynamicContentBundle:SubscribedEvents\Timeline:index.html.php”,“view”:"[object] (Mautic\CoreBundle\Templating\Engine\PhpEngine: {})"},“app”:"[object] (Symfony\Bundle\FrameworkBundle\Templating\GlobalVariables: {})",“event”:{“event”:“dynamic.content.sent”,“eventId”:“dynamic.content.sent595”,“eventLabel”:{“label”:“obrigado-por-solicitar-demonstracao-chat-corp”,“href”:"/s/dwc/view/4"},“eventType”:“Conteúdo Dinâmico Enviado”,“timestamp”:“2022-02-01 20:19:58”,“extra”:{“stat”:{“dynamic_content_id”:“4”,“id”:“595”,“dateSent”:“2022-02-01 20:19:58”,“name”:“obrigado-por-solicitar-demonstracao-chat-corp”,“sentDetails”:[]},“type”:“sent”},“contentTemplate”:“MauticDynamicContentBundle:SubscribedEvents\Timeline:index.html.php”,“icon”:“fa-envelope”,“contactId”:“16688”},“lead”:"[object] (Mautic\LeadBundle\Entity\Lead: Mautic\LeadBundle\Entity\Lead with ID #16688)",“mauticContent”:“lead”,“mauticTemplate”:“MauticDynamicContentBundle:SubscribedEvents\Timeline:index.html.php”,“view”:"[object] (Mautic\CoreBundle\Templating\Engine\PhpEngine: {})"} []

Alguém pode me ajudar?

13

Ele esta reclamando da ativação de um conteudo dinamico web.

{“dynamic_content_id”:“4”,
“id”:“595”
,“dateSent”:“2022-02-01 20:19:58”,
“name”:“obrigado-por-solicitar-demonstracao-chat-corp”,“
sentDetails”:

Confere se esta tudo ajustado com ele apos a migração.

1 curtida
14

Boa tarde, hoje começou esses erros, devo me preocupar? Por ser critical e error, acredito que tem alguma coisa que preciso me atentar, se alguém pode me dar uma ajuda :confused:

[2022-04-14 14:53:24] mautic.ERROR: Invalid clickthrough value: Yjo4OntmOjk6ImZiaGVkZiI7Yjo1Ont2OjM7Zjo0NzoiZGJ6Y2J2dGEuZmlmYWciO3Y6NDt2OjI2NTt9Zjo4OiJmemJ2eSI7djo1NDA7Zjo3OiJmZ2JnIjtmOjU1OiI5NTgxNjg0NzRiOTUxNzI2NjI1NjM3IjtmOjc6InlmYmUiO2Y6ODoiNzIxODUiO2Y6MDoiZHViYWFmeSI7Yjo0OntmOjg6ImZ6YnZ5Ijt2OjU0MDt9fQ== {“exception”:"[object] (Mautic\CoreBundle\Exception\InvalidDecodedStringException(code: 0): The string b:8:{f:9:“fbhedf”;b:5:{v:3;f:47:“dbzcbvta.fifag”;v:4;v:265;}f:8:“fzbvy”;v:540;f:7:“fgbg”;f:55:“958168474b951726625637”;f:7:“yfbe”;f:8:“72185”;f:0:“dubaafy”;b:4:{f:8:“fzbvy”;v:540;}} is not a serialized array at /var/www/html/app/bundles/CoreBundle/Helper/ClickthroughHelper.php:46)"} []
[2022-04-14 14:53:24] mautic.ERROR: Invalid clickthrough value: Yjo4OntmOjk6ImZiaGVkZiI7Yjo1Ont2OjM7Zjo0NzoiZGJ6Y2J2dGEuZmlmYWciO3Y6NDt2OjI2NTt9Zjo4OiJmemJ2eSI7djo1NDA7Zjo3OiJmZ2JnIjtmOjU1OiI5NTgxNjg0NzRiOTUxNzI2NjI1NjM3IjtmOjc6InlmYmUiO2Y6ODoiNzIxODUiO2Y6MDoiZHViYWFmeSI7Yjo0OntmOjg6ImZ6YnZ5Ijt2OjU0MDt9fQ== {“exception”:"[object] (Mautic\CoreBundle\Exception\InvalidDecodedStringException(code: 0): The string b:8:{f:9:“fbhedf”;b:5:{v:3;f:47:“dbzcbvta.fifag”;v:4;v:265;}f:8:“fzbvy”;v:540;f:7:“fgbg”;f:55:“958168474b951726625637”;f:7:“yfbe”;f:8:“72185”;f:0:“dubaafy”;b:4:{f:8:“fzbvy”;v:540;}} is not a serialized array at /var/www/html/app/bundles/CoreBundle/Helper/ClickthroughHelper.php:46)"} []
[2022-04-14 14:53:24] mautic.ERROR: Invalid clickthrough value: Yjo4OntmOjk6ImZiaGVkZiI7Yjo1Ont2OjM7Zjo0NzoiZGJ6Y2J2dGEuZmlmYWciO3Y6NDt2OjI2NTt9Zjo4OiJmemJ2eSI7djo1NDA7Zjo3OiJmZ2JnIjtmOjU1OiI5NTgxNjg0NzRiOTUxNzI2NjI1NjM3IjtmOjc6InlmYmUiO2Y6ODoiNzIxODUiO2Y6MDoiZHViYWFmeSI7Yjo0OntmOjg6ImZ6YnZ5Ijt2OjU0MDt9fQ== {“exception”:"[object] (Mautic\CoreBundle\Exception\InvalidDecodedStringException(code: 0): The string b:8:{f:9:“fbhedf”;b:5:{v:3;f:47:“dbzcbvta.fifag”;v:4;v:265;}f:8:“fzbvy”;v:540;f:7:“fgbg”;f:55:“958168474b951726625637”;f:7:“yfbe”;f:8:“72185”;f:0:“dubaafy”;b:4:{f:8:“fzbvy”;v:540;}} is not a serialized array at /var/www/html/app/bundles/CoreBundle/Helper/ClickthroughHelper.php:46)"} []
[2022-04-14 18:17:05] mautic.CRITICAL: Uncaught PHP Exception Doctrine\DBAL\Exception\DeadlockException: “An exception occurred while executing ‘UPDATE leads SET date_modified = ?, last_active = ? WHERE id = ?’ with params [“2022-04-14 18:17:05”, “2022-04-14 18:17:04”, “46045”]: SQLSTATE[40001]: Serialization failure: 1213 Deadlock found when trying to get lock; try restarting transaction” at /var/www/html/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/AbstractMySQLDriver.php line 51 {“exception”:"[object] (Doctrine\DBAL\Exception\DeadlockException(code: 0): An exception occurred while executing ‘UPDATE leads SET date_modified = ?, last_active = ? WHERE id = ?’ with params [“2022-04-14 18:17:05”, “2022-04-14 18:17:04”, “46045”]:\n\nSQLSTATE[40001]: Serialization failure: 1213 Deadlock found when trying to get lock; try restarting transaction at /var/www/html/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/AbstractMySQLDriver.php:51, Doctrine\DBAL\Driver\PDO\Exception(code: 40001): SQLSTATE[40001]: Serialization failure: 1213 Deadlock found when trying to get lock; try restarting transaction at /var/www/html/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDO/Exception.php:18, PDOException(code: 40001): SQLSTATE[40001]: Serialization failure: 1213 Deadlock found when trying to get lock; try restarting transaction at /var/www/html/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOStatement.php:112)"} []

15

Esse erro está falando que não está conseguindo serializar o link que manda pro usuário.
Tem que entender o que é que ta falhando. Pode ser falha em algum parametro do PHP.

Você consegue replicar o erro, ou ele acontece sem você saber o que causou?

1 curtida
16

Faz uma coisa, abre pelo phpmyadmin, seleciona todas as tabelas e experimenta dar um Repair nelas.

1 curtida
17

Infelizmente não sei o que causou, executei o repair:

Reparar tabela

A sua consulta SQL foi executada com êxito.

REPAIR TABLE assets, asset_downloads, audit_log, bundle_grapesjsbuilder, cache_items, campaigns, campaign_events, campaign_form_xref, campaign_leadlist_xref, campaign_leads, campaign_lead_event_failed_log, campaign_lead_event_log, campaign_summary, categories, channel_url_trackables, companies, companies_leads, contact_merge_records, dynamic_content, dynamic_content_lead_data, dynamic_content_stats, emails, email_assets_xref, email_copies, email_list_xref, email_stats, email_stats_devices, email_stat_replies, focus, focus_stats, forms, form_actions, form_fields, form_results_3_hotspot__e, form_results_5_bofu_hotsp, form_results_6_formulario, form_results_10_formulario, form_results_14_cc_chat_co, form_results_17_cc_solicit, form_results_18_hs_revenda, form_results_20_hs_revenda, form_results_21_hs_revenda, form_results_22_hs_bate_pa, form_results_23_teste_elem, form_submissions, imports, integr[…]`

Vou monitorar os erros aqui. obrigado

18

Vinicius, uma outra coisa que é bom você fazer, como o seu banco veio migrado é rodar um optimize nas tabelas do mautic.

Na verdade o ideal é ter uma frequencia desse optimize pelo menos a cada 30 dias.
Ajuda a manter o tamanho, evitar falhas desse tipo e ajuda a ficar mais rapido.

1 curtida
19

Opa legal, acabei de fazer isso, obrigado pela dica, poxa mas ainda tenho alguns erros na minha base, como estão como critical e error, estou preocupado:

[2022-04-16 00:45:25] mautic.CRITICAL: Uncaught PHP Exception Doctrine\DBAL\Exception\DeadlockException: “An exception occurred while executing ‘UPDATE leads SET date_modified = ?, last_active = ? WHERE id = ?’ with params [“2022-04-16 00:45:25”, “2022-04-16 00:45:25”, “1576”]: SQLSTATE[40001]: Serialization failure: 1213 Deadlock found when trying to get lock; try restarting transaction” at /var/www/html/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/AbstractMySQLDriver.php line 51 {“exception”:"[object] (Doctrine\DBAL\Exception\DeadlockException(code: 0): An exception occurred while executing ‘UPDATE leads SET date_modified = ?, last_active = ? WHERE id = ?’ with params [“2022-04-16 00:45:25”, “2022-04-16 00:45:25”, “1576”]:\n\nSQLSTATE[40001]: Serialization failure: 1213 Deadlock found when trying to get lock; try restarting transaction at /var/www/html/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/AbstractMySQLDriver.php:51, Doctrine\DBAL\Driver\PDO\Exception(code: 40001): SQLSTATE[40001]: Serialization failure: 1213 Deadlock found when trying to get lock; try restarting transaction at /var/www/html/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDO/Exception.php:18, PDOException(code: 40001): SQLSTATE[40001]: Serialization failure: 1213 Deadlock found when trying to get lock; try restarting transaction at /var/www/html/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOStatement.php:112)"} []
[2022-04-16 00:47:25] mautic.CRITICAL: Uncaught PHP Exception Doctrine\DBAL\Exception\DeadlockException: “An exception occurred while executing ‘UPDATE leads SET last_active = ? WHERE id = ?’ with params [“2022-04-16 00:47:25”, “51427”]: SQLSTATE[40001]: Serialization failure: 1213 Deadlock found when trying to get lock; try restarting transaction” at /var/www/html/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/AbstractMySQLDriver.php line 51 {“exception”:"[object] (Doctrine\DBAL\Exception\DeadlockException(code: 0): An exception occurred while executing ‘UPDATE leads SET last_active = ? WHERE id = ?’ with params [“2022-04-16 00:47:25”, “51427”]:\n\nSQLSTATE[40001]: Serialization failure: 1213 Deadlock found when trying to get lock; try restarting transaction at /var/www/html/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/AbstractMySQLDriver.php:51, Doctrine\DBAL\Driver\PDO\Exception(code: 40001): SQLSTATE[40001]: Serialization failure: 1213 Deadlock found when trying to get lock; try restarting transaction at /var/www/html/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDO/Exception.php:18, PDOException(code: 40001): SQLSTATE[40001]: Serialization failure: 1213 Deadlock found when trying to get lock; try restarting transaction at /var/www/html/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOStatement.php:112)"} []
[2022-04-15 23:51:32] mautic.NOTICE: PHP Notice - Undefined index: log - in file /var/www/html/app/bundles/DynamicContentBundle/Views/SubscribedEvents/Timeline/index.html.php - at line 11 {“mauticTemplateVars”:{“app”:"[object] (Symfony\Bundle\FrameworkBundle\Templating\GlobalVariables: {})",“event”:{“event”:“dynamic.content.sent”,“eventId”:“dynamic.content.sent357”,“eventLabel”:{“label”:“Formulário Site”,“href”:"/s/dwc/view/2"},“eventType”:“Conteúdo Dinâmico Enviado”,“timestamp”:“2021-09-12 16:16:40”,“extra”:{“stat”:{“dynamic_content_id”:“2”,“id”:“357”,“dateSent”:“2021-09-12 16:16:40”,“name”:“Formulário Site”,“sentDetails”:[]},“type”:“sent”},“contentTemplate”:“MauticDynamicContentBundle:SubscribedEvents\Timeline:index.html.php”,“icon”:“fa-envelope”,“contactId”:“10517”},“lead”:"[object] (Mautic\LeadBundle\Entity\Lead: Mautic\LeadBundle\Entity\Lead with ID #10517)",“mauticContent”:“lead”,“mauticTemplate”:“MauticDynamicContentBundle:SubscribedEvents\Timeline:index.html.php”,“view”:"[object] (Mautic\CoreBundle\Templating\Engine\PhpEngine: {})"},“app”:"[object] (Symfony\Bundle\FrameworkBundle\Templating\GlobalVariables: {})",“event”:{“event”:“dynamic.content.sent”,“eventId”:“dynamic.content.sent357”,“eventLabel”:{“label”:“Formulário Site”,“href”:"/s/dwc/view/2"},“eventType”:“Conteúdo Dinâmico Enviado”,“timestamp”:“2021-09-12 16:16:40”,“extra”:{“stat”:{“dynamic_content_id”:“2”,“id”:“357”,“dateSent”:“2021-09-12 16:16:40”,“name”:“Formulário Site”,“sentDetails”:[]},“type”:“sent”},“contentTemplate”:“MauticDynamicContentBundle:SubscribedEvents\Timeline:index.html.php”,“icon”:“fa-envelope”,“contactId”:“10517”},“lead”:"[object] (Mautic\LeadBundle\Entity\Lead: Mautic\LeadBundle\Entity\Lead with ID #10517)",“mauticContent”:“lead”,“mauticTemplate”:“MauticDynamicContentBundle:SubscribedEvents\Timeline:index.html.php”,“view”:"[object] (Mautic\CoreBundle\Templating\Engine\PhpEngine: {})"} []
[2022-04-15 23:51:32] mautic.NOTICE: PHP Notice - Trying to access array offset on value of type null - in file /var/www/html/app/bundles/DynamicContentBundle/Views/SubscribedEvents/Timeline/index.html.php - at line 11 {“mauticTemplateVars”:{“app”:"[object] (Symfony\Bundle\FrameworkBundle\Templating\GlobalVariables: {})",“event”:{“event”:“dynamic.content.sent”,“eventId”:“dynamic.content.sent357”,“eventLabel”:{“label”:“Formulário Site”,“href”:"/s/dwc/view/2"},“eventType”:“Conteúdo Dinâmico Enviado”,“timestamp”:“2021-09-12 16:16:40”,“extra”:{“stat”:{“dynamic_content_id”:“2”,“id”:“357”,“dateSent”:“2021-09-12 16:16:40”,“name”:“Formulário Site”,“sentDetails”:[]},“type”:“sent”},“contentTemplate”:“MauticDynamicContentBundle:SubscribedEvents\Timeline:index.html.php”,“icon”:“fa-envelope”,“contactId”:“10517”},“lead”:"[object] (Mautic\LeadBundle\Entity\Lead: Mautic\LeadBundle\Entity\Lead with ID #10517)",“mauticContent”:“lead”,“mauticTemplate”:“MauticDynamicContentBundle:SubscribedEvents\Timeline:index.html.php”,“view”:"[object] (Mautic\CoreBundle\Templating\Engine\PhpEngine: {})"},“app”:"[object] (Symfony\Bundle\FrameworkBundle\Templating\GlobalVariables: {})",“event”:{“event”:“dynamic.content.sent”,“eventId”:“dynamic.content.sent357”,“eventLabel”:{“label”:“Formulário Site”,“href”:"/s/dwc/view/2"},“eventType”:“Conteúdo Dinâmico Enviado”,“timestamp”:“2021-09-12 16:16:40”,“extra”:{“stat”:{“dynamic_content_id”:“2”,“id”:“357”,“dateSent”:“2021-09-12 16:16:40”,“name”:“Formulário Site”,“sentDetails”:[]},“type”:“sent”},“contentTemplate”:“MauticDynamicContentBundle:SubscribedEvents\Timeline:index.html.php”,“icon”:“fa-envelope”,“contactId”:“10517”},“lead”:"[object] (Mautic\LeadBundle\Entity\Lead: Mautic\LeadBundle\Entity\Lead with ID #10517)",“mauticContent”:“lead”,“mauticTemplate”:“MauticDynamicContentBundle:SubscribedEvents\Timeline:index.html.php”,“view”:"[object] (Mautic\CoreBundle\Templating\Engine\PhpEngine: {})"} []
[2022-04-16 12:27:49] mautic.CRITICAL: Uncaught PHP Exception Doctrine\DBAL\Exception\DeadlockException: “An exception occurred while executing ‘UPDATE leads SET date_modified = ?, last_active = ? WHERE id = ?’ with params [“2022-04-16 12:27:49”, “2022-04-16 12:27:49”, “29478”]: SQLSTATE[40001]: Serialization failure: 1213 Deadlock found when trying to get lock; try restarting transaction” at /var/www/html/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/AbstractMySQLDriver.php line 51 {“exception”:"[object] (Doctrine\DBAL\Exception\DeadlockException(code: 0): An exception occurred while executing ‘UPDATE leads SET date_modified = ?, last_active = ? WHERE id = ?’ with params [“2022-04-16 12:27:49”, “2022-04-16 12:27:49”, “29478”]:\n\nSQLSTATE[40001]: Serialization failure: 1213 Deadlock found when trying to get lock; try restarting transaction at /var/www/html/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/AbstractMySQLDriver.php:51, Doctrine\DBAL\Driver\PDO\Exception(code: 40001): SQLSTATE[40001]: Serialization failure: 1213 Deadlock found when trying to get lock; try restarting transaction at /var/www/html/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDO/Exception.php:18, PDOException(code: 40001): SQLSTATE[40001]: Serialization failure: 1213 Deadlock found when trying to get lock; try restarting transaction at /var/www/html/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOStatement.php:112)"} []
[2022-04-16 14:53:25] mautic.ERROR: Invalid clickthrough value: Yjo4OntmOjk6ImZiaGVkZiI7Yjo1Ont2OjM7Zjo0NzoiZGJ6Y2J2dGEuZmlmYWciO3Y6NDt2OjI2ODt9Zjo4OiJmemJ2eSI7djo1NDI7Zjo3OiJmZ2JnIjtmOjU1OiI5NThiZTE0ODgyMmE2MDQ5NjI3MjcyIjtmOjc6InlmYmUiO2Y6ODoiNzIxODUiO2Y6MDoiZHViYWFmeSI7Yjo0OntmOjg6ImZ6YnZ5Ijt2OjU0Mjt9fQ== {“exception”:"[object] (Mautic\CoreBundle\Exception\InvalidDecodedStringException(code: 0): The string b:8:{f:9:“fbhedf”;b:5:{v:3;f:47:“dbzcbvta.fifag”;v:4;v:268;}f:8:“fzbvy”;v:542;f:7:“fgbg”;f:55:“958be148822a6049627272”;f:7:“yfbe”;f:8:“72185”;f:0:“dubaafy”;b:4:{f:8:“fzbvy”;v:542;}} is not a serialized array at /var/www/html/app/bundles/CoreBundle/Helper/ClickthroughHelper.php:46)"} []

20

Ví algumas reclamações desse mesmo erro em outras pessoas la no github, vou continuar procurando, se aparecer alguma coisa te falo…