Your software
My Mautic version is: 5.2.2
My PHP version is: 8.3
My Database type and version is: MySQL 8.0
Your problem
I can’t see “Detail” of any contact. When I try, I got the error in the log like below. Any way to fix it?
These errors are showing in the log:
[2025-02-18T20:53:17.650374+00:00] mautic.CRITICAL: Uncaught PHP Exception Doctrine\DBAL\Exception\TableNotFoundException: “An exception occurred while executing a query: SQLSTATE[42S02]: Base table or view not found: 1146 Table ‘mautic_new.form_results_1_subscribe’ doesn’t exist” at /DIDACTED/vendor/doctrine/dbal/src/Driver/API/MySQL/ExceptionConverter.php line 49 {“exception”:“[object] (Doctrine\DBAL\Exception\TableNotFoundException(code: 1146): An exception occurred while executing a query: SQLSTATE[42S02]: Base table or view not found: 1146 Table ‘mautic_new.form_results_1_subscribe’ doesn’t exist at /DIDACTED/vendor/doctrine/dbal/src/Driver/API/MySQL/ExceptionConverter.php:49)\n[previous exception] [object] (Doctrine\DBAL\Driver\PDO\Exception(code: 1146): SQLSTATE[42S02]: Base table or view not found: 1146 Table ‘mautic_new.form_results_1_subscribe’ doesn’t exist at /DIDACTED/vendor/doctrine/dbal/src/Driver/PDO/Exception.php:28)\n[previous exception] [object] (PDOException(code: 42S02): SQLSTATE[42S02]: Base table or view not found: 1146 Table ‘mautic_new.form_results_1_subscribe’ doesn’t exist at /DIDACTED/vendor/doctrine/dbal/src/Driver/PDO/Statement.php:130)”} {“hostname”:“DIDACTED”,“pid”:1602957}
Just letting you know that I updated to 5.2.2. from 5.1.0. I’m not sure whether the update was completely successful or not. Other than this, it seems to work fine so far. Thanks!
Hmm, the error was occurring when I click to see the detail of a contact and I wasn’t able to see the detail. Somehow, now I am able to click and see detail of contacts. However, I still see one log of the same error in the log. I wonder why it happened. I can’t reproduce it.
The same error started to occur again today. I don’t know what triggers it. I’ve been using it fine, but suddenly I can see the detail, resulting in the error in the log.
I had this same problem and it took a little digging since I’m a Doctrine and Symfony novice, but the issue is fairly straightforward (albeit not ideal).
Mautic stores form submission results in a table called “form_results_XXX” where XXX is _formID_formName from your forms in Mautic. The error is indicating that the table does not exist. The table should exist even if it is empty.
Most likely direct DB manipulation and/or some failed mautic update process removed this table and there is insufficient error checking when accessing the form_results_ tables - e.g. the GUI acts weird, but the message is logged in the log files.
If you don’t care about your old submissions, the easy solution to this is to go into each form you have created – Edit it and save it. You don’t need to make any changes, just save the form. Then things should start working again.
If you do care about your old submissions, you will need to restore the tables(s) from a backup.