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) »
  • Strangeness after running UpdateMembershipRecord.php
Pages: [1]

Author Topic: Strangeness after running UpdateMembershipRecord.php  (Read 2219 times)

alexlyn

  • Guest
Strangeness after running UpdateMembershipRecord.php
October 20, 2008, 09:02:47 am
I just learned about the UpdateMembershipRecord.php script recently, and ran it on my site last night.  It unexpectedly (to me at least) generated many e-mail reminders to past and present members, which is hopefully a one-time issue.  I'll know tonight when the job runs again  :).

Since running UpdateMembershipRecord.php, I have over 100 Activities showing on the CiviCRM home page.  In the past, I have never had activities shown on the home page.  See the attached screen shot.

What's strange is that the activities are shown in red, and there doesn't seem to be a way to clear them.  When I click the "View" link beside an activity, I get the following error message:

warning: Invalid argument supplied for foreach() in /home/ciacom/public_html/sites/all/modules/civicrm/CRM/Core/BAO/CustomGroup.php on line 1155.

My site is running CiviCRM 2.03.

Any ideas what's going on here?

Thanks in advance,
Alex.


Yashodha Chaku

  • Forum Godess / God
  • Ask me questions
  • *****
  • Posts: 755
  • Karma: 57
    • CiviCRM
Re: Strangeness after running UpdateMembershipRecord.php
October 20, 2008, 10:32:08 am
Quote
Since running UpdateMembershipRecord.php, I have over 100 Activities showing on the CiviCRM home page.  In the past, I have never had activities shown on the home page.

Since you ran UpdateMembershipRecord.php which updated the statuses, so Activities got recorded.

Quote
What's strange is that the activities are shown in red, and there doesn't seem to be a way to clear them.  When I click the "View" link beside an activity, I get the following error message:

warning: Invalid argument supplied for foreach() in /home/ciacom/public_html/sites/all/modules/civicrm/CRM/Core/BAO/CustomGroup.php on line 1155.

Creation of Activities is valid behavior, but instead of scheduled it should have Completed status. I think was bug and is been fixed in latest 2.0.x release. I would recommend to upgrade your installation 2.1.

HTH
-Yashodha



Found this reply helpful? Contribute NOW and help us improve CiviCRM with the Make it Happen! initiative.

alexlyn

  • Guest
Re: Strangeness after running UpdateMembershipRecord.php
October 20, 2008, 10:46:48 am
Yashodha,

Thanks for your quick reply!

Is there anything I can do to change activity status to Completed now that they're in the Scheduled state?  A SQL query, for example?

I am planning on upgrading to 2.1, but it will take a bit of testing because it requires that I move to Drupal 6 as well. 

Alex.

Yashodha Chaku

  • Forum Godess / God
  • Ask me questions
  • *****
  • Posts: 755
  • Karma: 57
    • CiviCRM
Re: Strangeness after running UpdateMembershipRecord.php
October 20, 2008, 11:55:00 am
You could fire an SQL query :

Code: [Select]
UPDATE `civicrm_activity` SET `status_id` = 2 WHERE (
`activity_type_id` = 7 OR `activity_type_id` = 8
) AND `status_id` =1

Yet I would suggest upgrading to at least latest 2.0.x release.

-Yashodha
« Last Edit: October 20, 2008, 02:12:29 pm by Kurund Jalmi »
Found this reply helpful? Contribute NOW and help us improve CiviCRM with the Make it Happen! initiative.

organicathlete

  • Guest
Re: Strangeness after running UpdateMembershipRecord.php
October 22, 2008, 04:59:46 pm
I have the same issue on 2.0.5, and yes, it was a bug.  I found the record of it here.   I can't tell if 2.0.6 fixes it, though it looks like this issue was filed in September and 2.0.6 was released in August.   The issue shows resolved, but there doesn't appear to be anyway to fix it in 2.0.  Any clues?

We want to upgrade to 2.1, but we're waiting on other drupal modules to release 6.0 compatible versions.

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: Strangeness after running UpdateMembershipRecord.php
October 22, 2008, 05:41:48 pm
You can get the patch from http://fisheye.civicrm.org/viewrep/CiviCRM/branches/v2.0/api/Membership.php?r1=13630&r2=17037

Kurund
Found this reply helpful? Support CiviCRM

Denver Dave

  • Ask me questions
  • ****
  • Posts: 471
  • Karma: 9
Re: Strangeness after running UpdateMembershipRecord.php
October 26, 2008, 07:55:54 pm
I think we are ready to have the status updated, but may not be ready to send reminder emails to the whole past batch.  In the Member Types setup screen, if a Renewal Reminder Message is not selected and a Renewal Reminder Day is not set, will a reminder email be sent?  Sounds like from the first post in this thread, that it might be.

Any insights?

lcdweb

  • Forum Godess / God
  • I live on this forum
  • *****
  • Posts: 1620
  • Karma: 116
    • www.lcdservices.biz
  • CiviCRM version: many versions...
  • CMS version: Joomla/Drupal
  • MySQL version: 5.1+
  • PHP version: 5.2+
Re: Strangeness after running UpdateMembershipRecord.php
October 31, 2008, 12:23:41 pm
Dave --
Correct. You determine if a reminder notice goes out through the member type config. This way you can choose if there are some member types that you want to have receive reminders, and others that you don't. And you can also disable all reminders, per your post, in which case the update script simply takes care of the membership status updates.
support CiviCRM through 'make it happen' initiatives!
http://civicrm.org/mih

Pages: [1]
  • CiviCRM Community Forums (archive) »
  • Old sections (read-only, deprecated) »
  • Support »
  • Using CiviCRM »
  • Using CiviMember (Moderator: Deepak Srivastava) »
  • Strangeness after running UpdateMembershipRecord.php

This forum was archived on 2017-11-26.