Agenda CVCM

Message : SQLSTATE[42S22]: Column not found: 1054 Unknown column 'agp.AGP_DATEDEBUT' in 'order clause'
Trace :
#0 /home/wwwroot/democ/www/include/class/common/class.paging.php(108): PDOStatement->execute()
#1 /home/wwwroot/democ/www/include/class/agenda/class.pagingAgenda.php(36): Paging->fetchAll()
#2 /home/wwwroot/democ/www/include/ajax/agenda/ajax.agendaListeItem.php(19): PagingAgenda->fetchAll()
#3 /home/wwwroot/democ/www/include/tpl/tpl_agendaListe.php(81): include('/home/wwwroot/d...')
#4 /home/wwwroot/democ/www/include/class/participation/tab/paragraph/class.ext_db_tabParagraphTemplate.php(85): include('/home/wwwroot/d...')
#5 /home/wwwroot/democ/www/include/tpl/views/participation/tab/paragraph/view.tabParagraphTemplate.php(3): TabParagraphTemplate->displayTemplate()
#6 /home/wwwroot/democ/www/include/class/common/class.view.php(185): include('/home/wwwroot/d...')
#7 /home/wwwroot/democ/www/include/tpl/views/participation/tab/paragraph/view.tabParagraph.php(22): View->render()
#8 /home/wwwroot/democ/www/include/class/common/class.view.php(185): include('/home/wwwroot/d...')
#9 /home/wwwroot/democ/www/include/class/participation/tab/paragraph/class.ext_db_tabParagraph.php(130): View->render()
#10 /home/wwwroot/democ/www/include/class/participation/tab/paragraph/class.ext_db_tabParagraphTemplate.php(103): TabParagraph->render()
#11 /home/wwwroot/democ/www/include/tpl/views/participation/tab/view.tab.php(14): TabParagraphTemplate->render()
#12 /home/wwwroot/democ/www/include/class/common/class.view.php(185): include('/home/wwwroot/d...')
#13 /home/wwwroot/democ/www/include/class/participation/tab/class.ext_db_tab.php(153): View->render()
#14 /home/wwwroot/democ/www/include/ajax/participation/tab/ajax.participationTabContent.php(32): Tab->render()
#15 /home/wwwroot/democ/www/include/tpl/tpl_participation.php(35): include_once('/home/wwwroot/d...')
#16 /home/wwwroot/democ/www/include/gabarit_site/GAB_DEMOC/inc.fo_contenu.php(28): include_once('/home/wwwroot/d...')
#17 /home/wwwroot/democ/www/include/gabarit_site/GAB_DEMOC/inc.document.php(19): include_once('/home/wwwroot/d...')
#18 /home/wwwroot/democ/www/index.php(300): include_once('/home/wwwroot/d...')
#19 {main}

SQL: [927] select distinct DE_AGENDA.ID_AGENDA,ID_PARTICIPATION,ID_FORMULAIRE,AGN_LIBELLE,AGN_VISUEL,AGN_RESUME,AGN_DESCRIPTION,AGN_ORGANISATEUR,AGN_FORMULAIREEXTERNE,AGN_LIBELLEBTNINSCRIPTION,AGN_DATEDEBUTPUBLICATION,AGN_DATEFINPUBLICATION,AGN_LIEU,AGN_ADRESSE,AGN_LATITUDE,AGN_LONGITUDE,AGN_CODEPOSTAL,AGN_VILLE,AGN_MASQUEDANSLALISTE,DE_AGENDA.SIT_CODE,null as ID_PARTAGEAGENDA from DE_AGENDA where SIT_CODE = :SIT_CODE and AGN_DATEDEBUTPUBLICATION <= :AGN_DATEDEBUTPUBLICATION and AGN_DATEFINPUBLICATION >= :AGN_DATEFINPUBLICATION and ID_PARTICIPATION = :ID_PARTICIPATION and ( DE_AGENDA.ID_PARTICIPATION IS NULL or DE_AGENDA.ID_PARTICIPATION not in ( select distinct DE_GROUPE_PARTICIPATION.ID_PARTICIPATION from DE_GROUPE_PARTICIPATION where DE_GROUPE_PARTICIPATION.GRP_CONSULTATION = 1 ) ) order by agp.AGP_DATEDEBUT asc limit 24 Sent SQL: [900] select distinct DE_AGENDA.ID_AGENDA,ID_PARTICIPATION,ID_FORMULAIRE,AGN_LIBELLE,AGN_VISUEL,AGN_RESUME,AGN_DESCRIPTION,AGN_ORGANISATEUR,AGN_FORMULAIREEXTERNE,AGN_LIBELLEBTNINSCRIPTION,AGN_DATEDEBUTPUBLICATION,AGN_DATEFINPUBLICATION,AGN_LIEU,AGN_ADRESSE,AGN_LATITUDE,AGN_LONGITUDE,AGN_CODEPOSTAL,AGN_VILLE,AGN_MASQUEDANSLALISTE,DE_AGENDA.SIT_CODE,null as ID_PARTAGEAGENDA from DE_AGENDA where SIT_CODE = 'SIT_VAULNAVEYSHAUT' and AGN_DATEDEBUTPUBLICATION <= 1714860000 and AGN_DATEFINPUBLICATION >= 1714946399 and ID_PARTICIPATION = '43360' and ( DE_AGENDA.ID_PARTICIPATION IS NULL or DE_AGENDA.ID_PARTICIPATION not in ( select distinct DE_GROUPE_PARTICIPATION.ID_PARTICIPATION from DE_GROUPE_PARTICIPATION where DE_GROUPE_PARTICIPATION.GRP_CONSULTATION = 1 ) ) order by agp.AGP_DATEDEBUT asc limit 24 Params: 4 Key: Name: [9] :SIT_CODE paramno=-1 name=[9] ":SIT_CODE" is_param=1 param_type=2 Key: Name: [25] :AGN_DATEDEBUTPUBLICATION paramno=-1 name=[25] ":AGN_DATEDEBUTPUBLICATION" is_param=1 param_type=1 Key: Name: [23] :AGN_DATEFINPUBLICATION paramno=-1 name=[23] ":AGN_DATEFINPUBLICATION" is_param=1 param_type=1 Key: Name: [17] :ID_PARTICIPATION paramno=-1 name=[17] ":ID_PARTICIPATION" is_param=1 param_type=2