It looks like you're new here. If you want to get involved, click one of these buttons!
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.
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)
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.