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 »
  • Upgrading CiviCRM (Moderator: Deepak Srivastava) »
  • Bug (?) after upgrading 2.1 to 2.2: problem with tags and advanced search
Pages: [1]

Author Topic: Bug (?) after upgrading 2.1 to 2.2: problem with tags and advanced search  (Read 2786 times)

geert.je

  • I’m new here
  • *
  • Posts: 16
  • Karma: 2
    • Flemish environment movement
  • CiviCRM version: 4.1.0
  • CMS version: Drupal 7
Bug (?) after upgrading 2.1 to 2.2: problem with tags and advanced search
April 02, 2009, 07:02:33 am
Something strange is happening now in the 2.2 installation (Civi 2.2.0, Drupal 6). After using an advanced search and searching for tagged contacts, I get the list as it should be. But when I do an action (export, tag, delete, map, new smart group...), all records are selected: the search criteria are disappeared. (also when I do "edit search criteria" the previous criteria concerning tags are gone.

> I didn't get this in civi 2.1.4.
> I don't get this error with other fields like address-fields, custom fields... only with tags
> I don't get this error using Search builder (where you can search tags using the tag_id).
> And I don't see this behaviour in drupal.demo.civicrm.org 2.2.

So it looks like when executing the search form, the form values are correct, but the values (only of the tag-criteria) are not "transported" to a next step such as edit this criteria, actions on the list...

There must be some kind of problem with "remembering the tag-value of the advanced search form"...

Has someone else the same problem? Is there a solution? 

« Last Edit: April 02, 2009, 07:05:03 am by geert.vosec »

Donald Lobo

  • Administrator
  • I’m (like) Lobo ;)
  • *****
  • Posts: 15963
  • Karma: 470
    • CiviCRM site
  • CiviCRM version: 4.2+
  • CMS version: Drupal 7, Joomla 2.5+
  • MySQL version: 5.5.x
  • PHP version: 5.4.x
Re: Bug (?) after upgrading 2.1 to 2.2: problem with tags and advanced search
April 02, 2009, 07:10:54 am

can u reproduce this issue on the demo server (http://drupal.demo.civicrm.org/) and if so file an issue and we'll fix for 2.2.2

if not, can u upgrade your site to 2.2.1 and see if that fixes the issue

thanx

lobo
A new CiviCRM Q&A resource needs YOUR help to get started. Visit our StackExchange proposed site, sign up and vote on 5 questions

geert.je

  • I’m new here
  • *
  • Posts: 16
  • Karma: 2
    • Flemish environment movement
  • CiviCRM version: 4.1.0
  • CMS version: Drupal 7
Re: Bug (?) after upgrading 2.1 to 2.2: problem with tags and advanced search
April 02, 2009, 12:32:53 pm
Lobo,

I cannot reproduce the issue in http://drupal.demo.civicrm.org  (is that a new install or an upgrade?) It seems there is no bug there.
I upgraded tot 2.2.1. and still I have the same problem.

I can always use the other search forms like "find records" and "search builder". They work fine. I'm not stucked but it would be nice if also "advanced search" work fine with the tags.

Thanks for the reaction.
Geert


geert.je

  • I’m new here
  • *
  • Posts: 16
  • Karma: 2
    • Flemish environment movement
  • CiviCRM version: 4.1.0
  • CMS version: Drupal 7
Re: Bug (?) after upgrading 2.1 to 2.2: problem with tags and advanced search
April 06, 2009, 02:26:57 am
Hi,
I did some more tests.
1. Upgrading to 2.2.2: still the same problem
2. New install of 2.2.2 with loading the sample data: then I have NO PROBLEM (I think, this excludes possible problems with php versions etc on our server...)
3. Than, I copied the database of our install to the new install: again I have this problem. (I only made this change in the database: UPDATE civicrm_domain SET config_backend = NULL WHERE id = 1)

So I suppose there can only be something wrong in the database?

In the database, I get this messages for the table: civicrm_entity_tag (and for some other tables similar messages)
UNIQUE and INDEX keys should not both be set for column `contact_id`
Maybe that cuases the problem?


Geert


Donald Lobo

  • Administrator
  • I’m (like) Lobo ;)
  • *****
  • Posts: 15963
  • Karma: 470
    • CiviCRM site
  • CiviCRM version: 4.2+
  • CMS version: Drupal 7, Joomla 2.5+
  • MySQL version: 5.5.x
  • PHP version: 5.4.x
