1. Fabrik 3.9 has been released. If you have updated Joomla to 3.9, this is a required update.
    Dismiss Notice

Users and Groups inside Fabrik - NN table problem

Discussion in 'Community' started by marcelf, Nov 8, 2019 at 10:17 AM.

  1. marcelf

    marcelf Member

    Level: Community
    Hi,

    I users and groups to be a list in fabrik. So far no problem, because I can make a list using joomla_users or joomla_groups.

    But when I create a user inside fabrik list, its creating the a invalid user, because the user created hasnt a group.

    So if make a databasejoin mulitlist from users to groups, fabrik creates users_repeat_groups, BUT the right way is use joomla_usergroups.

    Is there a way to change (manually) the NN table created by fabrik for joomla_usergroups ? I mean fabrik could use a NN table that already exists ?

    Thanks,
    Marcel
     
  2. troester

    troester Well-Known Member Staff Member

    Level: Community
    Usually you can link Fabrik lists to any (also Joomla) database table.

    But #_user_usergroup_map has a combined primary key (2 columns user_id and group_id) which is not supported by Fabrik.
    You must fill this n-m-table via php code if you want to do it manually.

    But did you have a look at Fabrik's "Joomla users" form plugin?
    http://fabrikar.com/forums/index.php?wiki/joomla-user-form-plugin/
     

Share This Page