Hi,
I'm trying to replicate the OSTraining Custom Joomla User list.
I created User, User Group Map and Usergroups lists.
In the user list, added a db join from users to user_group_map table and that works fine displaying users and mapping to groups in the list.
Adding join from user_group_map table to usergroups table gives me this error:
500 SQL=ALTER TABLE `cla_users` ADD INDEX `fb_join_group_id_INDEX` (`group_id` )
Is this an issue of permissions or am I not doing something correctly?
John
I'm trying to replicate the OSTraining Custom Joomla User list.
I created User, User Group Map and Usergroups lists.
In the user list, added a db join from users to user_group_map table and that works fine displaying users and mapping to groups in the list.
Adding join from user_group_map table to usergroups table gives me this error:
500 SQL=ALTER TABLE `cla_users` ADD INDEX `fb_join_group_id_INDEX` (`group_id` )
Is this an issue of permissions or am I not doing something correctly?
John