Brettflan
Active Member
We recently updated to Social Groups 3.4.0, and today, this new error showed up in our error log for the first time:
Code:
XF\Db\Exception: MySQL statement prepare error [1054]: Unknown column 'group_post.event_id' in 'on clause' src/XF/Db/AbstractStatement.php:230
Stack trace
SELECT `post_watch`.`user_id`
FROM `xf_tl_group_post_watch` AS `post_watch`
LEFT JOIN `xf_user` AS `user`
ON (`user`.`user_id` = `post_watch`.`user_id`)
INNER JOIN `xf_tl_group_post` AS `group_post` ON (`group_post`.`event_id` = `post_watch`.`post_id`)
LEFT JOIN `xf_tl_group_member` AS `member` ON
(`member`.`user_id` = `post_watch`.`user_id` AND `member`.`group_id` = `group_post`.`group_id`)
LEFT JOIN `xf_tl_group_view` AS `group_view` ON
(`group_view`.`group_id` = `member`.`group_id` AND `view`.`user_id` = `member`.`user_id`)
WHERE `post_watch`.`post_id` = ?
AND `user`.`is_banned` = '0'
AND `user`.`user_state` = 'valid'
AND `group_view`.`view_date` >= 1662132689
------------
#0 src/XF/Db/Mysqli/Statement.php(198): XF\Db\AbstractStatement->getException('MySQL statement...', 1054, '42S22')
#1 src/XF/Db/Mysqli/Statement.php(41): XF\Db\Mysqli\Statement->getException('MySQL statement...', 1054, '42S22')
#2 src/XF/Db/Mysqli/Statement.php(56): XF\Db\Mysqli\Statement->prepare()
#3 src/XF/Db/AbstractAdapter.php(96): XF\Db\Mysqli\Statement->execute()
#4 src/XF/Db/AbstractAdapter.php(157): XF\Db\AbstractAdapter->query('
SE...', Array)
#5 src/addons/Truonglv/Groups/Notifier/Post/Watch.php(77): XF\Db\AbstractAdapter->fetchAll('
SE...', Array)
#6 src/XF/Service/AbstractNotifier.php(265): Truonglv\Groups\Notifier\Post\Watch->getDefaultNotifyData()
#7 src/XF/Service/AbstractNotifier.php(33): XF\Service\AbstractNotifier->ensureDataLoaded()
#8 src/XF/Service/AbstractNotifier.php(58): XF\Service\AbstractNotifier->notify(3)
#9 src/addons/Truonglv/Groups/Service/Comment/Creator.php(82): XF\Service\AbstractNotifier->notifyAndEnqueue(3)
#10 src/addons/Truonglv/Groups/ControllerPlugin/Comment.php(43): Truonglv\Groups\Service\Comment\Creator->sendNotifications()
#11 src/addons/Truonglv/Groups/Pub/Controller/Post.php(117): Truonglv\Groups\ControllerPlugin\Comment->actionComment(Object(Truonglv\Groups\Entity\Post), Object(Truonglv\Groups\Entity\Group))
#12 src/XF/Mvc/Dispatcher.php(352): Truonglv\Groups\Pub\Controller\Post->actionComment(Object(XF\Mvc\ParameterBag))
#13 src/XF/Mvc/Dispatcher.php(259): XF\Mvc\Dispatcher->dispatchClass('Truonglv\\Groups...', 'Comment', Object(XF\Mvc\RouteMatch), Object(Truonglv\Groups\Pub\Controller\Post), NULL)
#14 src/XF/Mvc/Dispatcher.php(115): XF\Mvc\Dispatcher->dispatchFromMatch(Object(XF\Mvc\RouteMatch), Object(Truonglv\Groups\Pub\Controller\Post), NULL)
#15 src/XF/Mvc/Dispatcher.php(57): XF\Mvc\Dispatcher->dispatchLoop(Object(XF\Mvc\RouteMatch))
#16 src/XF/App.php(2483): XF\Mvc\Dispatcher->run()
#17 src/XF.php(524): XF\App->run()
#18 index.php(20): XF::runApp('XF\\Pub\\App')
#19 {main}
Request state
array(4) {
["url"] => string(35) "/index.php?group-posts/1522/comment"
["referrer"] => string(73) "https://forums.taleworlds.com/index.php?groups/warband-winter-league.525/"
["_GET"] => array(1) {
["group-posts/1522/comment"] => string(0) ""
}
["_POST"] => array(8) {
["_xfToken"] => string(8) "********"
["message_html"] => string(68) "<p>why we keep playing same faction on open and close every week</p>"
["last_date"] => string(1) "0"
["last_known_date"] => string(1) "0"
["load_extra"] => string(1) "1"
["_xfRequestUri"] => string(44) "/index.php?groups/warband-winter-league.525/"
["_xfWithData"] => string(1) "1"
["_xfResponseType"] => string(4) "json"
}
}