Wappler Version : 5.2.0
Operating System : Windows 11
Server Model: Linux Centos
Database Type: Mariadb
Hosting Type: Dedied
What do you think should happen?
hello there is a problem concerning the email addresses with dashes, I systematically encounter an error
{“code”:0,“file”:“/var/www/vhosts/paritys.com/sousdomaines/automation/dmxConnectLib/PHPMailer/PHPMailer/PHPMailer.php”,“line”:1092,“message”:"Invalid address: (to): “,“trace”:”#0
example : test@test-test.com
In order to show the exact error returned by the SMTP server please do so:
Open the following file in your site root:
/dmxConnectLib/PHPMailer/PHPMailer/PHPMailer.php
and edit line 401 from:
public $SMTPDebug = 1;
to
public $SMTPDebug = 3;
save the file and try sending the mail once again. You will see more detailed error in the console - please paste it here.
Try it again using a real email address that’s working - I’ve had similar issues when testing out using a non-working made-up email. If that fixes the issue then you need to handle that non working email address error in your code.
Invalid address: (to): <br>
Thank you, in fact I have a real address just I can’t put it in the post ^^
I need the WHOLE message that appears in the dev tools.
Invalid address: (to): <br>
{"code":0,"file":"\/var\/www\/vhosts\/paritys.com\/sousdomaines\/automation\/dmxConnectLib\/PHPMailer\/PHPMailer\/PHPMailer.php","line":1092,"message":"Invalid address: (to): ","trace":"#0 \/var\/www\/vhosts\/paritys.com\/sousdomaines\/automation\/dmxConnectLib\/PHPMailer\/PHPMailer\/PHPMailer.php(1014): PHPMailer\\PHPMailer\\PHPMailer->addOrEnqueueAnAddress()\n#1 \/var\/www\/vhosts\/paritys.com\/sousdomaines\/automation\/dmxConnectLib\/modules\/mail.php(84): PHPMailer\\PHPMailer\\PHPMailer->addAddress()\n#2 \/var\/www\/vhosts\/paritys.com\/sousdomaines\/automation\/dmxConnectLib\/lib\/App.php(197): modules\\mail->send()\n#3 \/var\/www\/vhosts\/paritys.com\/sousdomaines\/automation\/dmxConnectLib\/lib\/App.php(169): lib\\App->execSteps()\n#4 \/var\/www\/vhosts\/paritys.com\/sousdomaines\/automation\/dmxConnectLib\/lib\/App.php(137): lib\\App->execSteps()\n#5 \/var\/www\/vhosts\/paritys.com\/sousdomaines\/automation\/dmxConnectLib\/modules\/core.php(99): lib\\App->exec()\n#6 \/var\/www\/vhosts\/paritys.com\/sousdomaines\/automation\/dmxConnectLib\/lib\/App.php(197): modules\\core->condition()\n#7 \/var\/www\/vhosts\/paritys.com\/sousdomaines\/automation\/dmxConnectLib\/lib\/App.php(169): lib\\App->execSteps()\n#8 \/var\/www\/vhosts\/paritys.com\/sousdomaines\/automation\/dmxConnectLib\/lib\/App.php(137): lib\\App->execSteps()\n#9 \/var\/www\/vhosts\/paritys.com\/sousdomaines\/automation\/dmxConnectLib\/modules\/core.php(97): lib\\App->exec()\n#10 \/var\/www\/vhosts\/paritys.com\/sousdomaines\/automation\/dmxConnectLib\/lib\/App.php(197): modules\\core->condition()\n#11 \/var\/www\/vhosts\/paritys.com\/sousdomaines\/automation\/dmxConnectLib\/lib\/App.php(169): lib\\App->execSteps()\n#12 \/var\/www\/vhosts\/paritys.com\/sousdomaines\/automation\/dmxConnectLib\/lib\/App.php(137): lib\\App->execSteps()\n#13 \/var\/www\/vhosts\/paritys.com\/sousdomaines\/automation\/dmxConnectLib\/modules\/core.php(69): lib\\App->exec()\n#14 \/var\/www\/vhosts\/paritys.com\/sousdomaines\/automation\/dmxConnectLib\/lib\/App.php(197): modules\\core->repeat()\n#15 \/var\/www\/vhosts\/paritys.com\/sousdomaines\/automation\/dmxConnectLib\/lib\/App.php(169): lib\\App->execSteps()\n#16 \/var\/www\/vhosts\/paritys.com\/sousdomaines\/automation\/dmxConnectLib\/lib\/App.php(137): lib\\App->execSteps()\n#17 \/var\/www\/vhosts\/paritys.com\/sousdomaines\/automation\/dmxConnectLib\/lib\/App.php(126): lib\\App->exec()\n#18 \/var\/www\/vhosts\/paritys.com\/sousdomaines\/automation\/dmxConnectLib\/lib\/App.php(104): lib\\App->exec()\n#19 \/var\/www\/vhosts\/paritys.com\/sousdomaines\/automation\/dmxConnect\/api\/Generation_Factures_PDF\/Generation\/Api_GrabzIT.php(8): lib\\App->define()\n#20 {main}"}I don’t think you’ve done what i described in my post.
line 402 not 401
Not sure which file are you editing:
But as i explained you need to edit the following file and upload it to your server:
This is my FTP the software created a file locally when editing
Open the file in Wappler, edit it, save it and upload it your server after that.
So what expression exactly are you using for the TO mail option in the send mail step?
"else": {
"steps": [
{
"name": "",
"module": "mail",
"action": "send",
"options": {
"instance": "Mail_Generation_Factures_PDF",
"subject": "{{'Facture n°'+query[0].E_NumeroFacture}}",
"fromName": "Maison Paritys",
"fromEmail": "noreply@paritys.com",
"toName": "{{query2[0].C_Nom}}",
"toEmail": "{{query2[0].C_Email}}",
"body": "<p><br></p><p>Cher Madame / Monsieur {{query2[0].C_Nom}}<br><br><br>\nNous vous remercions infiniment pour votre commande passée il y a quelques jours.<br><br>\nPar cet email nous vous envoyons votre facture relative aux produits expédiés de la commande {{query[0].E_Id}}.<br><br>\nConcernant l’expédition de votre colis vous pouvez cliquer sur le lien : <a href=\"https://trace.dpd.fr/tracer_{{query[0].E_NumeroBon}}_09240777\">https://trace.dpd.fr/tracer_{{query[0].E_NumeroBon}}_09240777</a>\n et suivre ainsi l’acheminement de votre commande.<br><br>\nSi vous avez la moindre question n’hésitez surtout pas à nous contacter via l’adresse email : <a href=\"mailto:commercial@paritys.com\">commercial@paritys.com</a> ; nous sommes à votre entière disposition.<br><br><br>\nAttention : Vous ne recevrez plus de facture par papier.<br><br><br>\nNous vous souhaitons une Merveilleuse Journée et nous vous remercions à nouveau pour votre fidélité.<br><br><br>\nBien à vous,<br>\nMaison Paritys<br>\nDepuis 1946<br><br></p><p class=\"MsoNormal\">Retrouvez l’ensemble de nos collections sur notre site <a href=\"https://www.paritys.com\">https://www.paritys.com</a> et commandez directement en ligne 24h/24. Nous serons heureux de vous guider pas à pas, donc n’hésitez pas à nous contacter !</p>\n<img class=\"fit-picture\"\n src=\"https://automation.paritys.com/assets/images/MailSignature.jpg\"\n alt=\"Paritys\">",
"attachments": [
"{{'/datas/generations/generation_factures_pdf/factures/'+query[0].CF_CodeClient+'/'+fichier}}"
],
"recipientType": "extended",
"contentType": "html",
"cc": "morgan.forges@paritys.com"
},
"output": true
},Hi, looks like the {{query2[0].C_Email}} is empty.
Try to creating a Set Value after Database Query “query2” with same value of the To Email:
Database Query: query2
Set Value test_email = {{query2[0].C_Email}} ->output
And Disable your last condition.
Now test and see if test_email in DevTool with XHR has some output, if is empty that means the problem is the query it self.
Thank you indeed I was missing a condition that checks if the email address exists before sending
Thank you all