I have been using OGUR successfully (and gratefully ... amazing module) for almost a year and a half.

Unfortunately, OGUR based role access to some content has stopped working correctly (user with group admin permission cannot edit own event)
Also, the admin screen for OGUR no longer allows me to change the default role for new members joining a group.
When I submit the changes on this admin page, I get the error (below) and the default role remains unchanged.



    * user warning: Duplicate entry 'og_user_roles_assign_typegrouprole_group_generic' for key 1 query: INSERT INTO bcsis_variable (name, value) VALUES ('og_user_roles_assign_typegrouprole_group_generic_group', 'i:0;') in /home/groupsal/public_html/includes/database.mysql.inc on line 174.
    * user warning: Duplicate entry 'og_user_roles_typegrouprole_value_group_generic_' for key 1 query: INSERT INTO bcsis_variable (name, value) VALUES ('og_user_roles_typegrouprole_value_group_generic_group', 's:1:\"6\";') in /home/groupsal/public_html/includes/database.mysql.inc on line 174.
    * user warning: Duplicate entry 'og_user_roles_assign_typegrouprole_group_generic' for key 1 query: INSERT INTO bcsis_variable (name, value) VALUES ('og_user_roles_assign_typegrouprole_group_generic_public_group', 'i:0;') in /home/groupsal/public_html/includes/database.mysql.inc on line 174.
    * user warning: Duplicate entry 'og_user_roles_typegrouprole_value_group_generic_' for key 1 query: INSERT INTO bcsis_variable (name, value) VALUES ('og_user_roles_typegrouprole_value_group_generic_public_group', 's:1:\"6\";') in /home/groupsal/public_html/includes/database.mysql.inc on line 174.
    * user warning: Duplicate entry 'og_user_roles_assign_typegrouprole_group_learnin' for key 1 query: INSERT INTO bcsis_variable (name, value) VALUES ('og_user_roles_assign_typegrouprole_group_learning_group', 'i:0;') in /home/groupsal/public_html/includes/database.mysql.inc on line 174.
    * user warning: Duplicate entry 'og_user_roles_typegrouprole_value_group_learning' for key 1 query: INSERT INTO bcsis_variable (name, value) VALUES ('og_user_roles_typegrouprole_value_group_learning_group', 's:1:\"6\";') in /home/groupsal/public_html/includes/database.mysql.inc on line 174.
    * user warning: Duplicate entry 'og_user_roles_assign_typegrouprole_group_matrix_' for key 1 query: INSERT INTO bcsis_variable (name, value) VALUES ('og_user_roles_assign_typegrouprole_group_matrix_group', 'i:0;') in /home/groupsal/public_html/includes/database.mysql.inc on line 174.
    * user warning: Duplicate entry 'og_user_roles_typegrouprole_value_group_matrix_g' for key 1 query: INSERT INTO bcsis_variable (name, value) VALUES ('og_user_roles_typegrouprole_value_group_matrix_group', 's:1:\"6\";') in /home/groupsal/public_html/includes/database.mysql.inc on line 174.
    * user warning: Duplicate entry 'og_user_roles_assign_typegrouprole_group_school_' for key 1 query: INSERT INTO bcsis_variable (name, value) VALUES ('og_user_roles_assign_typegrouprole_group_school_parents', 'i:0;') in /home/groupsal/public_html/includes/database.mysql.inc on line 174.
    * user warning: Duplicate entry 'og_user_roles_typegrouprole_value_group_school_p' for key 1 query: INSERT INTO bcsis_variable (name, value) VALUES ('og_user_roles_typegrouprole_value_group_school_parents', 's:1:\"6\";') in /home/groupsal/public_html/includes/database.mysql.inc on line 174.
    * user warning: Duplicate entry 'og_user_roles_assign_typegrouprole_group_work_gr' for key 1 query: INSERT INTO bcsis_variable (name, value) VALUES ('og_user_roles_assign_typegrouprole_group_work_group', 'i:0;') in /home/groupsal/public_html/includes/database.mysql.inc on line 174.
    * user warning: Duplicate entry 'og_user_roles_typegrouprole_value_group_work_gro' for key 1 query: INSERT INTO bcsis_variable (name, value) VALUES ('og_user_roles_typegrouprole_value_group_work_group', 's:1:\"6\";') in /home/groupsal/public_html/includes/database.mysql.inc on line 174.

I already have the correct patch installed and clear user permissions cache setting enabled.

One thought I have looking at the error above is that the number of characters in the variable name may be exceeded for the entry in the database table. For example, Duplicate entry 'og_user_roles_typegrouprole_value_group_work_gro' seems to be truncated the drupal system name of the group referenced by this error is actually group_work_group

Could changing the character string length of the table field associated with this variable solve the problem? Would this screw up anything else?

Ideas anyone?

Thanks,

Jack

Comments

lias’s picture

lias commented

I am also experiencing role issues. One of the roles I have enabled for group admins is the ability to assign student role that has permission to post comments. Once the admin has assigned the role the user still can't post comments in the forum section. When I enable to the role for the user in drupal's access permission table the user can then post comments.

sun’s picture

sun
Primary language German
Location Karlsruhe
commented
Status: Active » Closed (won't fix)

Drupal 5 is globally, unconditionally, and officially unsupported since Jan 7th, 2011 - the release of Drupal 7. You are encouraged to upgrade to Drupal 6, or even better, Drupal 7.