I got this error message when installed OG Forum D7. Please let me know if you have any ideas.

Thank you!

PDOException: SQLSTATE[42S02]: Base table or view not found: 1146 Table 'reachia_drupal_p5.field_data_group_audience' doesn't exist: SELECT DISTINCT base.tid AS tid, base.vid AS vid, base.name AS name, base.description AS description, base.format AS format, base.weight AS weight, v.machine_name AS vocabulary_machine_name FROM {taxonomy_term_data} base INNER JOIN {taxonomy_vocabulary} v ON base.vid = v.vid LEFT OUTER JOIN {field_data_group_audience} ga ON ga.entity_id = base.tid WHERE (base.tid IN (:db_condition_placeholder_0)) AND( (ga.group_audience_gid IS NULL ) OR (ga.group_audience_gid IN (:db_condition_placeholder_1)) )AND (ga.entity_type = :db_condition_placeholder_2) AND (ga.bundle = :db_condition_placeholder_3) ; Array ( [:db_condition_placeholder_0] => 6 [:db_condition_placeholder_1] => node [:db_condition_placeholder_2] => taxonomy_term [:db_condition_placeholder_3] => forums ) in DrupalDefaultEntityController->load() (line 196 of /home/reachia/public_html/p5/includes/entity.inc).

Running OG 7.x-2.0-alpha2

CommentFileSizeAuthor
#11 og_forum_D7-og_7.x-2.x-compatibility-1599372-11.patch7.57 KBFeuerwagen
#9 og_forum_D7-og_7.x-2.x-compatibility-1599372-9.patch4.9 KBFeuerwagen
Support from Acquia helps fund testing for Drupal Acquia logo

Comments

epieddy’s picture

epieddy CreditAttribution: epieddy commented
Title: PDOException: SQLSTATE[42S02]: Base table or view not found: 1146 » Incompatibility with OG 7.x-2.x
Assigned: Unassigned » epieddy
Status: Active » Needs work

Hi,

I have checked and OG 7.x-2.x change completely the way of managing membership with groups. (No more OG Audience field, which is the main field used in OG 7.x-1.x and OG Forum D7 7.x-1.x).

I need to make a new branch 2.x for OG Forum D7 to be compatible with OG 2.x.

It may take some times. I will post information in this issue about the new branch.

(Changing the issue title to : Incompatibility with OG 7.x-2.x)

Thanks for the info.

klucid’s picture

klucid CreditAttribution: klucid commented

Thanks for your reply. I appreciate your work on this module!

kaizerking’s picture

kaizerking CreditAttribution: kaizerking commented

Ok this is the reason i could not make it work,
Waiting for the 2.x please

JohnnyX’s picture

JohnnyX CreditAttribution: JohnnyX commented

Also waiting for 2.x ...
Following

I found some similar modules...
http://drupal.org/project/spaces_og_forum (???)
http://drupal.org/project/og_forum_D7 (OG 7.1)
http://drupal.org/sandbox/markwk/1572364 (OG 7.1)
http://drupal.org/sandbox/thepanz/1110446 (dead?)

Yuri’s picture

Yuri CreditAttribution: Yuri commented

I am very much in need for this 2.x version and would be happy to test any patch out

PlayfulWolf’s picture

PlayfulWolf CreditAttribution: PlayfulWolf commented

definitely I am also the beta tester

kaizerking’s picture

kaizerking CreditAttribution: kaizerking commented

any up date on expected date 2.x release?

epieddy’s picture

epieddy CreditAttribution: epieddy commented

No, i'm really sorry, right now i don't have time to work on the 2.x version.

I will work on it as soon as i can and post informations here.

Feuerwagen’s picture

Feuerwagen
he/him
Primary language German
Location Bonn 🇩🇪🇪🇺
CreditAttribution: Feuerwagen commented
Status: Needs work » Needs review
FileSize
og_forum_D7-og_7.x-2.x-compatibility-1599372-9.patch4.9 KB

Well I made an attempt on implementing the necessary changes to get it work with og 2.x. In fact the new style of og to store its membership entries in the database is the only remarkable difference as far as I can see.

