Erreur SQL
QUERY :
SELECT SQL_CALC_FOUND_ROWS s.ID_COMPET,s.ID_COMPET_FUSION,s.DISTANCE_INTER,s.TRAD_TXT_URL,s.TRAD_URL_FR,s.TRAD_TXT_TITREREF,s.TRAD_TITREREF_FR,s.TRAD_TXT_M_DESCRIPT,s.TRAD_M_DESCRIPT_FR,s.REF_FREQ,s.REF_PRIORITY,s.SUP,s.ID_ADMIN,s.DATEU,s.DATEC,s.TRAD_NOM_FR,s.ID,s.NUM,s.TRAD_TXT_NOM,s.DISTANCE,s.NO_COMPET,s.ALTITUDE,s.CUMUL_D_UP,s.CUMUL_D_DOWN,s.DATE_FIN,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_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_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,COALESCE((select T_NOM_1.VALUE from texte AS T_NOM_1 where T_NOM_1.ID_TXT = s.TRAD_TXT_NOM and T_NOM_1.ACTUEL = 1 and T_NOM_1.ID_LANG = 1) , '') as TRAD_NOM_1,COALESCE((select T_NOM_2.VALUE from texte AS T_NOM_2 where T_NOM_2.ID_TXT = s.TRAD_TXT_NOM and T_NOM_2.ACTUEL = 1 and T_NOM_2.ID_LANG = 2) , '') as TRAD_NOM_2 FROM suivi_pts_ctrl as s WHERE ID_COMPET=907 AND SUP!=1 ORDER BY s.DISTANCE 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_suivicompet.php(544): Z_Model->get_list(Array, Array, false, false)
#4 /home/izam/domains/endurancechrono.com/public_html/include/display/page/page_direct_evenement.php(59): Z_SuiviPtsCtrl->get_list_bulk(Array, Array)
#5 /home/izam/domains/endurancechrono.com/public_html/index.php(559): include('/home/izam/doma...')
#6 {main}
REQUEST PAGE :
/fr/Trail_du_Pont_du_Gard_4/20_km?list=all&num=697
REQUEST POST :
Array
(
)
REQUEST GET :
Array
(
[list] => all
[num] => 697
)
English
Français
