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.
On Sunday, April 26, 2020 at 9:43:14 PM UTC-7, Chris Alemany wrote: > > 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 [email protected]. To view this discussion on the web visit https://groups.google.com/d/msgid/weewx-user/a6ae8964-054f-48c8-b9fb-bcebc487cf0c%40googlegroups.com.