Feuerwagen’s picture

Feuerwagen
he/him
Primary language German
Location Bonn 🇩🇪🇪🇺
CreditAttribution: Feuerwagen commented
Status: Needs review » Needs work

Poor work by me: The patch in #9 only works without forum_access enabled. Otherwise, more stuff needs to be changed, as both functions og_roles and og_get_users_by_roles were removed from og 2.x. In fact og_rules still exists but seems to behave differently.

Feuerwagen’s picture

Feuerwagen
he/him
Primary language German
Location Bonn 🇩🇪🇪🇺
CreditAttribution: Feuerwagen commented
Status: Needs work » Needs review
FileSize
og_forum_D7-og_7.x-2.x-compatibility-1599372-11.patch7.57 KB

After some more work, I got this module running without errors (even with forum_access activated). Needed to implement two new functions to replace former functions of og 1.x which are now removed in og 2.x.
I don't think that I chose the most elegant solution but I needed to get it done as soon as possible.

Media Crumb’s picture

Media Crumb CreditAttribution: Media Crumb commented

Maybe epieddy can take a look and roll this into a new release. Thanks for the hard work.

epieddy’s picture

epieddy CreditAttribution: epieddy commented
Status: Needs review » Fixed

Hi,

I took a look at the patch which is really clean and seems to work.

I've created a new release 7.x-2.0-alpha1 with Feuerwagen patch.

Thank you very much for the help and once again sorry for being late.

Status: Fixed » Closed (fixed)

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

tchilly’s picture

tchilly CreditAttribution: tchilly commented

Forum (forum) 7.26
OG Forum (og_forum) 7.x-2.0-alpha1+1-dev
Forum Access (forum_access) 7.x-1.2
ACL (acl) 7.x-1.0

Gets phat error when creating a new container/forum and assigning it to a group;

( ! ) Fatal error: Call to undefined function og_get_users_by_roles() in D:\Wamp\www\project_m\sites\all\modules\og_forum_D7\og_forum.module on line 314
Call Stack
#	Time	Memory	Function	Location
1	0.0003	156744	{main}( )	..\index.php:0
2	0.1909	21388848	menu_execute_active_handler( )	..\index.php:21
3	0.1914	21443168	call_user_func_array ( )	..\menu.inc:517
4	0.1914	21443352	forum_form_main( )	..\menu.inc:517
5	0.1914	21443520	drupal_get_form( )	..\forum.admin.inc:29
6	0.1914	21444144	drupal_build_form( )	..\form.inc:131
7	0.1932	21681848	drupal_process_form( )	..\form.inc:380
8	0.2162	22550192	form_execute_handlers( )	..\form.inc:868
9	0.2162	22553384	forum_form_submit( )	..\form.inc:1478
10	0.2162	22554392	taxonomy_term_save( )	..\forum.admin.inc:101
11	0.2379	23994448	field_attach_insert( )	..\taxonomy.module:641
12	0.2382	23994592	_field_invoke( )	..\field.attach.inc:938
13	0.2383	23996000	entityreference_field_insert( )	..\field.attach.inc:209
14	0.2398	23996496	OgBehaviorHandler->insert( )	..\entityreference.module:258
15	0.2398	23996520	OgBehaviorHandler->OgMembershipCrud( )	..\OgBehaviorHandler.class.php:43
16	0.2435	24427440	og_group( )	..\OgBehaviorHandler.class.php:134
17	0.2495	24785424	OgMembership->save( )	..\og.module:2039
18	0.2695	24796944	Entity->save( )	..\og.membership.inc:77
19	0.2695	24796976	EntityAPIController->save( )	..\entity.inc:197
20	0.2710	24808976	EntityAPIController->invoke( )	..\entity.controller.inc:455
21	0.2719	24811032	module_invoke_all( )	..\entity.controller.inc:352
22	0.2722	24812168	call_user_func_array ( )	..\module.inc:895
23	0.2722	24812352	og_forum_og_membership_insert( )	..\module.inc:895