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

Updating database fails in upgrade from 3.0 when trying twice without purging the cache

    Details

    • Type: Bug
    • Status: Closed
    • Priority: Major
    • Resolution: Fixed
    • Affects Version/s: 3.1.0-RC4, 3.1.0-RC5
    • Fix Version/s: 3.1.4-RC1
    • Component/s: None
    • Labels:
      None

      Description

      General Error
      SQL ERROR [ mysqli ]

      Incorrect integer value: 'avatar.driver.upload' for column 'user_avatar_type' at row 2 [1366]

      SQL

      UPDATE phpbb_users SET user_avatar_type = 'avatar.driver.upload' WHERE user_avatar_type = '1'

      BACKTRACE

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

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

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

      FILE: [ROOT]/phpbb/db/migration/data/v310/avatar_types.php
      LINE: 46
      CALL: phpbb\db\driver\mysqli->sql_query()

      FILE: (not given by php)
      LINE: (not given by php)
      CALL: phpbb\db\migration\data\v310\avatar_types->update_user_avatar_type()

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

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

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

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

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

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

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

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

      http://img819.imageshack.us/img819/8933/tzn0.png

        Attachments

          Activity

            People

            • Assignee:
              Marc Marc
              Reporter:
              nextgen Melvin García
            • Votes:
              0 Vote for this issue
              Watchers:
              5 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved: