Hi, hope i'm in the right place.

Using D 7.19 and Organic Groups 7.2 rc3

Don't know what any of this error means, but it seems to refer to og_extras code trying to input some kind of roles info.

This happened when I tried to install "Group Details" on a panel region (i don't know if its referring to a block, view, or what but it shows up in the panel manager add content link under the "miscellaneous" category.)

Notice: Undefined variable: role_rids in og_extras_preprocess_og_extras_group_info() (line 47 of /home/ctest01/public_html/qudt/sites/all/modules/og_extras/theme/theme.inc).
Warning: Invalid argument supplied for foreach() in DatabaseCondition->compile() (line 1854 of /home/ctest01/public_html/qudt/includes/database/query.inc).
PDOException: SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '))' at line 1: SELECT og_users_roles.uid AS uid FROM {og_users_roles} og_users_roles WHERE (gid = :db_condition_placeholder_0) AND (rid IN ()) ; Array ( [:db_condition_placeholder_0] => 11 ) in og_extras_get_users_by_roles() (line 77 of /home/ctest01/public_html/qudt/sites/all/modules/og_extras/og_extras.module).

Am I doing something wrong trying to install Group Details on the front page panel of an Organic Group?
Is there a better concept or way?
Is this a common problem (searched and didn't see it anywhere)?
Is there a workaround?
Do I need to provide more info?

Thanks

Jack

Support from Acquia helps fund testing for Drupal Acquia logo

Comments

mark2741’s picture

I'm seeing a similar error. Using Drupal 7.20.

Using latest OG Extras with OG 7.x.2 (stable). When I add the Group Details block to any region and then save and go to a group page I get the following error:

------------------------------
Notice: Undefined variable: role_rids in og_extras_preprocess_og_extras_group_info() (line 47 of /home/karkades/public_html/sites/all/modules/og_extras/theme/theme.inc).

Warning: Invalid argument supplied for foreach() in DatabaseCondition->compile() (line 1854 of /home/karkades/public_html/includes/database/query.inc).

PDOException: SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '))' at line 1: SELECT og_users_roles.uid AS uid FROM {og_users_roles} og_users_roles WHERE (gid = :db_condition_placeholder_0) AND (rid IN ()) ; Array ( [:db_condition_placeholder_0] => 91 ) in og_extras_get_users_by_roles() (line 77 of /home/karkades/public_html/sites/all/modules/og_extras/og_extras.module).
-------------------------------

Removing the block from the region allows the page/site to load properly.

Important: I am not using Panels - I just used the EVA Module (Entity Views Attachment) per the OG 7.x.2 tutorials at drupalize.me. I may ditch EVA and try Panels but the other reporter says they get a similar error with this block when using panels.

I'm using the Corolla theme from Adaptive Themes, if that makes a difference.

kvoelker’s picture

I'm seeing the same error. Using:

Drupal 7.21
Panels 3.3
OG 2.0
OG Extras 1.1

jaspm2004’s picture

the same error for me here... any update? :(

jaspm2004’s picture

im using the dev version now and the error seems to be gone. version 7.x-1.x-dev

hope this helps... :D

kostajh’s picture

Status: Active » Fixed

I can confirm that this is fixed in 7.x-1.x-dev.

Status: Fixed » Closed (fixed)

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

Mo Omar’s picture

Status: Closed (fixed) » Active

I have the same problem using the following modules:
D7.22 and D7.21
OG_extras 7.x-1.1
OG-7.x-2.2

All the blocks provided by OG_extras are working fine except the block "group details". It does give me the following error:

Error
The website encountered an unexpected error. Please try again later.
Error message
• Strict warning: Only variables should be passed by reference in og_extras_subscribe() (line 52 of Xxx\sites\all\modules\og_extras\og_extras.module).
• Notice: Undefined variable: role_rids in og_extras_preprocess_og_extras_group_info() (line 47 of Xxx\sites\all\modules\og_extras\theme\theme.inc).
• Warning: Invalid argument supplied for foreach() in DatabaseCondition->compile() (line 1854 of Xxx\includes\database\query.inc).
• PDOException: SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '))' at line 1: SELECT og_users_roles.uid AS uid FROM {og_users_roles} og_users_roles WHERE (gid = :db_condition_placeholder_0) AND (rid IN ()) ; Array ( [:db_condition_placeholder_0] => 2 ) in og_extras_get_users_by_roles() (line 77 of Xxx\sites\all\modules\og_extras\og_extras.module).

NancyDru’s picture

Status: Active » Closed (fixed)

As stated above, fixed in -dev release.

axle_foley00’s picture

Confirming also that it is fixed in -dev release. Why not roll out a stable release from -dev with the fix?