# Most links/buttons clicked in the admin-area show an 500 Error

**URL:** <https://forum.mautic.org/t/most-links-buttons-clicked-in-the-admin-area-show-an-500-error/32779>\
**Category:** Mautic 5 Install/Upgrade Support\
**Created:** [July 16, 2024, 10:15am UTC](https://forum.mautic.org/t/most-links-buttons-clicked-in-the-admin-area-show-an-500-error/32779 "2024-07-16T10:15:45Z")\
**Posts on this page:** 5\
**Page:** 1

<div class="post-metadata">

**Author:** ![imihandstand](https://sea2.discourse-cdn.com/flex020/user_avatar/forum.mautic.org/imihandstand/32/1499_2.png) [@imihandstand](https://forum.mautic.org/u/imihandstand)\
**Post date:** [July 16, 2024, 10:15am UTC](https://forum.mautic.org/t/most-links-buttons-clicked-in-the-admin-area-show-an-500-error/32779/1 "2024-07-16T10:15:45Z")

</div>

**Your software**  
My Mautic version is: 5.1.0  
My PHP version is: 8.0.30  
My Database type and version is: 10.3.39-MariaDB, pdo\_mysql

**Your problem**  
My problem is:  
Since upgrading to v5, when I try click any link in the admin-area of Mautic ( for example going like the Contacts page ("mautic/s/contacts) edit a Tag via clicking it’s Edit-button with the link “/mautic/s/tags/edit/364?tmpl=list” ), it doesnt work - I get an 500 Error. The console says:

“GET /mautic/s/tags/edit/364?tmpl=list&\_=1721122832680&mauticUserLastActive=126”  
“Status: 500”

For example these errors are showing in the log:

```auto
[2024-07-16T10:08:24.754165+00:00] mautic.CRITICAL: Uncaught PHP Exception Doctrine\DBAL\Exception\InvalidFieldNameException: "An exception occurred while executing a query: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'm0_.deduplicate' in 'field list'" at /home/imicp/mautic/mautic/vendor/doctrine/dbal/src/Driver/API/MySQL/ExceptionConverter.php line 67 {"exception":"[object] (Doctrine\\DBAL\\Exception\\InvalidFieldNameException(code: 1054): An exception occurred while executing a query: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'm0_.deduplicate' in 'field list' at /home/imicp/mautic/mautic/vendor/doctrine/dbal/src/Driver/API/MySQL/ExceptionConverter.php:67)\n[previous exception] [object] (Doctrine\\DBAL\\Driver\\PDO\\Exception(code: 1054): SQLSTATE[42S22]: Column not found: 1054 Unknown column 'm0_.deduplicate' in 'field list' at /home/imicp/mautic/mautic/vendor/doctrine/dbal/src/Driver/PDO/Exception.php:28)\n[previous exception] [object] (PDOException(code: 42S22): SQLSTATE[42S22]: Column not found: 1054 Unknown column 'm0_.deduplicate' in 'field list' at /home/imicp/mautic/mautic/vendor/doctrine/dbal/src/Driver/PDO/Connection.php:71)"} {"hostname":"server.verfuehren-befriedigen-tipps.de","pid":11905}
[2024-07-16T10:08:42.122289+00:00] mautic.CRITICAL: Uncaught PHP Exception Doctrine\DBAL\Exception\InvalidFieldNameException: "An exception occurred while executing a query: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'm0_.deduplicate' in 'field list'" at /home/imicp/mautic/mautic/vendor/doctrine/dbal/src/Driver/API/MySQL/ExceptionConverter.php line 67 {"exception":"[object] (Doctrine\\DBAL\\Exception\\InvalidFieldNameException(code: 1054): An exception occurred while executing a query: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'm0_.deduplicate' in 'field list' at /home/imicp/mautic/mautic/vendor/doctrine/dbal/src/Driver/API/MySQL/ExceptionConverter.php:67)\n[previous exception] [object] (Doctrine\\DBAL\\Driver\\PDO\\Exception(code: 1054): SQLSTATE[42S22]: Column not found: 1054 Unknown column 'm0_.deduplicate' in 'field list' at /home/imicp/mautic/mautic/vendor/doctrine/dbal/src/Driver/PDO/Exception.php:28)\n[previous exception] [object] (PDOException(code: 42S22): SQLSTATE[42S22]: Column not found: 1054 Unknown column 'm0_.deduplicate' in 'field list' at /home/imicp/mautic/mautic/vendor/doctrine/dbal/src/Driver/PDO/Connection.php:71)"} {"hostname":"server.verfuehren-befriedigen-tipps.de","pid":11948}
[2024-07-16T10:08:55.674138+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 'imicp_mauimi1.maut1l_email_list_excluded' doesn't exist" at /home/imicp/mautic/mautic/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 'imicp_mauimi1.maut1l_email_list_excluded' doesn't exist at /home/imicp/mautic/mautic/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 'imicp_mauimi1.maut1l_email_list_excluded' doesn't exist at /home/imicp/mautic/mautic/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 'imicp_mauimi1.maut1l_email_list_excluded' doesn't exist at /home/imicp/mautic/mautic/vendor/doctrine/dbal/src/Driver/PDO/Statement.php:130)"} {"hostname":"server.verfuehren-befriedigen-tipps.de","pid":12045}
[2024-07-16T10:08:55.680131+00:00] mautic.CRITICAL: Exception thrown when handling an exception (Doctrine\DBAL\Exception\InvalidFieldNameException: An exception occurred while executing a query: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'm0_.deduplicate' in 'field list' at /home/imicp/mautic/mautic/vendor/doctrine/dbal/src/Driver/API/MySQL/ExceptionConverter.php line 67) {"exception":"[object] (Doctrine\\DBAL\\Exception\\InvalidFieldNameException(code: 1054): An exception occurred while executing a query: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'm0_.deduplicate' in 'field list' at /home/imicp/mautic/mautic/vendor/doctrine/dbal/src/Driver/API/MySQL/ExceptionConverter.php:67)\n[previous exception] [object] (Doctrine\\DBAL\\Driver\\PDO\\Exception(code: 1054): SQLSTATE[42S22]: Column not found: 1054 Unknown column 'm0_.deduplicate' in 'field list' at /home/imicp/mautic/mautic/vendor/doctrine/dbal/src/Driver/PDO/Exception.php:28)\n[previous exception] [object] (PDOException(code: 42S22): SQLSTATE[42S22]: Column not found: 1054 Unknown column 'm0_.deduplicate' in 'field list' at /home/imicp/mautic/mautic/vendor/doctrine/dbal/src/Driver/PDO/Connection.php:71)"} {"hostname":"server.verfuehren-befriedigen-tipps.de","pid":12045}
[2024-07-16T10:08:55.680271+00:00] mautic.CRITICAL: Uncaught PHP Exception Doctrine\DBAL\Exception\InvalidFieldNameException: "An exception occurred while executing a query: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'm0_.deduplicate' in 'field list'" at /home/imicp/mautic/mautic/vendor/doctrine/dbal/src/Driver/API/MySQL/ExceptionConverter.php line 67 {"exception":"[object] (Doctrine\\DBAL\\Exception\\InvalidFieldNameException(code: 1054): An exception occurred while executing a query: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'm0_.deduplicate' in 'field list' at /home/imicp/mautic/mautic/vendor/doctrine/dbal/src/Driver/API/MySQL/ExceptionConverter.php:67)\n[previous exception] [object] (Doctrine\\DBAL\\Driver\\PDO\\Exception(code: 1054): SQLSTATE[42S22]: Column not found: 1054 Unknown column 'm0_.deduplicate' in 'field list' at /home/imicp/mautic/mautic/vendor/doctrine/dbal/src/Driver/PDO/Exception.php:28)\n[previous exception] [object] (PDOException(code: 42S22): SQLSTATE[42S22]: Column not found: 1054 Unknown column 'm0_.deduplicate' in 'field list' at /home/imicp/mautic/mautic/vendor/doctrine/dbal/src/Driver/PDO/Connection.php:71)\n[previous 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 'imicp_mauimi1.maut1l_email_list_excluded' doesn't exist at /home/imicp/mautic/mautic/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 'imicp_mauimi1.maut1l_email_list_excluded' doesn't exist at /home/imicp/mautic/mautic/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 'imicp_mauimi1.maut1l_email_list_excluded' doesn't exist at /home/imicp/mautic/mautic/vendor/doctrine/dbal/src/Driver/PDO/Statement.php:130)"} {"hostname":"server.verfuehren-befriedigen-tipps.de","pid":12045}
[2024-07-16T10:08:55.682789+00:00] mautic.CRITICAL: Exception thrown when handling an exception (Doctrine\DBAL\Exception\InvalidFieldNameException: An exception occurred while executing a query: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'm0_.deduplicate' in 'field list' at /home/imicp/mautic/mautic/vendor/doctrine/dbal/src/Driver/API/MySQL/ExceptionConverter.php line 67) {"exception":"[object] (Doctrine\\DBAL\\Exception\\InvalidFieldNameException(code: 1054): An exception occurred while executing a query: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'm0_.deduplicate' in 'field list' at /home/imicp/mautic/mautic/vendor/doctrine/dbal/src/Driver/API/MySQL/ExceptionConverter.php:67)\n[previous exception] [object] (Doctrine\\DBAL\\Driver\\PDO\\Exception(code: 1054): SQLSTATE[42S22]: Column not found: 1054 Unknown column 'm0_.deduplicate' in 'field list' at /home/imicp/mautic/mautic/vendor/doctrine/dbal/src/Driver/PDO/Exception.php:28)\n[previous exception] [object] (PDOException(code: 42S22): SQLSTATE[42S22]: Column not found: 1054 Unknown column 'm0_.deduplicate' in 'field list' at /home/imicp/mautic/mautic/vendor/doctrine/dbal/src/Driver/PDO/Connection.php:71)"} {"hostname":"server.verfuehren-befriedigen-tipps.de","pid":12045}
[2024-07-16T10:08:55.682862+00:00] mautic.CRITICAL: Uncaught PHP Exception Doctrine\DBAL\Exception\InvalidFieldNameException: "An exception occurred while executing a query: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'm0_.deduplicate' in 'field list'" at /home/imicp/mautic/mautic/vendor/doctrine/dbal/src/Driver/API/MySQL/ExceptionConverter.php line 67 {"exception":"[object] (Doctrine\\DBAL\\Exception\\InvalidFieldNameException(code: 1054): An exception occurred while executing a query: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'm0_.deduplicate' in 'field list' at /home/imicp/mautic/mautic/vendor/doctrine/dbal/src/Driver/API/MySQL/ExceptionConverter.php:67)\n[previous exception] [object] (Doctrine\\DBAL\\Driver\\PDO\\Exception(code: 1054): SQLSTATE[42S22]: Column not found: 1054 Unknown column 'm0_.deduplicate' in 'field list' at /home/imicp/mautic/mautic/vendor/doctrine/dbal/src/Driver/PDO/Exception.php:28)\n[previous exception] [object] (PDOException(code: 42S22): SQLSTATE[42S22]: Column not found: 1054 Unknown column 'm0_.deduplicate' in 'field list' at /home/imicp/mautic/mautic/vendor/doctrine/dbal/src/Driver/PDO/Connection.php:71)\n[previous exception] [object] (Doctrine\\DBAL\\Exception\\InvalidFieldNameException(code: 1054): An exception occurred while executing a query: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'm0_.deduplicate' in 'field list' at /home/imicp/mautic/mautic/vendor/doctrine/dbal/src/Driver/API/MySQL/ExceptionConverter.php:67)\n[previous exception] [object] (Doctrine\\DBAL\\Driver\\PDO\\Exception(code: 1054): SQLSTATE[42S22]: Column not found: 1054 Unknown column 'm0_.deduplicate' in 'field list' at /home/imicp/mautic/mautic/vendor/doctrine/dbal/src/Driver/PDO/Exception.php:28)\n[previous exception] [object] (PDOException(code: 42S22): SQLSTATE[42S22]: Column not found: 1054 Unknown column 'm0_.deduplicate' in 'field list' at /home/imicp/mautic/mautic/vendor/doctrine/dbal/src/Driver/PDO/Connection.php:71)\n[previous 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 'imicp_mauimi1.maut1l_email_list_excluded' doesn't exist at /home/imicp/mautic/mautic/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 'imicp_mauimi1.maut1l_email_list_excluded' doesn't exist at /home/imicp/mautic/mautic/vendor/doctrine/dbal/src/Driver/PDO/Exception.php:28)\n[previous exception] Over 9 levels deep, aborting normalization"} {"hostname":"server.verfuehren-befriedigen-tipps.de","pid":12045}
[2024-07-16T10:08:55.685857+00:00] mautic.CRITICAL: Exception thrown when handling an exception (Doctrine\DBAL\Exception\InvalidFieldNameException: An exception occurred while executing a query: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'm0_.deduplicate' in 'field list' at /home/imicp/mautic/mautic/vendor/doctrine/dbal/src/Driver/API/MySQL/ExceptionConverter.php line 67) {"exception":"[object] (Doctrine\\DBAL\\Exception\\InvalidFieldNameException(code: 1054): An exception occurred while executing a query: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'm0_.deduplicate' in 'field list' at /home/imicp/mautic/mautic/vendor/doctrine/dbal/src/Driver/API/MySQL/ExceptionConverter.php:67)\n[previous exception] [object] (Doctrine\\DBAL\\Driver\\PDO\\Exception(code: 1054): SQLSTATE[42S22]: Column not found: 1054 Unknown column 'm0_.deduplicate' in 'field list' at /home/imicp/mautic/mautic/vendor/doctrine/dbal/src/Driver/PDO/Exception.php:28)\n[previous exception] [object] (PDOException(code: 42S22): SQLSTATE[42S22]: Column not found: 1054 Unknown column 'm0_.deduplicate' in 'field list' at /home/imicp/mautic/mautic/vendor/doctrine/dbal/src/Driver/PDO/Connection.php:71)"} {"hostname":"server.verfuehren-befriedigen-tipps.de","pid":12045}
[2024-07-16T10:08:55.687357+00:00] mautic.ERROR: Doctrine\DBAL\Exception\InvalidFieldNameException: An exception occurred while executing a query: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'm0_.deduplicate' in 'field list' - in file /home/imicp/mautic/mautic/vendor/doctrine/dbal/src/Driver/API/MySQL/ExceptionConverter.php - at line 67 [] {"hostname":"server.verfuehren-befriedigen-tipps.de","pid":12045}
[2024-07-16T10:09:03.359139+00:00] mautic.CRITICAL: Uncaught PHP Exception Doctrine\DBAL\Exception\InvalidFieldNameException: "An exception occurred while executing a query: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'm0_.is_index' in 'field list'" at /home/imicp/mautic/mautic/vendor/doctrine/dbal/src/Driver/API/MySQL/ExceptionConverter.php line 67 {"exception":"[object] (Doctrine\\DBAL\\Exception\\InvalidFieldNameException(code: 1054): An exception occurred while executing a query: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'm0_.is_index' in 'field list' at /home/imicp/mautic/mautic/vendor/doctrine/dbal/src/Driver/API/MySQL/ExceptionConverter.php:67)\n[previous exception] [object] (Doctrine\\DBAL\\Driver\\PDO\\Exception(code: 1054): SQLSTATE[42S22]: Column not found: 1054 Unknown column 'm0_.is_index' in 'field list' at /home/imicp/mautic/mautic/vendor/doctrine/dbal/src/Driver/PDO/Exception.php:28)\n[previous exception] [object] (PDOException(code: 42S22): SQLSTATE[42S22]: Column not found: 1054 Unknown column 'm0_.is_index' in 'field list' at /home/imicp/mautic/mautic/vendor/doctrine/dbal/src/Driver/PDO/Connection.php:71)"} {"hostname":"server.verfuehren-befriedigen-tipps.de","pid":12108}

```

Steps I have tried to fix the problem:  
I tried everything, wasn’t able to make Mautic run correctly with 2 weeks of work. I tried for example uploading fresh v5.1 files and imported the config-files (and .htaccess-file, as with the original one the site didnt work).

---

<div class="post-metadata">

**Author:** ![joeyk](https://sea2.discourse-cdn.com/flex020/user_avatar/forum.mautic.org/joeyk/32/11164_2.png) [@joeyk](https://forum.mautic.org/u/joeyk)\
**Post date:** [July 16, 2024, 3:28pm UTC](https://forum.mautic.org/t/most-links-buttons-clicked-in-the-admin-area-show-an-500-error/32779/2 "2024-07-16T15:28:29Z")

</div>

Your Mysql is failing. Did you upload a large amount of data suddenly?  
Do you have space on device?

---

<div class="post-metadata">

**Author:** ![imihandstand](https://sea2.discourse-cdn.com/flex020/user_avatar/forum.mautic.org/imihandstand/32/1499_2.png) [@imihandstand](https://forum.mautic.org/u/imihandstand)\
**Post date:** [July 17, 2024, 10:14am UTC](https://forum.mautic.org/t/most-links-buttons-clicked-in-the-admin-area-show-an-500-error/32779/3 "2024-07-17T10:14:07Z")

</div>

As backups while trying to solve the issues, I did a few copies of my mautic-folder (mautic2, mautic3, etc.) and mautic-database. I deleted now and left just a few.  
Disk Usage: 5.21 GB / unlimited

Still same issue

---

<div class="post-metadata">

**Author:** ![imihandstand](https://sea2.discourse-cdn.com/flex020/user_avatar/forum.mautic.org/imihandstand/32/1499_2.png) [@imihandstand](https://forum.mautic.org/u/imihandstand)\
**Post date:** [July 18, 2024, 10:24am UTC](https://forum.mautic.org/t/most-links-buttons-clicked-in-the-admin-area-show-an-500-error/32779/4 "2024-07-18T10:24:34Z")

</div>

As I really tried already everything and nothing worked, I’m forced to install a fresh Mautic and transfer the data to it with some automation.

So this topic can be closed (I’m not sure how to)

---

<div class="post-metadata">

**Author:** ![system](https://us1.discourse-cdn.com/flex020/uploads/mautic/original/1X/43c63600fe51440378769136903f1fa2a9a34102.png) [@system](https://forum.mautic.org/u/system)\
**Post date:** [July 19, 2024, 10:25pm UTC](https://forum.mautic.org/t/most-links-buttons-clicked-in-the-admin-area-show-an-500-error/32779/5 "2024-07-19T22:25:28Z")

</div>

This topic was automatically closed 36 hours after the last reply. New replies are no longer allowed.