CiviCRM Community Forums (archive)

*

News:

Have a question about CiviCRM?
Get it answered quickly at the new
CiviCRM Stack Exchange Q+A site
This forum was archived on 25 November 2017. Learn more.
How to get involved.
What to do if you think you've found a bug.



  • CiviCRM Community Forums (archive) »
  • Old sections (read-only, deprecated) »
  • Support »
  • Installing CiviCRM »
  • Drupal Installations (Moderator: Piotr Szotkowski) »
  • Issue with Drupal module civicrm_group
Pages: [1]

Author Topic: Issue with Drupal module civicrm_group  (Read 1237 times)

ichi

  • I’m new here
  • *
  • Posts: 17
  • Karma: 0
  • CiviCRM version: 4.5.5
  • CMS version: Drupal 7.31
  • MySQL version: 5.5.41-0+wheezy1
  • PHP version: 5.4.4-14+deb7u14
Issue with Drupal module civicrm_group
October 19, 2014, 11:32:22 pm
I use 2 separated databases for Drupal and for CiviCRM. When activating the Drupal module civicrm_group and using the page CiviGroup Roles Sync, I get this error message :

An AJAX HTTP error occurred. HTTP Result Code: 500 Debugging information follows. Path: /batch?render=overlay&id=46&op=do StatusText: Service unavailable (with message) ResponseText: PDOException: SQLSTATE[42S02]: Base table or view not found: 1146 Table 'drupal.civicrm_group' doesn't exist: SELECT cgr.group_id AS group_id FROM {civicrm_group_roles_rules} cgr INNER JOIN {civicrm_group} cg ON cg.id = cgr.group_id WHERE (cgr.role_id = :db_condition_placeholder_0) AND (cg.saved_search_id IS NULL ) ; Array ( [:db_condition_placeholder_0] => 3 ) in civicrm_group_roles_add_remove_groups() (line 664 of /home/photocontact/public_html/sites/all/modules/civicrm/drupal/modules/civicrm_group_roles/civicrm_group_roles.module).

The table civicrm_group does exist on the Civi DB.

What shall I do ? Is an install trouble ? Shall replicate the table civicrm_group on the Drupal DB ?

Eileen

  • Forum Godess / God
  • I’m (like) Lobo ;)
  • *****
  • Posts: 4195
  • Karma: 218
    • Fuzion
Re: Issue with Drupal module civicrm_group
October 19, 2014, 11:44:32 pm
I think moving the table across would work - don't replicate it - because you risk having it seem to work but using a different copy of the table in different circumstances - an error is better than seeming to work but not really.

You also might be able to use table prefixing in your civicrm.settings.php file - which you have presumably set up for views?
Make today the day you step up to support CiviCRM and all the amazing organisations that are using it to improve our world - http://civicrm.org/contribute

Hershel

  • Forum Godess / God
  • I’m (like) Lobo ;)
  • *****
  • Posts: 4640
  • Karma: 176
    • CiviHosting
  • CiviCRM version: Latest
  • CMS version: Mostly WordPress and Drupal
Re: Issue with Drupal module civicrm_group
October 20, 2014, 03:40:51 am
ichi, you need to do the Views Integration procedure:

http://wiki.civicrm.org/confluence/display/CRMDOC/Views3+Integration

in order to use Views with CiviCRM.
CiviHosting and CiviOnline -- The CiviCRM hosting experts, since 2007

See here for the official: What to do if you think you've found a bug.

calbasi

  • I post occasionally
  • **
  • Posts: 36
  • Karma: 0
    • calbasi.net
  • CiviCRM version: 4.5
  • CMS version: Drupal 7
  • MySQL version: 5.1
  • PHP version: 5.3
Re: Issue with Drupal module civicrm_group
March 03, 2015, 12:05:59 am
There was a bug introduced at 4.5.2 and fixed at 4.5.5 : https://issues.civicrm.org/jira/browse/CRM-15693
Pages: [1]
  • CiviCRM Community Forums (archive) »
  • Old sections (read-only, deprecated) »
  • Support »
  • Installing CiviCRM »
  • Drupal Installations (Moderator: Piotr Szotkowski) »
  • Issue with Drupal module civicrm_group

This forum was archived on 2017-11-26.