Customers module error

[rmassoud]

When I click on the customers module or the products module I get the below error.

[09-Sep-2016 17:02:36 Africa/Cairo] SQLSTATE[42000]: Syntax error or access violation: 1055 Expression #9 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'siwapp.c2.id' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by. Failing Query: "SELECT c.id AS c__id, c.name AS c__name, c.name_slug AS c__name_slug, c.identification AS c__identification, c.email AS c__email, c.contact_person AS c__contact_person, c.invoicing_address AS c__invoicing_address, c.shipping_address AS c__shipping_address, c2.id AS c2__id, c2.series_id AS c2__series_id, c2.customer_id AS c2__customer_id, c2.customer_name AS c2__customer_name, c2.customer_identification AS c2__customer_identification, c2.customer_email AS c2__customer_email, c2.invoicing_address AS c2__invoicing_address, c2.shipping_address AS c2__shipping_address, c2.contact_person AS c2__contact_person, c2.terms AS c2__terms, c2.notes AS c2__notes, c2.base_amount AS c2__base_amount, c2.discount_amount AS c2__discount_amount, c2.net_amount AS c2__net_amount, c2.gross_amount AS c2__gross_amount, c2.paid_amount AS c2__paid_amount, c2.tax_amount AS c2__tax_amount, c2.status AS c2__status, c2.type AS c2__type, c2.draft AS c2__draft, c2.closed AS c2__closed, c2.sent_by_email AS c2__sent_by_email, c2.number AS c2__number, c2.recurring_invoice_id AS c2__recurring_invoice_id, c2.issue_date AS c2__issue_date, c2.due_date AS c2__due_date, c2.days_to_due AS c2__days_to_due, c2.enabled AS c2__enabled, c2.max_occurrences AS c2__max_occurrences, c2.must_occurrences AS c2__must_occurrences, c2.period AS c2__period, c2.period_type AS c2__period_type, c2.starting_date AS c2__starting_date, c2.finishing_date AS c2__finishing_date, c2.last_execution_date AS c2__last_execution_date, c2.created_at AS c2__created_at, c2.updated_at AS c2__updated_at FROM customer c LEFT JOIN common c2 ON c.id = c2.customer_id AND (c2.type = 'Invoice') WHERE c.id IN ('5', '10', '14', '9', '12', '16', '3', '13', '4', '2') GROUP BY c.id ORDER BY c.name desc, c.name desc"
[09-Sep-2016 17:02:53 Africa/Cairo] SQLSTATE[42000]: Syntax error or access violation: 1055 Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'siwapp.p.id' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by. Failing Query: "SELECT p.id AS p__id, p.reference AS p__reference, p.description AS p__description, p.price AS p__price, FORMAT(SUM(IF(c.draft=1
OR c.type='RecurringInvoice'
OR i.quantity IS NULL, 0, i.quantity)), 0) AS c__0, SUM(IF(c.draft = 1
OR c.type = 'RecurringInvoice'
OR i.quantity IS NULL
OR i.unitary_cost IS NULL, 0, i.quantity * i.unitary_cost)) AS c__1, 't' AS p__2 FROM product p LEFT JOIN item i ON p.id = i.product_id LEFT JOIN common c ON i.common_id = c.id GROUP BY p__2 ORDER BY p.reference desc, p.reference desc"
[09-Sep-2016 17:03:31 Africa/Cairo] SQLSTATE[42000]: Syntax error or access violation: 1055 Expression #9 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'siwapp.c2.id' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by. Failing Query: "SELECT c.id AS c__id, c.name AS c__name, c.name_slug AS c__name_slug, c.identification AS c__identification, c.email AS c__email, c.contact_person AS c__contact_person, c.invoicing_address AS c__invoicing_address, c.shipping_address AS c__shipping_address, c2.id AS c2__id, c2.series_id AS c2__series_id, c2.customer_id AS c2__customer_id, c2.customer_name AS c2__customer_name, c2.customer_identification AS c2__customer_identification, c2.customer_email AS c2__customer_email, c2.invoicing_address AS c2__invoicing_address, c2.shipping_address AS c2__shipping_address, c2.contact_person AS c2__contact_person, c2.terms AS c2__terms, c2.notes AS c2__notes, c2.base_amount AS c2__base_amount, c2.discount_amount AS c2__discount_amount, c2.net_amount AS c2__net_amount, c2.gross_amount AS c2__gross_amount, c2.paid_amount AS c2__paid_amount, c2.tax_amount AS c2__tax_amount, c2.status AS c2__status, c2.type AS c2__type, c2.draft AS c2__draft, c2.closed AS c2__closed, c2.sent_by_email AS c2__sent_by_email, c2.number AS c2__number, c2.recurring_invoice_id AS c2__recurring_invoice_id, c2.issue_date AS c2__issue_date, c2.due_date AS c2__due_date, c2.days_to_due AS c2__days_to_due, c2.enabled AS c2__enabled, c2.max_occurrences AS c2__max_occurrences, c2.must_occurrences AS c2__must_occurrences, c2.period AS c2__period, c2.period_type AS c2__period_type, c2.starting_date AS c2__starting_date, c2.finishing_date AS c2__finishing_date, c2.last_execution_date AS c2__last_execution_date, c2.created_at AS c2__created_at, c2.updated_at AS c2__updated_at FROM customer c LEFT JOIN common c2 ON c.id = c2.customer_id AND (c2.type = 'Invoice') WHERE c.id IN ('5', '10', '14', '9', '12', '16', '3', '13', '4', '2') GROUP BY c.id ORDER BY c.name desc, c.name desc"