Re: Bug (?) after upgrading 2.1 to 2.2: problem with tags and advanced search
April 06, 2009, 07:36:43 am

1. can you check and verify your exact mysql version (also any chance you can upgrade to the latest 5.0.x)

2. the db error (UNIQUE and INDEX keys...), when do you get those messages? Is it a warning or a error? civicrm.mysql has got quite a few UNIQUE indexes across the entire schema

3. Most likely this is an issue with the db upgrade from 2.1 -> 2.2 and somethign failed, maybe this statement:

ALTER TABLE civicrm_entity_tag
  ADD UNIQUE UI_contact_id_tag_id ( contact_id, tag_id );

(though this should not cause the symptoms you described)

4. Can you do a mysqldump from your 2.2 upgraded DB (wthout the schema) and load it to a clean schema from 2.2

thanx

lobo
A new CiviCRM Q&A resource needs YOUR help to get started. Visit our StackExchange proposed site, sign up and vote on 5 questions

civiZEN

  • I’m new here
  • *
  • Posts: 5
  • Karma: 1
Re: Bug (?) after upgrading 2.1 to 2.2: problem with tags and advanced search
April 06, 2009, 01:07:41 pm
I can confirm this error on our install.

It only occurs in Advanced Search for us too.

Encountered it when using advanced search to find contacts who were tagged with various tags and add them to a new group.
The search results list what looks like the right number of contacts.
The add to group action puts what looks like all contacts in there instead of the number reported in the search results.

To get around this for now we selected custom searches, and used the Include / Exclude Contacts in a Group / Tag search.
That worked, however, selecting 'All x contacts' would not make the action menu activate. Selecting 'Selected Records only' activated the action menu and then we were able to select 'All x contacts' and finally use the 'Add to group' action successfully.

geert.je

  • I’m new here
  • *
  • Posts: 16
  • Karma: 2
    • Flemish environment movement
  • CiviCRM version: 4.1.0
  • CMS version: Drupal 7
Re: Bug (?) after upgrading 2.1 to 2.2: problem with tags and advanced search
April 06, 2009, 01:15:34 pm
Hi 'colleague',
Than we are at least two... I'll keep on trying to find out what's going on.
What you mention that you must select "selected records only" before "all x records" can be activated: I have the same problem.

This is our verion of MySQL and PHP:
MySQL database   5.0.51a
PHP   5.2.4-2ubuntu5.3

civiZEN: what are your versions? did you face this problem also after upgrading 2.1 tot 2.2 ?

(More information for Lobo tomorrow)

Thanx all!!!

Geert

Donald Lobo

  • Administrator
  • I’m (like) Lobo ;)
  • *****
  • Posts: 15963
  • Karma: 470
    • CiviCRM site
  • CiviCRM version: 4.2+
  • CMS version: Drupal 7, Joomla 2.5+
  • MySQL version: 5.5.x
  • PHP version: 5.4.x
Re: Bug (?) after upgrading 2.1 to 2.2: problem with tags and advanced search
April 06, 2009, 03:26:35 pm

would be great if we can get ssh access to either one of your servers. Might help us isolate and fix the bug more quickly. Ping us on IRC if this is possible. Note that coverage this week will be spotty (on spring/ski break)

lobo
A new CiviCRM Q&A resource needs YOUR help to get started. Visit our StackExchange proposed site, sign up and vote on 5 questions

civiZEN

  • I’m new here
  • *
  • Posts: 5
  • Karma: 1
Re: Bug (?) after upgrading 2.1 to 2.2: problem with tags and advanced search
April 10, 2009, 01:45:45 am
This one is on hold for me for right now as it is non-critical and we'll be upgrading to 2.2.2 before revisiting this.

