Results 1 to 5 of 5

Thread: Delete All Contacts

  1. #1
    Join Date
    Apr 2010
    Posts
    6

    Default Delete All Contacts

    Hello,
    I have SugarCE Version 5.5.1 (Build 1202) and when I try to delete all contacts the webserver crashes and the contacts are not all deleted. I can delete many at a time (tested up to 100). Any ideas?

    Thanks,

    Jordan

  2. #2
    andopes's Avatar
    andopes is offline A Sugar Hero | Help Forum Moderator
    Join Date
    Jul 2006
    Location
    São Paulo - Brazil
    Posts
    8,335

    Default Re: Delete All Contacts

    Probably you are facing a memory limit issue on php.
    Consider updating the value of attribute memory_limit to 256M at php.ini and restart your web server.

    Cheers
    André Lopes
    DevToolKit / Project of the Month - June 2009
    Lampada Global Services- Open Source Solutions
    Avenida Ipiranga, 318
    Bloco B - CJ 1602
    São Paulo, SP 01046-010
    Brazil
    Office: +55 11 3237-3110
    Mobile: +55 11 7636-5859
    e-mail: andre@lampadaglobal.com

    Lampada Global delivers offshore software development and support services to customers around the world.
    Lampada is proud to be a SugarCRM Gold Partner, revolutionizing Customer Relationship Management.

    I DO NOT answer questions through PM and Email. If you need some help post your question into SugarForum.

  3. #3
    Join Date
    Apr 2010
    Posts
    6

    Default Re: Delete All Contacts

    Thank you, the memory_limit was set to 256M but the timeout was set to 60 seconds and the delete process was taking longer than that so I changed the time to 300 and now it works perfectly.

    Regards,

    Jordan

  4. #4
    Join Date
    Apr 2010
    Posts
    6

    Default Re: Delete All Contacts

    Now that I upgraded to Beta6 the timelimit in the php.ini seems to get ignored and is always set at 60 seconds, could the upgrade point to a different php.ini somewhere?

    Thanks,

  5. #5
    Gumbercules is offline Junior Member
    Join Date
    Dec 2008
    Posts
    1

    Default Re: Delete All Contacts

    Run this in MySQL:

    UPDATE contacts SET deleted='1';

    That will have the same net effect as Sugar's delete all option - but it won't abuse PHP memory usage.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. How do I delete fields from 'Contacts'
    By ianmcgreene in forum Help
    Replies: 1
    Last Post: 2008-12-08, 08:58 AM
  2. Delete Contacts
    By nieboerb in forum Help
    Replies: 2
    Last Post: 2008-01-30, 06:51 PM
  3. HELP : Where to Delete Multiple COntacts
    By stefang in forum Help
    Replies: 2
    Last Post: 2006-06-09, 04:18 AM
  4. How to delete all contacts
    By whatley in forum Help
    Replies: 2
    Last Post: 2005-10-24, 01:50 PM
  5. SQL delete contacts
    By bjs3 in forum General Discussion
    Replies: 4
    Last Post: 2005-07-17, 01:56 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •