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

Updating database fails in migration v310/avatar_types.php

    Details

    • Type: Bug
    • Status: Unverified Fix
    • Priority: Blocker
    • Resolution: Fixed
    • Affects Version/s: 3.1.0-a2
    • Fix Version/s: 3.1.0-a3
    • Component/s: Build System
    • Labels:
      None
    • Environment:
      MySQL(i) 5.5.32
      PHP Version 5.4.19

      Description

      General Error
      SQL ERROR [ mysqli ]

      Truncated incorrect DOUBLE value: 'avatar.driver.gravatar' [1292]

      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: 451
      CALL: call_user_func_array()

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

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

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

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

        Activity

        Hide
        bantu Andreas Fischer added a comment -

        What is the type of the user_avatar_type column at this point for you?

        Show
        bantu Andreas Fischer added a comment - What is the type of the user_avatar_type column at this point for you?
        Hide
        wintstar wintstar added a comment -

        Only 3 avatars have been inserted is Test Forum

        avatar.driver.gravatar
        avatar.driver.local
        avatar.driver.upload

        Show
        wintstar wintstar added a comment - Only 3 avatars have been inserted is Test Forum avatar.driver.gravatar avatar.driver.local avatar.driver.upload

          People

          • Assignee:
            EXreaction EXreaction [X] (Inactive)
            Reporter:
            wintstar wintstar
          • Votes:
            0 Vote for this issue
            Watchers:
            3 Start watching this issue

            Dates

            • Created:
              Updated:
              Resolved:

              Development