Our team intervenes within 48 hours, we recommend you submit a public ticket so that other developers can help to fix the issue as soon as possible.

If you purchased the item 6 months ago, please read the Item Support Policy carefully before submitting a ticket.

Note: don’t share item or server credentials on public, use the private option.

Okay
  Public Ticket #2790875
Failure in the Payment > Invoices menu in the web portal
Closed

Comments

  •  1
    oliveira0501 started the conversation

    When entering the Paymento> Invoices menu on the portal, the error below is displayed:

    Error Number: 1055

    Expression # 1 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'guia.invoice.id' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode = only_full_group_by

    SELECT * FROM `invoice` GROUP BY` invoice`.`created_at` ORDER BY `invoice`.`created_at` DESC LIMIT 15

    Filename: modules / payment / models / Payment_model.php

    Line Number: 425

    Note: It is a new installation.

  •   oliveira0501 replied privately
  •   oliveira0501 replied privately
  •  1
    oliveira0501 replied

    I noticed that in version 2.6 the same problem continues.