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

feeds.attachments_base - server 500 error for large attachment tables

    Details

    • Type: Bug
    • Status: Closed (View Workflow)
    • Priority: Major
    • Resolution: Fixed
    • Affects Version/s: 3.1.10, 3.2.0-RC1
    • Fix Version/s: 3.1.11-RC1, 3.2.0
    • Component/s: Other
    • Labels:
    • Environment:

      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

            • Assignee:
              Marc Marc
              Reporter:
              jcocking jcocking
            • Votes:
              0 Vote for this issue
              Watchers:
              3 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved: