Get answers quicker by searching

Howdy, Stranger!

It looks like you're new here. If you want to get involved, click one of these buttons!

In this Discussion

Campaign sent to 0 recipients (Ubuntu & PHP 7)
  • Vote Up0Vote Down ZackZack
    Posts: 6Sendy user

    I updated to Ubuntu 16.04 LTS which ships with PHP7 by default. I reinstalled the typical necessary PHP7 modules (php7.0-mysql php7.0-xml libapache2-mod-php7.0 php7.0-curl and then phpenmod curl phpenmod xml phpenmod xmlreader phpenmod simplexml) and restored functionality to all my sites except for Sendy.

    When I send a campaign, no matter which list I choose, it will act as if it has sent the campaign instantly. When I view the report, it says it has sent the campaign to 0 recipients.

    I'm at a loss since I don't know what else I could be missing that could be causing this error. Any help is greatly appreciated.

  • 5 Comments
  • Vote Up0Vote Down BenBen
    Posts: 3,102Sendy support

    Sendy is tested and works on PHP 7.

    Can you please login to MySQL via SSH, then run select @@sql_mode; and let me know what's the result?

  • Vote Up0Vote Down ZackZack
    Posts: 6Sendy user

    Thank you so much for your help, Ben. Here's the MySQL response:

     +------------------------------------------------------------------------------------------+
     | @@sql_mode
     +------------------------------------------------------------------------------------------+
     | ONLY_FULL_GROUP_BY,STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,
       ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION
     +------------------------------------------------------------------------------------------+
     1 row in set (0.00 sec)
    
  • Vote Up0Vote Down BenBen
    Posts: 3,102Sendy support

    Can you please remove ONLY_FULL_GROUP_BY from the list?

  • Vote Up0Vote Down ZackZack
    Posts: 6Sendy user

    You are the man, Ben. Issue is resolved after removing ONLY_FULL_GROUP_BY from 'sql_mode'.

    Here's how I permanently removed ONLY_FULL_GROUP_BY from sql_mode if it will help anyone else:

    sudo nano /etc/mysql/mysql.conf.d/mysqld.cnf (location will vary, but this is where mine was)

    Paste the following at bottom of [mysqld] section

    sql_mode = "STRICT_TRANS_TABLES,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION"
    ^ Basically whatever sql_modes you wish to keep, making sure that ONLY_FULL_GROUP_BY is not in this list.

    Save and restart MySQL:

    sudo service mysql restart

    Thank you again for all your assistance! You rock.

  • Vote Up0Vote Down BenBen
    Posts: 3,102Sendy support

    Glad to hear you resolved it. :) Thanks for sharing.

This discussion has been closed.
All Discussions