Voilà la fraction de log correspondant au bug :

185.2.4.98 - 2018-07-10 14:51:04 - 7 - [Db] Database connection was successfull! 185.2.4.98 - 2018-07-10 14:51:04 - 7 - Executing query: SELECT `oitar_database`.`version` AS `version` FROM `oitar_database` LIMIT 1 185.2.4.98 - 2018-07-10 14:51:04 - 6 - Plugin galette-plugin-events is explicitely disabled 185.2.4.98 - 2018-07-10 14:51:04 - 6 - Plugin galette-plugin-maps is explicitely disabled 185.2.4.98 - 2018-07-10 14:51:04 - 7 - [Db] Database connection was successfull! 185.2.4.98 - 2018-07-10 14:51:04 - 7 - [Db] Database connection was successfull! 185.2.4.98 - 2018-07-10 14:51:04 - 6 - Plugin galette-plugin-events is explicitely disabled 185.2.4.98 - 2018-07-10 14:51:04 - 6 - Plugin galette-plugin-maps is explicitely disabled 185.2.4.98 - 2018-07-10 14:51:04 - 7 - Executing query: SELECT DISTINCT `oitar_statuts`.`id_statut` AS `id_statut`, `oitar_statuts`.`libelle_statut` AS `libelle_statut`, `oitar_statuts`.`priorite_statut` AS `priorite_statut` FROM `oitar_statuts` ORDER BY `priorite_statut` ASC 185.2.4.98 - 2018-07-10 14:51:04 - 7 - Executing query: SELECT `oitar_l10n`.`text_trans` AS `text_trans` FROM `oitar_l10n` WHERE `text_orig` = 'A' AND `text_locale` = 'fr_FR.utf8' LIMIT 1 185.2.4.98 - 2018-07-10 14:51:04 - 7 - Executing query: SELECT `oitar_l10n`.`text_trans` AS `text_trans` FROM `oitar_l10n` WHERE `text_orig` = 'C' AND `text_locale` = 'fr_FR.utf8' LIMIT 1 185.2.4.98 - 2018-07-10 14:51:04 - 7 - Executing query: SELECT `oitar_l10n`.`text_trans` AS `text_trans` FROM `oitar_l10n` WHERE `text_orig` = 'M' AND `text_locale` = 'fr_FR.utf8' LIMIT 1 185.2.4.98 - 2018-07-10 14:51:04 - 7 - Executing query: SELECT `oitar_l10n`.`text_trans` AS `text_trans` FROM `oitar_l10n` WHERE `text_orig` = 'MI' AND `text_locale` = 'fr_FR.utf8' LIMIT 1 185.2.4.98 - 2018-07-10 14:51:04 - 7 - Executing query: SELECT `oitar_l10n`.`text_trans` AS `text_trans` FROM `oitar_l10n` WHERE `text_orig` = 'Non renseigné' AND `text_locale` = 'fr_FR.utf8' LIMIT 1 185.2.4.98 - 2018-07-10 14:51:04 - 7 - [Galette\Filters\MembersList|Pagination] Setting property `orderby` 185.2.4.98 - 2018-07-10 14:51:04 - 7 - [MembersList] Getting property `email_filter` 185.2.4.98 - 2018-07-10 14:51:04 - 7 - [MembersList] Getting property `email_filter` 185.2.4.98 - 2018-07-10 14:51:04 - 7 - [MembersList] Getting property `filter_str` 185.2.4.98 - 2018-07-10 14:51:04 - 7 - [MembersList] Getting property `membership_filter` 185.2.4.98 - 2018-07-10 14:51:04 - 7 - [MembersList] Getting property `account_status_filter` 185.2.4.98 - 2018-07-10 14:51:04 - 7 - [MembersList] Getting property `group_filter` 185.2.4.98 - 2018-07-10 14:51:04 - 7 - [MembersList] Getting property `group_filter` 185.2.4.98 - 2018-07-10 14:51:04 - 7 - [MembersList] Getting property `group_filter` 185.2.4.98 - 2018-07-10 14:51:04 - 7 - [MembersList] Getting property `orderby` 185.2.4.98 - 2018-07-10 14:51:04 - 7 - [Galette\Filters\MembersList|Pagination] Getting property `orderby` 185.2.4.98 - 2018-07-10 14:51:05 - 7 - [Db] Database connection was successfull! 185.2.4.98 - 2018-07-10 14:51:05 - 7 - Executing query: SELECT `oitar_database`.`version` AS `version` FROM `oitar_database` LIMIT 1 185.2.4.98 - 2018-07-10 14:51:05 - 6 - Plugin galette-plugin-events is explicitely disabled 185.2.4.98 - 2018-07-10 14:51:05 - 6 - Plugin galette-plugin-maps is explicitely disabled 185.2.4.98 - 2018-07-10 14:51:05 - 7 - [Db] Database connection was successfull! 185.2.4.98 - 2018-07-10 14:51:05 - 7 - [Db] Database connection was successfull! 185.2.4.98 - 2018-07-10 14:51:05 - 6 - Plugin galette-plugin-events is explicitely disabled 185.2.4.98 - 2018-07-10 14:51:05 - 6 - Plugin galette-plugin-maps is explicitely disabled 185.2.4.98 - 2018-07-10 14:51:05 - 7 - Executing query: SELECT DISTINCT `oitar_statuts`.`id_statut` AS `id_statut`, `oitar_statuts`.`libelle_statut` AS `libelle_statut`, `oitar_statuts`.`priorite_statut` AS `priorite_statut` FROM `oitar_statuts` ORDER BY `priorite_statut` ASC 185.2.4.98 - 2018-07-10 14:51:05 - 7 - Executing query: SELECT `oitar_l10n`.`text_trans` AS `text_trans` FROM `oitar_l10n` WHERE `text_orig` = 'A' AND `text_locale` = 'fr_FR.utf8' LIMIT 1 185.2.4.98 - 2018-07-10 14:51:05 - 7 - Executing query: SELECT `oitar_l10n`.`text_trans` AS `text_trans` FROM `oitar_l10n` WHERE `text_orig` = 'C' AND `text_locale` = 'fr_FR.utf8' LIMIT 1 185.2.4.98 - 2018-07-10 14:51:05 - 7 - Executing query: SELECT `oitar_l10n`.`text_trans` AS `text_trans` FROM `oitar_l10n` WHERE `text_orig` = 'M' AND `text_locale` = 'fr_FR.utf8' LIMIT 1 185.2.4.98 - 2018-07-10 14:51:05 - 7 - Executing query: SELECT `oitar_l10n`.`text_trans` AS `text_trans` FROM `oitar_l10n` WHERE `text_orig` = 'MI' AND `text_locale` = 'fr_FR.utf8' LIMIT 1 185.2.4.98 - 2018-07-10 14:51:05 - 7 - Executing query: SELECT `oitar_l10n`.`text_trans` AS `text_trans` FROM `oitar_l10n` WHERE `text_orig` = 'Non renseigné' AND `text_locale` = 'fr_FR.utf8' LIMIT 1

