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:
[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).