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

Localisation imageset being refreshed too frequently causing broken images

    Details

    • Type: Bug
    • Status: Closed
    • Priority: Major
    • Resolution: Fixed
    • Affects Version/s: 3.0.6
    • Fix Version/s: 3.1.0-b1
    • Component/s: Styles
    • Labels:
      None
    • Environment:
      PHP Environment: 5.2.11
      Database: MySQL 5.0.81

      Description

      When the localisation imageset refreshes for one person it automatically does it for everyone at every page load, this causes a vast amount of spam in the admin log of (Refreshed "en" localisation of imageset), this will be triggered by anonymous users, bots, registered users and administrators. The result of this causes all the topic icons, post reply icons and other localised images to not appear.

      The current workaround is to purge the cache, twice. This issue started after upgrading from 3.0.5 to 3.0.6, it appears that not everyone will come across this error but others have reported it on the support forums.

      Also, manually refreshing the imageset, template and theme did not resolve the issue.

        Activity

        Hide
        Kryptyx Kryptyx [X] (Inactive) added a comment -

        @ Basta:

        Unfortunetly my solution was to not use the PHPBB sessions in a cron job. I instead modified the tables that I needed to by using a standard MYSQL call to the database (instead of usings PHPBB's DB class).

        Show
        Kryptyx Kryptyx [X] (Inactive) added a comment - @ Basta: Unfortunetly my solution was to not use the PHPBB sessions in a cron job. I instead modified the tables that I needed to by using a standard MYSQL call to the database (instead of usings PHPBB's DB class).
        Hide
        basta basta added a comment -

        Kryptyx, thanks I can see how you fixed it. However I'm still confused how a cronjob can mess up cached images. Alright there might be some cached MySQL results that phpbb scripts cannot access but how can this mess up cached images?

        I do have a cronjob that uses the $db->sql_query call but it does nothing with the images that disappear sometimes.

        How about using the optional Cache parameter (set to 0 to avoid caching the SQL results)? Do you think this would help?

        Show
        basta basta added a comment - Kryptyx, thanks I can see how you fixed it. However I'm still confused how a cronjob can mess up cached images. Alright there might be some cached MySQL results that phpbb scripts cannot access but how can this mess up cached images? I do have a cronjob that uses the $db->sql_query call but it does nothing with the images that disappear sometimes. How about using the optional Cache parameter (set to 0 to avoid caching the SQL results)? Do you think this would help?
        Hide
        Kryptyx Kryptyx [X] (Inactive) added a comment -

        The issue is caused by a user on the system other than "nobody" creates these files. Since they are not getting created by the apache user on the system they get limited permissions when the cache files are created. Then when PHPBB tries to follow its normal routine it can not execute these files (due to permission issues).

        I suppose a possible fix would be to run another cron job and change the permissions on the files.

        EDIT: Preventing them from being created by passing "0" may resolve the issue, I'd say its worth a shot.

        Show
        Kryptyx Kryptyx [X] (Inactive) added a comment - The issue is caused by a user on the system other than "nobody" creates these files. Since they are not getting created by the apache user on the system they get limited permissions when the cache files are created. Then when PHPBB tries to follow its normal routine it can not execute these files (due to permission issues). I suppose a possible fix would be to run another cron job and change the permissions on the files. EDIT: Preventing them from being created by passing "0" may resolve the issue, I'd say its worth a shot.
        Hide
        Ectoman AJ Quick added a comment -

        This has occured to my site twice in the last two years. The imageset disappears and then is stuck refreshing for every page for every visitor. I purged the cache twice and it brought back the defaul imageset. Not my custom imageset that I created using the admin panel. Very annoying.

        Show
        Ectoman AJ Quick added a comment - This has occured to my site twice in the last two years. The imageset disappears and then is stuck refreshing for every page for every visitor. I purged the cache twice and it brought back the defaul imageset. Not my custom imageset that I created using the admin panel. Very annoying.
        Hide
        nickvergessen Joas Schilling added a comment -

        This is not an issue anymore in 3.1 as the data is not stored in the db anymore and not served via styles.php

        Show
        nickvergessen Joas Schilling added a comment - This is not an issue anymore in 3.1 as the data is not stored in the db anymore and not served via styles.php

          People

          • Assignee:
            nickvergessen Joas Schilling
            Reporter:
            Kryptyx Kryptyx [X] (Inactive)
          • Votes:
            0 Vote for this issue
            Watchers:
            5 Start watching this issue

            Dates

            • Created:
              Updated:
              Resolved:

              Development