1. 

   cedetafa, Member

   I made some reports with form for sending email. Everything worked, till I moved the whole structure from our test server to the destination one. I copied the complete code and settings from all reports working together. But the email-subject and the email-body is empty. I copied it back to the test server and it works there.
2. 

   myDBR Team, Key Master

   Hi,
   you can use the mail-debug-option to see what is being sent to the mail server.

   Also you can compare the report output in test and production server via the export as SQL option (or add &export=sql to the URL).

   --
   myDBR Team
3. 

   cedetafa, Member

   I switched the debug on, but how do I get the informations from it?
4. 

   myDBR Team, Key Master

   When you use the

   select 'dbr.mail.debug', 1;

   you will see the calls between myDBR and your mail server. You can take a look if you report actually sends any data to the mail server. Compare the output between the test and production servers.

   --
   myDBR Team
5. 

   cedetafa, Member

   2018-06-21 10:41:53 CLIENT -> SERVER: DATA
   2018-06-21 10:41:53 CLIENT -> SERVER: Date: Thu, 21 Jun 2018 12:41:53 +0200
   ...
   2018-06-21 10:41:53 CLIENT -> SERVER: Subject:
   ...
   2018-06-21 10:41:53 CLIENT -> SERVER: X-Mailer: PHPMailer 5.2.25 (https://github.com/PHPMailer/PHPMailer)
   2018-06-21 10:41:53 CLIENT -> SERVER: MIME-Version: 1.0
   2018-06-21 10:41:53 CLIENT -> SERVER: Content-Type: text/plain; charset=UTF-8
   2018-06-21 10:41:53 CLIENT -> SERVER:
   2018-06-21 10:41:53 CLIENT -> SERVER:
   2018-06-21 10:41:53 CLIENT -> SERVER:
   2018-06-21 10:41:53 CLIENT -> SERVER: .
   2018-06-21 10:41:54 CLIENT -> SERVER: RSET
   2018-06-21 10:41:54 CLIENT -> SERVER: QUIT
6. 

   myDBR Team, Key Master

   OK,
   looks like your production server report does not return any data.

   Run the report with '&export=sql' added to the URL. This way you will see the data that is being generated when the report is being run. The export=sql flag tells myDBR to show the data as SQL, but not to execute it.

   --
   myDBR Team

Reply

You must log in to post.