Deleting Visitor Messages

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

  1. kev

    kev Regular Member

    1,224
    61
    434
    Am I missing something here? Members can not hard delete Visitor Messages on their profiles?
     
  2. Nick

    Nick Regular Member

    7,441
    218
    458
    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

    1,224
    61
    434
    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

    7,441
    218
    458
    Perhaps with a query. :shrug:
     
  5. Boss

    Boss Resident Silly Man

    941
    23
    104
    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

    7,441
    218
    458
    I think he only wants to delete the ones that are soft-deleted already.
     
  7. Peacelily

    Peacelily Adept

    245
    10
    104
    Oooh, I would love to know this query as well.
     
  8. MjrNuT

    MjrNuT Grand Master

    579
    36
    104
    Curious, what is the benefit of this? Just to remove clutter, unneeded data?
     
  9. Boss

    Boss Resident Silly Man

    941
    23
    104
    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

    1,224
    61
    434
    Its taking out the trash, there is no need in having the remains of "deleted" messages laying around.
     
  11. MjrNuT

    MjrNuT Grand Master

    579
    36
    104
    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