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) »
  • Some activities missing in 4.0.5
Pages: [1]

Author Topic: Some activities missing in 4.0.5  (Read 1795 times)

Stuart Parker

  • I post occasionally
  • **
  • Posts: 64
  • Karma: 2
  • CiviCRM version: 4.5.2
  • CMS version: Drupal 7
  • MySQL version: 5.1.63
  • PHP version: 5.2.14
Some activities missing in 4.0.5
August 05, 2011, 01:38:53 am
After upgrading to 4.0.5, I'm finding that for some contacts only about 5 activities are shown under the Activities tab for a given contact. The summary tab correctly shows the full number of activities.

For example, one contact has 41 activities. On the first page under the Activities tab, 5 activities are shown. If I click on the page counter at the bottom, I get another list of 4 activities and it says "Showing 26 to 41 of 41 entries".

Any ideas?

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: Some activities missing in 4.0.5
August 05, 2011, 04:02:43 am
I am not sure I understood your problem, if possible can you attach screenshots.

Kurund
Found this reply helpful? Support CiviCRM

Stuart Parker

  • I post occasionally
  • **
  • Posts: 64
  • Karma: 2
  • CiviCRM version: 4.5.2
  • CMS version: Drupal 7
  • MySQL version: 5.1.63
  • PHP version: 5.2.14
Re: Some activities missing in 4.0.5
August 05, 2011, 05:59:58 am
Ok, sure. Here is a screenshot. I've just scrubbed private information.

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: Some activities missing in 4.0.5
August 06, 2011, 01:02:18 am
I am not able to replicate on my local nor on demo. Looks like your db is slightly messed up. Can you try to replicate this on http://drupal.demo.civicrm.org

Kurund
Found this reply helpful? Support CiviCRM

Stuart Parker

  • I post occasionally
  • **
  • Posts: 64
  • Karma: 2
  • CiviCRM version: 4.5.2
  • CMS version: Drupal 7
  • MySQL version: 5.1.63
  • PHP version: 5.2.14
Re: Some activities missing in 4.0.5
August 06, 2011, 01:29:51 am
Hi Kurund. Thanks for looking at this. No, I can't replicate it on the demo.

On my installation, the database still has all the activities, but Civi is only showing the most recent third/quarter of activities for most contacts, although the displayed count is correct.

Any ideas for how to fix the database?

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: Some activities missing in 4.0.5
August 06, 2011, 01:43:15 am
I guess you will have to debug the query generated for activity selector. That might give you some idea for this behavior

Kurund
Found this reply helpful? Support CiviCRM

Stuart Parker

  • I post occasionally
  • **
  • Posts: 64
  • Karma: 2
  • CiviCRM version: 4.5.2
  • CMS version: Drupal 7
  • MySQL version: 5.1.63
  • PHP version: 5.2.14
Re: Some activities missing in 4.0.5
August 06, 2011, 04:35:59 am
Ok, it's not me going mad. :o

I have now replicated this on the demo site. Basically, it's caused by activities that are "With" multiple contacts. Somehow, all of the other contacts are counted within the 25 (or whatever) to be shown. This restricts the list of activities shown beneath such an activity.

If you go into the demo site and look at the activities under "Test Registrant", you'll see that I've put a phone call activity in there with lots of people and the activities below it are not shown:
http://drupal.demo.civicrm.org/civicrm/contact/view?action=browse&reset=1&cid=103&selectedChild=activity

Looks like a bug to me, as it didn't used to do this.

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: Some activities missing in 4.0.5
August 06, 2011, 04:43:57 am
Thanks for the details analysis of the problem, please go ahead and file a bug report in issue tracker.

Kurund
Found this reply helpful? Support CiviCRM

Stuart Parker

  • I post occasionally
  • **
  • Posts: 64
  • Karma: 2
  • CiviCRM version: 4.5.2
  • CMS version: Drupal 7
  • MySQL version: 5.1.63
  • PHP version: 5.2.14
Re: Some activities missing in 4.0.5
August 06, 2011, 05:00:39 am
Ok, I've filed a report

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: Some activities missing in 4.0.5
August 06, 2011, 05:30:53 am
for tracking purpose: http://issues.civicrm.org/jira/browse/CRM-8613

Kurund
Found this reply helpful? Support CiviCRM

davej

  • Ask me questions
  • ****
  • Posts: 404
  • Karma: 21
Re: Some activities missing in 4.0.5
August 18, 2011, 08:22:25 am
Same problem here in 3.4.5 . Thanks for filing the issue.

Dave J

Pages: [1]
  • CiviCRM Community Forums (archive) »
  • Old sections (read-only, deprecated) »
  • Support »
  • Upgrading CiviCRM (Moderator: Deepak Srivastava) »
  • Some activities missing in 4.0.5

This forum was archived on 2017-11-26.