I have three content types defined as group nodes. The machine-readable names for these types are:

* organization
* organization_1
* organization_2

When I tried to submit /admin/og/og_user_roles the first time I got:

Warning: Table 'watchdog' was not locked with LOCK TABLES query: INSERT INTO watchdog (uid, type, message, severity, link, location, referer, hostname, timestamp) VALUES (1, 'php', '<em>Duplicate entry &amp;#039;og_user_roles_assign_typegrouprole_organization_&amp;#039; for key 1\nquery: INSERT INTO variable (name, value) VALUES (&amp;#039;og_user_roles_assign_typegrouprole_organization_1&amp;#039;, &amp;#039;i:0;&amp;#039;)</em> in <em>/home/brian/www/drupal-5/includes/database.mysql.inc</em> on line <em>172</em>.', 2, '', 'http://stafforg.5/admin/og/og_user_roles', 'http://stafforg.5/admin/og/og_user_roles', '127.0.0.1', 1219511097) in /home/brian/www/drupal-5/includes/database.mysql.inc on line 172

The problem seems to be that my machine-readable content type names, when appended to 'og_user_roles_assign_typegrouprole_' are exceeding the max length of the variable table's name column. I have worked around the problem by going to admin/og/og > Content Types and editing content types so that their Type: fields read org, org_1, org_2

Thanks for your work on OG_User_Roles.

Is a 6.x version planned?

Comments

somebodysysop’s picture

somebodysysop commented
Status: Active » Postponed

Yes, I recoginize this. Been trying to get to a point where I could figure out what to about it. Problem is that for the current user base, changing the code for variables that are already in use might present a huge problem.

somebodysysop’s picture

somebodysysop commented
Version: 5.x-3.2 » 6.x-1.x-dev
Assigned: Unassigned » somebodysysop
Status: Postponed » Fixed

It took a while, but this has been fixed in 6.x-1.x-dev module. Release should be available for download in about 12 hours. Will be included in next 6.x stable release.

Important Note:

This could only be fixed by changing the name of the Drupal variable for the OGUR settings: "Default group role for users who join groups of this type:".

This means that after you install this latest release, you will have to go into OGUR settings and re-enter your "Default group role for users who join groups of this type:" settings, if you have any.

Thanks, briwood@drupal.org for reporting this. Sorry for the delay.

Status: Fixed » Closed (fixed)

Automatically closed -- issue fixed for 2 weeks with no activity.