truonglv
Well-known member
It depends on group privacy.Can guests see forum posts?
It depends on group privacy.Can guests see forum posts?
Server error log
ErrorException: [E_USER_WARNING] Accessed unknown getter 'user_id' on Truonglv\Groups:Group[1] src/XF/Mvc/Entity/Entity.php:209
Generated by: admin Jan 21, 2023 at 2:06 PM
Stack trace
#0 [internal function]: XF::handlePhpError(512, '[E_USER_WARNING...', '/home/nginx/dom...', 209)
#1 src/XF/Mvc/Entity/Entity.php(209): trigger_error('Accessed unknow...', 512)
#2 src/XF/Mvc/Entity/Entity.php(119): XF\Mvc\Entity\Entity->get('user_id')
#3 src/addons/xenbros/Attachmentpro/XF/Entity/Attachment.php(18): XF\Mvc\Entity\Entity->__get('user_id')
#4 src/addons/DC/AdvancedDownload/XF/Pub/Controller/Attachment.php(30): xenbros\Attachmentpro\XF\Entity\Attachment->canView(NULL)
#5 src/addons/SV/AttachmentImprovements/XF/Pub/Controller/Attachment.php(25): DC\AdvancedDownload\XF\Pub\Controller\Attachment->actionIndex(Object(XF\Mvc\ParameterBag))
#6 src/XF/Mvc/Dispatcher.php(352): SV\AttachmentImprovements\XF\Pub\Controller\Attachment->actionIndex(Object(XF\Mvc\ParameterBag))
#7 src/XF/Mvc/Dispatcher.php(259): XF\Mvc\Dispatcher->dispatchClass('XF:Attachment', 'Index', Object(XF\Mvc\RouteMatch), Object(SV\AttachmentImprovements\XF\Pub\Controller\Attachment), NULL)
#8 src/XF/Mvc/Dispatcher.php(115): XF\Mvc\Dispatcher->dispatchFromMatch(Object(XF\Mvc\RouteMatch), Object(SV\AttachmentImprovements\XF\Pub\Controller\Attachment), NULL)
#9 src/XF/Mvc/Dispatcher.php(57): XF\Mvc\Dispatcher->dispatchLoop(Object(XF\Mvc\RouteMatch))
#10 src/XF/App.php(2483): XF\Mvc\Dispatcher->run()
#11 src/XF.php(524): XF\App->run()
#12 index.php(20): XF::runApp('XF\\Pub\\App')
#13 {main}
Request state
array(4) {
["url"] => string(40) "/attachments/2023-01-21_13-51-07-png.294"
["referrer"] => bool(false)
["_GET"] => array(1) {
["/attachments/2023-01-21_13-51-07-png_294"] => string(0) ""
}
["_POST"] => array(0) {
}
}
Notable changes:
- Refactor group notifications.
- Added whats new group posts
- Improvement display groups
Notable changes:
- Fixed query invalid column.
Sorry for insisting but the event is a bit close. There is any way to know the numer (and username) of ongoing people?Hello! When an event of a group have more than 10 assistants, the widget only show the avatar of 10 of them, and the admin of the group, and also me, we can't know the full list of the members that set to participate to the event.
How can we increase the maximum of the targets that the widget of the event assistants shows?
Thanks
In the event detail page you can filter them by ongoing type.Sorry for insisting but the event is a bit close. There is any way to know the numer (and username) of ongoing people?
Thx
Yes but it only shows 10 users, and there are 13 people ongoing. We can't know who are the other 3 members that go to the event.In the event detail page you can filter them by ongoing type.
XF\Db\Exception: MySQL statement prepare error [1054]: Unknown column 'view.user_id' in 'on clause' src/XF/Db/AbstractStatement.php:230
Generated by: LittleJohn Mar 9, 2023 at 2:37 PM
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`.`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` >= 1676259441
------------
#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(2353): 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(26) "/group-posts/20586/comment"
["referrer"] => string(40) "https://*****/group-posts/20586/"
["_GET"] => array(1) {
["/group-posts/20586/comment"] => string(0) ""
}
["_POST"] => array(10) {
["_xfToken"] => string(8) "********"
["message_html"] => string(59) "<p>nice 😂</p>"
["attachment_hash"] => string(32) "aed3944857b2c3ada453da2cbf010ab6"
["attachment_hash_combined"] => string(95) "{"type":"tl_group_comment","context":{"group_id":14},"hash":"aed3944857b2c3ada453da2cbf010ab6"}"
["last_date"] => string(1) "0"
["last_known_date"] => string(1) "0"
["load_extra"] => string(1) "1"
["_xfRequestUri"] => string(19) "/group-posts/20586/"
["_xfWithData"] => string(1) "1"
["_xfResponseType"] => string(4) "json"
}
}
It was fixed now. Thank you.Hi @truonglv so you have any idea what would cause this error? It's thrown since the last upgrade was installed.
Code:XF\Db\Exception: MySQL statement prepare error [1054]: Unknown column 'view.user_id' in 'on clause' src/XF/Db/AbstractStatement.php:230 Generated by: LittleJohn Mar 9, 2023 at 2:37 PM 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`.`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` >= 1676259441 ------------ #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(2353): 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(26) "/group-posts/20586/comment" ["referrer"] => string(40) "https://*****/group-posts/20586/" ["_GET"] => array(1) { ["/group-posts/20586/comment"] => string(0) "" } ["_POST"] => array(10) { ["_xfToken"] => string(8) "********" ["message_html"] => string(59) "<p>nice 😂</p>" ["attachment_hash"] => string(32) "aed3944857b2c3ada453da2cbf010ab6" ["attachment_hash_combined"] => string(95) "{"type":"tl_group_comment","context":{"group_id":14},"hash":"aed3944857b2c3ada453da2cbf010ab6"}" ["last_date"] => string(1) "0" ["last_known_date"] => string(1) "0" ["load_extra"] => string(1) "1" ["_xfRequestUri"] => string(19) "/group-posts/20586/" ["_xfWithData"] => string(1) "1" ["_xfResponseType"] => string(4) "json" } }
Sorry but I really need to know the ongoing peopleYes but it only shows 10 users, and there are 13 people ongoing. We can't know who are the other 3 members that go to the event.
I think we need increase the "maximum ongoing members in event card", like the similar option I upload in image in this post:
View attachment 282672
The problem is:
View attachment 282673
It was fixed in next release.Sorry but I really need to know the ongoing people
ThanksIt was fixed in next release.
Notable changes:
- Improvement display event guests
- Allow increase attach files into resources
- Improvement display files in resource.
- Fixed some errors.
We use essential cookies to make this site work, and optional cookies to enhance your experience.