Re: [Galette-discussion] Problème avec l'Ajout de colonnes triées dans l

Trace

#0 /home/oh2lebt2/asso.oitar.info/lib/Galette/Repository/Members.php(245): Galette\Core\Pagination->setLimits(false)
#1 /home/oh2lebt2/asso.oitar.info/includes/routes/members.routes.php(345): Galette\Repository\Members->getMembersList(true)
#2 [internal function]: Closure->{closure}(Object(Slim\Http\Request), Object(Slim\Http\Response), Array)
#3 /home/oh2lebt2/asso.oitar.info/vendor/slim/slim/Slim/Handlers/Strategies/RequestResponse.php(41): call_user_func(Object(Closure), Object(Slim\Http\Request), Object(Slim\Http\Response), Array)
#4 /home/oh2lebt2/asso.oitar.info/vendor/slim/slim/Slim/Route.php(335): Slim\Handlers\Strategies\RequestResponse->__invoke(Object(Closure), Object(Slim\Http\Request), Object(Slim\Http\Response), Array)
#5 /home/oh2lebt2/asso.oitar.info/includes/main.inc.php(236): Slim\Route->__invoke(Object(Slim\Http\Request), Object(Slim\Http\Response))
#6 [internal function]: Closure->{closure}(Object(Slim\Http\Request), Object(Slim\Http\Response), Object(Slim\Route))
#7 /home/oh2lebt2/asso.oitar.info/vendor/slim/slim/Slim/DeferredCallable.php(43): call_user_func_array(Object(Closure), Array)
#8 [internal function]: Slim\DeferredCallable->__invoke(Object(Slim\Http\Request), Object(Slim\Http\Response), Object(Slim\Route))
#9 /home/oh2lebt2/asso.oitar.info/vendor/slim/slim/Slim/MiddlewareAwareTrait.php(70): call_user_func(Object(Slim\DeferredCallable), Object(Slim\Http\Request), Object(Slim\Http\Response), Object(Slim\Route))
#10 /home/oh2lebt2/asso.oitar.info/vendor/slim/slim/Slim/MiddlewareAwareTrait.php(117): Slim\Route->Slim\{closure}(Object(Slim\Http\Request), Object(Slim\Http\Response))
#11 /home/oh2lebt2/asso.oitar.info/vendor/slim/slim/Slim/Route.php(313): Slim\Route->callMiddlewareStack(Object(Slim\Http\Request), Object(Slim\Http\Response))
#12 /home/oh2lebt2/asso.oitar.info/vendor/slim/slim/Slim/App.php(495): Slim\Route->run(Object(Slim\Http\Request), Object(Slim\Http\Response))
#13 /home/oh2lebt2/asso.oitar.info/vendor/akrabat/rka-slim-session-middleware/RKA/SessionMiddleware.php(47): Slim\App->__invoke(Object(Slim\Http\Request), Object(Slim\Http\Response))
#14 [internal function]: RKA\SessionMiddleware->__invoke(Object(Slim\Http\Request), Object(Slim\Http\Response), Object(Slim\App))
#15 /home/oh2lebt2/asso.oitar.info/vendor/slim/slim/Slim/DeferredCallable.php(43): call_user_func_array(Object(RKA\SessionMiddleware), Array)
#16 [internal function]: Slim\DeferredCallable->__invoke(Object(Slim\Http\Request), Object(Slim\Http\Response), Object(Slim\App))
#17 /home/oh2lebt2/asso.oitar.info/vendor/slim/slim/Slim/MiddlewareAwareTrait.php(70): call_user_func(Object(Slim\DeferredCallable), Object(Slim\Http\Request), Object(Slim\Http\Response), Object(Slim\App))
#18 /home/oh2lebt2/asso.oitar.info/includes/main.inc.php(370): Slim\App->Slim\{closure}(Object(Slim\Http\Request), Object(Slim\Http\Response))
#19 [internal function]: Closure->{closure}(Object(Slim\Http\Request), Object(Slim\Http\Response), Object(Closure))
#20 /home/oh2lebt2/asso.oitar.info/vendor/slim/slim/Slim/DeferredCallable.php(43): call_user_func_array(Object(Closure), Array)
#21 [internal function]: Slim\DeferredCallable->__invoke(Object(Slim\Http\Request), Object(Slim\Http\Response), Object(Closure))
#22 /home/oh2lebt2/asso.oitar.info/vendor/slim/slim/Slim/MiddlewareAwareTrait.php(70): call_user_func(Object(Slim\DeferredCallable), Object(Slim\Http\Request), Object(Slim\Http\Response), Object(Closure))
#23 /home/oh2lebt2/asso.oitar.info/includes/main.inc.php(395): Slim\App->Slim\{closure}(Object(Slim\Http\Request), Object(Slim\Http\Response))
#24 [internal function]: Closure->{closure}(Object(Slim\Http\Request), Object(Slim\Http\Response), Object(Closure))
#25 /home/oh2lebt2/asso.oitar.info/vendor/slim/slim/Slim/DeferredCallable.php(43): call_user_func_array(Object(Closure), Array)
#26 [internal function]: Slim\DeferredCallable->__invoke(Object(Slim\Http\Request), Object(Slim\Http\Response), Object(Closure))
#27 /home/oh2lebt2/asso.oitar.info/vendor/slim/slim/Slim/MiddlewareAwareTrait.php(70): call_user_func(Object(Slim\DeferredCallable), Object(Slim\Http\Request), Object(Slim\Http\Response), Object(Closure))
#28 /home/oh2lebt2/asso.oitar.info/includes/main.inc.php(452): Slim\App->Slim\{closure}(Object(Slim\Http\Request), Object(Slim\Http\Response))
#29 [internal function]: Closure->{closure}(Object(Slim\Http\Request), Object(Slim\Http\Response), Object(Closure))
#30 /home/oh2lebt2/asso.oitar.info/vendor/slim/slim/Slim/DeferredCallable.php(43): call_user_func_array(Object(Closure), Array)
#31 [internal function]: Slim\DeferredCallable->__invoke(Object(Slim\Http\Request), Object(Slim\Http\Response), Object(Closure))
#32 /home/oh2lebt2/asso.oitar.info/vendor/slim/slim/Slim/MiddlewareAwareTrait.php(70): call_user_func(Object(Slim\DeferredCallable), Object(Slim\Http\Request), Object(Slim\Http\Response), Object(Closure))
#33 /home/oh2lebt2/asso.oitar.info/vendor/slim/slim/Slim/MiddlewareAwareTrait.php(117): Slim\App->Slim\{closure}(Object(Slim\Http\Request), Object(Slim\Http\Response))
#34 /home/oh2lebt2/asso.oitar.info/vendor/slim/slim/Slim/App.php(388): Slim\App->callMiddlewareStack(Object(Slim\Http\Request), Object(Slim\Http\Response))
#35 /home/oh2lebt2/asso.oitar.info/vendor/slim/slim/Slim/App.php(296): Slim\App->process(Object(Slim\Http\Request), Object(Slim\Http\Response))
#36 /home/oh2lebt2/asso.oitar.info/includes/main.inc.php(465): Slim\App->run()
#37 /home/oh2lebt2/asso.oitar.info/webroot/index.php(44): require_once('/home/oh2lebt2/...')
#38 {main}

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 :

se dégrade ... Exemple dans */templates/default/gestion_adherents.tpl* /<th class="left">// // <a href=""members" data="" => {_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="" width="10" height="6" alt=""/>// // {else}// // <img src="" width="10"

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

Détails

Trace