Author Topic: Delete All Contacts (Read 5005 times)

Tachikoma · December 18, 2007, 11:56:26 am

What is the best/easiest way to start over with my contact list?
Is it in SQL admin? Or is there a way through CiviCRM Admin?

twowheeler · December 18, 2007, 01:43:19 pm

You could select all contacts (on "find contacts" page, do a search with no groups or tags selected) and then select delete from the drop down list.

yasheshb · December 20, 2007, 11:20:53 pm

How many contacts are to be deleted. I was able to delete 8900 contacts
yesterday but it took about 20 mins to do so.
i've set my
max_execution_time = 3600
to 1 hour in php.ini.

lcdweb · December 24, 2007, 11:12:03 am

I would highly recommend twowheelers suggestion (delete through the find contacts tool) rather than through MySQL. Some of the contact's data are scattered throughout multiple tables. Deleting through CiviCRM ensures all related records are also deleted.

yasheshb · December 27, 2007, 01:47:37 am

in case you want to do it programmatically.. you can use the api's too..

http://wiki.civicrm.org/confluence/display/CRMDOC/Search+APIs
http://wiki.civicrm.org/confluence/display/CRMDOC/Contact+APIs

first search for contacts and delete them.

the crm_delete_contact(&$contact, $userId = null)
does a clean delete (deletes all related data from other tables that depend on the contact).

yashesh

KermitJr · January 05, 2008, 05:28:05 am

I could use some help with this one. When I go to the find contacts page and attempt to search without adding anything, I get:

Code: [Select]

Sorry. A non-recoverable error has occurred.

Could not find valid Key

Return to home page.

I tried entering % as a wildcard, too. and custom search with >=A

Drupal 5.3 and Civic latest (1.9?)

Traceback:
backTrace

/home/opentech/public_html/sites/all/modules/civicrm/CRM/Core/Error.php, backtrace, 255
/home/opentech/public_html/sites/all/modules/civicrm/CRM/Core/Controller.php, fatal, 182
/home/opentech/public_html/sites/all/modules/civicrm/CRM/Core/Controller.php, key, 136
/home/opentech/public_html/sites/all/modules/civicrm/CRM/Contact/Controller/Search.php, __construct, 59
/home/opentech/public_html/sites/all/modules/civicrm/CRM/Core/Invoke.php, __construct, 457
/home/opentech/public_html/sites/all/modules/civicrm/CRM/Core/Invoke.php, search, 378
/home/opentech/public_html/sites/all/modules/civicrm/CRM/Core/Invoke.php, contact, 92
/home/opentech/public_html/sites/all/modules/civicrm/drupal/civicrm.module, invoke, 319
, civicrm_invoke,
/home/opentech/public_html/includes/menu.inc, call_user_func_array, 418
/home/opentech/public_html/index.php, menu_execute_active_handler, 15

unrecoverable error
Sorry. A non-recoverable error has occurred.

Could not find valid Key

Return to home page.

I want to list all my contacts.
Thanks!
KermitJr

penguinhead · January 20, 2008, 02:49:01 am

I a having exactly the same problem, has anyone got a resolution to this issue? It seems quite common throughout the forum, but can't see any answers?

mennonot · July 15, 2009, 11:40:19 am

Kermit and Penguin,

I had this same problem when trying to delete all contacts. I found the solution here:

http://issues.civicrm.org/jira/browse/CRM-1894

I ran this mysql query in the database with my Drupal tables:

ALTER TABLE sessions CONVERT TO CHARACTER SET utf8;

Hope this works for you and anyone else who comes across this topic.

CiviCRM Community Forums (archive)

News:

Author Topic: Delete All Contacts (Read 5005 times)

Tachikoma

Delete All Contacts

twowheeler

Re: Delete All Contacts

yasheshb

Re: Delete All Contacts

lcdweb

Re: Delete All Contacts

yasheshb

Re: Delete All Contacts

KermitJr

Re: Delete All Contacts

penguinhead

Re: Delete All Contacts

mennonot

Re: Sorry. A non-recoverable error has occurred.