Your software
My Mautic version is: 4.4.5
My PHP version is: 8.0
My Database type and version is: mariadb 10.61.8
Your problem
My problem is:
Hi, I just upgraded from mysql to MariaDB 10.6 and now I am unable to access backend.
These errors are showing in the log:
[2024-06-21 18:36:20] mautic.CRITICAL: Uncaught PHP Exception Doctrine\DBAL\Exception\DriverException: "An exception occurred while executing 'SELECT DATE_FORMAT(t.date_added, '%Y-%m-%d') AS date, COUNT(*) AS count FROM bm_leads t WHERE t.date_added BETWEEN ? AND ? GROUP BY DATE_FORMAT(t.date_added, '%Y-%m-%d') ORDER BY DATE_FORMAT(t.date_added, '%Y-%m-%d') ASC LIMIT 32' with params ["2024-05-21 00:00:00", "2024-06-21 23:59:59"]: SQLSTATE[42S02]: Base table or view not found: 1932 Table 'database.bm_leads' doesn't exist in engine"
database.bm_emails Error : Unknown data type: 'MYSQL_JSON' error : Corrupt
Steps I have tried to fix the problem:
none yet
What can I do to solve the issue? I have full dumps of database (while it was MySQL).
Thank you