Cotilleando
New Member
Please fix it asap
thanks
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`.`post_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` >= 1663400794
------------
#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}
thanks