PM2_5 no such column errors on weather34

43 views
Skip to first unread message

Chris Alemany

unread,
Apr 27, 2020, 12:43:14 AM4/27/20
to weewx-user
Hi all,

I just updated to a new version of the weather34 skin and am having a problem with the database schema.  I have a purple air station and it is hooked in with the purpleair extension which displays fine in the regular skin here:

However weather34 is complaining of a missing column which is preventing the archivedata.php file from being generated.

default       21:35:26.641849-0700    Python  manager: Added record 2020-04-26 21:35:00 PDT (1587962100) to daily summary in 'weewx.sdb'
error 21:35:32.756817-0700 Python no such column: pm2_5 in "SELECT avg(pm2_5) FROM archive WHERE dateTime > 1587875700 AND dateTime <= 1587962100 AND pm2_5 IS NOT NULL"
default 21:35:32.756968-0700 Python cheetahgenerator: Generate failed with exception '<class 'weedb.NoColumnError'>'
default 21:35:32.757054-0700 Python cheetahgenerator: **** Ignoring template /Users/Shared/weewx/skins/Weather34/archivedata.php.tmpl
default 21:35:32.757129-0700 Python cheetahgenerator: **** Reason: no such column: pm2_5
error 21:35:32.860069-0700 Python no such column: uva in "SELECT dateTime, uva, usUnits, `interval` FROM archive WHERE dateTime >= ? AND dateTime <= ?"
error 21:35:32.860202-0700 Python no such column: uvb in "SELECT dateTime, uvb, usUnits, `interval` FROM archive WHERE dateTime >= ? AND dateTime <= ?"
error 21:35:32.860348-0700 Python no such column: uvaWm in "SELECT dateTime, uvaWm, usUnits, `interval` FROM archive WHERE dateTime >= ? AND dateTime <= ?"
error 21:35:32.860419-0700 Python no such column: uvbWm in "SELECT dateTime, uvbWm, usUnits, `interval` FROM archive WHERE dateTime >= ? AND dateTime <= ?"
error 21:35:32.860481-0700 Python no such column: full_spectrum in "SELECT dateTime, full_spectrum, usUnits, `interval` FROM archive WHERE dateTime >= ? AND dateTime <= ?"
error 21:35:32.860543-0700 Python no such column: lux in "SELECT dateTime, lux, usUnits, `interval` FROM archive WHERE dateTime >= ? AND dateTime <= ?"
error 21:35:32.860624-0700 Python no such column: infrared in "SELECT dateTime, infrared, usUnits, `interval` FROM archive WHERE dateTime >= ? AND dateTime <= ?"
error 21:35:32.860687-0700 Python no such column: pm2_5 in "SELECT dateTime, pm2_5, usUnits, `interval` FROM archive WHERE dateTime >= ? AND dateTime <= ?"
error 21:35:32.860830-0700 Python no such column: pm10_0 in "SELECT dateTime, pm10_0, usUnits, `interval` FROM archive WHERE dateTime >= ? AND dateTime <= ?"

I've tried temperarily removing mention of pm2.5 from the skin file but it isn't helping.

Any suggestions greatly appreciated!
Cheers
Chris
Message has been deleted

Chris Alemany

unread,
Apr 27, 2020, 1:58:33 AM4/27/20
to weewx...@googlegroups.com
Hi J D,

Your comment made me try completely removing line 280:

$pm25 = “$span($hour ……

from archviedata.php.tmpl. Previously I had just commented it out.

The archivedata file generates now! Perhaps the other errors are erroneous or, because none of those other values are present in the template file, they are not preventing the file from generating.

Thank you for the suggestion of deleting the line, at least now there is data in the display!  I’ll await Ian’s advice on getting purple air values working.

Cheers
Chris

On Apr 26, 2020, at 10:41 PM, J D <balloon...@gmail.com> wrote:

Hi,
Ian is the owner of this so I just emailed him. When he gets online later he will help with this.
I am curious where you got the archivedata.php.tmpl file since the one I am using does not have these fields.?
You can always make a copy of the file and delete the missing fields from the tmpl file since they really should not be there.

--
You received this message because you are subscribed to a topic in the Google Groups "weewx-user" group.
To unsubscribe from this topic, visit https://groups.google.com/d/topic/weewx-user/uVzE9-Ok2eo/unsubscribe.
To unsubscribe from this group and all its topics, send an email to weewx-user+...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/weewx-user/a6ae8964-054f-48c8-b9fb-bcebc487cf0c%40googlegroups.com.

steeple ian

unread,
Apr 27, 2020, 2:55:01 AM4/27/20
to weewx...@googlegroups.com
Hi Chris,
My sincere apologies. I have been tidying up the repository over the last few days and I must had inadvertently overwritten with my own personal private customised version. The offending line has now been deleted. 

By word of explanation, I am for myself using a beta version of the upcoming WeeWX 4.00 which has an extended database including fields for particle measurement. 

Apologies once again,

Ian



You received this message because you are subscribed to the Google Groups "weewx-user" group.
To unsubscribe from this group and stop receiving emails from it, send an email to weewx-user+...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/weewx-user/78563004-93B2-4BD6-AA88-8E8A9B3489FE%40gmail.com.

Christopher Joseph Alemany

unread,
Apr 27, 2020, 2:59:16 AM4/27/20
to weewx...@googlegroups.com
Hi Ian! No worries at all. Sounds like something I would do. :) At least that explanation makes perfect sense!

I may have other questions tomorrow about things that kinda broke when I upgraded, but for now it’s bed time here. Thanks again for your work!

Chris

“They always tell me it takes time. How much more time do you want...for your progress?”
James Baldwin

Chris Alemany
V9Y4M2

On Apr 26, 2020, at 23:55, steeple ian <steep...@gmail.com> wrote:


Reply all
Reply to author
Forward
0 new messages