Sendy Forum

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!

Sign In Apply for Membership

Categories

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,246Sendy 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,246Sendy 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 mysqld restart

    Thank you again for all your assistance! You rock.

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

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

This discussion has been closed.
All Discussions