Private message 500 error

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • yi.zhou@xplusz.com
    Member
    • Feb 2017
    • 31
    • 5.2.x

    [Bug / Issue] Private message 500 error

    Hi there, I have run into 500 error when I create private message, the message did get sent but it didn't save in sent items folder, and this only happen to one of my forum which has 250k users. I did some investigating, I think I found the issue, but don't know how to fix it.
    In core/vb/library/content/privatemessage.php, line 555.

    PHP Code:
                $includeFoldersQry $this->assertor->getRows('vBForum:messagefolder', array(
                        
    vB_dB_Query::TYPE_KEY => vB_dB_Query::QUERY_SELECT,
                        
    'titlephrase'=> array(self::TRASH_FOLDERself::MESSAGE_FOLDER),
                        
    vB_dB_Query::COLUMNS_KEY => array('folderid')
                    )
                );
                
    $includeFolders = array(-1);    // -1 so that array is not empty. Other wise IN clause breaks

                
    foreach($includeFoldersQry AS $includeFolder)
                {
                    
    $includeFolders[] = $includeFolder['folderid'];
                } 
    This select all user's folder that is "trash" and "message", in my case I have around 1.5 million record in messagefolder table, and script just die here try to select all those folder, I assume it should return around 375k result, since each user has 8 folder and select two folder from it. However this query took too long and it just give me 500 error instead



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

    #2
    Fixing bugs like this is out of the scope of the technical support we can provide. 1.5 Million Private Messages for one person is an obscene amount. Even 375K for one person is an obscene amount. My recommendation would be to delete the majority of these old archived messages.

    You will need to create a JIRA here: http://tracker.vbulletin.com/secure/...91&issuetype=1
    Translations provided by Google.

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

    Comment

    • yi.zhou@xplusz.com
      Member
      • Feb 2017
      • 31
      • 5.2.x

      #3
      Hi Wayne Luke , sorry I didn't mean one user have 1.5 million private message, when new user register, it creates 8 folder in the messagefolder table, because I have 250K user, now there are 1.5 million record in my messagefolder, 8 folders per user, but that sql statement select all user's folder that is "trash" and "message" which I don't understand why.

      Click image for larger version

Name:	Screen Shot 2017-09-27 at 11.50.46 AM.png
Views:	81
Size:	28.5 KB
ID:	4378113

      Comment

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

        #4
        Still has to be listed as a bug as stated. Technical Support representatives don't write code.
        Translations provided by Google.

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

        Comment

        Related Topics

        Collapse

        Working...