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) »
  • Unable to delete contacts in search
Pages: [1]

Author Topic: Unable to delete contacts in search  (Read 538 times)

TJH43

  • I’m new here
  • *
  • Posts: 24
  • Karma: 0
  • CiviCRM version: 4.4.5
  • CMS version: Drupal 7.27
  • MySQL version: 5.5.37
  • PHP version: 5.3.10
Unable to delete contacts in search
September 22, 2012, 08:11:47 am
Did a tag search in Find Contacts resulting in 128,243 Individuals found.  Select records: All 128,243.  Requested action "Delete permanently".  After about a minute got a white screen at:
http://www.example.com/civicrm/contact/search?_qf_Delete_display=true&qfKey=cc42e1fe7a70df15dc4be71a90b94782_2464.

Searching for the same tag again I still get 128,243 contacts found.

Tried clearing all caches.  No luck.

I also tried deleting 50 at a time.  That seems to work.  I get the warning page "are you sure..." I select "Delete Contact(s)" The next page does not seem to fully load in Firefox.  But the contacts are deleted. When I do another search the contact total is 50 less.

However, deleting 50 at a time is not going to work because of the time involved.  I'm on deadline.

My short term plan is to install another newer instance of CiviCRM so I can upload new contact info and produce mail labels.
Currently running:
CiviCRM 4.0.7
Drupal 7.9

TJH43

  • I’m new here
  • *
  • Posts: 24
  • Karma: 0
  • CiviCRM version: 4.4.5
  • CMS version: Drupal 7.27
  • MySQL version: 5.5.37
  • PHP version: 5.3.10
Re: Unable to delete contacts in search
September 22, 2012, 09:36:21 am
Found these in the Recent log messages at about the same time I had this problem:

Referer was: civicrm/contact/search/builder?reset=1
Location was: /civicrm/contact/search/builder
Notice: Undefined index: tag in CRM_Contact_Selector->getColumnHeaders() (line 446 of /var/www/JPS2012/sites/all/modules/civicrm/CRM/Contact/Selector.php).

Referrer was: civicrm/dashboard
Location was: civicrm/ajax/contactactivity?snippet=4&context=dashlet&cid=1
Notice: Undefined index: sortBy in CRM_Activity_BAO_Activity::getContactActivitySelector() (line 2280 of /var/www/JPS2012/sites/all/modules/civicrm/CRM/Activity/BAO/Activity.php).

TJH43

  • I’m new here
  • *
  • Posts: 24
  • Karma: 0
  • CiviCRM version: 4.4.5
  • CMS version: Drupal 7.27
  • MySQL version: 5.5.37
  • PHP version: 5.3.10
Re: Unable to delete contacts in search
September 22, 2012, 12:30:38 pm
My DB has 128K contact records. I notice that the civicrm_prevnext_cache table has 4 Mil records and is using 1.1GB  of storage.   Should I empty this table in phpMyAdmin?

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: Unable to delete contacts in search
September 22, 2012, 02:26:44 pm

yes, you can truncate the table

there is a scheduled job that you should run on a regular basis to do this task (and other cleanup stuff)

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
Pages: [1]
  • CiviCRM Community Forums (archive) »
  • Old sections (read-only, deprecated) »
  • Support »
  • Using CiviCRM »
  • Using Core CiviCRM Functions (Moderator: Yashodha Chaku) »
  • Unable to delete contacts in search

This forum was archived on 2017-11-26.