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) »
  • Adv. search results are cut off depending on the selected sorting
Pages: [1]

Author Topic: Adv. search results are cut off depending on the selected sorting  (Read 852 times)

laborg

  • Guest
Adv. search results are cut off depending on the selected sorting
May 18, 2009, 04:31:17 am
Hi!

I stumbled over a strange problem on which I need your help!
The result of an advanced search gives a list with 211 persons. 1-25 are said to be shown (1st page), but I only count 17 (this number differs on all pages, but is never 25) persons... The last 8 persons are cut off. On the second page the list starts with the cut-off persons from the first page but is itself reduced to a number smaller < 25, and so on...
After changing the sorting to anything other than the name by clicking on the related header the problem disappears.
I can not make any sense of this behaviour, but maybe some of you know whats happening here.

I greatly thank you in advance!
Gerhard

Ps.: I'm using Civicrm 2.0.7 and drupal 5.18 (I know its old, but I really can't update the site to a newer version)
« Last Edit: May 18, 2009, 05:05:07 am by laborg »

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: Adv. search results are cut off depending on the selected sorting
May 18, 2009, 09:46:56 am

most likely this is due to some inconsistent values in the db (due to a few bugs). Some of the contacts have either multiple primary address/phone/emails which messes up the query and counts and hence the listing. If you are familiar with mysql, you can run a few queries to see how many contacts have multiple is_primary addresses / phone / email's. Ping us on IRC if u need help

lobo

p.s> you definitely should try to upgrade :)
A new CiviCRM Q&A resource needs YOUR help to get started. Visit our StackExchange proposed site, sign up and vote on 5 questions

laborg

  • Guest
Re: Adv. search results are cut off depending on the selected sorting
May 19, 2009, 06:31:13 am
Thank you Lobo!

All my contacts have a phone number of the primary address (named "Korrespondenz") and a fax number of the billing adress. Both, the fax number and the phone number had set the is_primary field. First I thought this would not matter, because they had a different location_type_id, but after setting the is_primary of all fax entries to 0 my problem was solved.
(The reason I use another location_type for the fax number lies in a unresolved bug within the integrated drupal-civicrm registration form)

Now my question:
How can I make sure that new fax entries aren't written with the is_primary field set to 1?

thx alot,
gerhard

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: Adv. search results are cut off depending on the selected sorting
May 19, 2009, 06:43:51 am

unfortunately i need to use the: 2.0 is no longer supported line here :(

your best bet for now (assuming u'll upgrade in the next few months) would be to write a cron script with the sql cleanup query to set is_primary for all the fax entries to 0 periodically (every day/hour etc). its kinda hackish but will do the job for now

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

Pages: [1]
  • CiviCRM Community Forums (archive) »
  • Old sections (read-only, deprecated) »
  • Support »
  • Using CiviCRM »
  • Using Core CiviCRM Functions (Moderator: Yashodha Chaku) »
  • Adv. search results are cut off depending on the selected sorting

This forum was archived on 2017-11-26.