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

Upgrade from 3.0 to 3.3 fails with SQL "Incorrect integer value" error

XMLWordPrintable

    • Icon: Bug Bug
    • Resolution: Unresolved
    • Icon: Major Major
    • None
    • 3.3.14
    • Migrations
    • None

      Upgrade from 3.0 to 3.3 can fail with the error like:

      General Error:SQL ERROR [ mysqll ]incorrect integer value: " for column `thego826_forum`.`phpbb_users`.`user_avatar_type` at row 1
      [1366]SQLINSERT INTO phpbb_users (username, username_clean, user_password, user_email, group_id, user_type, user_permissions,
      user_timezone, user_dateformat, user_lang, user_style, user_actkey, user_ip, user_regdate, user_passchg, user_options, user_new,
      user_ inactive_reason, user _inactive_time, user_lastmark, user_lastvisit, user_lastpost_time, user_lastpage, user_posts, user_colour,
      user_avatar, user_avatar_type, user_avatar_width, user_avatar_height, user_new_privmsg, user_unread_privmsg, user_last_privmsg,
      user_ _message_rules, user_full_folder, user_emailtime, user_notify, user_notify_pm, user_notify_type, user_allow_pm,
      user_allow_viewonline, user_allow_viewemail, user_allow_massemail, user_sig, user_sig_bbcode_uid, user_sig_bbcode_bitfeld
      user _form_salt) VALUES ("Bing [Bot]', 'bing [bot]', ", ", '6', 2, ", O, 'D M d, Y g:i a', 'en', "1", ", ", 1743094310, 1743094310, 230271, 0, 0, 0,
      1743094310, 0, O, ", O, '9E8DA7', ", ", O, 0, 0, 0, 0, 0, -3, 0, 0, 1, 0, 1, 1, 1, O, ", ", ", 'kiq81laq81hnemz5') in file [ROOT]/thegorbalsanecdotes/phpbb/db/driver/driver.php on line 1028
      

      This happens on installing data of \phpbb\db\migration\data\v310\bot_update migration.

      The possible cause is that \phpbb\db\migration\data\v310\avatars.php migration, which changes "user_avatar_type" column type from tinyint(2) to varchar(255), depends on \phpbb\db\migration\data\v30x\release_3_0_11, while \phpbb\db\migration\data\v310\bot_update.php migration depends on \phpbb\db\migration\data\v310\rc6 only.

      So it is possible that on some installations bot_update.php can run before avatars.php migration.

      For the reference: https://www.phpbb.com/community/viewtopic.php?t=2661448

            Unassigned Unassigned
            rxu rxu
            Votes:
            0 Vote for this issue
            Watchers:
            1 Start watching this issue

              Created:
              Updated: