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

Console database migrate function can not update from 3.0.12 to 3.1

    Details

    • Type: Bug
    • Status: Unverified Fix
    • Priority: Blocker
    • Resolution: Fixed
    • Affects Version/s: 3.1.0-RC2
    • Fix Version/s: 3.1.0-RC3
    • Component/s: CLI, Update system
    • Labels:
      None

      Description

      E:\Develop\olympus>php phpBB\bin\phpbbcli.php db:migrate
       
      Fatal error: SQL ERROR [ mysqli ]<br /><br />Table 'copy.community_migrations' doesn't exist [1146]<br /><br />SQL<br /><br />INSERT INTO community_migrations
                                       (migration_depends_on, migration_schema_done, migration_data_done, migration_data_state, migration_start_time, migration_end_time, migration_name) VALUES ('a:0:{}', 1, 1, '', 0, 0, '\\phpbb\\db\\migration\\data\\v30x\\release_3_0_0') in E:\Develop\olympus\phpBB\phpbb\db\driver\driver.php on line 844
       
      Call Stack:
          0.0000     133016   1. {main}() E:\Develop\olympus\phpBB\bin\phpbbcli.php:0
          1.3104    9821016   2. Symfony\Component\Console\Application->run() E:\Develop\olympus\phpBB\bin\phpbbcli.php:54
          1.3104   10071928   3. phpbb\console\application->doRun() E:\Develop\olympus\phpBB\vendor\symfony\console\Symfony\Component\Console\Application.php:121
          1.3104   10072072   4. Symfony\Component\Console\Application->doRun() E:\Develop\olympus\phpBB\phpbb\console\application.php:103
          1.3104   10072728   5. Symfony\Component\Console\Application->doRunCommand() E:\Develop\olympus\phpBB\vendor\symfony\console\Symfony\Component\Console\Application.php:191
          1.3104   10072848   6. Symfony\Component\Console\Command\Command->run() E:\Develop\olympus\phpBB\vendor\symfony\console\Symfony\Component\Console\Application.php:891
          1.3260   10074864   7. phpbb\console\command\db\migrate->execute() E:\Develop\olympus\phpBB\vendor\symfony\console\Symfony\Component\Console\Command\Command.php:244
          1.4040   10820448   8. phpbb\db\migrator->update() E:\Develop\olympus\phpBB\phpbb\console\command\db\migrate.php:68
          1.4040   10820728   9. phpbb\db\migrator->try_apply() E:\Develop\olympus\phpBB\phpbb\db\migrator.php:155
          1.4040   10821960  10. phpbb\db\migrator->try_apply() E:\Develop\olympus\phpBB\phpbb\db\migrator.php:205
          1.4040   10823184  11. phpbb\db\migrator->try_apply() E:\Develop\olympus\phpBB\phpbb\db\migrator.php:205
          1.4040   10824416  12. phpbb\db\migrator->try_apply() E:\Develop\olympus\phpBB\phpbb\db\migrator.php:205
          1.4040   10825648  13. phpbb\db\migrator->try_apply() E:\Develop\olympus\phpBB\phpbb\db\migrator.php:205
          1.4040   10826872  14. phpbb\db\migrator->try_apply() E:\Develop\olympus\phpBB\phpbb\db\migrator.php:205
          1.4040   10828104  15. phpbb\db\migrator->try_apply() E:\Develop\olympus\phpBB\phpbb\db\migrator.php:205
          1.4040   10829336  16. phpbb\db\migrator->try_apply() E:\Develop\olympus\phpBB\phpbb\db\migrator.php:205
          1.4040   10830568  17. phpbb\db\migrator->try_apply() E:\Develop\olympus\phpBB\phpbb\db\migrator.php:205
          1.4040   10831800  18. phpbb\db\migrator->try_apply() E:\Develop\olympus\phpBB\phpbb\db\migrator.php:205
          1.4040   10833024  19. phpbb\db\migrator->try_apply() E:\Develop\olympus\phpBB\phpbb\db\migrator.php:205
          1.4040   10834248  20. phpbb\db\migrator->try_apply() E:\Develop\olympus\phpBB\phpbb\db\migrator.php:205
          1.4040   10835472  21. phpbb\db\migrator->try_apply() E:\Develop\olympus\phpBB\phpbb\db\migrator.php:205
          1.4040   10836696  22. phpbb\db\migrator->try_apply() E:\Develop\olympus\phpBB\phpbb\db\migrator.php:205
          1.4196   10837920  23. phpbb\db\migrator->try_apply() E:\Develop\olympus\phpBB\phpbb\db\migrator.php:205
          1.4196   10839144  24. phpbb\db\migrator->try_apply() E:\Develop\olympus\phpBB\phpbb\db\migrator.php:205
          1.4196   10840368  25. phpbb\db\migrator->try_apply() E:\Develop\olympus\phpBB\phpbb\db\migrator.php:205
          1.4196   10841592  26. phpbb\db\migrator->try_apply() E:\Develop\olympus\phpBB\phpbb\db\migrator.php:205
          1.4196   10842816  27. phpbb\db\migrator->try_apply() E:\Develop\olympus\phpBB\phpbb\db\migrator.php:205
          1.4196   10844040  28. phpbb\db\migrator->try_apply() E:\Develop\olympus\phpBB\phpbb\db\migrator.php:205
          1.4196   10845264  29. phpbb\db\migrator->try_apply() E:\Develop\olympus\phpBB\phpbb\db\migrator.php:205
          1.4196   10846488  30. phpbb\db\migrator->try_apply() E:\Develop\olympus\phpBB\phpbb\db\migrator.php:205
          1.4196   10847712  31. phpbb\db\migrator->try_apply() E:\Develop\olympus\phpBB\phpbb\db\migrator.php:205
          1.4196   10848936  32. phpbb\db\migrator->try_apply() E:\Develop\olympus\phpBB\phpbb\db\migrator.php:205
          1.4196   10850160  33. phpbb\db\migrator->try_apply() E:\Develop\olympus\phpBB\phpbb\db\migrator.php:205
          1.4196   10851384  34. phpbb\db\migrator->try_apply() E:\Develop\olympus\phpBB\phpbb\db\migrator.php:205
          1.4196   10852616  35. phpbb\db\migrator->try_apply() E:\Develop\olympus\phpBB\phpbb\db\migrator.php:205
          1.4196   10919336  36. phpbb\db\migrator->try_apply() E:\Develop\olympus\phpBB\phpbb\db\migrator.php:205
          1.4196   10920560  37. phpbb\db\migrator->try_apply() E:\Develop\olympus\phpBB\phpbb\db\migrator.php:205
          1.4196   10921784  38. phpbb\db\migrator->try_apply() E:\Develop\olympus\phpBB\phpbb\db\migrator.php:205
          1.4196   10923008  39. phpbb\db\migrator->try_apply() E:\Develop\olympus\phpBB\phpbb\db\migrator.php:205
          1.4196   10924232  40. phpbb\db\migrator->try_apply() E:\Develop\olympus\phpBB\phpbb\db\migrator.php:205
          1.4196   10925456  41. phpbb\db\migrator->try_apply() E:\Develop\olympus\phpBB\phpbb\db\migrator.php:205
          1.4196   10926680  42. phpbb\db\migrator->try_apply() E:\Develop\olympus\phpBB\phpbb\db\migrator.php:205
          1.4196   10927904  43. phpbb\db\migrator->try_apply() E:\Develop\olympus\phpBB\phpbb\db\migrator.php:205
          1.4196   10929128  44. phpbb\db\migrator->try_apply() E:\Develop\olympus\phpBB\phpbb\db\migrator.php:205
          1.4196   10930352  45. phpbb\db\migrator->try_apply() E:\Develop\olympus\phpBB\phpbb\db\migrator.php:205
          1.4196   10931576  46. phpbb\db\migrator->try_apply() E:\Develop\olympus\phpBB\phpbb\db\migrator.php:205
          1.4196   10934072  47. phpbb\db\migrator->set_migration_state() E:\Develop\olympus\phpBB\phpbb\db\migrator.php:237
          1.4196   10935232  48. phpbb\db\driver\factory->sql_query() E:\Develop\olympus\phpBB\phpbb\db\migrator.php:589
          1.4196   10935264  49. phpbb\db\driver\mysqli->sql_query() E:\Develop\olympus\phpBB\phpbb\db\driver\factory.php:329
          1.4196   10935264  50. phpbb\db\driver\driver->sql_error() E:\Develop\olympus\phpBB\phpbb\db\driver\mysqli.php:194
          1.4196   10936168  51. trigger_error() E:\Develop\olympus\phpBB\phpbb\db\driver\driver.php:844

      I then retried after purging the cache. even with --safe-mode

      E:\Develop\olympus>php phpBB\bin\phpbbcli.php db:migrate --safe-mode
       
      Fatal error: SQL ERROR [ mysqli ]<br /><br />Table 'copy.community_ext' doesn't exist [1146]<br /><br />SQL<br /><br />SELECT *
                              FROM community_ext in E:\Develop\olympus\phpBB\phpbb\db\driver\driver.php on line 844
       
      Call Stack:
          0.0000     135408   1. {main}() E:\Develop\olympus\phpBB\bin\phpbbcli.php:0
          1.1600    4507328   2. require('E:\Develop\olympus\phpBB\includes\compatibility_globals.php') E:\Develop\olympus\phpBB\bin\phpbbcli.php:59
          1.2000    6108952   3. Symfony\Component\DependencyInjection\ContainerBuilder->get() E:\Develop\olympus\phpBB\includes\compatibility_globals.php:45
          1.2000    6109160   4. Symfony\Component\DependencyInjection\ContainerBuilder->createService() E:\Develop\olympus\phpBB\vendor\symfony\dependency-injection\Symfony\Component\DependencyInjection\ContainerBuilder.php:490
          1.2000    6192240   5. ReflectionClass->newInstanceArgs() E:\Develop\olympus\phpBB\vendor\symfony\dependency-injection\Symfony\Component\DependencyInjection\ContainerBuilder.php:959
          1.2000    6192832   6. phpbb\extension\manager->__construct() E:\Develop\olympus\phpBB\vendor\symfony\dependency-injection\Symfony\Component\DependencyInjection\ContainerBuilder.php:959
          1.2000    6193512   7. phpbb\extension\manager->load_extensions() E:\Develop\olympus\phpBB\phpbb\extension\manager.php:67
          1.2000    6193632   8. phpbb\db\driver\factory->sql_query() E:\Develop\olympus\phpBB\phpbb\extension\manager.php:92
          1.2000    6193664   9. phpbb\db\driver\mysqli->sql_query() E:\Develop\olympus\phpBB\phpbb\db\driver\factory.php:329
          1.2100    6193864  10. phpbb\db\driver\driver->sql_error() E:\Develop\olympus\phpBB\phpbb\db\driver\mysqli.php:194
          1.2100    6194928  11. trigger_error() E:\Develop\olympus\phpBB\phpbb\db\driver\driver.php:844
       
      E:\Develop\olympus>

        Attachments

          Activity

            People

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

              Dates

              • Created:
                Updated:
                Resolved: