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) »
  • UpdateMembershipRecord.php - timing out
Pages: [1]

Author Topic: UpdateMembershipRecord.php - timing out  (Read 971 times)

lsankar

  • Guest
UpdateMembershipRecord.php - timing out
August 18, 2009, 10:40:21 am
Hi,

I am trying to update membership status by running UpdateMembershipRecord.php. The membership table has about 575 records. The script executes for a while and then ends with 404 error message and the statuses do not get updated.

This is the command I issued and the result - I have masked the site details, password etc

wget 'http://mywebsite/administrator/components/com_civicrm/civicrm/bin/UpdateMembershipRecord.php?name=username&pass=password&key=sitekey'

=> `UpdateMembershipRecord.php?name=username&pass=password&key=sitekey'
Resolving mywebsite.org... xx.xx.xx.xx
Connecting to mywebsite.org|xx.xx.xx.xx|:80... connected.
HTTP request sent, awaiting response... 404 Component not found
10:28:00 ERROR 404: Component not found.

I know the script exists and works fine because when I tested with just 10 membership records, the script executes properly.

I tried adding set_time_limit(0) to the beginning of the Updatemembershiprecord.php hoping to overrride the PHP max execution time - it did not help. I still get the 404 error.

Could you please help? Please let know if you need any other info.

My civicrm version: CiviCRM 2.2.7
Joomla version: 1.5.12
PHP Version 5.2.9
MySQL version 5.0.32

Thanks
Sankar

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: UpdateMembershipRecord.php - timing out
August 18, 2009, 11:14:51 am

1. who's the hosting provider? can you check with them and see if they can allow long running scripts

2. alternatively if u are a PHP programmer, you might want to modify the script and do a few chunks at a time using the LIMIT/OFFSET clause and then call it repeatedly. If you do so, please publish your changes

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

lsankar

  • Guest
Re: UpdateMembershipRecord.php - timing out
August 18, 2009, 02:27:40 pm
Thanks a lot for your response. I contacted the hosting provider Dreamhost. The max execution time is set to 90 secs. Dreamhost support suggested me to create a custom ini file to override the execution time. I have not had a chance to try your second suggestion.

In case some one needs this for future, here is a link for creating custom ini file. The thread refers to increasing upload size, but apparently it can be used for other ini variables

http://www.activecollab.com/forums/topic/1507/






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

This forum was archived on 2017-11-26.