# Form\_results\_1\_subscribe doesn't exist **URL:** \ **Category:** Mautic 5 Install/Upgrade Support\ **Created:** [February 18, 2025, 8:58pm UTC](https://forum.mautic.org/t/form-results-1-subscribe-doesnt-exist/35052 "2025-02-18T20:58:39Z")\ **Posts on this page:** 11\ **Page:** 1
**Author:** ![jm1](https://sea2.discourse-cdn.com/flex020/user_avatar/forum.mautic.org/jm1/32/13705_2.png) [@jm1](https://forum.mautic.org/u/jm1)\ **Post date:** [February 18, 2025, 8:58pm UTC](https://forum.mautic.org/t/form-results-1-subscribe-doesnt-exist/35052/1 "2025-02-18T20:58:39Z")
**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} ---
**Author:** ![jm1](https://sea2.discourse-cdn.com/flex020/user_avatar/forum.mautic.org/jm1/32/13705_2.png) [@jm1](https://forum.mautic.org/u/jm1)\ **Post date:** [February 18, 2025, 9:02pm UTC](https://forum.mautic.org/t/form-results-1-subscribe-doesnt-exist/35052/2 "2025-02-18T21:02:52Z")
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! ---
**Author:** ![jm1](https://sea2.discourse-cdn.com/flex020/user_avatar/forum.mautic.org/jm1/32/13705_2.png) [@jm1](https://forum.mautic.org/u/jm1)\ **Post date:** [February 19, 2025, 10:24pm UTC](https://forum.mautic.org/t/form-results-1-subscribe-doesnt-exist/35052/3 "2025-02-19T22:24:23Z")
The error disappered. I wonder if the error was fixed by one of the cron processes. ---
**Author:** ![dirk\_s](https://sea2.discourse-cdn.com/flex020/user_avatar/forum.mautic.org/dirk_s/32/748_2.png) [@dirk\_s](https://forum.mautic.org/u/dirk_s)\ **Post date:** [February 22, 2025, 10:56pm UTC](https://forum.mautic.org/t/form-results-1-subscribe-doesnt-exist/35052/4 "2025-02-22T22:56:07Z")
A bit strange - as the table either is there or not 😉 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? ---
**Author:** ![jm1](https://sea2.discourse-cdn.com/flex020/user_avatar/forum.mautic.org/jm1/32/13705_2.png) [@jm1](https://forum.mautic.org/u/jm1)\ **Post date:** [February 24, 2025, 2:29am UTC](https://forum.mautic.org/t/form-results-1-subscribe-doesnt-exist/35052/5 "2025-02-24T02:29:01Z")
> [@jm1](#): > > [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} 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. ---
**Author:** ![dirk\_s](https://sea2.discourse-cdn.com/flex020/user_avatar/forum.mautic.org/dirk_s/32/748_2.png) [@dirk\_s](https://forum.mautic.org/u/dirk_s)\ **Post date:** [February 25, 2025, 6:10pm UTC](https://forum.mautic.org/t/form-results-1-subscribe-doesnt-exist/35052/6 "2025-02-25T18:10:35Z")
could you check your database, if the table exists or not? ---
**Author:** ![jm1](https://sea2.discourse-cdn.com/flex020/user_avatar/forum.mautic.org/jm1/32/13705_2.png) [@jm1](https://forum.mautic.org/u/jm1)\ **Post date:** [February 28, 2025, 12:31am UTC](https://forum.mautic.org/t/form-results-1-subscribe-doesnt-exist/35052/7 "2025-02-28T00:31:28Z")
I don’t see a table named as `form_results_1_subscribe` in my db. ---
**Author:** ![jm1](https://sea2.discourse-cdn.com/flex020/user_avatar/forum.mautic.org/jm1/32/13705_2.png) [@jm1](https://forum.mautic.org/u/jm1)\ **Post date:** [February 28, 2025, 3:54am UTC](https://forum.mautic.org/t/form-results-1-subscribe-doesnt-exist/35052/8 "2025-02-28T03:54:20Z")
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. ---
**Author:** ![jm1](https://sea2.discourse-cdn.com/flex020/user_avatar/forum.mautic.org/jm1/32/13705_2.png) [@jm1](https://forum.mautic.org/u/jm1)\ **Post date:** [February 28, 2025, 3:57am UTC](https://forum.mautic.org/t/form-results-1-subscribe-doesnt-exist/35052/9 "2025-02-28T03:57:35Z")
I just found that the error occurs with certain contacts consistently. Not sure why some contacts are ok but others are not. ---
**Author:** ![dirk\_s](https://sea2.discourse-cdn.com/flex020/user_avatar/forum.mautic.org/dirk_s/32/748_2.png) [@dirk\_s](https://forum.mautic.org/u/dirk_s)\ **Post date:** [March 3, 2025, 7:30am UTC](https://forum.mautic.org/t/form-results-1-subscribe-doesnt-exist/35052/10 "2025-03-03T07:30:55Z")
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. ---
**Author:** ![dwbrott](https://sea2.discourse-cdn.com/flex020/user_avatar/forum.mautic.org/dwbrott/32/13472_2.png) [@dwbrott](https://forum.mautic.org/u/dwbrott)\ **Post date:** [April 12, 2025, 4:12pm UTC](https://forum.mautic.org/t/form-results-1-subscribe-doesnt-exist/35052/11 "2025-04-12T16:12:59Z")
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.