500 Internal Server Error, Unable to View Dashboard

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

Hi there,

Have you followed the step-by-step instructions here: https://www.mautic.org/docs/en/tips/update-failed.html?

This might well give you some information about whether there was a problem with your installation - it seems like some of your database tables are missing.

Also, 2.14.2 is pretty old - is there a reason why you’re installing such an old version? There are some regression bugs with 2.15.2 so I’d suggest installing 2.15.1 at the present moment in time, until the next release is made to address the bugs. Here’s the link to the release: https://github.com/mautic/mautic/releases/tag/2.15.1

ok, i will try add the new version now.
will remove the existing mautic version and do fresh install now

2 Likes