Form_results_1_subscribe doesn't exist

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!

The error disappered. I wonder if the error was fixed by one of the cron processes.

A bit strange - as the table either is there or not :wink:

Was this a brand new form without submissions before the upgrade? Could it be that there was a submission in between the fail and the success?

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.

could you check your database, if the table exists or not?

I don’t see a table named as form_results_1_subscribe in my db.

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 just found that the error occurs with certain contacts consistently. Not sure why some contacts are ok but others are not.

It sounds like the installation needs a check up:

  • webspace decently sized or run out of memory?
  • update completely finished or broke half way through process?
  • migrations all success full or still pending?
  • cache cleared?

I would also recreate another form and test it. Maybe with the same data and look up database.

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.

1 Like