Skip to content

Base table or view already exists: 1050 Table 'account_review_feed_pulls' #90

@Acr0most

Description

@Acr0most

I've the following issue trying to start a new fresh installation in docker from eramba project.

After clone the repository and adjust some .env variables I want to start the project with

docker compose -f docker-compose.simple-install.yml up --build -d

after startup the database the eramba container starts proper but hangs on restart-loop with the following error:

eramba  | > App\Console\Installer::postInstall
eramba  | Welcome to Eramba installation procedure!
eramba  | Skipped overwriting `config/app_local.php` file
eramba  | No Security.salt placeholder to replace.
eramba  | sending incremental file list
eramba  | emails/.gitkeep
eramba  |
eramba  | sent 819 bytes  received 48 bytes  1,734.00 bytes/sec
eramba  | total size is 0  speedup is 0.00
eramba  | sending incremental file list
eramba  | .gitkeep
eramba  |
eramba  | sent 199 bytes  received 37 bytes  472.00 bytes/sec
eramba  | total size is 0  speedup is 0.00
eramba  | Using connection: default
eramba  | -------------------------------------------------------------------------------
eramba  | Database appears to be empty.
eramba  | Running structural migrations.
eramba  |
eramba  |  == 20170222204044 Initial: migrating
eramba  | 2026-02-09 11:03:24 error: [PDOException] SQLSTATE[42S01]: Base table or view already exists: 1050 Table 'account_review_feed_pulls' already exists in /var/www/eramba/app/upgrade/vendor/robmorgan/phinx/src/Phinx/Db/Adapter/PdoAdapter.php on line 193
eramba  | Stack Trace:
eramba  | - /var/www/eramba/app/upgrade/vendor/robmorgan/phinx/src/Phinx/Db/Adapter/PdoAdapter.php:193
eramba  | - /var/www/eramba/app/upgrade/vendor/robmorgan/phinx/src/Phinx/Db/Adapter/MysqlAdapter.php:350
eramba  | - /var/www/eramba/app/upgrade/vendor/robmorgan/phinx/src/Phinx/Db/Adapter/AdapterWrapper.php:356
eramba  | - /var/www/eramba/app/upgrade/vendor/robmorgan/phinx/src/Phinx/Db/Adapter/TimedOutputAdapter.php:113
eramba  | - /var/www/eramba/app/upgrade/vendor/robmorgan/phinx/src/Phinx/Db/Adapter/AdapterWrapper.php:356
eramba  | - /var/www/eramba/app/upgrade/vendor/robmorgan/phinx/src/Phinx/Db/Plan/Plan.php:146
eramba  | - /var/www/eramba/app/upgrade/vendor/robmorgan/phinx/src/Phinx/Db/Table.php:715
eramba  | - /var/www/eramba/app/upgrade/vendor/robmorgan/phinx/src/Phinx/Db/Table.php:611
eramba  | - /var/www/eramba/app/upgrade/vendor/cakephp/migrations/src/Table.php:138
eramba  | - /var/www/eramba/app/upgrade/config/Migrations/20170222204044_Initial.php:71
eramba  | - /var/www/eramba/app/upgrade/vendor/robmorgan/phinx/src/Phinx/Migration/Manager/Environment.php:111
eramba  | - /var/www/eramba/app/upgrade/vendor/robmorgan/phinx/src/Phinx/Migration/Manager.php:385
eramba  | - /var/www/eramba/app/upgrade/vendor/robmorgan/phinx/src/Phinx/Migration/Manager.php:359
eramba  | - /var/www/eramba/app/upgrade/vendor/cakephp/migrations/src/Migrations.php:328
eramba  | - /var/www/eramba/app/upgrade/vendor/cakephp/migrations/src/Migrations.php:174
eramba  | - /var/www/eramba/app/upgrade/src/Lib/Updates/Migrator.php:275
eramba  | - /var/www/eramba/app/upgrade/src/Lib/Updates/Migrator.php:195
eramba  | - /var/www/eramba/app/upgrade/src/Lib/Updates/Migrator.php:97
eramba  | - /var/www/eramba/app/upgrade/src/Command/DatabaseInitializeCommand.php:96
eramba  | - /var/www/eramba/app/upgrade/vendor/cakephp/cakephp/src/Console/BaseCommand.php:189
eramba  | - /var/www/eramba/app/upgrade/vendor/cakephp/cakephp/src/Console/CommandRunner.php:334
eramba  | - /var/www/eramba/app/upgrade/vendor/cakephp/cakephp/src/Console/CommandRunner.php:172
eramba  | - /var/www/eramba/app/upgrade/bin/cake.php:12

I've tried different things to fix:

  • deleted all volumes (also from another older instance)
  • changed the whole project to a new folder so the docker compose logic won't use any old volumes
  • started the database first, dropped the eramba-DB and started the other containers afterwards

Actually nothing helps. Can you double check this? Maybe there is a blocking migration in the latest image?

Metadata

Metadata

Assignees

No one assigned

    Labels

    No labels
    No labels

    Type

    No type

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions