Response Time
24 — 48 hours
/administrator/index.php?option=com_easyblog&view=bloggers
An error has occurred.
1054 Unknown column 'a.usertype' in 'order clause' SQL=select count( p.id ) as `totalPost`, COUNT( DISTINCT(g.content_id) ) as `featured`, a.* from `i9r7q_users` as a left join `i9r7q_easyblog_post` as p on a.`id` = p.`created_by` and `p`.`published` = '1' and p.`state` = '0' left join `i9r7q_easyblog_featured` AS `g` ON a.`id`= g.`content_id` AND g.`type`= 'blogger' where (1 <= (select count(1) from `i9r7q_easyblog_acl_group` as ag inner join `i9r7q_easyblog_acl` as acl on ag.`acl_id` = acl.`id` inner join `i9r7q_user_usergroup_map` as up on ag.`content_id` = up.`group_id` where up.`user_id` = `a`.`id` and acl.`action` = 'add_entry' and ag.`type` = 'group' and ag.`status` = 1)) group by a.`id`ORDER BY a.usertype asc
This doesn't seem to affect any other part of the site.
This occured on 3.9.x series, I upgraded to 5.x. series error still there.
Thanks
Rowan
An error has occurred.
1054 Unknown column 'a.usertype' in 'order clause' SQL=select count( p.id ) as `totalPost`, COUNT( DISTINCT(g.content_id) ) as `featured`, a.* from `i9r7q_users` as a left join `i9r7q_easyblog_post` as p on a.`id` = p.`created_by` and `p`.`published` = '1' and p.`state` = '0' left join `i9r7q_easyblog_featured` AS `g` ON a.`id`= g.`content_id` AND g.`type`= 'blogger' where (1 <= (select count(1) from `i9r7q_easyblog_acl_group` as ag inner join `i9r7q_easyblog_acl` as acl on ag.`acl_id` = acl.`id` inner join `i9r7q_user_usergroup_map` as up on ag.`content_id` = up.`group_id` where up.`user_id` = `a`.`id` and acl.`action` = 'add_entry' and ag.`type` = 'group' and ag.`status` = 1)) group by a.`id`ORDER BY a.usertype asc
This doesn't seem to affect any other part of the site.
This occured on 3.9.x series, I upgraded to 5.x. series error still there.
Thanks
Rowan
5 Replies
The replies under this section are restricted to logged in users or users with an active subscription with us
