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 »
  • Using CiviCRM »
  • Using Drupal Modules (Moderator: Donald Lobo) »
  • Error with CiviGroup Roles Sync activated - Can't configure module/save profile
Pages: [1]

Author Topic: Error with CiviGroup Roles Sync activated - Can't configure module/save profile  (Read 1164 times)

SemperFi

  • I post frequently
  • ***
  • Posts: 177
  • Karma: 3
  • CiviCRM version: 4.5.4
  • CMS version: Wordpress 4.0.1
  • MySQL version: MySQL 5.5.16
  • PHP version: PHP 5.3.17
Error with CiviGroup Roles Sync activated - Can't configure module/save profile
June 11, 2011, 01:08:05 pm
Hi

My configuration : PHP 5.2.17/MySQL 5 // Drupal 7.2 - CiviCRCM 4.0.2 - drupal and civicrm databases are stored on two different mysql servers.

I activated the CiviGroup Roles Sync module and then when I tried to access the module configuration page I got an error page with this message :

PDOException : SQLSTATE[42S02]: Base table or view not found: 1146 Table 'xxx.civicrm_group_roles_rules' doesn't exist: SELECT cgr.role_id AS role_id FROM {civicrm_group_roles_rules} cgr WHERE (group_id = :db_condition_placeholder_0) ; Array ( [:db_condition_placeholder_0] => 1 ) dans civicrm_group_roles_civicrm_post() (ligne 200 dans /xxx/sites/all/modules/civicrm/drupal/modules/civicrm_group_roles/civicrm_group_roles.module).

Also, when I want to save an edited profile in CiviCRM, the same error is displayed.

Inactivating the module "CiviGroup Roles Sync" gets the problem solved.

Aside this, everything is working well.
Could you please help ?
Thanks
« Last Edit: June 12, 2011, 01:42:34 am by SemperFi »

Kurund Jalmi

  • Administrator
  • I’m (like) Lobo ;)
  • *****
  • Posts: 4169
  • Karma: 128
    • CiviCRM
  • CiviCRM version: 4.x, future
  • CMS version: Drupal 7, Joomla 3.x
  • MySQL version: 5.5.x
  • PHP version: 5.4.x
Re: Error with CiviGroup Roles Sync activated - Can't configure module/save profile
June 14, 2011, 02:30:08 am
When you install CiviGroup Role Sync module it should create "civicrm_group_roles_rules" table. Not sure what's the problem here. Can you check your db if table is created.

Kurund
Found this reply helpful? Support CiviCRM

SemperFi

  • I post frequently
  • ***
  • Posts: 177
  • Karma: 3
  • CiviCRM version: 4.5.4
  • CMS version: Wordpress 4.0.1
  • MySQL version: MySQL 5.5.16
  • PHP version: PHP 5.3.17
Re: Error with CiviGroup Roles Sync activated - Can't configure module/save profile
June 14, 2011, 02:48:26 am
Hello !
The table "civicrm_group_roles_rules" does exist in the civicrm database, but it's empty for now.
It contains 3 fields : id, role_id, group_id.
Any idea ?

Eileen

  • Forum Godess / God
  • I’m (like) Lobo ;)
  • *****
  • Posts: 4195
  • Karma: 218
    • Fuzion
Re: Error with CiviGroup Roles Sync activated - Can't configure module/save profile
June 14, 2011, 03:00:48 am
'xxx.civicrm_group_roles_rules'

xxx should be the name of the database that the table is in - if it isn't you need to look at prefixing the table in settings.php
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

Kurund Jalmi

  • Administrator
  • I’m (like) Lobo ;)
  • *****
  • Posts: 4169
  • Karma: 128
    • CiviCRM
  • CiviCRM version: 4.x, future
  • CMS version: Drupal 7, Joomla 3.x
  • MySQL version: 5.5.x
  • PHP version: 5.4.x
Re: Error with CiviGroup Roles Sync activated - Can't configure module/save profile
June 14, 2011, 03:24:00 am
I think that table is created in drupal db.

Kurund
Found this reply helpful? Support CiviCRM

SemperFi

  • I post frequently
  • ***
  • Posts: 177
  • Karma: 3
  • CiviCRM version: 4.5.4
  • CMS version: Wordpress 4.0.1
  • MySQL version: MySQL 5.5.16
  • PHP version: PHP 5.3.17
Re: Error with CiviGroup Roles Sync activated - Can't configure module/save profile
June 14, 2011, 04:39:23 am
Thanks for your help. I made it work by executing the following SQL request in the drupal database.
I'm now able to associate drupal roles with civicrm groups.

Code: [Select]
--
-- Table structure for table `civicrm_group_roles_rules`
--

CREATE TABLE IF NOT EXISTS `civicrm_group_roles_rules` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `role_id` int(10) unsigned NOT NULL,
  `group_id` int(10) unsigned NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

--
-- Dumping data for table `civicrm_group_roles_rules`
--

I observed that when I tried to reactivate the module, before doing this request, I got a blank page after having clicked on the "Save" buttom at the bottom of the modules list => time out.
There might be an issue with this function when drupal and civicrm are installed on separated database/serveur.

Anyway, thanks for your help, very useful - as always.
  ;)
Pages: [1]
  • CiviCRM Community Forums (archive) »
  • Old sections (read-only, deprecated) »
  • Support »
  • Using CiviCRM »
  • Using Drupal Modules (Moderator: Donald Lobo) »
  • Error with CiviGroup Roles Sync activated - Can't configure module/save profile

This forum was archived on 2017-11-26.