Your software
My Mautic version is: 7.0.0
My PHP version is: 8.3.30
My Database type and version is: Whatever is default
I installed Mautic via: Docker compose docker-mautic/examples/basic/docker-compose.yml
Your problem
My problem is:
Automation does not work. Contacts are not being added to segments & campaigns do not run
These errors are showing in the log:
In ExceptionConverter.php line 49:
An exception occurred while executing a query: SQLSTATE[42S02]: Base table
or view not found: 1146 Table ‘mautic_db.lead_lists’ doesn’t exist
In Exception.php line 28:
SQLSTATE[42S02]: Base table or view not found: 1146 Table ‘mautic_db.lead_l
ists’ doesn’t exist
In Connection.php line 71:
SQLSTATE[42S02]: Base table or view not found: 1146 Table ‘mautic_db.lead_l
ists’ doesn’t exist
Steps I have tried to fix the problem:
Entering the container and within bash, typing:
php /var/www/bin/console doctrine:migrations:migrate
php /var/www/bin/console cache:clear
php /var/www/html/bin/console mautic:segments:update
php /var/www/html/bin/console mautic:campaigns:update
php /var/www/html/bin/console mautic:campaigns:trigger
Then my contact gets added to a segment, segment email campaign gets started, email sent.
But I cannot get my next contact added to the segment and have the rest of the flow proceed. It also seems that when the container is restarted, the changes are not persistent and the database needs to be migrated and cleaned again.