Bonjour,
Un message d’erreur dans la v12 que je vous joins. J’ajoute qu’il s’agit d’une montée de version de la 11.0.4.
Warning : pg_num_rows() expects parameter 1 to be resource, boolean given in /code/htdocs/core/db/pgsql.class.php on line 625
Dolibarr a détecté une erreur technique.
Voici les informations qui pourront aider au diagnostic (Vous pouvez fixer l’option $dolibarr_main_prod sur ‹ 1 › pour supprimer quelques notifications):
Date: 20200705132849
Dolibarr: 12.0.0 - https://www.dolibarr.org
Niveau de fonctionnalités: 0
PHP: 7.2.31
Server: Apache/2.4.25 (Debian)
OS: Linux 76950784e76f 4.19.104-microsoft-standard #1 SMP Wed Feb 19 06:37:35 UTC 2020 x86_64
UserAgent: Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/83.0.4103.116 Safari/537.36 Edg/83.0.478.58
Url sollicitée: /compta/facture/list.php?restore_lastsearch_values=1
Referer: http://localhost:801/compta/facture/card.php?facid=316
Gestionnaire de menu: eldy_menu.php
Modules/Applications: user, syslog, cron, commande, propal, ecm, categorie, facture, societe, service
Type gestionnaire de base de données: pgsql
Requête dernier accès en base en erreur: SELECT f.rowid as id, f.ref, f.ref_client, f.type, f.note_private, f.note_public, f.increment, f.fk_mode_reglement, f.fk_cond_reglement, f.total as total_ht, f.tva as total_vat, f.total_ttc, f.localtax1 as total_localtax1, f.localtax2 as total_localtax2, f.fk_user_author, f.fk_multicurrency, f.multicurrency_code, f.multicurrency_tx, f.multicurrency_total_ht, f.multicurrency_total_tva as multicurrency_total_vat, f.multicurrency_total_ttc, f.datef as df, f.date_valid, f.date_lim_reglement as datelimite, f.module_source, f.pos_source, f.paye as paye, f.fk_statut, f.close_code, f.datec as date_creation, f.tms as date_update, f.date_closing as date_closing, f.retained_warranty, f.retained_warranty_date_limit, f.situation_final, f.situation_cycle_ref, f.situation_counter, s.rowid as socid, s.nom as name, s.email, s.town, s.zip, s.fk_pays, s.client, s.fournisseur, s.code_client, s.code_fournisseur, s.code_compta as code_compta_client, s.code_compta_fournisseur, typent.code as typent_code, state.code_departement as state_code, state.nom as state_name, country.code as country_code, p.rowid as project_id, p.ref as project_ref, p.title as project_label, u.login, SUM(pf.amount) as dynamount_payed, SUM(pf.multicurrency_amount) as multicurrency_dynamount_payed FROM llx_societe as s LEFT JOIN llx_c_country as country on (country.rowid = s.fk_pays) LEFT JOIN llx_c_typent as typent on (typent.id = s.fk_typent) LEFT JOIN llx_c_departements as state on (state.rowid = s.fk_departement), llx_facture as f LEFT JOIN llx_paiement_facture as pf ON pf.fk_facture = f.rowid LEFT JOIN llx_projet as p ON p.rowid = f.fk_projet LEFT JOIN llx_user AS u ON f.fk_user_author = u.rowid WHERE f.fk_soc = s.rowid AND f.entity IN (1) GROUP BY f.rowid, f.ref, ref_client, f.type, f.note_private, f.note_public, f.increment, f.fk_mode_reglement, f.fk_cond_reglement, f.total, f.tva, f.total_ttc, f.localtax1, f.localtax2, f.datef, f.date_valid, f.date_lim_reglement, f.module_source, f.pos_source, f.paye, f.fk_statut, f.close_code, f.datec, f.tms, f.date_closing, f.retained_warranty, f.retained_warranty_date_limit, f.situation_final, f.situation_cycle_ref, f.situation_counter, s.rowid, s.nom, s.email, s.town, s.zip, s.fk_pays, s.client, s.fournisseur, s.code_client, s.code_fournisseur, s.code_compta, s.code_compta_fournisseur, typent.code, state.code_departement, state.nom, country.code, p.rowid, p.ref, p.title ORDER BY f.datef DESC, f.rowid DESC LIMIT 26
Code retour dernier accès en base en erreur: DB_ERROR_42803
Information sur le dernier accès en base en erreur: ERROR: 42803: column « u.login » must appear in the GROUP BY clause or be used in an aggregate function\nLINE 1: …, p.ref as project_ref, p.title as project_label, u.login, S…\n ^\nLOCATION: check_ungrouped_columns_walker, parse_agg.c:1388
