Announcement

Collapse
No announcement yet.

Help: How to delete ALL pms from ALL users

Collapse
X
 
  • Filter
  • Time
  • Show
Clear All
new posts

  • Help: How to delete ALL pms from ALL users

    Is there an option for vB to delete all the PM's from all users? If so, please tell me how. Thank you!

  • #2
    Theres no option but I can give you a query to do so, but it would be 100% irreversable.

    Comment


    • #3
      Could you please do so, with complete instructions.

      I just want to start all PM's from scratch.

      Comment


      • #4
        To delete all PMs, run these 4 queries:

        UPDATE `user` SET `pmtotal` = '0',`pmunread` = '0';
        TRUNCATE TABLE `pm`;
        TRUNCATE TABLE `pmtext`;
        TRUNCATE TABLE `pmreceipt`;


        Of course, backup your database first.
        Steve Machol, former vBulletin Customer Support Manager (and NOT retired!)
        Change CKEditor Colors to Match Style (for 4.1.4 and above)

        Steve Machol Photography


        Mankind is the only creature smart enough to know its own history, and dumb enough to ignore it.


        Comment

        widgetinstance 262 (Related Topics) skipped due to lack of content & hide_module_if_empty option.
        Working...
        X