# Uh oh! I think I broke it. If I do it again, please report me to the system administrator!

**URL:** <https://forum.mautic.org/t/uh-oh-i-think-i-broke-it-if-i-do-it-again-please-report-me-to-the-system-administrator/27941>\
**Category:** Product Support\
**Created:** [May 8, 2023, 10:36am UTC](https://forum.mautic.org/t/uh-oh-i-think-i-broke-it-if-i-do-it-again-please-report-me-to-the-system-administrator/27941 "2023-05-08T10:36:06Z")\
**Posts on this page:** 1\
**Page:** 1

<div class="post-metadata">

**Author:** ![veeravenkatasai](https://sea2.discourse-cdn.com/flex020/user_avatar/forum.mautic.org/veeravenkatasai/32/14546_2.png) [@veeravenkatasai](https://forum.mautic.org/u/veeravenkatasai)\
**Post date:** [May 8, 2023, 10:36am UTC](https://forum.mautic.org/t/uh-oh-i-think-i-broke-it-if-i-do-it-again-please-report-me-to-the-system-administrator/27941/1 "2023-05-08T10:36:06Z")

</div>

**Your software**  
My Mautic version is: 4.47  
My PHP version is: 8.0.28  
My Database type and version is: 5.742

**Your problem**  
My problem is:

# Uh oh! I think I broke it. If I do it again, please report me to the system administrator!

#### **500** Internal Server Error

These errors are showing in the log:  
[2023-05-08 04:54:48] 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 ?) AND ((s.list\_id = ?) OR ((s.list\_id IS NULL) AND (EXISTS (SELECT null FROM ma\_lead\_lists\_leads lll WHERE (lll.leadlist\_id = ?) AND (lll.lead\_id = ph.lead\_id) AND (lll.manually\_removed = 0))))) GROUP BY s.id ORDER BY s.id DESC LIMIT 6’ with params [“2023-04-08 00:00:00”, “2023-05-08 23:59:59”, 10, 10]: SQLSTATE[42000]: Syntax error or access violation: 1055 Expression #10 of SELECT list is not in GROUP BY clause and contains nonaggregated column ‘domain-name\_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/domain-name/public\_html/domain-website/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 ?) AND ((s.list\_id = ?) OR ((s.list\_id IS NULL) AND (EXISTS (SELECT null FROM ma\_lead\_lists\_leads lll WHERE (lll.leadlist\_id = ?) AND (lll.lead\_id = ph.lead\_id) AND (lll.manually\_removed = 0))))) GROUP BY s.id ORDER BY s.id DESC LIMIT 6’ with params ["2023-04-08 00:00:00", "2023-05-08 23:59:59", 10, 10]:\n\nSQLSTATE[42000]: Syntax error or access violation: 1055 Expression #10 of SELECT list is not in GROUP BY clause and contains nonaggregated column ‘domain-name\_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/domain-anme/public\_html/domain-website/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 ‘domain-name\_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/domain-name/public\_html/crm-domain-website/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 ‘domain-name\_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/domain-name/public\_html/domain-website/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOStatement.php:117)”}  
[2023-05-08 04:55:01] 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 ?) AND ((s.list\_id = ?) OR ((s.list\_id IS NULL) AND (EXISTS (SELECT null FROM ma\_lead\_lists\_leads lll WHERE (lll.leadlist\_id = ?) AND (lll.lead\_id = ph.lead\_id) AND (lll.manually\_removed = 0))))) GROUP BY s.id ORDER BY s.id DESC LIMIT 6’ with params [“2023-04-08 00:00:00”, “2023-05-08 23:59:59”, 10, 10]: SQLSTATE[42000]: Syntax error or access violation: 1055 Expression #10 of SELECT list is not in GROUP BY clause and contains nonaggregated column ‘domain-name\_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/domain-name/public\_html/crm-domainwebsite/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 ?) AND ((s.list\_id = ?) OR ((s.list\_id IS NULL) AND (EXISTS (SELECT null FROM ma\_lead\_lists\_leads lll WHERE (lll.leadlist\_id = ?) AND (lll.lead\_id = ph.lead\_id) AND (lll.manually\_removed = 0))))) GROUP BY s.id ORDER BY s.id DESC LIMIT 6’ with params ["2023-04-08 00:00:00", "2023-05-08 23:59:59", 10, 10]:\n\nSQLSTATE[42000]: Syntax error or access violation: 1055 Expression #10 of SELECT list is not in GROUP BY clause and contains nonaggregated column ‘domain-name\_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/domain-name/public\_html/crm-domainwebsite/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 ‘domain-name\_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/domain-name/public\_html/crm.domain-website/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 ‘domain-name\_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/domain-name/public\_html/crm.domain-website/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOStatement.php:117)”}

Steps I have tried to fix the problem:  
I have cleared the cache and I have run the command update schema as suggested in mautic error documentation. Still, I am facing an issue.