mod_k2_users corrupts the database and generates this error. A 1 minute video screen grab is attached that shows when and how this happens. Please view it.
ERROR MESSAGE 1054 Unknown column 'juser.usertype' in 'order clause' SQL=SELECT juser.*, k2user.group, k2group.name as groupname FROM psg_users as juser LEFT JOIN psg_k2_users as k2user ON juser.id=k2user.userID LEFT JOIN psg_k2_user_groups as k2group ON k2user.group=k2group.id LEFT JOIN psg_user_usergroup_map as `map` ON juser.id=map.user_id WHERE juser.id>0 GROUP BY juser.id ORDER BY juser.usertype asc LIMIT 0, 100
This error is triggered when accessing the settings for "Retrieve Specific Users" on the back end of this module (K2 v2.6.7, J31, Php 5.3.x). When I sort the UserList by GROUP, this error is triggered and I can no longer access the user database via K2.
video would not upload, but here is an external link.
cloudserver2.com/k2-error.mp4
ERROR MESSAGE 1054 Unknown column 'juser.usertype' in 'order clause' SQL=SELECT juser.*, k2user.group, k2group.name as groupname FROM psg_users as juser LEFT JOIN psg_k2_users as k2user ON juser.id=k2user.userID LEFT JOIN psg_k2_user_groups as k2group ON k2user.group=k2group.id LEFT JOIN psg_user_usergroup_map as `map` ON juser.id=map.user_id WHERE juser.id>0 GROUP BY juser.id ORDER BY juser.usertype asc LIMIT 0, 100
This error is triggered when accessing the settings for "Retrieve Specific Users" on the back end of this module (K2 v2.6.7, J31, Php 5.3.x). When I sort the UserList by GROUP, this error is triggered and I can no longer access the user database via K2.
video would not upload, but here is an external link.
cloudserver2.com/k2-error.mp4