Your software
My Mautic version is: 5.x
My PHP version is: 8.2.26
My Database type and version is: 10.11.10-MariaDB-ubu2204
Your problem
My problem is: When uploading and publishing an asset (jpeg) I can view it when logged in, but it returns a 500-error when trying to access it from a not logged in browser.
These errors are showing in the log:
[2024-12-12T11:53:48.804175+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_.trigger_window' in 'SELECT'" at /var/www/vhosts/XXXXXX.de/mautic/web/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_.trigger_window' in 'SELECT' at /var/www/vhosts/XXXXXX.de/mautic/web/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_.trigger_window' in 'SELECT' at /var/www/vhosts/XXXXXX.de/mautic/web/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_.trigger_window' in 'SELECT' at /var/www/vhosts/XXXXXX.de/mautic/web/vendor/doctrine/dbal/src/Driver/PDO/Statement.php:130)"} {"hostname":"subhost.XXXXXX.de","pid":76699}
Steps I have tried to fix the problem:
- Renamed the asset
- Remove hyphens from the asset alias