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 On Mon, 27 Apr 2020 at 06:58, Chris Alemany <[email protected]> wrote: > 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 <[email protected]> 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. > > 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 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 > [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 > <https://groups.google.com/d/msgid/weewx-user/a6ae8964-054f-48c8-b9fb-bcebc487cf0c%40googlegroups.com?utm_medium=email&utm_source=footer> > . > > > -- > 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/78563004-93B2-4BD6-AA88-8E8A9B3489FE%40gmail.com > <https://groups.google.com/d/msgid/weewx-user/78563004-93B2-4BD6-AA88-8E8A9B3489FE%40gmail.com?utm_medium=email&utm_source=footer> > . > -- 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/CADASSaR1Jg_hUeovHdjRXH9TvNJZHF0_%2BayFa970GMTURzoPbA%40mail.gmail.com.
