Bonjour,
Dolibarr envoie une erreur bloquante lorsque l’on souhaite trier par type la liste de factures présentée à https://ndm.tld/compta/accounting-files.php?mainmenu=accountancy&leftmenu=accountancy_files
Type gestionnaire de base de données: mysqli
Requête dernier accès en base en erreur: SELECT t.rowid as id, t.ref, t.paye as paid, total as total_ht, total_ttc, tva as total_vat, fk_soc, t.datef as date, 'Invoice' as item, s.nom as thirdparty_name, s.code_client as thirdparty_code, c.code as country_code, s.tva_intra as vatnum FROM llx_facture as t LEFT JOIN llx_societe as s ON s.rowid = t.fk_soc LEFT JOIN llx_c_country as c ON c.rowid = s.fk_pays WHERE datef between '2019-07-17 00:00:00' AND '2019-08-02 23:59:59' AND t.entity IN (0,1) AND t.fk_statut <> 0 UNION ALL SELECT t.rowid as id, t.ref, paye as paid, total_ht, total_ttc, total_tva as total_vat, fk_soc, datef as date, 'SupplierInvoice' as item, s.nom as thirdparty_name, s.code_fournisseur as thirdparty_code, c.code as country_code, s.tva_intra as vatnum FROM llx_facture_fourn as t LEFT JOIN llx_societe as s ON s.rowid = t.fk_soc LEFT JOIN llx_c_country as c ON c.rowid = s.fk_pays WHERE datef between '2019-07-17 00:00:00' AND '2019-08-02 23:59:59' AND t.entity IN (0,1) AND t.fk_statut <> 0 UNION ALL SELECT t.rowid as id, t.ref, paid, total_ht, total_ttc, total_tva as total_vat, fk_user_author as fk_soc, date_fin as date, 'ExpenseReport' as item, CONCAT(CONCAT(u.lastname, ' '), u.firstname) as thirdparty_name, '' as thirdparty_code, c.code as country_code, '' as vatnum FROM llx_expensereport as t LEFT JOIN llx_user as u ON u.rowid = t.fk_user_author LEFT JOIN llx_c_country as c ON c.rowid = u.fk_country WHERE date_fin between '2019-07-17 00:00:00' AND '2019-08-02 23:59:59' AND t.entity IN (0,1) AND t.fk_statut <> 0 UNION ALL SELECT t.rowid as id, t.ref, paid, amount as total_ht, amount as total_ttc, 0 as total_vat, 0 as fk_soc, datedon as date, 'Donation' as item, t.societe as thirdparty_name, '' as thirdparty_code, c.code as country_code, '' as vatnum FROM llx_don as t LEFT JOIN llx_c_country as c ON c.rowid = t.fk_country WHERE datedon between '2019-07-17 00:00:00' AND '2019-08-02 23:59:59' AND t.entity IN (0,1) AND t.fk_statut <> 0 UNION ALL SELECT t.rowid as id, t.label as ref, 1 as paid, amount as total_ht, amount as total_ttc, 0 as total_vat, t.fk_user as fk_soc, datep as date, 'SalaryPayment' as item, CONCAT(CONCAT(u.lastname, ' '), u.firstname) as thirdparty_name, '' as thirdparty_code, c.code as country_code, '' as vatnum FROM llx_payment_salary as t LEFT JOIN llx_user as u ON u.rowid = t.fk_user LEFT JOIN llx_c_country as c ON c.rowid = u.fk_country WHERE datep between '2019-07-17 00:00:00' AND '2019-08-02 23:59:59' AND t.entity IN (0,1) UNION ALL SELECT t.rowid as id, t.libelle as ref, paye as paid, amount as total_ht, amount as total_ttc, 0 as total_tva, 0 as fk_soc, date_creation as date, 'SocialContributions' as item, '' as thirdparty_name, '' as thirdparty_code, '' as country_code, '' as vatnum FROM llx_chargesociales as t WHERE date_creation between '2019-07-17 00:00:00' AND '2019-08-02 23:59:59' AND t.entity IN (0,1) ORDER BY type DESC
Code retour dernier accès en base en erreur: DB_ERROR_NOSUCHFIELD
Information sur le dernier accès en base en erreur: Unknown column 'type' in 'order clause'Par ailleurs, le tri par Date ne retourne pas d’erreur mais ne semble pas fonctionner : les lignes du tableau sont légèrement ré-ordonnées mais pas par date.
