Your software
My Mautic version is: 2.14.2
My PHP version is: 7.0
Your problem
My problem is:
The dashboard shows:
Uh oh! I think I broke it. If I do it again, please report me to the system administrator!
500 Internal Server Error
These errors are showing in the log:
[2019-08-29 08:17:20] mautic.CRITICAL: Uncaught PHP Exception Doctrine\DBAL\Exception\TableNotFoundException: “An exception occurred while executing ‘SELECT DATE_FORMAT(t.date_added, ‘%Y-%m-%d’) AS date, COUNT() AS count FROM 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 31’ with params [“2019-07-30 00:00:00”, “2019-08-29 08:17:20”]: SQLSTATE[42S02]: Base table or view not found: 1146 Table ‘bigflipp_leads19.leads’ doesn’t exist" at /home/bigflippingdeals/public_html/leads/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/AbstractMySQLDriver.php line 53 {“exception”:"[object] (Doctrine\DBAL\Exception\TableNotFoundException(code: 0): An exception occurred while executing 'SELECT DATE_FORMAT(t.date_added, ‘%Y-%m-%d’) AS date, COUNT() AS count FROM 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 31’ with params [“2019-07-30 00:00:00”, “2019-08-29 08:17:20”]:\n\nSQLSTATE[42S02]: Base table or view not found: 1146 Table ‘bigflipp_leads19.leads’ doesn’t exist at /home/bigflippingdeals/public_html/leads/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/AbstractMySQLDriver.php:53, Doctrine\DBAL\Driver\PDOException(code: 42S02): SQLSTATE[42S02]: Base table or view not found: 1146 Table ‘bigflipp_leads19.leads’ doesn’t exist at /home/bigflippingdeals/public_html/leads/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOStatement.php:107, PDOException(code: 42S02): SQLSTATE[42S02]: Base table or view not found: 1146 Table ‘bigflipp_leads19.leads’ doesn’t exist at /home/bigflippingdeals/public_html/leads/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOStatement.php:105)”}
I dont know how to fix
Kindly help