Fonction executerSQL-ERREUR RequeteSQL=SELECT ml.idMesure, tm.Unite, CONCAT('[Date.UTC(',year(ml.moment),',',(month(ml.moment)-1),',',day(ml.moment),',',hour(ml.moment),',',minute(ml.moment),',',second(ml.moment),'), ',ml.valeur,']') AS donnee, m.nomMesure, c.nomCapteur, b.nom, si.nomSite, so.nomSociete, ml.valeur FROM agroasis.t_mesuresLog ml JOIN agroasis.t_mesures m ON m.id = ml.idMesure JOIN agroasis.t_capteurs c ON c.id = m.idCapteur JOIN agroasis.t_bornes b ON b.id = c.idBorne JOIN agroasis.t_sites si ON si.id = b.idSite JOIN agroasis.t_societes so ON so.id = si.idSociete JOIN agroasis.t_typemesures tm ON tm.id = m.idTypeMesure WHERE ml.moment >= DATE_FORMAT(now(), '%Y-%m-%d 00:00:00') AND idBorne = ORDER BY idMesure, moment DESC
string(56) "SQLSTATE[42000]: Syntax error or access violation: 1064 " Fonction executerSQL-ERREUR RequeteSQL=SELECT tm.nomMesure, tm.Unite FROM agroasis.t_typemesures tm JOIN agroasis.t_mesures m ON tm.id = m.idTypeMesure WHERE m.id = 1
string(58) "SQLSTATE[42S22]: Column not found: 1054 Unknown error 1054" Fonction executerSQL-ERREUR RequeteSQL=SELECT tm.nomMesure, tm.Unite FROM agroasis.t_typemesures tm JOIN agroasis.t_mesures m ON tm.id = m.idTypeMesure WHERE m.id = 3
string(58) "SQLSTATE[42S22]: Column not found: 1054 Unknown error 1054" Fonction executerSQL-ERREUR RequeteSQL=SELECT tm.nomMesure, tm.Unite FROM agroasis.t_typemesures tm JOIN agroasis.t_mesures m ON tm.id = m.idTypeMesure WHERE m.id = 5
string(58) "SQLSTATE[42S22]: Column not found: 1054 Unknown error 1054" Fonction executerSQL-ERREUR RequeteSQL=SELECT tm.nomMesure, tm.Unite FROM agroasis.t_typemesures tm JOIN agroasis.t_mesures m ON tm.id = m.idTypeMesure WHERE m.id = 7
string(58) "SQLSTATE[42S22]: Column not found: 1054 Unknown error 1054"