Uploaded image for project: 'phpBB'
  1. phpBB
  2. PHPBB-14838

feeds.attachments_base - server 500 error for large attachment tables

XMLWordPrintable

    • Icon: Bug Bug
    • Resolution: Fixed
    • Icon: Major Major
    • 3.1.11-RC1, 3.2.0
    • 3.1.10, 3.2.0-RC1
    • Other

      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

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

              Created:
              Updated:
              Resolved: