GERAL - Assuntos diversos relacionados ao MTC Fácil

Post para publicação de duvidas gerais no conteúto do MTC Fácil

Olá @leoborlot Acho que seria super interessante poder comentar sobre o treinamento, o uso dos diferentes plugins do Mautic, tanto os que estão no MarketPlace, quanto os que não estão, e podem ser úteis.

1 Like

Confesso que quando gravei o Marketplance era ainda apenas uma ideia. Agora que eles está começando a criar forma, vai ser legal regravar e mostrar o processo.
Principalmente por que devem aumentar as ofertas de recursos.

Hoje eu uso princialmente o plugin que mostra os emails em fila (este es´ta incluso na nossa versão do Mautic), o plugin do recaptcha (também incluso), e particularmente uso o Crontester do kuzmany, só não coloquei na imagem por que ele ainda vende, dai acho que seria desvalorizar o trabalho dele.

Estou ansioso pra ver o que o pessoal vai colocar pra vender quando liberarem.

1 Like

Sugestão de abordar o N8N e suas integrações com Mautic. Estou fazendo os primeiros testes e fiquei muito satisfeito com o “limpador de base” que eu fiz para barrar bots e spammers:

1 Like

Outra sugestão é criar uma comunidade com as ferramentas open source para marketing:

  • Mautic
  • Elementor
  • N8N
  • outras que nem sei que existem
1 Like

Aonda vc pegou informação dessa API que verifica?

1 Like

No emailfirst.co vc consegue fazer validação de email e telefone.

2 Likes

Um excelente trabalho. Parabéns @ffontouras !!!

1 Like

Mais emailfirst.co ainda está funcionando? Eu tinha instalado com n8n e funcionando e verificando todos os e-mails, e parou de funcionar

1 Like

Olá @leoborlot . Acabei de terminar uma nova instalação com o script e, quando quero executar o mtc-cache, o sistema me diz que esse comando não existe.

2 Likes

Todos os “comandos mágicos” só existem dentro do container do Mautic.
O caminho é entrar pelo Portainer, acessar o console do container e ai sim executar o mtc-cache

2 Likes

Mostra ai o caminho felipe!

1 Like

LOL! @leoborlot Eu gosto da coisa dos “comandos mágicos”. E eu confirmo. Eu tentei, e “EUREKA!!”

2 Likes

Olá @Leo. O caminho certo pra login es app.emailfirst.co

2 Likes

Acredito que emailfirst seja um desenvolvimento do PowerTic (Luiz e Rodrigo). A verdade é que fiquei muito contente com a ligação através do n8n, mas um dia deixou de funcionar e quando entrei vi que tinham feito um conector directo para o Mautic, sem N8N. Eu não tentei esse ainda.

1 Like

Vou ver esses detalhes já posto, daí qq coisa eu exporto o meu workflow.

Ok. Obrigado @ffontouras.
Ainda não usei o validador de telefone

1 Like

Boa noite pessoal, acabei de migrar para o mautic 4.2.1, vi da versão 3, porém meu Mautic está com os logs abaixo, alguém pode me ajudar a sanar esta falha, pelo visto está com erro na atualização de segmentos, obrigado

[2022-04-11 22:44:17] mautic.NOTICE: Doctrine\DBAL\Exception\DriverException: An exception occurred while executing ‘SELECT count(leadIdPrimary) count, max(leadIdPrimary) maxId, min(leadIdPrimary) minId FROM (SELECT DISTINCT l.id as leadIdPrimary, par22q.lead_id AS par22q_lead_id FROM leads l LEFT JOIN lead_lists_leads par22q ON par22q.lead_id = l.id and (par22q.leadlist_id = 74) WHERE (l.date_identified = ?) AND (par22q.lead_id IS NULL)) sss’ with params [“esta semana”]: SQLSTATE[HY000]: General error: 1525 Incorrect DATETIME value: ‘esta semana’ (uncaught exception) at /var/www/html/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/AbstractMySQLDriver.php line 128 while running console command mautic:segments:update [] []

[2022-04-11 22:44:17] mautic.WARNING: Command mautic:segments:update exited with status code 1 [] []

[2022-04-11 22:44:45] 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”:“50184”,“0”:“https://dtnetwork.com.br/%",“second_to_last”:“116067”},“sq”:"[object] (Doctrine\DBAL\Query\QueryBuilder: SELECT h.date_hit latest_hit FROM page_hits h WHERE (h.lead_id = 50184) AND (h.id <> 116067))”,“result”:false} []

[2022-04-11 22:44:45] 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”:“50184”,“0”:“https://dtnetwork.com.br/%",“second_to_last”:“116067”},“sq”:"[object] (Doctrine\DBAL\Query\QueryBuilder: SELECT h.date_hit latest_hit FROM page_hits h WHERE (h.lead_id = 50184) AND (h.id <> 116067))”,“result”:false} []

[2022-04-11 22:44:51] 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”:“50185”,“0”:“https://dtnetwork.com.br/%",“second_to_last”:“116068”},“sq”:"[object] (Doctrine\DBAL\Query\QueryBuilder: SELECT h.date_hit latest_hit FROM page_hits h WHERE (h.lead_id = 50185) AND (h.id <> 116068))”,“result”:false} []

[2022-04-11 22:44:51] 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”:“50185”,“0”:“https://dtnetwork.com.br/%",“second_to_last”:“116068”},“sq”:"[object] (Doctrine\DBAL\Query\QueryBuilder: SELECT h.date_hit latest_hit FROM page_hits h WHERE (h.lead_id = 50185) AND (h.id <> 116068))”,“result”:false} []

[2022-04-11 22:45: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”:“50186”,“0”:“https://dtnetwork.com.br/%",“second_to_last”:“116069”},“sq”:"[object] (Doctrine\DBAL\Query\QueryBuilder: SELECT h.date_hit latest_hit FROM page_hits h WHERE (h.lead_id = 50186) AND (h.id <> 116069))”,“result”:false} []

[2022-04-11 22:45: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”:“50186”,“0”:“https://dtnetwork.com.br/%",“second_to_last”:“116069”},“sq”:"[object] (Doctrine\DBAL\Query\QueryBuilder: SELECT h.date_hit latest_hit FROM page_hits h WHERE (h.lead_id = 50186) AND (h.id <> 116069))”,“result”:false} []

[2022-04-11 22:48:05] 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”:“50187”,“0”:“https://dtnetwork.com.br/%",“second_to_last”:“116070”},“sq”:"[object] (Doctrine\DBAL\Query\QueryBuilder: SELECT h.date_hit latest_hit FROM page_hits h WHERE (h.lead_id = 50187) AND (h.id <> 116070))”,“result”:false} []

[2022-04-11 22:48:05] 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”:“50187”,“0”:“https://dtnetwork.com.br/%",“second_to_last”:“116070”},“sq”:"[object] (Doctrine\DBAL\Query\QueryBuilder: SELECT h.date_hit latest_hit FROM page_hits h WHERE (h.lead_id = 50187) AND (h.id <> 116070))”,“result”:false} []

[2022-04-11 22:48:08] 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”:“50188”,“0”:“https://dtnetwork.com.br/%",“second_to_last”:“116071”},“sq”:"[object] (Doctrine\DBAL\Query\QueryBuilder: SELECT h.date_hit latest_hit FROM page_hits h WHERE (h.lead_id = 50188) AND (h.id <> 116071))”,“result”:false} []

[2022-04-11 22:48:08] 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”:“50188”,“0”:“https://dtnetwork.com.br/%",“second_to_last”:“116071”},“sq”:"[object] (Doctrine\DBAL\Query\QueryBuilder: SELECT h.date_hit latest_hit FROM page_hits h WHERE (h.lead_id = 50188) AND (h.id <> 116071))”,“result”:false} []

[2022-04-11 22:48:10] mautic.ERROR: Segment QB: Query Exception: An exception occurred while executing ‘SELECT count(leadIdPrimary) count, max(leadIdPrimary) maxId, min(leadIdPrimary) minId FROM (SELECT DISTINCT l.id as leadIdPrimary, par1xp.lead_id AS par1xp_lead_id FROM leads l LEFT JOIN lead_lists_leads par1xp ON par1xp.lead_id = l.id and (par1xp.leadlist_id = 74) WHERE (l.date_identified = ?) AND (par1xp.lead_id IS NULL)) sss’ with params [“esta semana”]: SQLSTATE[HY000]: General error: 1525 Incorrect DATETIME value: ‘esta semana’ {“query”:“SELECT count(leadIdPrimary) count, max(leadIdPrimary) maxId, min(leadIdPrimary) minId FROM (SELECT DISTINCT l.id as leadIdPrimary, par1xp.lead_id AS par1xp_lead_id FROM leads l LEFT JOIN lead_lists_leads par1xp ON par1xp.lead_id = l.id and (par1xp.leadlist_id = 74) WHERE (l.date_identified = :par1xo) AND (par1xp.lead_id IS NULL)) sss”,“parameters”:{“par1xo”:“esta semana”}} []

[2022-04-11 22:48:10] mautic.NOTICE: Doctrine\DBAL\Exception\DriverException: An exception occurred while executing ‘SELECT count(leadIdPrimary) count, max(leadIdPrimary) maxId, min(leadIdPrimary) minId FROM (SELECT DISTINCT l.id as leadIdPrimary, par1xp.lead_id AS par1xp_lead_id FROM leads l LEFT JOIN lead_lists_leads par1xp ON par1xp.lead_id = l.id and (par1xp.leadlist_id = 74) WHERE (l.date_identified = ?) AND (par1xp.lead_id IS NULL)) sss’ with params [“esta semana”]: SQLSTATE[HY000]: General error: 1525 Incorrect DATETIME value: ‘esta semana’ (uncaught exception) at /var/www/html/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/AbstractMySQLDriver.php line 128 while running console command mautic:segments:update [] []

[2022-04-11 22:48:10] mautic.WARNING: Command mautic:segments:update exited with status code 1 [] []

[2022-04-11 22:50:07] 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”:“50191”,“0”:“https://dtnetwork.com.br/%",“second_to_last”:“116075”},“sq”:"[object] (Doctrine\DBAL\Query\QueryBuilder: SELECT h.date_hit latest_hit FROM page_hits h WHERE (h.lead_id = 50191) AND (h.id <> 116075))”,“result”:false} []

[2022-04-11 22:50:07] 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”:“50191”,“0”:“https://dtnetwork.com.br/%",“second_to_last”:“116075”},“sq”:"[object] (Doctrine\DBAL\Query\QueryBuilder: SELECT h.date_hit latest_hit FROM page_hits h WHERE (h.lead_id = 50191) AND (h.id <> 116075))”,“result”:false} []

[2022-04-11 22:50:13] 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”:“50192”,“0”:“https://dtnetwork.com.br/%",“second_to_last”:“116076”},“sq”:"[object] (Doctrine\DBAL\Query\QueryBuilder: SELECT h.date_hit latest_hit FROM page_hits h WHERE (h.lead_id = 50192) AND (h.id <> 116076))”,“result”:false} []

[2022-04-11 22:50:13] 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”:“50192”,“0”:“https://dtnetwork.com.br/%",“second_to_last”:“116076”},“sq”:"[object] (Doctrine\DBAL\Query\QueryBuilder: SELECT h.date_hit latest_hit FROM page_hits h WHERE (h.lead_id = 50192) AND (h.id <> 116076))”,“result”:false} []

[2022-04-11 22:50:49] 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”:“50193”,“0”:“https://dtnetwork.com.br/%",“second_to_last”:“116077”},“sq”:"[object] (Doctrine\DBAL\Query\QueryBuilder: SELECT h.date_hit latest_hit FROM page_hits h WHERE (h.lead_id = 50193) AND (h.id <> 116077))”,“result”:false} []

[2022-04-11 22:50:49] 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”:“50193”,“0”:“https://dtnetwork.com.br/%",“second_to_last”:“116077”},“sq”:"[object] (Doctrine\DBAL\Query\QueryBuilder: SELECT h.date_hit latest_hit FROM page_hits h WHERE (h.lead_id = 50193) AND (h.id <> 116077))”,“result”:false} []

1 Like

Qual segmento e este? Qual filtro?
O log e recente ou e de antes de atualizar o banco?

2 Likes

Bom dia, o log é recente, após eu mudar para português e limpar o cachê com o comando mtc-cache esse erro parou, mas agora estou com outro erro, acabei de publicar como um novo tópico, seria bom se tivesse a categoria, Erros e logs

2 Likes