Cordialement,

Georges Beyna

Johan a écrit :
Le 10 juillet 2018 11:43:15 GMT+02:00, Contact CID Auditeur 
<[email protected]> a écrit :
Bonjour à tous,

J'ai ajouté des colonnes dans gestion_adherents.tpl, jusque là pas de
problème, ça marche, Certaines doivent avoir une option de tri et là ça

se dégrade ...

Exemple dans */templates/default/gestion_adherents.tpl*

/<th class="left">//
//                        <a href="{path_for name="members"
data=["option" => {_T string='order' domain="routes"}, "value" =>
"Galette\Repository\Members::ORDERBY_BIRTHDATE"|constant]}">//
//                            {_T string="Birth date"}//
//                            {if $filters->orderby eq
constant('Galette\Repository\Members::ORDERBY_BIRTHDATE')}//
//                                {if $filters->ordered eq
constant('Galette\Filters\MembersList::ORDER_ASC')}//
//                                    <img
src="{base_url}/{$template_subdir}images/down.png" width="10"
height="6"
alt=""/>//
//                                {else}//
//                                    <img
src="{base_url}/{$template_subdir}images/up.png" width="10" height="6"
alt=""/>//
//                                {/if}//
//                            {/if}//
//                        </a>//
//                    </th>/

+

/<td class="{$rclass}">{$member->birthdate}</td>/


dans *lib/Galette/Repository/Members.php*

/const ORDERBY_BIRTHDATE = 6;/

+

/case self::ORDERBY_BIRTHDATE://
//                if ( $this->canOrderBy('ddn_adh', $fields) ) {//
//                    $order[] = 'ddn_adh ' .
$this->_filters->getDirection();//
//                }//
//            break;/

En faisant attention à la position du CASE


Au clic sur l'entête de col, j'ai une erreur : *Erreur de
l’application*


J'ai du oublier quelque chose mais QUOI ??? Une autre modif ??? Dans un

autre fichier ??? Merci d'avance pour votre aide
Salut,

Pas trop d'idée sans creuser davantage, il faudrait voir ce que disent les logs 
dans un premier temps.

++
Johan


Répondre à