I’ve only used the query on smaller sets of data, nothing “huge” yet. So if you have a huge dataset to test it on, please let everyone know your results!

I’ve tried and it’s working really fine.

Have you tried with a huge database ?

Cheers

I input the details into Outlook and into gmail and I could send emails just fine.

My code looked as follows:

$this->Email->template = 'activate';
$this->Email->sendAs = 'both';
$this->Email->smtpOptions = array(
   'port'=>$port,
   'timeout'=>'30',
   'host' => $host,
   'username'=>$username,
   'password'=>$password,
);
$this->Email->delivery = 'smtp';
$this->Email->send();

All standard if you look at the cookbook.
After desperately looking for a solution for about just as long as we looked for the problem with phpmailer I decided, why not. I changed the line

$this->Email->delivery = 'smtp';

to

$this->Email->delivery = 'SMTP';

and then BAM. It worked. So strange.

    case 'SMTP':
    case 'smtp':
        return $this->SmtpSend($header, $body);

      // Choose the mailer and send through it
      switch($this->Mailer) {
        case 'sendmail':
          return $this->SendmailSend($header, $body);
        case 'SMTP':
          return $this->SmtpSend($header, $body);
        case 'smtp':
          return $this->SmtpSend($header, $body);
        default:
          return $this->MailSend($header, $body);
      }

adding the SMTP in capital letters to be sure it goes through.
I also checked the system by echoing data from the SmtpSend() function to make sure that the system is indeed using SMTP and not mail() or sendmail().

So if then indeed the Mailer variable is never used other than internally than I am still left with no explanation as to why the smtp is now working, and why it was not working prior to the change. If anyone can give me more input it will really be appreciated.

In the meantime I will further investigate it myself.

that variable is for internal use only and it has to be lowercase ’smtp’ otherwise it will try and use the mail() method, which is probably why it ‘appears’ to work