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.