cray146

  • I post occasionally
  • **
  • Posts: 31
  • Karma: 1
  • CiviCRM version: 4.2
  • CMS version: Drupal 7
  • MySQL version: 5
  • PHP version: 5.3
Re: Bug (?) after upgrading 2.1 to 2.2: problem with tags and advanced search
April 15, 2009, 04:50:02 am
Hi,

I can confirm this too. We started out with a clean 2.2.0 install so it's not an issue with upgrading.

Our setup:

* Drupal 6.10
* CiviCRM 2.2.0
* MySQL   5.0.51a
* Apache/2.2.9 (Debian) PHP/5.2.6-1+lenny2 with Suhosin-Patch mod_ssl/2.2.9 OpenSSL/0.9.8g

Description of the problem:

Using Advanced Search, I'm searching for contacts that speak Dutch (custom field Preferred Language = 'nl') and are tagged with a certain tag. The search works and i get a list with matching contacts. The search criteria are displayed as follows in the result page:

 Tagged IN <a_certain_tag> ...AND...
Preferred Language = Dutch

Next, i select all matching contacts and try to add them to a group. However, in the 'Add Contacts to A Group' page, the number of selected contacts reported is wrong.

Apparently, the matching with the tag is lost in the process and the search criteria are reduced to:

Preferred Language = Dutch

I'm currently using Search Builder as a workaround. I enter the same search criteria in Search Builder and get the same matching contacts. Adding the selected contacts to a group (smart group or otherwise) work ok in this case.

Chris

Donald Lobo

  • Administrator
  • I’m (like) Lobo ;)
  • *****
  • Posts: 15963
  • Karma: 470
    • CiviCRM site
  • CiviCRM version: 4.2+
  • CMS version: Drupal 7, Joomla 2.5+
  • MySQL version: 5.5.x
  • PHP version: 5.4.x
Re: Bug (?) after upgrading 2.1 to 2.2: problem with tags and advanced search
April 15, 2009, 07:23:35 am

as mentioned before, we cannot replicate this on our servers :(

we will need ssh access to a machine that has the issue to track and fix this bug. please contact us on IRC if this is possible

thanx

lobo
A new CiviCRM Q&A resource needs YOUR help to get started. Visit our StackExchange proposed site, sign up and vote on 5 questions

geert.je

  • I’m new here
  • *
  • Posts: 16
  • Karma: 2
    • Flemish environment movement
  • CiviCRM version: 4.1.0
  • CMS version: Drupal 7
Re: Bug (?) after upgrading 2.1 to 2.2: problem with tags and advanced search
April 17, 2009, 06:21:20 am
I will contact you after a short break until app. 30 april. I've not forgotten it.
Geert

Donald Lobo

  • Administrator
  • I’m (like) Lobo ;)
  • *****
  • Posts: 15963
  • Karma: 470
    • CiviCRM site
  • CiviCRM version: 4.2+
  • CMS version: Drupal 7, Joomla 2.5+
  • MySQL version: 5.5.x
  • PHP version: 5.4.x
Re: Bug (?) after upgrading 2.1 to 2.2: problem with tags and advanced search
April 17, 2009, 07:54:56 am

no hassle. i got a database that reproduced this issue and this is now fixed in svn

will be part of 2.2.3

lobo
A new CiviCRM Q&A resource needs YOUR help to get started. Visit our StackExchange proposed site, sign up and vote on 5 questions

geert.je

  • I’m new here
  • *
  • Posts: 16
  • Karma: 2
    • Flemish environment movement
  • CiviCRM version: 4.1.0
  • CMS version: Drupal 7
Re: Bug (?) after upgrading 2.1 to 2.2: problem with tags and advanced search
April 18, 2009, 03:44:18 am
thanx
I think I just saw the issue on: http://issues.civicrm.org/jira/browse/CRM-4386

Geert
Pages: [1]
  • CiviCRM Community Forums (archive) »
  • Old sections (read-only, deprecated) »
  • Support »
  • Upgrading CiviCRM (Moderator: Deepak Srivastava) »
  • Bug (?) after upgrading 2.1 to 2.2: problem with tags and advanced search

This forum was archived on 2017-11-26.