Erreur SQL
QUERY :
SELECT SQL_CALC_FOUND_ROWS s.POINTS_PENALITE_RAID,s.TRAD_TXT_TITREREF,s.TRAD_TXT_URL,s.CLASSEMENT,s.CLASSEMENT_CAT,s.DATE_DEPART_REEL,s.DATE_DEPART,s.PARENT_COUREUR_ID,s.NB_TOUR,s.MEILLEUR_TOUR,s.DISTANCE,s.BALISE_RAID_SAVE,s.POINTS_RAID,s.TEMPS_RAID,s.POINTS_BALISE_RAID,s.TEMPS_BALISE_RAID,s.TRAD_URL_FR,s.TEMPS_PENALITE_RAID,s.ID_VAGUE,s.NB_BALISE_WIN,s.NB_BALISE_LOST,s.TEMPS_MS_LAST_PTS_CTRL,s.TEMPS_MS_NEXT_PTS_CTRL,s.STATUT_PAYE,s.REF_COUREUR_ID,s.ID_CLIENT,s.CLASSEMENT_SEXE,s.CLASSEMENT_FEDERATION,s.ID_INSCRIPTION,s.FICHIER_VALIDE,s.TRAD_URL_PROFIL_FR,s.TRAD_TXT_URL_PROFIL,s.TEMPS_LAST_PTS_CTRL,s.ID_LAST_PTS_CTRL,s.DATE_STATUT,s.PATH_FICHIER_VALIDE,s.ID_COMPET,s.ID,s.TRAD_TITREREF_FR,s.ID_NEXT_PTS_CTRL,s.TEMPS_NEXT_PTS_CTRL,s.VITESSE,s.DATEC,s.DATEU,s.STATUT,s.SUP,s.TRAD_TXT_M_DESCRIPT,s.ID_ADMIN,s.TRAD_M_DESCRIPT_FR,s.REF_PRIORITY,s.REF_FREQ,s.NUM_DOSSARD,s.NOM,s.PRENOM,s.SEXE,s.ANNEE_NAISSANCE,s.DATE_NAISSANCE,s.ID_CATEGORIE,s.CLUB,s.LICENCE,s.FEDERATION,s.ID_PAYS,s.NATION,s.VILLE,s.DEPT,s.EMAIL,s.TEL_PORT,s.NUM_RFID,s.POINTS_CORRECTION_RAID,s.TEMPS_CORRECTION_RAID,s.CHALLENGE_POINT_BONUS,s.ABANDON,s.DATE_ABANDON,s.PRIS_DEPART,s.ORGANISATEUR,COALESCE((select T_TITREREF_1.VALUE from texte AS T_TITREREF_1 where T_TITREREF_1.ID_TXT = s.TRAD_TXT_TITREREF and T_TITREREF_1.ACTUEL = 1 and T_TITREREF_1.ID_LANG = 1) , '') as TRAD_TITREREF_1,COALESCE((select T_TITREREF_2.VALUE from texte AS T_TITREREF_2 where T_TITREREF_2.ID_TXT = s.TRAD_TXT_TITREREF and T_TITREREF_2.ACTUEL = 1 and T_TITREREF_2.ID_LANG = 2) , '') as TRAD_TITREREF_2,COALESCE((select T_URL_1.VALUE from texte AS T_URL_1 where T_URL_1.ID_TXT = s.TRAD_TXT_URL and T_URL_1.ACTUEL = 1 and T_URL_1.ID_LANG = 1) , '') as TRAD_URL_1,COALESCE((select T_URL_2.VALUE from texte AS T_URL_2 where T_URL_2.ID_TXT = s.TRAD_TXT_URL and T_URL_2.ACTUEL = 1 and T_URL_2.ID_LANG = 2) , '') as TRAD_URL_2,COALESCE((select T_URL_PROFIL_1.VALUE from texte AS T_URL_PROFIL_1 where T_URL_PROFIL_1.ID_TXT = s.TRAD_TXT_URL_PROFIL and T_URL_PROFIL_1.ACTUEL = 1 and T_URL_PROFIL_1.ID_LANG = 1) , '') as TRAD_URL_PROFIL_1,COALESCE((select T_URL_PROFIL_2.VALUE from texte AS T_URL_PROFIL_2 where T_URL_PROFIL_2.ID_TXT = s.TRAD_TXT_URL_PROFIL and T_URL_PROFIL_2.ACTUEL = 1 and T_URL_PROFIL_2.ID_LANG = 2) , '') as TRAD_URL_PROFIL_2,COALESCE((select T_M_DESCRIPT_1.VALUE from texte AS T_M_DESCRIPT_1 where T_M_DESCRIPT_1.ID_TXT = s.TRAD_TXT_M_DESCRIPT and T_M_DESCRIPT_1.ACTUEL = 1 and T_M_DESCRIPT_1.ID_LANG = 1) , '') as TRAD_M_DESCRIPT_1,COALESCE((select T_M_DESCRIPT_2.VALUE from texte AS T_M_DESCRIPT_2 where T_M_DESCRIPT_2.ID_TXT = s.TRAD_TXT_M_DESCRIPT and T_M_DESCRIPT_2.ACTUEL = 1 and T_M_DESCRIPT_2.ID_LANG = 2) , '') as TRAD_M_DESCRIPT_2 FROM suivi_coureur as s WHERE ID_COMPET=460 AND STATUT=0 AND SUP!=1 AND CLASSEMENT!=0 AND ID_CATEGORIE=295 AND ID_LAST_PTS_CTRL!=0 AND ID_NEXT_PTS_CTRL=0 AND SEXE=3 ORDER BY s.CLASSEMENT ASC
INFO :
MySQL server has gone away
STACK TRACE :
#0 /home/izam/public_html/zam/classe/pdo.mysql.php(102): Z_PDOMySQL->show_error(' SELECT SQL_CAL...', Array)
#1 /home/izam/public_html/zam/classe/pdo.mysql.php(184): Z_PDOMySQL->query(' SELECT SQL_CAL...')
#2 /home/izam/public_html/zam/classe/model.php(760): Z_PDOMySQL->select_all(' SELECT SQL_CAL...')
#3 /home/izam/domains/endurancechrono.com/public_html/admin/zam_back/classe/model/m_suivicoureur.php(103): Z_Model->get_list(Array, Array, false, false, NULL, Array, Array, Array, true)
#4 /home/izam/domains/endurancechrono.com/public_html/zam_front/classe/suivi_coureur_extends.php(5): Z_SuiviCoureur->get_list_bulk_front(Array, Array, false, false, NULL, Array, Array, Array)
#5 /home/izam/domains/endurancechrono.com/public_html/include/display/page/page_direct_evenement.php(1400): Z_SuiviCoureurExtends->get_list_bulk(Array, Array)
#6 /home/izam/domains/endurancechrono.com/public_html/index.php(559): include('/home/izam/doma...')
#7 {main}
REQUEST PAGE :
/fr/10_km_de_Montpellier_1/10_km?list=cat&num=427
REQUEST POST :
Array
(
)
REQUEST GET :
Array
(
[list] => cat
[num] => 427
)
English
Français
