ferdinand
Customer
The following server error occurs when unsubscribe from all emails is selected on the summary email unsubscribe page. (Xenforo.com/email-stop/1/activity-summary?c=hash)
Code:
XF\Db\Exception: MySQL query error [1366]: Incorrect integer value: '' for column 'email_subscribe' at row 1 src/XF/Db/AbstractStatement.php:230
Generated by: Joshua Ferdinand Mar 30, 2024
Stack trace
UPDATE `xf_dbtech_usertagging_hash_watch` SET `email_subscribe` = ? WHERE user_id = ?
------------
#0 src/XF/Db/Mysqli/Statement.php(198): XF\Db\AbstractStatement->getException('MySQL query err...', 1366, 'HY000')
#1 src/XF/Db/Mysqli/Statement.php(79): XF\Db\Mysqli\Statement->getException('MySQL query err...', 1366, 'HY000')
#2 src/XF/Db/AbstractAdapter.php(96): XF\Db\Mysqli\Statement->execute()
#3 src/XF/Db/AbstractAdapter.php(324): XF\Db\AbstractAdapter->query('UPDATE `xf_dbt...', Array)
#4 src/addons/DBTech/UserTagging/Repository/HashWatch.php(150): XF\Db\AbstractAdapter->update('xf_dbtech_usert...', Array, 'user_id = ?', 1)
#5 src/addons/DBTech/UserTagging/EmailStop/Hash.php(72): DBTech\UserTagging\Repository\HashWatch->setWatchStateForAll(Object(OzzModz\ProfilePostPreReg\XF\Entity\User), 'update', Array)
#6 src/XF/Service/User/EmailStop.php(223): DBTech\UserTagging\EmailStop\Hash->stopAll(Object(OzzModz\ProfilePostPreReg\XF\Entity\User))
#7 src/XF/Service/User/EmailStop.php(206): XF\Service\User\EmailStop->stopContent('dbtech_usertagg...')
#8 src/XF/Service/User/EmailStop.php(163): XF\Service\User\EmailStop->stopAllContent()
#9 src/XF/Service/User/EmailStop.php(124): XF\Service\User\EmailStop->stopAll()
#10 src/XF/Pub/Controller/EmailStop.php(21): XF\Service\User\EmailStop->stop('all')
#11 src/XF/Mvc/Dispatcher.php(352): XF\Pub\Controller\EmailStop->actionIndex(Object(XF\Mvc\ParameterBag))
#12 src/XF/Mvc/Dispatcher.php(259): XF\Mvc\Dispatcher->dispatchClass('XF:EmailStop', 'Index', Object(XF\Mvc\RouteMatch), Object(XF\Pub\Controller\EmailStop), NULL)
#13 src/XF/Mvc/Dispatcher.php(115): XF\Mvc\Dispatcher->dispatchFromMatch(Object(XF\Mvc\RouteMatch), Object(XF\Pub\Controller\EmailStop), NULL)
#14 src/XF/Mvc/Dispatcher.php(57): XF\Mvc\Dispatcher->dispatchLoop(Object(XF\Mvc\RouteMatch))
#15 src/XF/App.php(2487): XF\Mvc\Dispatcher->run()
#16 src/XF.php(524): XF\App->run()
#17 index.php(20): XF::runApp('XF\\Pub\\App')
#18 {main}
Request state
array(4) {
["url"] => string(49) "/email-stop/1/?c=5eb8befbd481f030a0b96516d807a769"
["referrer"] => string(91) "https://atomicacademia.com/email-stop/1/activity-summary?c=5eb8befbd481f030a0b96516d807a769"
["_GET"] => array(1) {
["c"] => string(32) "5eb8befbd481f030a0b96516d807a769"
}
["_POST"] => array(3) {
["_xfToken"] => string(8) "********"
["stop"] => string(3) "all"
["c"] => string(32) "5eb8befbd481f030a0b96516d807a769"
}
}