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

Database update from 3.1.10 to 3.2.1 broken (postgreSQL)

    Details

    • Type: Bug
    • Status: Open (View Workflow)
    • Priority: Blocker
    • Resolution: Unresolved
    • Affects Version/s: 3.2.1
    • Fix Version/s: None
    • Component/s: Installation system
    • Environment:
      localhost, OS: Fedora 25
      PostgreSQL 9.5.7 on x86_64-redhat-linux-gnu, compiled by gcc (GCC) 6.3.1 20161221 (Red Hat 6.3.1-1), 64-bit
      PHP Version 5.6.30

      Description

      Upgrading from phpBB 3.1.10 to 3.2.1 breaks while updating the database. I cannot proceed. (A work-around is discussed at the end of this post.)

      I followed the recommended procedure:

      • Downloaded the full 3.2.1 package and extracted to the phpBB3/ directory
      • Deleted the files as instructed
      • Copied files from my 3.1.10 production area (config.php, images/, files/, store/ into phpBB3/

      Then:

      # php ./bin/phpbbcli.php db:migrate --safe-mode

       Stops on a fatal error. The error message and stack trace:

      Installed Schema: \phpbb\db\migration\data\v31x\remove_duplicate_migrations; Time: 0.00 seconds
      Installed Data: \phpbb\db\migration\data\v31x\remove_duplicate_migrations; Time: 0.00 seconds
      Installed Schema: \phpbb\db\migration\data\v31x\increase_size_of_emotion; Time: 0.01 seconds
      Installed Data: \phpbb\db\migration\data\v31x\increase_size_of_emotion; Time: 0.00 seconds
      Installed Schema: \phpbb\db\migration\data\v31x\add_smtp_ssl_context_config_options; Time: 0.00 seconds
      Installed Data: \phpbb\db\migration\data\v31x\add_smtp_ssl_context_config_options; Time: 0.00 seconds
      Installed Schema: \phpbb\db\migration\data\v31x\add_jabber_ssl_context_config_options; Time: 0.00 seconds
      Installed Data: \phpbb\db\migration\data\v31x\add_jabber_ssl_context_config_options; Time: 0.00 seconds
      Installed Schema: \phpbb\db\migration\data\v31x\update_hashes; Time: 0.00 seconds
      Installed Data: \phpbb\db\migration\data\v31x\update_hashes; Time: 0.00 seconds
      Installed Schema: \phpbb\db\migration\data\v31x\add_latest_topics_index; Time: 0.21 seconds
      Installed Data: \phpbb\db\migration\data\v31x\add_latest_topics_index; Time: 0.00 seconds
      Installed Schema: \phpbb\db\migration\data\v31x\v3111rc1; Time: 0.00 seconds
      Installed Data: \phpbb\db\migration\data\v31x\v3111rc1; Time: 0.00 seconds
      Installed Schema: \phpbb\db\migration\data\v31x\v3111; Time: 0.00 seconds
      Installed Data: \phpbb\db\migration\data\v31x\v3111; Time: 0.00 seconds
      Installed Schema: \phpbb\db\migration\data\v320\dev; Time: 0.00 seconds
      Installed Data: \phpbb\db\migration\data\v320\dev; Time: 0.00 seconds
      Installed Schema: \phpbb\db\migration\data\v320\remove_profilefield_wlm; Time: 0.00 seconds
      Installed Data: \phpbb\db\migration\data\v320\remove_profilefield_wlm; Time: 0.00 seconds
      Installed Schema: \phpbb\db\migration\data\v320\allowed_schemes_links; Time: 0.00 seconds
      Installed Data: \phpbb\db\migration\data\v320\allowed_schemes_links; Time: 0.00 seconds
      Installed Schema: \phpbb\db\migration\data\v320\announce_global_permission; Time: 0.00 seconds
      Installed Data: \phpbb\db\migration\data\v320\announce_global_permission; Time: 2.47 seconds
      Installed Schema: \phpbb\db\migration\data\v320\font_awesome_update; Time: 0.00 seconds
      Installed Data: \phpbb\db\migration\data\v320\font_awesome_update; Time: 0.00 seconds
      Installed Schema: \phpbb\db\migration\data\v320\icons_alt; Time: 0.02 seconds
      Installed Data: \phpbb\db\migration\data\v320\icons_alt; Time: 0.00 seconds
      Installed Schema: \phpbb\db\migration\data\v320\log_post_id; Time: 1.62 seconds
      Installed Data: \phpbb\db\migration\data\v320\log_post_id; Time: 0.00 seconds
      Installed Schema: \phpbb\db\migration\data\v320\remove_outdated_media; Time: 0.00 seconds
      Installed Data: \phpbb\db\migration\data\v320\remove_outdated_media; Time: 0.00 seconds
      Installed Schema: \phpbb\db\migration\data\v320\notifications_board; Time: 0.00 seconds
      Installed Data: \phpbb\db\migration\data\v320\notifications_board; Time: 0.72 seconds
      Installed Schema: \phpbb\db\migration\data\v320\v320a1; Time: 0.00 seconds
      Installed Data: \phpbb\db\migration\data\v320\v320a1; Time: 0.00 seconds
      Installed Schema: \phpbb\db\migration\data\v320\text_reparser; Time: 0.00 seconds
      PHP Warning: file_put_contents(/var/www/html/phpBB3/bin/../cache/production//s9e_renderer_d0e3f88f82c1fbae32143ff0f04521ffbc264238.php): failed to open stream: No such file or directory in /var/www/html/phpBB3/vendor/s9e/text-formatter/src/Configurator.php on line 5849
      PHP Warning: include(/var/www/html/phpBB3/bin/../cache/production//s9e_renderer_d0e3f88f82c1fbae32143ff0f04521ffbc264238.php): failed to open stream: No such file or directory in /var/www/html/phpBB3/vendor/s9e/text-formatter/src/Configurator.php on line 5852
      PHP Warning: include(): Failed opening '/var/www/html/phpBB3/bin/../cache/production//s9e_renderer_d0e3f88f82c1fbae32143ff0f04521ffbc264238.php' for inclusion (include_path='.:/usr/share/pear:/usr/share/php') in /var/www/html/phpBB3/vendor/s9e/text-formatter/src/Configurator.php on line 5852
      PHP Fatal error: Uncaught Error: Class 's9e_renderer_d0e3f88f82c1fbae32143ff0f04521ffbc264238' not found in /var/www/html/phpBB3/vendor/s9e/text-formatter/src/Configurator.php:5853
      Stack trace:
      #0 /var/www/html/phpBB3/vendor/s9e/text-formatter/src/Configurator.php(4686): s9e\TextFormatter\Configurator\RendererGenerators\PHP->getRenderer(Object(s9e\TextFormatter\Configurator\Rendering))
      #1 /var/www/html/phpBB3/vendor/s9e/text-formatter/src/Configurator.php(101): s9e\TextFormatter\Configurator\Rendering->getRenderer()
      #2 /var/www/html/phpBB3/phpbb/textformatter/s9e/factory.php(385): s9e\TextFormatter\Configurator->finalize()
      #3 /var/www/html/phpBB3/phpbb/textformatter/s9e/parser.php(47): phpbb\textformatter\s9e\factory->regenerate()
      #4 [internal function]: phpbb\textformatter\s9e\parser->__construct(Object(phpbb\cache\driver\memcache), '_text_formatter...', Object(phpbb\textformatter\s9e\factory), Object(phpbb\event\dispatcher))
      #5 /var/www/html/phpBB3/vendor/symfony/dependency-injection/ContainerBuilder.php(936): ReflectionCla in /var/www/html/phpBB3/vendor/s9e/text-formatter/src/Configurator.php on line 5853

      My config.php:
       

      <?php // phpBB 3.0.x auto-generated configuration file // Do not change anything in this file! 
      $dbms = 'postgres';
       $dbhost = 'localhost';
       $dbport = ''; $dbname = 'phpBB32';
       $dbuser = '(user)';
       $dbpasswd = '(password)';
       $table_prefix = '';
       $acm_type = 'memcache';
       $load_extensions = ''; @define('PHPBB_DISPLAY_LOAD_TIME', true);
      @define('PHPBB_INSTALLED', true);
      // @define('DEBUG', true);
      // @define('DEBUG_EXTRA', true); ?> 
      

      During an earlier upgrade (3.1.8), I experienced a problem with the automatic updater which was traced to a problem with memcache.

      In config.php, I replaced 

      $acm_type = 'memcache';

      with

      $acm_type = 'phpbb\\cache\\driver\\file';

      The upgrade was successful. I will upgrade my board by temporarily modifying config.php to use 'phpbb\\cache\\driver
      file'; during the database update.

      The prior memcache discussion is here: PHPBB3-14496 Automatic update relies on cache creating files in cache folder

      The support forum discussion is here: Database update from 3.1.10 to 3.2.1 broken (PostgreSQL)

        Attachments

          Activity

            People

            • Assignee:
              Unassigned
              Reporter:
              Lady_G Lady_G
            • Votes:
              0 Vote for this issue
              Watchers:
              1 Start watching this issue

              Dates

              • Created:
                Updated: