# I have some problems with mautic after updating the latest version **URL:** \ **Category:** Mautic 4 Install/Upgrade Support\ **Created:** [June 1, 2022, 10:10pm UTC](https://forum.mautic.org/t/i-have-some-problems-with-mautic-after-updating-the-latest-version/24320 "2022-06-01T22:10:14Z")\ **Posts on this page:** 6\ **Page:** 1
**Author:** ![julianos](https://sea2.discourse-cdn.com/flex020/user_avatar/forum.mautic.org/julianos/32/6373_2.png) [@julianos](https://forum.mautic.org/u/julianos)\ **Post date:** [June 1, 2022, 10:10pm UTC](https://forum.mautic.org/t/i-have-some-problems-with-mautic-after-updating-the-latest-version/24320/1 "2022-06-01T22:10:15Z")
![phot0 1](https://us1.discourse-cdn.com/flex020/uploads/mautic/original/2X/6/6b00461e35551320c9b6a874fe928cbb1d72c01d.jpeg) ![photo 2](https://us1.discourse-cdn.com/flex020/uploads/mautic/original/2X/d/d84cc633f2c194885a29a8d49d4d99526bf59b95.png) ![photo 3](https://us1.discourse-cdn.com/flex020/uploads/mautic/original/2X/8/8cf0395037346472fdf6ec3a02d46ac27d0e4f92.png) My Mautic version is: v4.3.1 My PHP version is: PHP 7.4 (ea-php74) My Database type and version is: ibmysql - 5.6.43 Only dashboard page error: **500** Internal Server Error 1. Only The “Dashboard” page doesn’t work and gives: _ **500** Internal Server Error_ (photo 1) 1. I don’t see some numbers, like points, number of people of the emails to send I see this: _% points% points_ or _% pending%_ (photo 2-3) 1. These errors are showing in the log: [2022-06-01 23:25:00] mautic.CRITICAL: Uncaught PHP Exception Doctrine\DBAL\Exception\DriverException: “An exception occurred while executing ‘SELECT s.id, s.lead\_id, s.email\_address, s.is\_read, s.email\_id, s.date\_sent, s.date\_read, e.name AS email\_name, COUNT(ph.id) AS link\_hits, c.id AS company\_id, c.companyname AS company\_name, campaign.id AS campaign\_id, campaign.name AS campaign\_name, ll.id AS segment\_id, ll.name AS segment\_name FROM ma\_email\_stats s LEFT JOIN ma\_emails e ON s.email\_id = e.id LEFT JOIN ma\_page\_hits ph ON ph.source = “email” and ph.source\_id = s.email\_id and ph.lead\_id = s.lead\_id LEFT JOIN ma\_companies\_leads cl ON s.lead\_id = cl.lead\_id LEFT JOIN ma\_companies c ON cl.company\_id = c.id LEFT JOIN ma\_campaign\_events ce ON s.source = “campaign.event” and s.source\_id = ce.id LEFT JOIN ma\_lead\_lists ll ON s.list\_id = ll.id LEFT JOIN ma\_campaigns campaign ON ce.campaign\_id = campaign.id WHERE s.date\_sent BETWEEN ? AND ? GROUP BY s.id ORDER BY s.id DESC LIMIT 6’ with params [“2022-05-01 00:00:00”, “2022-06-01 00:00:00”]: SQLSTATE[42000]: Syntax error or access violation: 1055 Expression #10 of SELECT list is not in GROUP BY clause and contains nonaggregated column ‘fznextau\_ma1.c.id’ which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql\_mode=only\_full\_group\_by” at /home/redacted/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/AbstractMySQLDriver.php line 128 {“exception”:"[object] (Doctrine\DBAL\Exception\DriverException(code: 0): An exception occurred while executing ‘SELECT s.id, s.lead\_id, s.email\_address, s.is\_read, s.email\_id, s.date\_sent, s.date\_read, e.name AS email\_name, COUNT(ph.id) AS link\_hits, c.id AS company\_id, c.companyname AS company\_name, campaign.id AS campaign\_id, campaign.name AS campaign\_name, ll.id AS segment\_id, ll.name AS segment\_name FROM ma\_email\_stats s LEFT JOIN ma\_emails e ON s.email\_id = e.id LEFT JOIN ma\_page\_hits ph ON ph.source = “email” and ph.source\_id = s.email\_id and ph.lead\_id = s.lead\_id LEFT JOIN ma\_companies\_leads cl ON s.lead\_id = cl.lead\_id LEFT JOIN ma\_companies c ON cl.company\_id = c.id LEFT JOIN ma\_campaign\_events ce ON s.source = “campaign.event” and s.source\_id = ce.id LEFT JOIN ma\_lead\_lists ll ON s.list\_id = ll.id LEFT JOIN ma\_campaigns campaign ON ce.campaign\_id = campaign.id WHERE s.date\_sent BETWEEN ? AND ? GROUP BY s.id ORDER BY s.id DESC LIMIT 6’ with params [“2022-05-01 00:00:00”, “2022-06-01 00:00:00”]:\n\nSQLSTATE[42000]: Syntax error or access violation: 1055 Expression #10 of SELECT list is not in GROUP BY clause and contains nonaggregated column ‘fznextau\_ma1.c.id’ which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql\_mode=only\_full\_group\_by at /home/redacted/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/AbstractMySQLDriver.php:128, Doctrine\DBAL\Driver\PDO\Exception(code: 42000): SQLSTATE[42000]: Syntax error or access violation: 1055 Expression #10 of SELECT list is not in GROUP BY clause and contains nonaggregated column ‘fznextau\_ma1.c.id’ which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql\_mode=only\_full\_group\_by at /home/redacted/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDO/Exception.php:18, PDOException(code: 42000): SQLSTATE[42000]: Syntax error or access violation: 1055 Expression #10 of SELECT list is not in GROUP BY clause and contains nonaggregated column ‘fznextau\_ma1.c.id’ which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql\_mode=only\_full\_group\_by at /home/redacted/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOStatement.php:117)"} {“hostname”:“redacted”,“pid”:24547} Steps I have tried to fix the problem: i tried to delete the “cache” folder but then i restored it. ---
**Author:** ![silavapi](https://sea2.discourse-cdn.com/flex020/user_avatar/forum.mautic.org/silavapi/32/7424_2.png) [@silavapi](https://forum.mautic.org/u/silavapi)\ **Post date:** [June 9, 2022, 8:25am UTC](https://forum.mautic.org/t/i-have-some-problems-with-mautic-after-updating-the-latest-version/24320/2 "2022-06-09T08:25:25Z")
> [@julianos](#): > > My Database type and version is: ibmysql - 5.6.43 Are you using MySQL 5.6? If so, you need to update: [Requirements - Mautic Community](https://www.mautic.org/download/requirements) > MySQL (InnoDB support required) Minimum MySQL version is **5.7** or MariaDB **10.2**. ---
**Author:** ![julianos](https://sea2.discourse-cdn.com/flex020/user_avatar/forum.mautic.org/julianos/32/6373_2.png) [@julianos](https://forum.mautic.org/u/julianos)\ **Post date:** [June 9, 2022, 8:40am UTC](https://forum.mautic.org/t/i-have-some-problems-with-mautic-after-updating-the-latest-version/24320/3 "2022-06-09T08:40:03Z")
With the dashboard I solved by emptying the database table of “\_widgets”. I don’t know what to do with the points that are not seen in the users profile: % points% points _[[third photo]](https://us1.discourse-cdn.com/flex020/uploads/mautic/original/2X/8/8cf0395037346472fdf6ec3a02d46ac27d0e4f92.png)_ MySQL - 5.7.38 ---
**Author:** ![silavapi](https://sea2.discourse-cdn.com/flex020/user_avatar/forum.mautic.org/silavapi/32/7424_2.png) [@silavapi](https://forum.mautic.org/u/silavapi)\ **Post date:** [June 9, 2022, 8:42am UTC](https://forum.mautic.org/t/i-have-some-problems-with-mautic-after-updating-the-latest-version/24320/4 "2022-06-09T08:42:29Z")
Sorry misread that - strange that it is not pulling in the points value! Maybe a translation problem. Can you tell me what language you are using? Maybe try to re-get the translation pack? ---
**Author:** ![julianos](https://sea2.discourse-cdn.com/flex020/user_avatar/forum.mautic.org/julianos/32/6373_2.png) [@julianos](https://forum.mautic.org/u/julianos)\ **Post date:** [June 9, 2022, 9:12am UTC](https://forum.mautic.org/t/i-have-some-problems-with-mautic-after-updating-the-latest-version/24320/5 "2022-06-09T09:12:34Z")
I tried putting back the original language of the system, nothing happened. I re-downloaded the language pack, nothing. Continue to stay % points% points I am using the Italian language ---
**Author:** ![escopecz](https://sea2.discourse-cdn.com/flex020/user_avatar/forum.mautic.org/escopecz/32/370_2.png) [@escopecz](https://forum.mautic.org/u/escopecz)\ **Post date:** [June 17, 2022, 7:24am UTC](https://forum.mautic.org/t/i-have-some-problems-with-mautic-after-updating-the-latest-version/24320/6 "2022-06-17T07:24:36Z")
This is related to this PR: [Remove transChoice() as it is deprecated in Symfony 4.2 by ts-navghane · Pull Request #11046 · mautic/mautic · GitHub](https://github.com/mautic/mautic/pull/11046) which needed to be done for preparation for Symfony 5. We did not expect to cause these issues. All the translations on Transifex will have to be updated accordingly.