Delete Sent Messages for User does not work in 5.2.3

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • craigyb
    Member
    • Jun 2008
    • 36

    Delete Sent Messages for User does not work in 5.2.3

    "Delete Sent Messages for User" does not work in 5.2.3
    From user AdminCP

    When you run it again it says their are no sent messages left but the user is still over their quota and stats show they are still there.
    The process thinks the PMs are deleted.

    Delete All Messages works fine from user AdminCP.

    I have a user with over 65535 messages and 64000 are in the sent folder.
    They cannot send PMs until they are below the maximum.
    There is no way to remove some without removing all.
    Unless you want to delete this many 20 at a time.

    thanks
  • Mark.B
    vBulletin Support
    • Feb 2004
    • 24286
    • 6.0.X

    #2
    I'm not sure this process works from the AdminCP. I have a feeling it's a leftover from vB4. I'll have to do some testing but I'm fairly certain these have to be deleted by the user from the front end.
    MARK.B
    vBulletin Support
    ------------
    My Unofficial vBulletin 6.0.0 Demo: https://www.talknewsuk.com
    My Unofficial vBulletin Cloud Demo: https://www.adminammo.com

    Comment

    • craigyb
      Member
      • Jun 2008
      • 36

      #3
      How does he delete 64,000 from the front end?
      Then how do you empty the trash?

      Delete all messages works fine but he also has 2000 messages in his inbox I don't want to delete.
      Don't seem figure out any way to export them out and SQL queries sound like they are really tricky.


      Comment

      • craigyb
        Member
        • Jun 2008
        • 36

        #4
        Well I managed to clear out the trash folder through PHP Admin using these queries.
        Sorry to lazy to write it into an all in one query but you get the idea.

        Code:
        DELETE FROM `$Database`.`node` WHERE `node`.`nodeid` = 895843 AND `node`.`userid` = 1903;
        DELETE FROM `$Database`.`sentto` WHERE `sentto`.`nodeid` = 895843 AND `sentto`.`userid` = 1903 AND `sentto`.`folderid` = 13675;
        DELETE FROM `$Database`.`privatemessage` WHERE `privatemessage`.`nodeid` = 895843;
        13675 is the folder id of trash for this user so this should work for other folders if you know their ID.
        Each user has different folder IDs so you will have to look it up by user id.

        Code:
        [URL="https://dani.rockheartmedia.org:2087/cpsess0826357819/3rdparty/phpMyAdmin/url.php?url=http%3A%2F%2Fdev.mysql.com%2Fdoc%2Frefman%2F5.6%2Fen%2Fselect.html&token=bc2c4677b1459cd36e11baca296caa73"]SELECT[/URL] * FROM `messagefolder`WHERE `userid` [URL="https://dani.rockheartmedia.org:2087/cpsess0826357819/3rdparty/phpMyAdmin/url.php?url=http%3A%2F%2Fdev.mysql.com%2Fdoc%2Frefman%2F5.6%2Fen%2Fcomparison-operators.html%23operator_equal&token=bc2c4677b1459cd36e11baca296caa73"]=[/URL] 1903
        Click image for larger version

Name:	phpadmin.jpg
Views:	200
Size:	77.2 KB
ID:	4350558
        Attached Files
        Last edited by craigyb; Fri 12 Aug '16, 3:03pm.

        Comment

        • craigyb
          Member
          • Jun 2008
          • 36

          #5
          That still didn't help.

          the stats show the user is under the limit but he still cannot send messages.

          What is stopping this. He cannot delete anything cause it just goes to trash.
          I thought I emptied the trash and still he cannot send messages.

          Is there some flag when they go over the limit somewhere?

          This is ridiculous that PMs cannot be properly managed.

          Can the PM limit be increased? I have set it higher than the maximum like 100,000 but it just reverts to the maximum.

          How can i fix this user?
          It doesn't appear to me that there is actually any way to clear out trash or deleted messages.
          Even straight from the database it doesn't work.

          Comment

          • glennrocksvb
            Former vBulletin Developer
            • Mar 2011
            • 4011
            • 5.7.X

            #6
            Try clearing system cache in AdminCP.

            Flag Icon Postbit Insert GIPHY Impersonate User BETTER INITIALS AVATAR Better Name Card Quote Selected Text Bookmark Posts Post Footer Translate Stop Links in Posts +MORE!

            Comment

            • Wayne Luke
              vBulletin Technical Support Lead
              • Aug 2000
              • 73981

              #7
              Choose "Delete All User's Private Messages" from the quick links drop down.

              Deleting messages sent by the user doesn't affect their own private messages. It is an anti-spam tool to clear the messages they sent to others before you ban or delete them.
              Translations provided by Google.

              Wayne Luke
              The Rabid Badger - a vBulletin Cloud demonstration site.
              vBulletin 5 API

              Comment

              Related Topics

              Collapse

              Working...