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 Core CiviCRM Functions (Moderator: Yashodha Chaku) »
  • Problem changing Settings for Group
Pages: [1]

Author Topic: Problem changing Settings for Group  (Read 1116 times)

petednz

  • Forum Godess / God
  • I’m (like) Lobo ;)
  • *****
  • Posts: 4899
  • Karma: 193
    • Fuzion
  • CiviCRM version: 3.x - 4.x
  • CMS version: Drupal 6 and 7
Problem changing Settings for Group
November 15, 2010, 09:49:48 pm
An existing smart group is not currently set for Mailing List. I open settings and check the box and save and get this
Code: [Select]
Please correct the following errors in the form fields below:
Group 'XXXX Board (Smart Group)' already exists.Any suggestions?

Think i have seen this before but searched without luck. This is 3.2.4 - tried replicating on Demo but either won't fail there, or I haven't got the right combination of factors (eg tongue on left v right)

Any suggestions? I know we can change this value in the DB - but why are we hitting this problem?
Sign up to StackExchange and get free expert advice: https://civicrm.org/blogs/colemanw/get-exclusive-access-free-expert-help

pete davis : www.fuzion.co.nz : connect + campaign + communicate

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: Problem changing Settings for Group
November 15, 2010, 09:56:50 pm
Group name is unique and we don't change group name when label is changed. So looks like you had created a group with same name and then changed label. Now you are again trying to create new group with same name hence you are getting this error message.

Hth
Kurund
Found this reply helpful? Support CiviCRM

petednz

  • Forum Godess / God
  • I’m (like) Lobo ;)
  • *****
  • Posts: 4899
  • Karma: 193
    • Fuzion
  • CiviCRM version: 3.x - 4.x
  • CMS version: Drupal 6 and 7
Re: Problem changing Settings for Group
November 15, 2010, 10:02:21 pm
Kurund - not sure if we are on same song - this is an existing group, i go to settings, i make an edit, i save. Why does it tell me the group exists? I know it exists, i am trying to edit it.
Sign up to StackExchange and get free expert advice: https://civicrm.org/blogs/colemanw/get-exclusive-access-free-expert-help

pete davis : www.fuzion.co.nz : connect + campaign + communicate

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: Problem changing Settings for Group
November 15, 2010, 10:09:25 pm
Oh you mean it's not allowing you to edit the group. Can you check your db if you have any other groups with same name.

Kurund
Found this reply helpful? Support CiviCRM

Portable Studio

  • I’m new here
  • *
  • Posts: 3
  • Karma: 0
Re: Problem changing Settings for Group
November 16, 2010, 11:19:22 pm
I'm getting the exact same problem as peterd.

I've checked my database and I do not have any groups with duplicate names.

Any assistance would be great thanks.

xavier

  • Forum Godess / God
  • I’m (like) Lobo ;)
  • *****
  • Posts: 4453
  • Karma: 161
    • Tech To The People
  • CiviCRM version: yes probably
  • CMS version: drupal
Re: Problem changing Settings for Group
November 17, 2010, 12:16:00 am
Hi,

Was a bug on 3.2.x that sounds very similar

http://issues.civicrm.org/jira/browse/CRM-6958

Has been fixed already. can you try patching your install ?
X+
-Hackathon and data journalism about the European parliament 24-26 jan. Watch out the result

Portable Studio

  • I’m new here
  • *
  • Posts: 3
  • Karma: 0
Re: Problem changing Settings for Group
November 17, 2010, 03:34:41 pm
Thanks Xavier,

But my error (and peterds) appears unrelated to bug #6958.


I couldn't tell you how to re-create the bug, but I can say how I came across it.

I've imported contacts from multiple CSV's, each import went into a new group (ie the group was created as part of the import process).
I then wanted to send a mail out to one of the groups.
Realising that I could only email groups marked as 'Mailing List', I went to edit the group, ticket 'Mailing List' and saved.
I am then presented with the following error:
'Please correct the following errors in the form fields below:
Group 'Local government' already exists.'


Having a look in the database shows no duplicate group names in 'civicrm_group'.

