Mautic Community Forums

Base table or view not found

Im trying to Install Mautic 2.0 and during the DB setup process I keep getting this error,



SQLSTATE[42S02]: Base table or view not found: 1146 Table ‘mauticbd.lead_fields’ doesn’t exist



Any ideas how to fix this?

Clean Install.

Im trying to Install Mautic 2.0 and during the DB setup process I keep getting this error,

SQLSTATE[42S02]: Base table or view not found: 1146 Table ‘mauticbd.lead_fields’ doesn’t exist

Any ideas how to fix this?

I get a similar error after I did an upgrade from 2.0.1 to 2.1 through the web interface. I am running php 7.0.9

[2016-08-15 14:18:54] mautic.CRITICAL: Uncaught PHP Exception DoctrineDBALExceptionTableNotFoundException: “An exception occurred while executing ‘SELECT es.id as id, es.device as device FROM lead_devices es WHERE es.lead_id = 1119’: SQLSTATE[42S02]: Base table or view not found: 1146 Table ‘marketing.lead_devices’ doesn’t exist” at /directory/to/mautic/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 es.id as id, es.device as device FROM lead_devices es WHERE es.lead_id = 1119’:nnSQLSTATE[42S02]: Base table or view not found: 1146 Table ‘marketing.lead_devices’ doesn’t exist at /directory/to/mautic/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 ‘marketing.lead_devices’ doesn’t exist at /directory/to/mautic/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOConnection.php:106, PDOException(code: 42S02): SQLSTATE[42S02]: Base table or view not found: 1146 Table ‘marketing.lead_devices’ doesn’t exist at /directory/to/mautic/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOConnection.php:104)"} []

Looking through the documentation I failed to update the database schema. I did this with the following command after which everything is working so far:

$ php app/console doctrine:migrations:migrate --env=prod

reference:
https://github.com/mautic/mautic