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 CiviMember (Moderator: Deepak Srivastava) »
  • Search not pulling everyone
Pages: [1]

Author Topic: Search not pulling everyone  (Read 2356 times)

jsimonis

  • I post frequently
  • ***
  • Posts: 316
  • Karma: 4
    • Forward Support, Inc.
  • CiviCRM version: 4.4-4.5
  • CMS version: Drupal 7
  • MySQL version: 5.5.37-cll
  • PHP version: 5.3.29
Search not pulling everyone
April 23, 2008, 08:52:41 pm
When we run a search for members based on End date that is a month back (March 23, 2008) to a year from today (April 23, 2009), it cuts off in the Ps. We don't get any names from Q-Z, and there are plenty of members who should come up from those letters.

I've tried upping the memory and execution time, but that doesn't change anything.

Any ideas on what could be causing this?

Thanks!

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: Search not pulling everyone
April 23, 2008, 09:53:05 pm
how many are you getting up to your P's?
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

jsimonis

  • I post frequently
  • ***
  • Posts: 316
  • Karma: 4
    • Forward Support, Inc.
  • CiviCRM version: 4.4-4.5
  • CMS version: Drupal 7
  • MySQL version: 5.5.37-cll
  • PHP version: 5.3.29
Re: Search not pulling everyone
April 25, 2008, 02:39:26 am
It pulls around 370. When I did it yesterday, it was exactly at 370. But I've been told that when others pulled it, they got 374 sometimes and 375 other times.

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: Search not pulling everyone
April 25, 2008, 03:09:20 am

If you have access to the mysql query log, you can see the query invoked for the alphabetic pager. You can search for this in your query log with: "SELECT DISTINCT UPPER(LEFT(contact_a.sort_name, 1))". Can you run that query manually and see if the results include Q-Z

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

jsimonis

  • I post frequently
  • ***
  • Posts: 316
  • Karma: 4
    • Forward Support, Inc.
  • CiviCRM version: 4.4-4.5
  • CMS version: Drupal 7
  • MySQL version: 5.5.37-cll
  • PHP version: 5.3.29
Re: Search not pulling everyone
April 25, 2008, 03:59:03 am
I don't know that I have access to the log on that server. How would you normally go about finding it?

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: Search not pulling everyone
April 25, 2008, 04:27:59 am

Unless you are running your own server / virtual server you probably dont have access to the logs. You should check with your hosting provider if they can turn this on for you for a short period of time

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

jsimonis

  • I post frequently
  • ***
  • Posts: 316
  • Karma: 4
    • Forward Support, Inc.
  • CiviCRM version: 4.4-4.5
  • CMS version: Drupal 7
  • MySQL version: 5.5.37-cll
  • PHP version: 5.3.29
Re: Search not pulling everyone
April 25, 2008, 04:58:30 am
No, they're running on a shared host. I can have her ask, but I have the feeling the answer will be no.

jsimonis

  • I post frequently
  • ***
  • Posts: 316
  • Karma: 4
    • Forward Support, Inc.
  • CiviCRM version: 4.4-4.5
  • CMS version: Drupal 7
  • MySQL version: 5.5.37-cll
  • PHP version: 5.3.29
Re: Search not pulling everyone
May 25, 2008, 01:36:20 am
We weren't able to get access to the logs since it's a shared server.

I did notice something - it does indeed pull everyone when you run the search. It tells you there are only 359 contact, but I can click on the letters for the last names, and I can see everyone. But if I click on "next" to see the next page, it'll only go partway thru "R."

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: Search not pulling everyone
May 25, 2008, 02:15:44 am
I know we have had issues in past related to Search Result numbers not matching what is being shown. On one occasion it had to do with people have multiple memberships, and while the count included these, the display did not, or something like that, or even vice versa. Worth checking if you are getting any contacts displaying more than once. Just a thought. (only spotted this post http://forum.civicrm.org/index.php/topic,2596.0.html but am sure I had another rave on this sort of issue)
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

jsimonis

  • I post frequently
  • ***
  • Posts: 316
  • Karma: 4
    • Forward Support, Inc.
  • CiviCRM version: 4.4-4.5
  • CMS version: Drupal 7
  • MySQL version: 5.5.37-cll
  • PHP version: 5.3.29
Re: Search not pulling everyone
May 25, 2008, 11:41:19 pm
Nope, none more than once. We only have the one membership.
Pages: [1]
  • CiviCRM Community Forums (archive) »
  • Old sections (read-only, deprecated) »
  • Support »
  • Using CiviCRM »
  • Using CiviMember (Moderator: Deepak Srivastava) »
  • Search not pulling everyone

This forum was archived on 2017-11-26.