Hallo,

The following Error i get when i call the USER in K2.

1054 Unknown column 'juser.usertype' in 'order clause' SQL=SELECT juser.*, k2user.group, k2group.name as groupname FROM s9afm_users as juser LEFT JOIN s9afm_k2_users as k2user ON juser.id=k2user.userID LEFT JOIN s9afm_k2_user_groups as k2group ON k2user.group=k2group.id LEFT JOIN s9afm_user_usergroup_map as `map` ON juser.id=map.user_id WHERE juser.id>0 GROUP BY juser.id ORDER BY juser.usertype asc

The site is working fine. Any idea how to fix that?

Thx for help.

Gerald

Hi,
Fixed it. Just by out and in login! (strange :-)

Thx

Hi,

get the same issue ... Login again doesn´t fix the issue ... it appears every time if you want to sort the k2 users by group ...

Regards
Marco

Hello Marco,

Did you update, install an extension or change anything?
Are you using any other extensions? This specific error might be caused by a 3rd party extension.