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: https://www.alberniweather.ca/index.html
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 -- 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+unsubscr...@googlegroups.com. To view this discussion on the web visit https://groups.google.com/d/msgid/weewx-user/3af8e4f6-d85b-4478-9a66-7558dca42578%40googlegroups.com.