I'm at a bit of a loss here, I attempted altering the 'group_type' field in 'civicrm_group' to no avail.
I also couldn't find what the 'group_type' field is a foreign key of.

petednz

  • Forum Godess / God
  • I’m (like) Lobo ;)
  • *****
  • Posts: 4899
  • Karma: 193
    • Fuzion
  • CiviCRM version: 3.x - 4.x
  • CMS version: Drupal 6 and 7
Re: Problem changing Settings for Group
November 17, 2010, 03:43:29 pm
hi - i think there is something to do with characters - on mine i had brackets - removed - fixed

But if your group is just called Local Government then I can't make a suggestion
Sign up to StackExchange and get free expert advice: https://civicrm.org/blogs/colemanw/get-exclusive-access-free-expert-help

pete davis : www.fuzion.co.nz : connect + campaign + communicate

xavier

  • Forum Godess / God
  • I’m (like) Lobo ;)
  • *****
  • Posts: 4453
  • Karma: 161
    • Tech To The People
  • CiviCRM version: yes probably
  • CMS version: drupal
Re: Problem changing Settings for Group
November 17, 2010, 04:02:57 pm
Check the content of your database for the table civicrm_group.

Check for the group local government. what are the value of title and name ? are they other groups that have the value and name ?

(my bet: one of these value is an empty one)

you can update manually the empty value and put "XavierWasRight" in it. (I'm assuming you don't have a group already named "XavierWasRight" ;)

X+
-Hackathon and data journalism about the European parliament 24-26 jan. Watch out the result

Portable Studio

  • I’m new here
  • *
  • Posts: 3
  • Karma: 0
Re: Problem changing Settings for Group
November 17, 2010, 04:19:25 pm
Title is 'Local_Government', name is 'Local Government'.

No other groups share the same title or name.

Here is a dump of all the values the group in question has:

ID - 8
name - Local_Government
title - Local Government
description - Desc
source - NULL
saved_search_id - NULL
is_active - 1
visibility - User and User Admin Only
where_clause -  ( `civicrm_group_contact-8`.group_id IN ( 8 ) AND `civicrm_group_contact-8`.status IN ("Added") )
select_tables - a:12:{s:15:"civicrm_contact";i:1;s:15:"civicrm_address";i:1;s:22:"civicrm_state_province";i:1;s:15:"civicrm_country";i:1;s:13:"civicrm_email";i:1;s:13:"civicrm_phone";i:1;s:10:"civicrm_im";i:1;s:19:"civicrm_worldregion";i:1;s:25:"`civicrm_group_contact-8`";s:114:" LEFT JOIN civicrm_group_contact `civicrm_group_contact-8` ON contact_a.id = `civicrm_group_contact-8`.contact_id ";s:6:"gender";i:1;s:17:"individual_prefix";i:1;s:17:"individual_suffix";i:1;}
where_tables - a:2:{s:15:"civicrm_contact";i:1;s:25:"`civicrm_group_contact-8`";s:114:" LEFT JOIN civicrm_group_contact `civicrm_group_contact-8` ON contact_a.id = `civicrm_group_contact-8`.contact_id ";}
group_type - NULL
cache_date - NULL
parents - NULL
children - NULL
is_hidden - 0

Please note that 'Local Government' is just the example I'm using here, my other groups also suffer from this bug.

Kiran Jagtap

  • Ask me questions
  • ****
  • Posts: 533
  • Karma: 51
Re: Problem changing Settings for Group
November 17, 2010, 09:28:12 pm
Could you fire bellow query and let us know results.

SELECT count(*) FROM `civicrm_group` WHERE name like 'your group name' or title like 'your group title';

There should be a single group in db w/ same name or title.

Actually related issue is here : http://issues.civicrm.org/jira/browse/CRM-6682
here we took the call and decided not to allow multiple groups w/ same name or title.

hope this help

kiran
You Are Designed To Choose... Defined By Choice.
Pages: [1]
  • CiviCRM Community Forums (archive) »
  • Old sections (read-only, deprecated) »
  • Support »
  • Using CiviCRM »
  • Using Core CiviCRM Functions (Moderator: Yashodha Chaku) »
  • Problem changing Settings for Group

This forum was archived on 2017-11-26.