Keyword

User Error Joomla! 500 - An error has occurred. Unknown co

  • John Vincent
  • John Vincent's Avatar Topic Author
  • Offline
  • Senior Member
More
9 years 2 months ago #136614 by John Vincent
Hi,

I am not sure if this is related to K2 but I have imported all my users from Joomla. In the Joomla User control panel when I try to sort or save the users i get the error below. But I can access the users if I go to K2 > users

Any ideas on whats going on or link to a solution would be great

Thanks

John

500 - An error has occurred.

Unknown column 'a.usertype' in 'group statement' SQL=SELECT a.* FROM `j25_users` AS a LEFT JOIN j25_user_usergroup_map AS map2 ON map2.user_id = a.id WHERE map2.group_id = 8 AND (a.name LIKE '%%' OR a.username LIKE '%%' OR a.email LIKE '%%') GROUP BY a.id,a.name,a.username,a.password,a.usertype,a.block,a.sendEmail,a.registerDate,a.lastvisitDate,a.activation,a.params,a.email ORDER BY a.name asc Unknown column 'a.usertype' in 'group statement' SQL=SELECT a.* FROM `j25_users` AS a LEFT JOIN j25_user_usergroup_map AS map2 ON map2.user_id = a.id WHERE map2.group_id = 8 AND (a.name LIKE '%%' OR a.username LIKE '%%' OR a.email LIKE '%%') GROUP BY a.id,a.name,a.username,a.password,a.usertype,a.block,a.sendEmail,a.registerDate,a.lastvisitDate,a.activation,a.params,a.email ORDER BY a.name asc LIMIT 0, 20 Unknown column 'a.usertype' in 'group statement' SQL=SELECT a.* FROM `j25_users` AS a LEFT JOIN j25_user_usergroup_map AS map2 ON map2.user_id = a.id WHERE map2.group_id = 8 AND (a.name LIKE '%%' OR a.username LIKE '%%' OR a.email LIKE '%%') GROUP BY a.id,a.name,a.username,a.password,a.usertype,a.block,a.sendEmail,a.registerDate,a.lastvisitDate,a.activation,a.params,a.email ORDER BY a.name asc

Return to Control Panel

Please Log in or Create an account to join the conversation.

  • Krikor Boghossian
  • Krikor Boghossian's Avatar
  • Offline
  • Platinum Member
More
9 years 2 months ago #136615 by Krikor Boghossian
Replied by Krikor Boghossian on topic User Error Joomla! 500 - An error has occurred. Unknown co
Hello John, this is a core Joomla! issue, it is unrelated to K2.

JoomlaWorks Support Team
---
Please search the forum before posting a new topic :)

Please Log in or Create an account to join the conversation.

  • John Vincent
  • John Vincent's Avatar Topic Author
  • Offline
  • Senior Member
More
9 years 2 months ago #136616 by John Vincent
Thanks for the reply. I'll check the joomla forums

Please Log in or Create an account to join the conversation.

  • Krikor Boghossian
  • Krikor Boghossian's Avatar
  • Offline
  • Platinum Member
More
9 years 2 months ago #136618 by Krikor Boghossian
Replied by Krikor Boghossian on topic User Error Joomla! 500 - An error has occurred. Unknown co
You 're welcome and good luck :)

JoomlaWorks Support Team
---
Please search the forum before posting a new topic :)

Please Log in or Create an account to join the conversation.


Powered by Kunena Forum