Michael,
Just updated the plugin to 2.18.0.6 and noticed that if I select say the humidity icon from either device page or general page to review the humidity and then annual, it pulls up the current year without issue. Should I select 2017 or another year, the screen comes up blank and sits there. If I close the blank annual chart and open it again, then it displays 2017 or whatever info chart fine.
In the log, I see these messages. Looks like there's an issue in the query.
Could you please take a look?
Thanks,
Robert
Mar-30 10:55:02 AM mcsSprinklers CalendarASP Day=101, Device=, SQL=SELECT SampleDate from d WHERE ((SampleDate > #2017-12-30 00:00:00#) And (Discrete = 1)) ORDER BY SampleDate;, Value=0 Line 0 The Microsoft Jet database engine cannot find the input table or query 'd'. Make sure it exists and that its name is spelled correctly.
Mar-30 10:51:32 AM mcsSprinklers CalendarASP Day=101, Device=, SQL=SELECT SampleDate from d WHERE ((SampleDate > #2017-12-30 00:00:00#) And (Discrete = 1)) ORDER BY SampleDate;, Value=0 Line 0 The Microsoft Jet database engine cannot find the input table or query 'd'. Make sure it exists and that its name is spelled correctly.
Mar-30 10:49:03 AM mcsSprinklers CalendarASP Day=101, Device=, SQL=SELECT SampleDate from d WHERE ((SampleDate > #2017-12-30 00:00:00#) And (Discrete = 1)) ORDER BY SampleDate;, Value=0 Line 0 The Microsoft Jet database engine cannot find the input table or query 'd'. Make sure it exists and that its name is spelled correctly.
Mar-30 10:48:37 AM mcsSprinklers CalendarASP Day=101, Device=, SQL=SELECT SampleDate from d WHERE ((SampleDate > #2017-12-30 00:00:00#) And (Discrete = 1)) ORDER BY SampleDate;, Value=0 Line 0 The Microsoft Jet database engine cannot find the input table or query 'd'. Make sure it exists and that its name is spelled correctly.
Just updated the plugin to 2.18.0.6 and noticed that if I select say the humidity icon from either device page or general page to review the humidity and then annual, it pulls up the current year without issue. Should I select 2017 or another year, the screen comes up blank and sits there. If I close the blank annual chart and open it again, then it displays 2017 or whatever info chart fine.
In the log, I see these messages. Looks like there's an issue in the query.
Could you please take a look?
Thanks,
Robert
Mar-30 10:55:02 AM mcsSprinklers CalendarASP Day=101, Device=, SQL=SELECT SampleDate from d WHERE ((SampleDate > #2017-12-30 00:00:00#) And (Discrete = 1)) ORDER BY SampleDate;, Value=0 Line 0 The Microsoft Jet database engine cannot find the input table or query 'd'. Make sure it exists and that its name is spelled correctly.
Mar-30 10:51:32 AM mcsSprinklers CalendarASP Day=101, Device=, SQL=SELECT SampleDate from d WHERE ((SampleDate > #2017-12-30 00:00:00#) And (Discrete = 1)) ORDER BY SampleDate;, Value=0 Line 0 The Microsoft Jet database engine cannot find the input table or query 'd'. Make sure it exists and that its name is spelled correctly.
Mar-30 10:49:03 AM mcsSprinklers CalendarASP Day=101, Device=, SQL=SELECT SampleDate from d WHERE ((SampleDate > #2017-12-30 00:00:00#) And (Discrete = 1)) ORDER BY SampleDate;, Value=0 Line 0 The Microsoft Jet database engine cannot find the input table or query 'd'. Make sure it exists and that its name is spelled correctly.
Mar-30 10:48:37 AM mcsSprinklers CalendarASP Day=101, Device=, SQL=SELECT SampleDate from d WHERE ((SampleDate > #2017-12-30 00:00:00#) And (Discrete = 1)) ORDER BY SampleDate;, Value=0 Line 0 The Microsoft Jet database engine cannot find the input table or query 'd'. Make sure it exists and that its name is spelled correctly.
Comment