Hi there,

I have replicated it locally, and it seems that all email are sent to the user. Maybe the emails still not sent out(sent to user), you can check whether those emails sent or not at Backend>Components>EasyBlog>Email Activities as shown https://screencast.com/t/Ag6RsN82Ax.

If there are emails in this section, it should working fine, and might be emails are not sent immediately after new blog post is posted as you might have disabled "Send emails on page load" at Backend>Components>EasyBlog>Settings>Notifications
but, if your site, got large number of user, i would advice you to setup cronjobs for your site.

If problems still persist, can you provide us with your backend and FTP access for further check on this issues? Please advice

Hi,

I have checked Backend > Components > EasyBlog > Email Activities and the only email address is the site admin.

"Send emails on page load" is enabled.

However, when I go to Posts and try to resend notifications, I get this error:

Error: 1253

COLLATION 'utf8_unicode_ci' is not valid for CHARACTER SET 'utf8mb4' SQL=insert into `#__easyblog_mailq` (`mailfrom`,`fromname`,`recipient`,`subject`,`created`,`status`,`template`,`data`,`param`) SELECT 'mark.hammond@key2.org.uk' as `mailfrom`,'Key2 Info' as `fromname`, x.`email` as `recipient`,'New blog post - Breaking through - moving...' as `subject`,'2017-02-13 11:02:25' as `created`, 0 as `status`, 'post.new' as `template`, '{\"blogTitle\":\"Breaking through - moving on from child sexual exploitation\",\"blogAuthor\":\"James Arimura\",\"blogAuthorAvatar\":\"http:\\/\\/http://www.key2info.org.uk\\/images\\/easyblog_avatar\\/827_IMG_2203.JPG\",\"blogAuthorLink\":\"http:\\/\\/www.key2info.org.uk\\/blogger\\/james-arimura\",\"blogAuthorEmail\":\"James.Arimura@key2.org.uk\",\"blogIntro\":\"<p dir=\\\"ltr\\\"><strong>Another video resource is now available providing valuable advice to young people, parents and support services on how previous victims of sexual exploitation have managed to move on.<\\/strong><\\/p>\\n<p><br>The short video can be watched via youtube <a href=\\\"https:\\/\\/http://www.youtube.com\\/watch?v=AItnP55q54c&feature=youtu.be\\\">here<\\/a>. To find out more about Child Sexual Exploitation, you can also go to the <a href=\\\"http:\\/\\/basisyorkshire.org.uk\\/\\\">website for Basis<\\/a>, an organisation that focuses on providing safety, information and support for those affected.<\\/p>\",\"blogContent\":\"\",\"blogCategory\":\"General\",\"blogLink\":\"http:\\/\\/http://www.key2info.org.uk\\/entry\\/general\\/breaking-through-moving-on-from-child-sexual-exploitation\",\"blogDate\":\"Friday, 10 February 2017\",\"blogCover\":\"http:\\/\\/http://www.key2info.org.uk\\/images\\/easyblog_articles\\/685\\/0a1a71655aadb328dd8d301b2d501cf9.png\"}' as `data`, concat('{"email":"', x.email, '","unsubscribe":"1"}') as `param` FROM (select a.`email` COLLATE utf8mb4_unicode_ci AS `email` from `#__users` as a where a.`block` = 0 and a.`id` NOT IN (17,124,833,850) UNION select a1.`email` COLLATE utf8_unicode_ci AS `email` FROM `#__easyblog_subscriptions` as a1 WHERE a1.`user_id` = '0') as x where x.email NOT IN ('James.Arimura@key2.org.uk','mark.hammond@key2.org.uk')

Hello David,

Is it possible for you to provide us with the back end and FTP access to your site to check on this issue? You may store your site access at http://stackideas.com/dashboard/site so you don't have to provide these information all the time

Thanks - I've done that now

Hi there,

It seems that i have been blocked from accessing your backend as shown https://screencast.com/t/oGeAH4VM8NFv. here are my IP address 60.52.64.224. Please advice.

Sorry, I had an Admin Tools IP blocker on. It should be fine now!

Hi there,

Sorry for the delay of this reply.

May i know whether you have update/upgrade your database as this 'utf8mb4_general_ci' is latest version of collations?
It seems that the issues is because your database using 'utf8mb4_general_ci' collations instead of 'utf8_unicode_ci', currently used by EasyBlog.

By the way, we have made some fixes on this path /administrator/components/com_easyblog/includes/easyblog.php. It should working fine now and this issues will be included on next release version.

Please give it a check and see how it goes .

Hi,

Sorry, I missed the notification of your reply. I looked in cpanel, and I have now set the collation to utf8_general_ci. Is that not correct, I set all my Joomla websites to this collation?

If I look in the backend in system information, I see:

Database Collation utf8_general_ci
Database Connection Collation: utf8mb4_general_ci

Is this ok?

Many thanks again,

Dave.

EDIT
Might this be because I had previously changed the database to UTF-8 multibyte using Admin Tools?

Hi David,

I am sorry for confusion above. Maybe i have not clearly explained it to you.

It is okay if you using its latest version or not as this collations is a new type and we haven't do any checking on that. By the way, we have done some fixes on your site, as stated above, and everything should works correctly. Please give it a check and see how it goes.