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

phpBB 3.0.12 on Oracle fails to upgrade to 3.1.0

    Details

    • Type: Bug
    • Status: Unverified Fix
    • Priority: Blocker
    • Resolution: Fixed
    • Affects Version/s: 3.1.0-dev
    • Fix Version/s: 3.1.0-RC3
    • Labels:
      None
    • Environment:
      Oracle 11g Express

      Description

      While attempting to upgrade a 3.0.12 board running on Oracle, the following error is encountered:

      Updating database to latest stable release

      Database type :: oracle
      Previous version :: 3.0.12
      Installed Data: \phpbb\db\migration\data\v310\style_update_p2; Time: 0.09 seconds

      SQL ERROR [ oracle ]

      ORA-01439: column to be modified must be empty to change datatype [1439]

      SQL

      ALTER TABLE phpbb_users MODIFY user_timezone varchar2(100) DEFAULT ''

      BACKTRACE

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

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

      FILE: [ROOT]/phpbb/db/driver/oracle.php
      LINE: 418
      CALL: phpbb\db\driver\driver->sql_error()

      FILE: [ROOT]/phpbb/db/tools.php
      LINE: 1506
      CALL: phpbb\db\driver\oracle->sql_query()

      FILE: [ROOT]/phpbb/db/tools.php
      LINE: 2586
      CALL: phpbb\db\tools->_sql_run_sql()

      FILE: [ROOT]/phpbb/db/tools.php
      LINE: 812
      CALL: phpbb\db\tools->sql_column_change()

      FILE: (not given by php)
      LINE: (not given by php)
      CALL: phpbb\db\tools->perform_schema_changes()

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

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

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

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

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

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

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

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

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

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

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

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

      FILE: [ROOT]/install/database_update.php
      LINE: 234
      CALL: phpbb\db\migrator->update()

        Activity

        Hide
        nickvergessen Joas Schilling added a comment -

        I think the easiest is to create a temporary data holder?

        1. Create a temp column with new type
        2. Copy stuff to temp (needs casting in worst case?)
        3. Clear column
        4. Change type of original column
        5. Copy from temp
        Show
        nickvergessen Joas Schilling added a comment - I think the easiest is to create a temporary data holder? Create a temp column with new type Copy stuff to temp (needs casting in worst case?) Clear column Change type of original column Copy from temp
        Hide
        Noxwizard Patrick Webster added a comment -

        Something to keep in mind, there can be indexes/constraints on the target column.

        Show
        Noxwizard Patrick Webster added a comment - Something to keep in mind, there can be indexes/constraints on the target column.

          People

          • Assignee:
            nickvergessen Joas Schilling
            Reporter:
            Noxwizard Patrick Webster
          • Votes:
            0 Vote for this issue
            Watchers:
            1 Start watching this issue

            Dates

            • Created:
              Updated:
              Resolved:

              Development