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

Can't upgrade to 3.1 from 3.0.11 and older

    Details

    • Type: Bug
    • Status: Closed
    • Priority: Major
    • Resolution: Fixed
    • Affects Version/s: 3.1.0-RC6
    • Fix Version/s: 3.1.0
    • Component/s: Installation system
    • Labels:
      None
    • Environment:
      PHP 5.4.6, mysqlnd 5.0.10, Firefox 34.0

      Description

      I tried to upgrade from 3.0.11 to 3.1 RC6 so I kept

      • config.php
      • /images/ directory
      • /files/ directory
      • /store/ directory
        and copied over the 3.1 full package.

      I got this error message:
      -------------------------
      Updating database to latest stable release

      Database type :: mysqli
      Previous version :: 3.0.11

      SQL ERROR [ mysqli ]
       
      Unknown column 'post_delete_user' in 'where clause' [1054]
       
      SQL
       
      UPDATE bb304_posts SET post_delete_user = 1 WHERE post_delete_user = 106660
       
      BACKTRACE
       
      FILE: (not given by php)
      LINE: (not given by php)
      CALL: msg_handler()
       
      FILE: [ROOT]/phpBB/db/driver/driver.php
      LINE: 855
      CALL: trigger_error()
       
      FILE: [ROOT]/phpBB/db/driver/mysqli.php
      LINE: 194
      CALL: phpbb\db\driver\driver->sql_error()
       
      FILE: [ROOT]/phpBB/db/driver/factory.php
      LINE: 329
      CALL: phpbb\db\driver\mysqli->sql_query()
       
      FILE: [ROOT]/includes/functions_user.php
      LINE: 607
      CALL: phpbb\db\driver\factory->sql_query()
       
      FILE: [ROOT]/phpBB/db/migration/data/v30x/release_3_0_12_rc1.php
      LINE: 117
      CALL: user_delete()
       
      FILE: (not given by php)
      LINE: (not given by php)
      CALL: phpbb\db\migration\data\v30x\release_3_0_12_rc1->update_bots()
       
      FILE: [ROOT]/phpBB/db/migrator.php
      LINE: 459
      CALL: call_user_func_array()
       
      FILE: [ROOT]/phpBB/db/migrator.php
      LINE: 405
      CALL: phpbb\db\migrator->run_step()
       
      FILE: [ROOT]/phpBB/db/migrator.php
      LINE: 253
      CALL: phpbb\db\migrator->process_data_step()
       
      FILE: [ROOT]/phpBB/db/migrator.php
      LINE: 205
      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: 206
      CALL: phpbb\db\migrator->update()

        Activity

        Hide
        nickvergessen Joas Schilling added a comment -

        Another error on 3.0.8:

        SQL ERROR [ mysqli ]
         
        Field 'user_occ' doesn't have a default value [1364]
         
        SQL
         
        INSERT INTO phpbb_users (username, username_clean, user_password, user_email, user_email_hash, 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_bitfield, user_form_salt) VALUES ('Bing [Bot]', 'bing [bot]', '', '', '00', '6', 2, '', 0, 'D M d, Y g:i a', 'en', '1', '', '', 1414348554, 1414348554, 230271, 0, 0, 0, 1414348554, 0, 0, '', 0, '9E8DA7', '', '', 0, 0, 0, 0, 0, 0, -3, 0, 0, 1, 0, 1, 1, 1, 0, '', '', '', '98849c922a599d68')
         
        BACKTRACE
         
        FILE: (not given by php)
        LINE: (not given by php)
        CALL: msg_handler()
         
        FILE: [ROOT]/phpbb/db/driver/driver.php
        LINE: 852
        CALL: trigger_error()
         
        FILE: [ROOT]/phpbb/db/driver/mysqli.php
        LINE: 194
        CALL: phpbb\db\driver\driver->sql_error()
         
        FILE: [ROOT]/phpbb/db/driver/factory.php
        LINE: 329
        CALL: phpbb\db\driver\mysqli->sql_query()
         
        FILE: [ROOT]/includes/functions_user.php
        LINE: 274
        CALL: phpbb\db\driver\factory->sql_query()
         
        FILE: [ROOT]/phpbb/db/migration/data/v30x/release_3_0_8_rc1.php
        LINE: 167
        CALL: user_add()
         
        FILE: (not given by php)
        LINE: (not given by php)
        CALL: phpbb\db\migration\data\v30x\release_3_0_8_rc1->update_bots()
         
        FILE: [ROOT]/phpbb/db/migrator.php
        LINE: 459
        CALL: call_user_func_array()
         
        FILE: [ROOT]/phpbb/db/migrator.php
        LINE: 405
        CALL: phpbb\db\migrator->run_step()
         
        FILE: [ROOT]/phpbb/db/migrator.php
        LINE: 253
        CALL: phpbb\db\migrator->process_data_step()
         
        FILE: [ROOT]/phpbb/db/migrator.php
        LINE: 205
        CALL: phpbb\db\migrator->try_apply()

        Show
        nickvergessen Joas Schilling added a comment - Another error on 3.0.8: SQL ERROR [ mysqli ]   Field 'user_occ' doesn't have a default value [1364]   SQL   INSERT INTO phpbb_users (username, username_clean, user_password, user_email, user_email_hash, 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_bitfield, user_form_salt) VALUES ('Bing [Bot]', 'bing [bot]', '', '', '00', '6', 2, '', 0, 'D M d, Y g:i a', 'en', '1', '', '', 1414348554, 1414348554, 230271, 0, 0, 0, 1414348554, 0, 0, '', 0, '9E8DA7', '', '', 0, 0, 0, 0, 0, 0, -3, 0, 0, 1, 0, 1, 1, 1, 0, '', '', '', '98849c922a599d68')   BACKTRACE   FILE: (not given by php) LINE: (not given by php) CALL: msg_handler()   FILE: [ROOT]/phpbb/db/driver/driver.php LINE: 852 CALL: trigger_error()   FILE: [ROOT]/phpbb/db/driver/mysqli.php LINE: 194 CALL: phpbb\db\driver\driver->sql_error()   FILE: [ROOT]/phpbb/db/driver/factory.php LINE: 329 CALL: phpbb\db\driver\mysqli->sql_query()   FILE: [ROOT]/includes/functions_user.php LINE: 274 CALL: phpbb\db\driver\factory->sql_query()   FILE: [ROOT]/phpbb/db/migration/data/v30x/release_3_0_8_rc1.php LINE: 167 CALL: user_add()   FILE: (not given by php) LINE: (not given by php) CALL: phpbb\db\migration\data\v30x\release_3_0_8_rc1->update_bots()   FILE: [ROOT]/phpbb/db/migrator.php LINE: 459 CALL: call_user_func_array()   FILE: [ROOT]/phpbb/db/migrator.php LINE: 405 CALL: phpbb\db\migrator->run_step()   FILE: [ROOT]/phpbb/db/migrator.php LINE: 253 CALL: phpbb\db\migrator->process_data_step()   FILE: [ROOT]/phpbb/db/migrator.php LINE: 205 CALL: phpbb\db\migrator->try_apply()
        Hide
        bog_tom bog_tom added a comment -

        So what is the resolution?

        I replaced the files as previously did and I got another error....
        ----------------------------------------

        Updating database to latest stable release

        Database type :: mysqli
        Previous version :: 3.1.0-dev
        Installing Schema: \phpbb\db\migration\data\v310\mysql_fulltext_drop.
        SQL ERROR [ mysqli ]

        Can't DROP 'post_subject'; check that column/key exists [1091]

        SQL

        DROP INDEX post_subject ON bb304_posts

        BACKTRACE

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

        FILE: [ROOT]/phpBB/db/driver/driver.php
        LINE: 855
        CALL: trigger_error()

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

        FILE: [ROOT]/phpBB/db/driver/factory.php
        LINE: 329
        CALL: phpbb\db\driver\mysqli->sql_query()

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

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

        FILE: [ROOT]/phpBB/db/tools.php
        LINE: 837
        CALL: phpbb\db\tools->sql_index_drop()

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

        FILE: [ROOT]/phpBB/db/migrator.php
        LINE: 510
        CALL: call_user_func_array()

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

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

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

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

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

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

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

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

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

        Show
        bog_tom bog_tom added a comment - So what is the resolution? I replaced the files as previously did and I got another error.... ---------------------------------------- Updating database to latest stable release Database type :: mysqli Previous version :: 3.1.0-dev Installing Schema: \phpbb\db\migration\data\v310\mysql_fulltext_drop. SQL ERROR [ mysqli ] Can't DROP 'post_subject'; check that column/key exists [1091] SQL DROP INDEX post_subject ON bb304_posts BACKTRACE FILE: (not given by php) LINE: (not given by php) CALL: msg_handler() FILE: [ROOT] /phpBB/db/driver/driver.php LINE: 855 CALL: trigger_error() FILE: [ROOT] /phpBB/db/driver/mysqli.php LINE: 194 CALL: phpbb\db\driver\driver->sql_error() FILE: [ROOT] /phpBB/db/driver/factory.php LINE: 329 CALL: phpbb\db\driver\mysqli->sql_query() FILE: [ROOT] /phpBB/db/tools.php LINE: 1428 CALL: phpbb\db\driver\factory->sql_query() FILE: [ROOT] /phpBB/db/tools.php LINE: 1960 CALL: phpbb\db\tools->_sql_run_sql() FILE: [ROOT] /phpBB/db/tools.php LINE: 837 CALL: phpbb\db\tools->sql_index_drop() FILE: (not given by php) LINE: (not given by php) CALL: phpbb\db\tools->perform_schema_changes() FILE: [ROOT] /phpBB/db/migrator.php LINE: 510 CALL: call_user_func_array() FILE: [ROOT] /phpBB/db/migrator.php LINE: 456 CALL: phpbb\db\migrator->run_step() FILE: [ROOT] /phpBB/db/migrator.php LINE: 277 CALL: phpbb\db\migrator->process_data_step() FILE: [ROOT] /phpBB/db/migrator.php LINE: 234 CALL: phpbb\db\migrator->try_apply() FILE: [ROOT] /phpBB/db/migrator.php LINE: 234 CALL: phpbb\db\migrator->try_apply() FILE: [ROOT] /phpBB/db/migrator.php LINE: 234 CALL: phpbb\db\migrator->try_apply() FILE: [ROOT] /phpBB/db/migrator.php LINE: 234 CALL: phpbb\db\migrator->try_apply() FILE: [ROOT] /phpBB/db/migrator.php LINE: 234 CALL: phpbb\db\migrator->try_apply() FILE: [ROOT] /phpBB/db/migrator.php LINE: 174 CALL: phpbb\db\migrator->try_apply() FILE: [ROOT] /install/database_update.php LINE: 206 CALL: phpbb\db\migrator->update()
        Hide
        bog_tom bog_tom added a comment -

        Fix not working...

        Show
        bog_tom bog_tom added a comment - Fix not working...
        Hide
        bantu Andreas Fischer added a comment -

        I am sorry, you're facing another problem. I've created a new ticket for it here: https://tracker.phpbb.com/browse/PHPBB3-13238

        Show
        bantu Andreas Fischer added a comment - I am sorry, you're facing another problem. I've created a new ticket for it here: https://tracker.phpbb.com/browse/PHPBB3-13238
        Hide
        bog_tom bog_tom added a comment -

        sweet...

        Show
        bog_tom bog_tom added a comment - sweet...

          People

          • Assignee:
            nickvergessen Joas Schilling
            Reporter:
            bog_tom bog_tom
          • Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

            Dates

            • Created:
              Updated:
              Resolved:

              Development