Table 'messenger_messages' already exists - example/basic

[tenup11]

After setting up Mautic via Docker based on example/basic I get an error during the installation step via the web UI. Error: An error occurred while attempting to install the data: An exception occurred while executing a query: SQLSTATE[42S01]: Base table or view already exists: 1050 Table 'messenger_messages' already exists

This happens on Debian 12 (fresh install) with nginx proxy manager also running via docker.

[pedrolucasoliva]

Same problem here. Docker compose file: version: '3'

x-mautic-volumes: &mautic-volumes

• ./mautic/mautic/config:/var/www/html/config:z
• ./mautic/mautic/logs:/var/www/html/var/logs:z
• ./mautic/mautic/media/files:/var/www/html/docroot/media/files:z
• ./mautic/mautic/media/images:/var/www/html/docroot/media/images:z
• ./mautic/cron:/opt/mautic/cron:z

services: mautic_db: image: mysql:8.0 container_name: mautic_db hostname: db.mautic environment:

• MYSQL_HOST=${MYSQL_HOST}
• MYSQL_ROOT_PASSWORD=${MYSQL_ROOT_PASSWORD}
• MYSQL_DATABASE=${MYSQL_DATABASE}
• MYSQL_USER=${MYSQL_USER}
• MYSQL_PASSWORD=${MYSQL_PASSWORD}
• TZ=${TIMEZONE} volumes:
• ./mautic/mysql-data:/var/lib/mysql healthcheck: test: mysqladmin --user=$$MYSQL_USER --password=$$MYSQL_PASSWORD ping start_period: 5s interval: 5s timeout: 5s retries: 10 networks:

• mautic

  mautic_web: image: mautic/mautic:5-apache container_name: mautic_web links:

• mautic_db:mysql volumes: *mautic-volumes environment:
• TIMEZONE=${TIMEZONE}
• DOCKER_MAUTIC_LOAD_TEST_DATA=${DOCKER_MAUTIC_LOAD_TEST_DATA}
• DOCKER_MAUTIC_RUN_MIGRATIONS=${DOCKER_MAUTIC_RUN_MIGRATIONS} labels:
• "traefik.enable=true"
• "traefik.docker.network=docker_web"
• "traefik.http.routers.mautic.rule=Host(xxxxx)"
• "traefik.http.routers.mautic.entrypoints=websecure"
• "traefik.http.services.mautic.loadbalancer.server.port=80"
• "traefik.http.routers.mautic.service=mautic"
• "traefik.http.routers.mautic.tls.certresolver=leresolver" env_file:
• .mautic_env healthcheck: test: curl http://localhost start_period: 5s interval: 5s timeout: 5s retries: 100 depends_on: mautic_db: condition: service_healthy networks:
• web

• mautic

  mautic_cron: image: mautic/mautic:5-apache container_name: mautic_cron links:

• mautic_db:mysql volumes: *mautic-volumes environment:
• TIMEZONE=${TIMEZONE}
• DOCKER_MAUTIC_ROLE=mautic_cron env_file:
• .mautic_env depends_on: mautic_web: condition: service_healthy networks:

• mautic

  mautic_worker: image: mautic/mautic:5-apache container_name: mautic_worker links:

• mautic_db:mysql volumes: *mautic-volumes environment:
• TIMEZONE=${TIMEZONE}
• DOCKER_MAUTIC_ROLE=mautic_worker env_file:
• .mautic_env depends_on: mautic_web: condition: service_healthy networks:
• mautic

volumes: mysql-data:

networks: web: driver: bridge mautic: driver: bridge

I already tried to recreate database and drop the tables.

[codewishofficial]

Same here. I tried to add a database table prefix and only the 'messenger_messages' is skipping the prefix

[ghost]

i got the same error. I was using basic example. I simplify docker-compose and change to Mariadb:latest and its gone.

follow the unique file docker-compose.yml working...

`version: '3.9'

services: mariadb: image: mariadb:latest environment: MYSQL_ROOT_PASSWORD: root_pwd MYSQL_DATABASE: mautic_db MYSQL_USER: mautic_db_user MYSQL_PASSWORD: mautic_db_pwd volumes:

• mariadb-data:/var/lib/mysql
  healthcheck: test: ["CMD-SHELL", "mariadb-admin ping -h localhost -u$$MYSQL_USER --password=$$MYSQL_PASSWORD"] interval: 10s timeout: 5s retries: 5 start_period: 30s networks:

• default

  mautic_web: image: mautic/mautic:5-apache ports:

• 8001:80 volumes:
• ./mautic/config:/var/www/html/config:z
• ./mautic/logs:/var/www/html/var/logs:z
• ./mautic/media/files:/var/www/html/docroot/media/files:z
• ./mautic/media/images:/var/www/html/docroot/media/images:z
• ./cron:/opt/mautic/cron:z environment:
• DOCKER_MAUTIC_LOAD_TEST_DATA=false
• DOCKER_MAUTIC_RUN_MIGRATIONS=false
• MAUTIC_DB_HOST=mariadb
• MAUTIC_DB_USER=mautic_db_user
• MAUTIC_DB_PASSWORD=mautic_db_pwd
• MAUTIC_DB_NAME=mautic_db

• MAUTIC_DB_PORT=3306 healthcheck: test: curl http://localhost start_period: 5s interval: 5s timeout: 5s retries: 100 depends_on: mariadb: condition: service_healthy

  mautic_cron: image: mautic/mautic:5-apache volumes:

• ./mautic/config:/var/www/html/config:z
• ./mautic/logs:/var/www/html/var/logs:z
• ./mautic/media/files:/var/www/html/docroot/media/files:z
• ./mautic/media/images:/var/www/html/docroot/media/images:z
• ./cron:/opt/mautic/cron:z environment:
• DOCKER_MAUTIC_ROLE=mautic_cron depends_on: mautic_web: condition: service_healthy networks:

• default

  mautic_worker: image: mautic/mautic:5-apache volumes:

• ./mautic/config:/var/www/html/config:z
• ./mautic/logs:/var/www/html/var/logs:z
• ./mautic/media/files:/var/www/html/docroot/media/files:z
• ./mautic/media/images:/var/www/html/docroot/media/images:z
• ./cron:/opt/mautic/cron:z environment:
• DOCKER_MAUTIC_ROLE=mautic_worker depends_on: mautic_web: condition: service_healthy networks:
• default

volumes: mariadb-data:

networks: default:`

[Basyuk]

I tried to solve the problem for two days. And I figured out how to bypass it. You need to stop the container with the worker service to solve the problem. This problem occurs because the worker, for some reason, constantly recreates the messenger_messages table.

[jackpassgfw]

Same mistake, not fixed yet

[humanbeinc]

Workaround for newbies:

comment these settings in .mautic_env:

#MAUTIC_MESSENGER_DSN_EMAIL="doctrine://default"
#MAUTIC_MESSENGER_DSN_HIT="doctrine://default"