object(ADODB_Exception)#6 (13) { ["dbms"]=> string(9) "postgres7" ["fn"]=> string(7) "EXECUTE" ["sql"]=> string(105) "SELECT * FROM obs_KJWX WHERE stn = 'KJWX' AND time >= 1397767430 AND time <= 1397853830 ORDER BY time ASC" ["params"]=> bool(false) ["host"]=> string(14) "localhost:5432" ["database"]=> string(3) "obs" ["message:protected"]=> string(202) "postgres7 error: [-1: ERROR: relation "obs_kjwx" does not exist at character 15] in EXECUTE("SELECT * FROM obs_KJWX WHERE stn = 'KJWX' AND time >= 1397767430 AND time <= 1397853830 ORDER BY time ASC") " ["string:private"]=> string(0) "" ["code:protected"]=> int(-1) ["file:protected"]=> string(62) "/usr/local/wx/2.1/programs/adodb/5.11/adodb-exceptions.inc.php" ["line:protected"]=> int(78) ["trace:private"]=> array(9) { [0]=> array(4) { ["file"]=> string(51) "/usr/local/wx/2.1/programs/adodb/5.11/adodb.inc.php" ["line"]=> int(1040) ["function"]=> string(11) "adodb_throw" ["args"]=> array(7) { [0]=> string(9) "postgres7" [1]=> string(7) "EXECUTE" [2]=> int(-1) [3]=> string(58) "ERROR: relation "obs_kjwx" does not exist at character 15" [4]=> string(105) "SELECT * FROM obs_KJWX WHERE stn = 'KJWX' AND time >= 1397767430 AND time <= 1397853830 ORDER BY time ASC" [5]=> bool(false) [6]=> object(ADODB_postgres7)#2 (91) { ["databaseType"]=> string(9) "postgres7" ["hasLimit"]=> bool(true) ["ansiOuter"]=> bool(true) ["charSet"]=> bool(true) ["dataProvider"]=> string(8) "postgres" ["hasInsertID"]=> bool(true) ["_resultid"]=> resource(37) of type (pgsql result) ["concat_operator"]=> string(2) "||" ["metaDatabasesSQL"]=> string(89) "select datname from pg_database where datname not in ('template0','template1') order by 1" ["metaTablesSQL"]=> string(289) "select tablename,'T' from pg_tables where tablename not like 'pg\_%' and tablename not in ('sql_features', 'sql_implementation_info', 'sql_languages', 'sql_packages', 'sql_sizing', 'sql_sizing_profiles') union select viewname,'V' from pg_views where viewname not like 'pg\_%'" ["isoDates"]=> bool(true) ["sysDate"]=> string(12) "CURRENT_DATE" ["sysTimeStamp"]=> string(17) "CURRENT_TIMESTAMP" ["blobEncodeType"]=> string(1) "C" ["metaColumnsSQL"]=> string(317) "SELECT a.attname,t.typname,a.attlen,a.atttypmod,a.attnotnull,a.atthasdef,a.attnum FROM pg_class c, pg_attribute a,pg_type t WHERE relkind in ('r','v') AND (c.relname='%s' or c.relname = lower('%s')) and a.attname not like '....%%' AND a.attnum > 0 AND a.atttypid = t.oid AND a.attrelid = c.oid ORDER BY a.attnum" ["metaColumnsSQL1"]=> string(385) "SELECT a.attname, t.typname, a.attlen, a.atttypmod, a.attnotnull, a.atthasdef, a.attnum FROM pg_class c, pg_attribute a, pg_type t, pg_namespace n WHERE relkind in ('r','v') AND (c.relname='%s' or c.relname = lower('%s')) and c.relnamespace=n.oid and n.nspname='%s' and a.attname not like '....%%' AND a.attnum > 0 AND a.atttypid = t.oid AND a.attrelid = c.oid ORDER BY a.attnum" ["metaKeySQL"]=> string(485) "SELECT ic.relname AS index_name, a.attname AS column_name,i.indisunique AS unique_key, i.indisprimary AS primary_key FROM pg_class bc, pg_class ic, pg_index i, pg_attribute a WHERE bc.oid = i.indrelid AND ic.oid = i.indexrelid AND (i.indkey[0] = a.attnum OR i.indkey[1] = a.attnum OR i.indkey[2] = a.attnum OR i.indkey[3] = a.attnum OR i.indkey[4] = a.attnum OR i.indkey[5] = a.attnum OR i.indkey[6] = a.attnum OR i.indkey[7] = a.attnum) AND a.attrelid = bc.oid AND bc.relname = '%s'" ["hasAffectedRows"]=> bool(true) ["true"]=> string(4) "TRUE" ["false"]=> string(5) "FALSE" ["fmtDate"]=> string(7) "'Y-m-d'" ["fmtTimeStamp"]=> string(13) "'Y-m-d H:i:s'" ["hasMoveFirst"]=> bool(true) ["hasGenID"]=> bool(true) ["_genIDSQL"]=> string(20) "SELECT NEXTVAL('%s')" ["_genSeqSQL"]=> string(27) "CREATE SEQUENCE %s START %s" ["_dropSeqSQL"]=> string(16) "DROP SEQUENCE %s" ["metaDefaultsSQL"]=> string(125) "SELECT d.adnum as num, d.adsrc as def from pg_attrdef d, pg_class c where d.adrelid=c.oid and c.relname='%s' order by d.adnum" ["random"]=> string(8) "random()" ["autoRollback"]=> bool(true) ["uniqueIisR"]=> bool(true) ["_bindInputArray"]=> bool(true) ["disableBlobs"]=> bool(false) ["database"]=> string(3) "obs" ["host"]=> string(14) "localhost:5432" ["user"]=> string(8) "obs_user" ["password"]=> string(10) "not stored" ["debug"]=> bool(false) ["maxblobsize"]=> int(262144) ["substr"]=> string(6) "substr" ["length"]=> string(6) "length" ["upperCase"]=> string(5) "upper" ["replaceQuote"]=> string(2) "\'" ["nameQuote"]=> string(1) """ ["uniqueOrderBy"]=> bool(false) ["emptyDate"]=> string(6) " " ["emptyTimeStamp"]=> string(6) " " ["lastInsID"]=> bool(false) ["hasTop"]=> bool(false) ["readOnly"]=> bool(false) ["hasTransactions"]=> bool(true) ["genID"]=> int(0) ["raiseErrorFn"]=> string(11) "adodb_throw" ["cacheSecs"]=> int(3600) ["memCache"]=> bool(false) ["memCacheHost"]=> NULL ["memCachePort"]=> int(11211) ["memCacheCompress"]=> bool(false) ["sysUTimeStamp"]=> bool(false) ["arrayClass"]=> string(18) "ADORecordSet_array" ["noNullStrings"]=> bool(false) ["numCacheHits"]=> int(1) ["numCacheMisses"]=> int(0) ["pageExecuteCountRows"]=> bool(true) ["uniqueSort"]=> bool(false) ["leftOuter"]=> bool(false) ["rightOuter"]=> bool(false) ["poorAffectedRows"]=> bool(false) ["fnExecute"]=> bool(false) ["fnCacheExecute"]=> bool(false) ["rsPrefix"]=> string(13) "ADORecordSet_" ["autoCommit"]=> bool(true) ["transOff"]=> int(0) ["transCnt"]=> int(0) ["fetchMode"]=> bool(false) ["null2null"]=> string(4) "null" ["bulkBind"]=> bool(false) ["_oldRaiseFn"]=> bool(false) ["_transOK"]=> NULL ["_connectionID"]=> resource(36) of type (pgsql link persistent) ["_errorMsg"]=> string(58) "ERROR: relation "obs_kjwx" does not exist at character 15" ["_errorCode"]=> bool(false) ["_queryID"]=> bool(false) ["_isPersistentConnection"]=> bool(true) ["_evalAll"]=> bool(false) ["_affected"]=> bool(false) ["_logsql"]=> bool(false) ["_transmode"]=> string(0) "" ["version"]=> array(2) { ["description"]=> string(113) "PostgreSQL 8.4.13 on x86_64-redhat-linux-gnu, compiled by GCC gcc (GCC) 4.1.2 20080704 (Red Hat 4.1.2-52), 64-bit" ["version"]=> string(6) "8.4.13" } ["pgVersion"]=> float(8.4) ["_nestedSQL"]=> bool(true) } } } [1]=> array(6) { ["file"]=> string(51) "/usr/local/wx/2.1/programs/adodb/5.11/adodb.inc.php" ["line"]=> int(1015) ["function"]=> string(8) "_Execute" ["class"]=> string(13) "ADOConnection" ["type"]=> string(2) "->" ["args"]=> array(2) { [0]=> string(105) "SELECT * FROM obs_KJWX WHERE stn = 'KJWX' AND time >= 1397767430 AND time <= 1397853830 ORDER BY time ASC" [1]=> bool(false) } } [2]=> array(6) { ["file"]=> string(51) "/usr/local/wx/2.1/programs/adodb/5.11/adodb.inc.php" ["line"]=> int(1805) ["function"]=> string(7) "Execute" ["class"]=> string(13) "ADOConnection" ["type"]=> string(2) "->" ["args"]=> array(2) { [0]=> string(105) "SELECT * FROM obs_KJWX WHERE stn = 'KJWX' AND time >= 1397767430 AND time <= 1397853830 ORDER BY time ASC" [1]=> bool(false) } } [3]=> array(6) { ["file"]=> string(41) "/usr/local/wx/2.1/local/modules/adodb.inc" ["line"]=> int(106) ["function"]=> string(12) "CacheExecute" ["class"]=> string(13) "ADOConnection" ["type"]=> string(2) "->" ["args"]=> array(3) { [0]=> int(300) [1]=> string(105) "SELECT * FROM obs_KJWX WHERE stn = 'KJWX' AND time >= 1397767430 AND time <= 1397853830 ORDER BY time ASC" [2]=> bool(false) } } [4]=> array(4) { ["file"]=> string(39) "/usr/local/wx/2.1/local/modules/obs.inc" ["line"]=> int(134) ["function"]=> string(3) "SQL" ["args"]=> array(5) { [0]=> &object(ADODB_postgres7)#2 (91) { ["databaseType"]=> string(9) "postgres7" ["hasLimit"]=> bool(true) ["ansiOuter"]=> bool(true) ["charSet"]=> bool(true) ["dataProvider"]=> string(8) "postgres" ["hasInsertID"]=> bool(true) ["_resultid"]=> resource(37) of type (pgsql result) ["concat_operator"]=> string(2) "||" ["metaDatabasesSQL"]=> string(89) "select datname from pg_database where datname not in ('template0','template1') order by 1" ["metaTablesSQL"]=> string(289) "select tablename,'T' from pg_tables where tablename not like 'pg\_%' and tablename not in ('sql_features', 'sql_implementation_info', 'sql_languages', 'sql_packages', 'sql_sizing', 'sql_sizing_profiles') union select viewname,'V' from pg_views where viewname not like 'pg\_%'" ["isoDates"]=> bool(true) ["sysDate"]=> string(12) "CURRENT_DATE" ["sysTimeStamp"]=> string(17) "CURRENT_TIMESTAMP" ["blobEncodeType"]=> string(1) "C" ["metaColumnsSQL"]=> string(317) "SELECT a.attname,t.typname,a.attlen,a.atttypmod,a.attnotnull,a.atthasdef,a.attnum FROM pg_class c, pg_attribute a,pg_type t WHERE relkind in ('r','v') AND (c.relname='%s' or c.relname = lower('%s')) and a.attname not like '....%%' AND a.attnum > 0 AND a.atttypid = t.oid AND a.attrelid = c.oid ORDER BY a.attnum" ["metaColumnsSQL1"]=> string(385) "SELECT a.attname, t.typname, a.attlen, a.atttypmod, a.attnotnull, a.atthasdef, a.attnum FROM pg_class c, pg_attribute a, pg_type t, pg_namespace n WHERE relkind in ('r','v') AND (c.relname='%s' or c.relname = lower('%s')) and c.relnamespace=n.oid and n.nspname='%s' and a.attname not like '....%%' AND a.attnum > 0 AND a.atttypid = t.oid AND a.attrelid = c.oid ORDER BY a.attnum" ["metaKeySQL"]=> string(485) "SELECT ic.relname AS index_name, a.attname AS column_name,i.indisunique AS unique_key, i.indisprimary AS primary_key FROM pg_class bc, pg_class ic, pg_index i, pg_attribute a WHERE bc.oid = i.indrelid AND ic.oid = i.indexrelid AND (i.indkey[0] = a.attnum OR i.indkey[1] = a.attnum OR i.indkey[2] = a.attnum OR i.indkey[3] = a.attnum OR i.indkey[4] = a.attnum OR i.indkey[5] = a.attnum OR i.indkey[6] = a.attnum OR i.indkey[7] = a.attnum) AND a.attrelid = bc.oid AND bc.relname = '%s'" ["hasAffectedRows"]=> bool(true) ["true"]=> string(4) "TRUE" ["false"]=> string(5) "FALSE" ["fmtDate"]=> string(7) "'Y-m-d'" ["fmtTimeStamp"]=> string(13) "'Y-m-d H:i:s'" ["hasMoveFirst"]=> bool(true) ["hasGenID"]=> bool(true) ["_genIDSQL"]=> string(20) "SELECT NEXTVAL('%s')" ["_genSeqSQL"]=> string(27) "CREATE SEQUENCE %s START %s" ["_dropSeqSQL"]=> string(16) "DROP SEQUENCE %s" ["metaDefaultsSQL"]=> string(125) "SELECT d.adnum as num, d.adsrc as def from pg_attrdef d, pg_class c where d.adrelid=c.oid and c.relname='%s' order by d.adnum" ["random"]=> string(8) "random()" ["autoRollback"]=> bool(true) ["uniqueIisR"]=> bool(true) ["_bindInputArray"]=> bool(true) ["disableBlobs"]=> bool(false) ["database"]=> string(3) "obs" ["host"]=> string(14) "localhost:5432" ["user"]=> string(8) "obs_user" ["password"]=> string(10) "not stored" ["debug"]=> bool(false) ["maxblobsize"]=> int(262144) ["substr"]=> string(6) "substr" ["length"]=> string(6) "length" ["upperCase"]=> string(5) "upper" ["replaceQuote"]=> string(2) "\'" ["nameQuote"]=> string(1) """ ["uniqueOrderBy"]=> bool(false) ["emptyDate"]=> string(6) " " ["emptyTimeStamp"]=> string(6) " " ["lastInsID"]=> bool(false) ["hasTop"]=> bool(false) ["readOnly"]=> bool(false) ["hasTransactions"]=> bool(true) ["genID"]=> int(0) ["raiseErrorFn"]=> string(11) "adodb_throw" ["cacheSecs"]=> int(3600) ["memCache"]=> bool(false) ["memCacheHost"]=> NULL ["memCachePort"]=> int(11211) ["memCacheCompress"]=> bool(false) ["sysUTimeStamp"]=> bool(false) ["arrayClass"]=> string(18) "ADORecordSet_array" ["noNullStrings"]=> bool(false) ["numCacheHits"]=> int(1) ["numCacheMisses"]=> int(0) ["pageExecuteCountRows"]=> bool(true) ["uniqueSort"]=> bool(false) ["leftOuter"]=> bool(false) ["rightOuter"]=> bool(false) ["poorAffectedRows"]=> bool(false) ["fnExecute"]=> bool(false) ["fnCacheExecute"]=> bool(false) ["rsPrefix"]=> string(13) "ADORecordSet_" ["autoCommit"]=> bool(true) ["transOff"]=> int(0) ["transCnt"]=> int(0) ["fetchMode"]=> bool(false) ["null2null"]=> string(4) "null" ["bulkBind"]=> bool(false) ["_oldRaiseFn"]=> bool(false) ["_transOK"]=> NULL ["_connectionID"]=> resource(36) of type (pgsql link persistent) ["_errorMsg"]=> string(58) "ERROR: relation "obs_kjwx" does not exist at character 15" ["_errorCode"]=> bool(false) ["_queryID"]=> bool(false) ["_isPersistentConnection"]=> bool(true) ["_evalAll"]=> bool(false) ["_affected"]=> bool(false) ["_logsql"]=> bool(false) ["_transmode"]=> string(0) "" ["version"]=> array(2) { ["description"]=> string(113) "PostgreSQL 8.4.13 on x86_64-redhat-linux-gnu, compiled by GCC gcc (GCC) 4.1.2 20080704 (Red Hat 4.1.2-52), 64-bit" ["version"]=> string(6) "8.4.13" } ["pgVersion"]=> float(8.4) ["_nestedSQL"]=> bool(true) } [1]=> &int(300) [2]=> &string(105) "SELECT * FROM obs_KJWX WHERE stn = 'KJWX' AND time >= 1397767430 AND time <= 1397853830 ORDER BY time ASC" [3]=> &NULL [4]=> &NULL } } [5]=> array(4) { ["file"]=> string(41) "/usr/local/wx/2.1/templates/code/text.php" ["line"]=> int(47) ["function"]=> string(18) "get_historical_obs" ["args"]=> array(3) { [0]=> &string(4) "KJWX" [1]=> &int(1397853830) [2]=> &int(1397767430) } } [6]=> array(4) { ["file"]=> string(35) "/usr/local/wx/2.1/local/prepend.inc" ["line"]=> int(47) ["args"]=> array(1) { [0]=> string(41) "/usr/local/wx/2.1/templates/code/text.php" } ["function"]=> string(7) "require" } [7]=> array(4) { ["file"]=> string(38) "/usr/local/wx/2.1/docs/app/prepend.inc" ["line"]=> int(3) ["args"]=> array(1) { [0]=> string(35) "/usr/local/wx/2.1/local/prepend.inc" } ["function"]=> string(7) "include" } [8]=> array(4) { ["file"]=> string(35) "/usr/local/wx/2.1/docs/app/text.php" ["line"]=> int(8) ["args"]=> array(1) { [0]=> string(38) "/usr/local/wx/2.1/docs/app/prepend.inc" } ["function"]=> string(7) "include" } } ["msg"]=> string(58) "ERROR: relation "obs_kjwx" does not exist at character 15" }
               ADOConnection.Execute(SELECT * FROM obs_KJWX WHERE stn = 'KJWX' AND time >= 1397767430 AND time <= 1397853830 ORDER BY time ASC, false) % line 1805, file: adodb.inc.php
            ADOConnection.CacheExecute(300, SELECT * FROM obs_KJWX WHERE stn = 'KJWX' AND time >= 1397767430 AND time <= 1397853830 ORDER BY time ASC, false) % line  106, file: adodb.inc
         SQL(Object:ADODB_postgres7, 300, SELECT * FROM obs_KJWX WHERE stn = 'KJWX' AND time >= 1397767430 AND time <= 1397853830 ORDER BY time ASC, null, null) % line  134, file: obs.inc
      get_historical_obs(KJWX, 1397853830, 1397767430) % line   47, file: text.php
   require(/usr/local/wx/2.1/templates/code/text.php) % line   47, file: prepend.inc
include(/usr/local/wx/2.1/local/prepend.inc) % line    3, file: prepend.inc
include(/usr/local/wx/2.1/docs/app/prepend.inc) % line    8, file: text.php
Error: ERROR: relation "obs_kjwx" does not exist at character 15 USWX : Local : Data : KJWX, Fort Ritchie
Friday, April 18, 2014, 4:43 PM EDT

KJWX, Fort Ritchie

Location: Fairfield, MD, United States Lat: 39.733
Local Time: 4:43 PM EDT (20:43 GMT) Lon: -77.433
Time Zone: US/Eastern Elev: 902 ft

Show me the last for .
Show Decoded



Support USWX by starting your Amazon purchase here.