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"

[IonutOjicaDE]

Hey there! I'm helping the new maintainers of this repository. It was neglected for some time but that changes now! Could you please re-test if you are still getting this issue so we could focus our limited time on the issues that are still relevant? If there will be no response we'll close this issue in 1 week. It can always be re-opened later on.

[shinde-rahul]

@IonutOjicaDE, this is still reproducible for the 5.2.4-apache image.

[cibero42]

Hello, we'll have a look on it after dealing with some priorities!

[henmohr]

Hello @tenup11. Can you mark the option 'backup existing tables'? Tested with a fresh install with this option and worked fine.