Project

General

Profile

Actions

Anomalie #1837

closed

Cannot sort transactions on payment type column

Added by Alain Paris about 1 month ago. Updated about 1 month ago.

Status:
Fermé
Priority:
Normal
Category:
Core
Target version:
Start date:
06/09/2024
Due date:
% Done:

100%

Estimated time:
Version utilisée:

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 

Actions #1

Updated by Johan Cwiklinski about 1 month 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
Actions #2

Updated by Johan Cwiklinski about 1 month ago

  • Status changed from Nouveau to Résolu
  • % Done changed from 0 to 100
Actions #3

Updated by Johan Cwiklinski about 1 month ago

  • Status changed from Résolu to Fermé
Actions

Also available in: Atom PDF