• Welcome to XF2 Addons. You can buy my Premium membership for $35 per year, and this gives you access to download any or ALL of the 335 add-ons that I have developed for Xenforo 2.x. In addition, Premium members will get technical support. Once the Premium membership has expired you can continue to use the installed addons on your forum as long as you like.

Email Subscription Error


I'm receiving the following error on one specific page when any users posts. For now I disabled the addon but here is the page that was generating it.

  • XF\Db\Exception: MySQL query error [1366]: Incorrect string value: '\xF0\x9F\x98\x80 -...' for column 'email_subject' at row 1
  • src/XF/Db/AbstractStatement.php:212
  • Generated by: clackey
  • Apr 24, 2018 at 1:50 PM
Stack trace
INSERT INTO xf_andy_email_log
(email_date, email_address, email_subject)


#0 src/XF/Db/Mysqli/Statement.php(196): XF\Db\AbstractStatement->getException('MySQL query err...', 1366, '22007')
#1 src/XF/Db/Mysqli/Statement.php(77): XF\Db\Mysqli\Statement->getException('MySQL query err...', 1366, '22007')
#2 src/XF/Db/AbstractAdapter.php(79): XF\Db\Mysqli\Statement->execute()
#3 src/addons/Andy/EmailLog/XF/Mail/Queue.php(33): XF\Db\AbstractAdapter->query('\n\t\t\tINSERT INTO...', Array)
#4 src/XF/Mail/Mailer.php(310): Andy\EmailLog\XF\Mail\Queue->queue(Object(Swift_Message))
#5 src/XF/Mail/Mail.php(352): XF\Mail\Mailer->queue(Object(Swift_Message))
#6 src/XF/Notifier/Post/AbstractWatch.php(128): XF\Mail\Mail->queue()
#7 src/XF/Service/AbstractNotifier.php(92): XF\Notifier\Post\AbstractWatch->sendEmail(Object(Siropu\AdsManager\XF\Entity\User))
#8 src/XF/Service/AbstractNotifier.php(44): XF\Service\AbstractNotifier->notifyType(Object(XF\Notifier\Post\ThreadWatch), Array, 1524595813.3351)
#9 src/XF/Service/AbstractNotifier.php(56): XF\Service\AbstractNotifier->notify(3)
#10 src/XF/Service/Thread/Replier.php(199): XF\Service\AbstractNotifier->notifyAndEnqueue(3)
#11 src/XF/Pub/Controller/Thread.php(300): XF\Service\Thread\Replier->sendNotifications()
#12 src/XF/Pub/Controller/Thread.php(433): XF\Pub\Controller\Thread->finalizeThreadReply(Object(XF\Service\Thread\Replier))
#13 src/XF/Mvc/Dispatcher.php(249): XF\Pub\Controller\Thread->actionAddReply(Object(XF\Mvc\ParameterBag))
#14 src/XF/Mvc/Dispatcher.php(88): XF\Mvc\Dispatcher->dispatchClass('XF:Thread', 'AddReply', 'json', Object(XF\Mvc\ParameterBag), 'forums', Object(XFMG\XF\Pub\Controller\Thread), NULL)
#15 src/XF/Mvc/Dispatcher.php(41): XF\Mvc\Dispatcher->dispatchLoop(Object(XF\Mvc\RouteMatch))
#16 src/XF/App.php(1891): XF\Mvc\Dispatcher->run()
#17 src/XF.php(328): XF\App->run()
#18 index.php(13): XF::runApp('XF\\Pub\\App')
#19 {main}
Similar threads
Thread starter Title Forum Replies Date
D Edit cron entry: Email subscription General 3
BassMan [suggestion] Email Subscription General 1
X Email subscription General 0
X Email subscription General 1
C Email Subscription Doesn't Check "Receive Site Mailings" General 6
I Email subscription, problem with "Guest" subscriptions General 4
I Email subscription 1.2 problem General 4
D Email Subscription Link missing General 5
BassMan Email subscription General 2
BassMan Email Subscription General 0
Andy High resolution email logo General 0
Andy Email deliverability Server Information 4
B Suggestion for First post email General 1
Tourmeister Email Bounce Log reset General 1
Tourmeister Email list generator for exporting General 2
D [Request] Add Option for Auto delete email confirm General 7
F Background in Register email General 0
X Suggestion new Add-on to Send Email General 0
L Register Email General 1
D Auto delete email confirm: Questions General 2
Andy Bulk email postmaster notification Server Information 0
M Register email: possible bug General 2
BassMan Register Email - server error General 3
V Register Email Not finding staff General 7
I Register Email General 1
C Email Subscriptions Link General 3
P New feature request for new thread email admin 1.2 needs General 1
M Editing the email in User upgrade reminder General 2
T User Tag email not working General 14
T Canā€™t get weekly digest test email working General 12
B New thread email admin on specific forums General 3
B Register Email 1.4 not sending mail General 6
P User tag email 1.2 is not working on my forum General 6
Andy Default email transport method General 3
BassMan Register email General 12
N Register email General 1
S Error Logs General 6
Andy Touch(): Unable to create file - error message General 0
Tourmeister Error in Convertimageall General 11
mkucuksari Bump Limit Addon Error General 2
N Similar threads error General 2
D Convert Image All Error General 3
BassMan [Quick Search] Console error General 1
D Featured Post Error? General 1
P rotate_imagemagick_pecl_extension_not_enabled error on Rotate add-on General 2
N Error in ConvertImageAll General 8
N Yet Another Header Thumbs Error General 3
N Change Limit Error General 1
N Resize error generated General 1

Similar threads