Results 1 to 4 of 4

Thread: Purge DB of all item with deleted = 1

  1. 2009-05-18, 04:42 PM #1
    chrislynch8's Avatar
    chrislynch8
    chrislynch8 is offline Sugar Community Member
    Send a message via MSN to chrislynch8
    Join Date
    Oct 2007
    Location
    Cork, Ireland
    Posts
    747

    Default Purge DB of all item with deleted = 1

    Hi,

    I want to remove everything with deleted = 1 in my DB. I know sugar has a process to do this, but sometime that fails. I want to create a script that I can manage on the server to do this outside of sugarCRM.

    What commands to I need to delete * from * where deleted = 1

    Rgds
    Chris
    Linkedin Profile:Chris Lynch

    FDC IT Solutions
    FDC House
    Wellington Road
    Cork
    Ireland
    Reply With Quote Reply With Quote
  2. 2009-05-18, 05:26 PM #2
    andopes's Avatar
    andopes
    andopes is offline A Sugar Hero | Help Forum Moderator
    Send a message via MSN to andopes Send a message via Skype™ to andopes
    Join Date
    Jul 2006
    Location
    São Paulo - Brazil
    Posts
    8,335

    Default Re: Purge DB of all item with deleted = 1

    Hi Chris

    Have a look on the function pruneDatabase at modules/Schedulers/_AddJobsHere.php

    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.
    Reply With Quote Reply With Quote
  3. 2009-05-19, 09:19 AM #3
    chrislynch8's Avatar
    chrislynch8
    chrislynch8 is offline Sugar Community Member
    Send a message via MSN to chrislynch8
    Join Date
    Oct 2007
    Location
    Cork, Ireland
    Posts
    747

    Default Re: Purge DB of all item with deleted = 1

    Thanks

    thats what I was looking for.

    Rgds
    Chris
    Linkedin Profile:Chris Lynch

    FDC IT Solutions
    FDC House
    Wellington Road
    Cork
    Ireland
    Reply With Quote Reply With Quote
  4. 2009-08-04, 12:57 PM #4
    chrislynch8's Avatar
    chrislynch8
    chrislynch8 is offline Sugar Community Member
    Send a message via MSN to chrislynch8
    Join Date
    Oct 2007
    Location
    Cork, Ireland
    Posts
    747

    Default Re: Purge DB of all item with deleted = 1

    Is there a way to get this job to prune the the cstm tables also?
    Linkedin Profile:Chris Lynch

    FDC IT Solutions
    FDC House
    Wellington Road
    Cork
    Ireland
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. How to purge an email account?
    By kickedmydog in forum Help
    Replies: 2
    Last Post: 2008-02-28, 09:47 PM
  2. 5.0.0a with IMAP account: auto-purge?
    By bluefox112 in forum Help
    Replies: 0
    Last Post: 2008-01-17, 09:22 PM
  3. purge ./sugar/cache -- old installer details?
    By dsga1 in forum General Discussion
    Replies: 0
    Last Post: 2007-03-06, 04:14 AM
  4. Purge of Sample Data
    By wtkachuk in forum Help
    Replies: 1
    Last Post: 2005-02-14, 06:48 PM

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
  •  

Forum Rules