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) »
  • Delete Member Timeout
Pages: [1]

Author Topic: Delete Member Timeout  (Read 1413 times)

cvining

  • I’m new here
  • *
  • Posts: 6
  • Karma: 0
  • CiviCRM version: 4.05
  • CMS version: Drupal 7
  • MySQL version: 5.0.92-50
  • PHP version: 5.2.17
Delete Member Timeout
September 21, 2011, 06:46:38 pm
OK, so I messed up on importing several hundred Membership records.  I used a Member search to identify the records I wanted to delete.  Some 300+ records.  It timed out.

By trial and error I found I could only delete three Membership records at a time without timing out.

Anyone else see this problem?  Anything to be done?  I'm using v.4.05 integrated with Drupal 7.

Right now I'm deleting 3 records at a time!

  -- Cronin

Erik Hommel

  • Forum Godess / God
  • I live on this forum
  • *****
  • Posts: 1773
  • Karma: 59
    • EE-atWork
  • CiviCRM version: all sorts
  • CMS version: Drupal
  • MySQL version: Ubuntu's latest LTS version
  • PHP version: Ubuntu's latest LTS version
Re: Delete Member Timeout
September 22, 2011, 02:24:09 am
hmmmm I am not too familiar with the database structure around memberships, otherwise I would have an MySQL statement for you....is it just the membership records you want to delete? Not the contact?
Consultant/project manager at EEatWork and CiviCooP (http://www.civicoop.org/)

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: Delete Member Timeout
September 22, 2011, 06:42:24 am

where are you hosting this site? 3 seems like an awfully small number / which most likely means you are running on a fairly slow server

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

cvining

  • I’m new here
  • *
  • Posts: 6
  • Karma: 0
  • CiviCRM version: 4.05
  • CMS version: Drupal 7
  • MySQL version: 5.0.92-50
  • PHP version: 5.2.17
Re: Delete Member Timeout
September 23, 2011, 03:53:22 am
Quote from: Donald Lobo on September 22, 2011, 06:42:24 am

where are you hosting this site? 3 seems like an awfully small number / which most likely means you are running on a fairly slow server

lobo

That's useful information for me.  It means it's not generic Civicrm thing, but has something to do with my setup/resources/configuration.  Good to know.

I'm using hotdrupal.com to host the site.  It is a shared server, but normally the performance has been pretty satisfactory.  Really, I've been quite happy with them for several years now.   I've got close to 6000 contacts.   Importing 500 contacts, and 500 memberships in a separate step, went pretty smoothly for example.

Now, that said, I'm always open to a better host.  Do you have any recommendations?  I'm budget conscious, but I'm always happy to pay more for value.

BTW, I solved my particular problem by restoring my civicrm database to the point before I started my latest updates (which I mainly do just once a year).  Thank goodness for backups!

  -- Cronin

Hershel

  • Forum Godess / God
  • I’m (like) Lobo ;)
  • *****
  • Posts: 4640
  • Karma: 176
    • CiviHosting
  • CiviCRM version: Latest
  • CMS version: Mostly WordPress and Drupal
Re: Delete Member Timeout
September 23, 2011, 07:54:00 am
I do not recall running a delete on 300 contacts on a shared host, but 3 is certainly extremely small and the maximum should be far greater. As noted, this is purely a matter of system resources (of course CiviCRM could potentially be optimized more, but that's a separate issue).

The About CiviCRM page ( http://civicrm.org/aboutcivicrm ) says:

CiviCRM is resource-intensive. We encourage users to consider Virtual Private Servers (VPS) OR (semi) dedicated hosting OR shared hosting from a host with experience hosting CiviCRM. Please review our Hosting provider information page for hosting options
CiviHosting and CiviOnline -- The CiviCRM hosting experts, since 2007

See here for the official: What to do if you think you've found a bug.
Pages: [1]
  • CiviCRM Community Forums (archive) »
  • Old sections (read-only, deprecated) »
  • Support »
  • Using CiviCRM »
  • Using Core CiviCRM Functions (Moderator: Yashodha Chaku) »
  • Delete Member Timeout

This forum was archived on 2017-11-26.