Actions
Anomalie #1837
closedCannot sort transactions on payment type column
Start date:
06/09/2024
Due date:
% Done:
100%
Estimated time:
Version utilisée:
Vote:
Description
Le tri de la nouvelle colonne "Type de Paiement" provoque une erreur.Trouvé après un upgrade de V1.0.4 vers V1.1.0 erreur reproduite sur la démo.
galette.log :
::1 - 2024-06-08 12:51:22 - ERROR - Query error: SELECT `t`.`trans_date` AS `trans_date`, `t`.`trans_id` AS `trans_id`, `t`.`trans_desc` AS `trans_desc`, `t`.`id_adh` AS `id_adh`, `t`.`trans_amount` AS `trans_amount`, `t`.`type_paiement_trans` AS `type_paiement_trans`, `a`.`nom_adh` AS `nom_adh`, `a`.`prenom_adh` AS `prenom_adh` FROM `galette_transactions` AS `t` INNER JOIN `galette_adherents` AS `a` ON `t`.`id_adh`=`a`.`id_adh` ORDER BY `7` ASC LIMIT 100 OFFSET 0 PDOException: SQLSTATE[42S22]: Column not found: 1054 Champ '7' inconnu dans order clause in B:\galetteinstall\galette\vendor\laminas\laminas-db\src\Adapter\Driver\Pdo\Connection.php:376 Stack trace: #0 B:\galetteinstall\galette\vendor\laminas\laminas-db\src\Adapter\Driver\Pdo\Connection.php(376): PDO->query('SELECT `t`.`tra...') ..... ::1 - 2024-06-08 12:51:22 - WARNING - Cannot list transactions | SQLSTATE[42S22]: Column not found: 1054 Champ '7' inconnu dans order clause
Updated by Johan Cwiklinski 5 months ago
- Subject changed from Gestion des transactions le tri de la colonne Type de paiement provoque une erreur to Cannot sort transactions on payment type column
- Category set to Core
- Assignee set to Johan Cwiklinski
- Target version set to 1.1.1
Updated by Johan Cwiklinski 5 months ago
- Status changed from Nouveau to Résolu
- % Done changed from 0 to 100
Appliqué par commit a58f453368c23e7519ff9c727bdfdeed16ccee73.
Actions