Dolibarr ERP & CRM » Bugs » bug #1822 SQL error in clientfourn.php report with PostgreSQLLatest modifications
Answer now
Snapshot| Details |
| Submitted by: | Marcos García (marcosgdf) | | Submitted on: | 2015-02-03 13:03 |
| Last Modified On: | 2015-02-03 13:03 | |
| Summary: | SQL error in clientfourn.php report with PostgreSQL |
| Description: | ( ! ) Xdebug: user triggered in /var/www/dolibarr/htdocs/core/lib/functions.lib.php on line 2371
Call Stack
# Time Memory Function Location
1 0.0010 242288 {main}( ) ../clientfourn.php:0
2 0.1429 1581552 dol_print_error( ) ../clientfourn.php:598
3 0.1476 1623640 xdebug_print_function_stack ( ) ../functions.lib.php:2371
Dolibarr ha detectado un error técnico.
He aquí la información que podrá ayudar al diagnóstico:
Fecha: 20150203120214
Dolibarr: 3.6.3
Nivel de funciones: 0
PHP: 5.5.20-1~dotdeb.1
Server: Apache/2.4.10 (Debian)
URL solicitada: /compta/resultat/clientfourn.php?leftmenu=ca
Referer: http://dolibarr.local/compta/resultat/clientfourn.php?leftmenu=ca
Gestor de menú: eldy_menu.php
Tipo de gestor de base de datos: pgsql
Petición último acceso a la base de datos erróneo: SELECT p.label as nom, date_format(p.datep,'%Y-%m') as dm, sum(p.amount) as amount, u.firstname, u.lastname, p.fk_user FROM llx_payment_salary as p INNER JOIN llx_user as u ON u.rowid=p.fk_user WHERE p.entity = 1 AND p.datep >= '2015-01-01 00:00:00' AND p.datep <= '2015-12-31 23:59:59' GROUP BY u.rowid ORDER BY u.firstname
Código devuelto último acceso a la base de datos erróneo: DB_ERROR_42803
Información sobre el último acceso a la base de datos erróneo: ERROR: 42803: column "p.label" must appear in the GROUP BY clause or be used in an aggregate function LINE 1: SELECT p.label as nom, date_format(p.datep,'%Y-%m') as dm, s... ^ LOCATION: check_ungrouped_columns_walker, parse_agg.c:911
XDebug informations:
File: /var/www/dolibarr/htdocs/compta/resultat/clientfourn.php
Line: 598
Function: {main} |
| Step to reproduce bug: | |
| Detected in version: | 3.6.2 | | Category: | Module: Accounting |
| Severity: | 5 - Major | | OS Type/Version: | |
| PHP version: | | | Database type and version: | PostgreSQL |
| Status |
| Status: | Open | | Assigned to: | None |
| Resolution: | None | |
|
|