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

Unable to update DB from 3.0.X to 3.1.X because of post_visibility

    Details

    • Type: Bug
    • Status: Closed
    • Priority: Blocker
    • Resolution: Fixed
    • Affects Version/s: 3.1.0-dev
    • Fix Version/s: 3.1.0-a1
    • Component/s: Installation system
    • Labels:
      None

      Description

      Trying to update a 3.0 db to 3.1 failed, because the function delete_posts() is called upon, which has "post_visibility" in its SQL query, although that field does not exist in 3.0 databases.

      General Error
      SQL ERROR [ mysqli ]

      Unknown column 'post_visibility' in 'field list' [1054]

      SQL

      SELECT post_id, poster_id, post_visibility, post_postcount, topic_id, forum_id FROM phpbb_posts WHERE poster_id = 116837

      BACKTRACE

      FILE: (not given by php)
      LINE: (not given by php)
      CALL: msg_handler()

      FILE: [ROOT]/phpbb/db/driver/driver.php
      LINE: 809
      CALL: trigger_error()

      FILE: [ROOT]/phpbb/db/driver/mysqli.php
      LINE: 187
      CALL: phpbb_db_driver->sql_error()

      FILE: [ROOT]/includes/functions_admin.php
      LINE: 781
      CALL: phpbb_db_driver_mysqli->sql_query()

      FILE: [ROOT]/includes/functions_user.php
      LINE: 564
      CALL: delete_posts()

      FILE: [ROOT]/phpbb/db/migration/data/30x/3_0_12_rc1.php
      LINE: 111
      CALL: user_delete()

      FILE: (not given by php)
      LINE: (not given by php)
      CALL: phpbb_db_migration_data_30x_3_0_12_rc1->update_bots()

      FILE: [ROOT]/phpbb/db/migrator.php
      LINE: 446
      CALL: call_user_func_array()

      FILE: [ROOT]/phpbb/db/migrator.php
      LINE: 392
      CALL: phpbb_db_migrator->run_step()

      FILE: [ROOT]/phpbb/db/migrator.php
      LINE: 237
      CALL: phpbb_db_migrator->process_data_step()

      FILE: [ROOT]/phpbb/db/migrator.php
      LINE: 153
      CALL: phpbb_db_migrator->try_apply()

        Issue Links

          Activity

          Hide
          nickvergessen Joas Schilling added a comment -

          That is going to be fixed with the auto update fix: http://tracker.phpbb.com/browse/PHPBB3-11574

          Show
          nickvergessen Joas Schilling added a comment - That is going to be fixed with the auto update fix: http://tracker.phpbb.com/browse/PHPBB3-11574

            People

            • Assignee:
              nickvergessen Joas Schilling
              Reporter:
              VSE Matt Friedman
            • Votes:
              0 Vote for this issue
              Watchers:
              3 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved:

                Development