implementation question and performance

Hi Alex,

We are having a problem with the UAM plugin, hope you can help. We have
Wordpress 4.2.3 and the 1.2.6.6 version of UAM.

Users started claiming that they do not have permissions to see what they
were expected to see.

We noted that their records at the wp_uam_accessgroup_to_object table were
not there. If we re-create their records then the permissions works
perfectly again.

As we didn´t remove that permissions and we have not idea about what was
happening, we set up a trigger at that table to persist in another table
any record that has been deleted. The trigger is:

CREATE TRIGGER my_trigger BEFORE DELETE ON wp_uam_accessgroup_to_object FOR
> EACH ROW
INSERT INTO wp_uam_accessgroup_to_object_AUDIT
(object_id,object_type,group_id)
VALUES
(OLD.object_id,OLD.object_type,OLD.group_id);

Our wp_uam_accessgroup_to_object table has just 7000 records, but the
wp_uam_accessgroup_to_object_AUDIT table grows insanely, up to 4 million
rows and counting (all duplicates of the same records).

After digging deeper in the possible causes of the problem we noted that
when a permission is changed from the WP interfase, the plugin deletes all
the records and then recreates all the records again; we do not understand
why this was implemented this way, but the trigger shows that.

In this single permission updates that deletes and re-builds the
wp_uam_accessgroup_to_object table again and again we suspect that the
causes of the problem are.

The questions are:

– does this behavior make sense to you ?
– do any other users report this same problem ?
– can you help us solve this problem ?

Any hints will be greatly appreciated.

Thanks,
Antonio

https://wordpress.org/plugins/user-access-manager/