Deleting Visitor Messages

Discussion in 'vBulletin Discussions' started by kev, Nov 14, 2009.

  1. kev

    kev Regular Member

    Joined:
    Mar 9, 2009
    Messages:
    1,224
    Likes Received:
    61
    Am I missing something here? Members can not hard delete Visitor Messages on their profiles?
     
  2. Nick

    Nick Regular Member

    Joined:
    Jul 27, 2008
    Messages:
    7,441
    Likes Received:
    218
    How to physically delete all visitor messages

    Since members can only soft-delete visitor messages, I periodically head to the moderator section of the UserCP to the deleted visitor messages ( /moderation.php?do=viewvms&type=deleted) and physically delete any VMs the users have removed from their profiles.
     
    2 people like this.
  3. kev

    kev Regular Member

    Joined:
    Mar 9, 2009
    Messages:
    1,224
    Likes Received:
    61
    Is there a way to quickly hard delete 3,347 deleted profile messages?

    This is really sad that I have to remove these manually. As if I dont already have enough to deal with.
     
  4. Nick

    Nick Regular Member

    Joined:
    Jul 27, 2008
    Messages:
    7,441
    Likes Received:
    218
    Perhaps with a query. :shrug:
     
  5. Boss

    Boss Resident Silly Man

    Joined:
    May 23, 2009
    Messages:
    941
    Likes Received:
    23
    Location:
    California
    First Name:
    Alex
    Run these queries:

    DELETE FROM visitormessage

    DELETE FROM visitormessage_hash

    UPDATE user SET vmunreadcount = 0, vmmoderatedcount = 0


    Backup your server first.


    It will permanently remove all visitor messages.
     
  6. Nick

    Nick Regular Member

    Joined:
    Jul 27, 2008
    Messages:
    7,441
    Likes Received:
    218
    I think he only wants to delete the ones that are soft-deleted already.
     
  7. Peacelily

    Peacelily Adept

    Joined:
    Jul 5, 2009
    Messages:
    245
    Likes Received:
    10
    Oooh, I would love to know this query as well.
     
  8. MjrNuT

    MjrNuT Grand Master

    Joined:
    Oct 14, 2009
    Messages:
    579
    Likes Received:
    36
    Curious, what is the benefit of this? Just to remove clutter, unneeded data?
     
  9. Boss

    Boss Resident Silly Man

    Joined:
    May 23, 2009
    Messages:
    941
    Likes Received:
    23
    Location:
    California
    First Name:
    Alex
    Yeah. With Invision I can, as an admin, just hard delete theme with one click, as can members. I find vBulletin's system to be a waste of time and disk resources.
     
  10. kev

    kev Regular Member

    Joined:
    Mar 9, 2009
    Messages:
    1,224
    Likes Received:
    61
    Its taking out the trash, there is no need in having the remains of "deleted" messages laying around.
     
  11. MjrNuT

    MjrNuT Grand Master

    Joined:
    Oct 14, 2009
    Messages:
    579
    Likes Received:
    36
    Oh i see now the issue. Thanks for the explanation. I think you just planted an OCD issue for me now......:adminaddict:

    (should have walked away)
     

Share This Page