# Email report loading spinner spins forever **URL:** \ **Category:** Product Support\ **Created:** [November 10, 2020, 10:45pm UTC](https://forum.mautic.org/t/email-report-loading-spinner-spins-forever/16971 "2020-11-10T22:45:53Z")\ **Posts on this page:** 4\ **Page:** 1
**Author:** ![daveusername](https://sea2.discourse-cdn.com/flex020/user_avatar/forum.mautic.org/daveusername/32/3730_2.png) [@daveusername](https://forum.mautic.org/u/daveusername)\ **Post date:** [November 10, 2020, 10:45pm UTC](https://forum.mautic.org/t/email-report-loading-spinner-spins-forever/16971/1 "2020-11-10T22:45:53Z")
**Your software** My Mautic version is: Mautic 3.1.2 - app/prod (kernel: app, env: prod, debug: false) My PHP version is:7.2.34 My Database type and version is: MySQL 8.0.22 **Your problem** The “loading spinner” on the Channel -\> Email report spins forever. I used the stock “Blank” starter template, adding random text I found and a trackable button; and sent it to a handful of test contacts. > **[Test Email #3](https://mautic.codetemporary.com/email/view/5fab0b0e040a3214869420)** Mautic knows that the emails have been opened; but whatever display is supposed to appear on the email page doesn’t seem to be working. The “loading” spinner spins forever. Have others seen this? Thanks! ---
**Author:** ![codes9](https://sea2.discourse-cdn.com/flex020/user_avatar/forum.mautic.org/codes9/32/682_2.png) [@codes9](https://forum.mautic.org/u/codes9)\ **Post date:** [November 11, 2020, 10:22pm UTC](https://forum.mautic.org/t/email-report-loading-spinner-spins-forever/16971/2 "2020-11-11T22:22:26Z")
Clear your cache. If it still continues. Tell us what’s in your Mautic log and webserver error log? ---
**Author:** ![daveusername](https://sea2.discourse-cdn.com/flex020/user_avatar/forum.mautic.org/daveusername/32/3730_2.png) [@daveusername](https://forum.mautic.org/u/daveusername)\ **Post date:** [November 12, 2020, 12:38am UTC](https://forum.mautic.org/t/email-report-loading-spinner-spins-forever/16971/3 "2020-11-12T00:38:07Z")
Hi @codes9. Thanks for the suggestion. Clearing the cache did not resolve the issue. No errors appearing in the webserver log, but I am seeing an error in the mautic log. Log fie: `/opt/bitnami/apps/mautic/htdocs/var/logs/mautic_prod-2020-11-12.php` The following error appears when I open channels-\>emails-\>any email: `[2020-11-11 19:19:18] mautic.CRITICAL: Uncaught PHP Exception Doctrine\DBAL\Exception\SyntaxErrorException: "An exception occurred while executing 'SELECT count(DISTINCT .ph.lead_id) as click_count, cs.leadlist_id FROM ma_channel_url_trackables cut INNER JOIN ma_page_hits ph ON ph.redirect_id = cut.redirect_id AND ph.source = cut.channel AND ph.source_id = cut.channel_id INNER JOIN ma_lead_lists_leads cs ON cs.lead_id = ph.lead_id WHERE (cut.channel = ?) AND (cut.channel_id IN (8)) AND (cs.leadlist_id IN (4, 5)) AND (ph.date_hit BETWEEN ? AND ?) GROUP BY cs.leadlist_id' with params ["email", "2020-10-10 00:00:00", "2020-11-11 19:19:18"]: SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '.ph.lead_id) as click_count, cs.leadlist_id FROM ma_channel_url_trackables cut I' at line 1" at /opt/bitnami/apps/mautic/htdocs/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/AbstractMySQLDriver.php line 79 {"exception":"[object] (Doctrine\\DBAL\\Exception\\SyntaxErrorException(code: 0): An exception occurred while executing 'SELECT count(DISTINCT .ph.lead_id) as click_count, cs.leadlist_id FROM ma_channel_url_trackables cut INNER JOIN ma_page_hits ph ON ph.redirect_id = cut.redirect_id AND ph.source = cut.channel AND ph.source_id = cut.channel_id INNER JOIN ma_lead_lists_leads cs ON cs.lead_id = ph.lead_id WHERE (cut.channel = ?) AND (cut.channel_id IN (8)) AND (cs.leadlist_id IN (4, 5)) AND (ph.date_hit BETWEEN ? AND ?) GROUP BY cs.leadlist_id' with params [\"email\", \"2020-10-10 00:00:00\", \"2020-11-11 19:19:18\"]:\n\nSQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '.ph.lead_id) as click_count, cs.leadlist_id FROM ma_channel_url_trackables cut I' at line 1 at /opt/bitnami/apps/mautic/htdocs/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/AbstractMySQLDriver.php:79, Doctrine\\DBAL\\Driver\\PDOException(code: 42000): SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '.ph.lead_id) as click_count, cs.leadlist_id FROM ma_channel_url_trackables cut I' at line 1 at /opt/bitnami/apps/mautic/htdocs/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOStatement.php:123, PDOException(code: 42000): SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '.ph.lead_id) as click_count, cs.leadlist_id FROM ma_channel_url_trackables cut I' at line 1 at /opt/bitnami/apps/mautic/htdocs/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOStatement.php:121)"} []` Thanks. ---
**Author:** ![codes9](https://sea2.discourse-cdn.com/flex020/user_avatar/forum.mautic.org/codes9/32/682_2.png) [@codes9](https://forum.mautic.org/u/codes9)\ **Post date:** [November 12, 2020, 12:40am UTC](https://forum.mautic.org/t/email-report-loading-spinner-spins-forever/16971/4 "2020-11-12T00:40:05Z")
Upgrade your MariaDB version to somewhere around 10.3 > [@500 Error](https://forum.mautic.org/t/500-error/16991/10): > > I’m happy your Installation is working again. Enjoy Mautic grinning TL;DR: For anyone else coming across this post in the future: Mariadb 10.4 needs PHP 7.3 in a Mautic install or Symfony will throw errors.