Your software
My Mautic version is: 2.16.3
My PHP version is: 7.3
Your problem
My problem is: Mautic is running but Components->Forms-> particular forms results view is not showing upon clicking on the link.
Also, the form itself is not showing on the front end.
These errors are showing in the log:
[2020-09-05 12:44:55] mautic.CRITICAL: Uncaught PHP Exception Doctrine\DBAL\Exception\TableNotFoundException: “An exception occurred while executing ‘SELECT count(r.submission_id) as count FROM mtc_form_results_1_signup__ne r INNER JOIN mtc_form_submissions s ON r.submission_id = s.id LEFT JOIN mtc_ip_addresses i ON s.ip_id = i.id WHERE r.form_id = 1’: SQLSTATE[42S02]: Base table or view not found: 1146 Table ‘mautic.mtc_form_results_1_signup__ne’ doesn’t exist” at /home/runcloud/webapps/app-kiehn/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 count(r.submission_id) as count FROM mtc_form_results_1_signup__ne r INNER JOIN mtc_form_submissions s ON r.submission_id = s.id LEFT JOIN mtc_ip_addresses i ON s.ip_id = i.id WHERE r.form_id = 1’:\n\nSQLSTATE[42S02]: Base table or view not found: 1146 Table ‘mautic.mtc_form_results_1_signup__ne’ doesn’t exist at /home/runcloud/webapps/app-kiehn/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 ‘mautic.mtc_form_results_1_signup__ne’ doesn’t exist at /home/runcloud/webapps/app-kiehn/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOConnection.php:106, PDOException(code: 42S02): SQLSTATE[42S02]: Base table or view not found: 1146 Table ‘mautic.mtc_form_results_1_signup__ne’ doesn’t exist at /home/runcloud/webapps/app-kiehn/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOConnection.php:104)"}
Steps I have tried to fix the problem:
I have checked MariaDB and “mtc_form_results_1_signup__ne” table really does not exist.
However I am not sure what SQL command to use to create it.