CLOUDS API Locations
SQLSTATE[42S02]: Base table or view not found: 1146 Table 'cronos.hourlyas' doesn't exist with query: SELECT "radmax2m_total" as `variable`,"Solar Radiation Maximum (2m)" as `name`,"rad2m_total" as `var_parent`,"2m" as `height`,"H" as `obtype`,"max" as `paramtype`,ROUND(MAX(srmax),2) as `value`,"W/m2" as `unit`,DATE_FORMAT(CONVERT_TZ(MAX(ob),'-05:00','US/Eastern'),'%l:%i %p %b %e %Y') as `time`,DATE_FORMAT(CONVERT_TZ(MIN(ob),'-05:00','US/Eastern'),'%l:%i %p %b %e %Y') as `time_min`,DATE_FORMAT(CONVERT_TZ(MAX(ob),'-05:00','US/Eastern'),'%l:%i %p %b %e %Y') as `time_max`,CONCAT(1+TIMESTAMPDIFF(HOUR,MIN(ob),MAX(ob)),' Hours') as `time_diff` FROM cronos.hourlyas d WHERE station="0246CA" AND ob >= DATE_SUB(NOW(), INTERVAL 24 HOUR) AND obtype IN ("H")
Error Trace:#0 /etc/httpd/autoload/scodb/scodb_class.php(171): PDO->prepare('SELECT "radmax2...')
#1 /etc/httpd/autoload/scodb/scodb.php(519): scodb_class->query('SELECT "radmax2...', Array)
#2 /home/repositories/api_container/html/lib/data_parameter_functions.php(2475): scodb_query(Object(scodb_api_read), 'SELECT "radmax2...')
#3 /home/repositories/api_container/html/locations.php(572): pullParamData(Array, Array)
#4 /home/repositories/api_container/html/locations.php(416): ShowStationInfo('0246CA')
#5 {main} with sel_q: SELECT "radmax2m_total" as `variable`,"Solar Radiation Maximum (2m)" as `name`,"rad2m_total" as `var_parent`,"2m" as `height`,"H" as `obtype`,"max" as `paramtype`,ROUND(MAX(srmax),2) as `value`,"W/m2" as `unit`,DATE_FORMAT(CONVERT_TZ(MAX(ob),'-05:00','US/Eastern'),'%l:%i %p %b %e %Y') as `time`,DATE_FORMAT(CONVERT_TZ(MIN(ob),'-05:00','US/Eastern'),'%l:%i %p %b %e %Y') as `time_min`,DATE_FORMAT(CONVERT_TZ(MAX(ob),'-05:00','US/Eastern'),'%l:%i %p %b %e %Y') as `time_max`,CONCAT(1+TIMESTAMPDIFF(HOUR,MIN(ob),MAX(ob)),' Hours') as `time_diff` FROM cronos.hourlyas d WHERE station="0246CA" AND ob >= DATE_SUB(NOW(), INTERVAL 24 HOUR) AND obtype IN ("H")