Uploaded image for project: 'phpBB'
  1. phpBB
  2. PHPBB-12368

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

XMLWordPrintable

    • Icon: Bug Bug
    • Resolution: Fixed
    • Icon: Major Major
    • 3.1.4-RC1
    • 3.1.0-RC4, 3.1.0-RC5
    • None
    • None

      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

            Marc Marc
            nextgen Melvin GarcĂ­a
            Votes:
            0 Vote for this issue
            Watchers:
            5 Start watching this issue

              Created:
              Updated:
              Resolved: