Uploaded image for project: 'phpBB3'
  1. phpBB3
  2. PHPBB3-14838

feeds.attachments_base - server 500 error for large attachment tables

    XMLWordPrintable

Details

    • Bug
    • Status: Closed (View Workflow)
    • Major
    • Resolution: Fixed
    • 3.1.10, 3.2.0-RC1
    • 3.1.11-RC1, 3.2.0
    • Other

    Description

      Function: feeds.attachments_base.fetch_attachments
      The sql query pulls all attachments from the attachments table. For phpBB installations with large attachment tables, this causes memory overload/server 500 issues.

      The sql query needs to be time boxed based on the a.filetime of the oldest post.post_time.

      For my temporary work around:
      https://www.phpbb.com/community/viewtopic.php?f=466&t=2390801&p=14544781#p14544781

      Attachments

        Activity

          People

            Marc Marc
            jcocking jcocking [X] (Inactive)
            Votes:
            0 Vote for this issue
            Watchers:
            3 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved: