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.