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

feeds.attachments_base - server 500 error for large attachment tables

    XMLWordPrintable

    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 [X] (Inactive)
            Votes:
            0 Vote for this issue
            Watchers:
            3 Start watching this issue

              Dates

              Created:
              Updated:
              Resolved: