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 3854 6th Ave Port Alberni, BC V9Y4M2 h:250-723-0889 w: 250-753-3245 x2106 e: chris...@gmail.com w: www.chrisalemany.ca w: www.alberniweather.ca w: www.vifreightbyrail.ca > On Apr 26, 2020, at 23:55, steeple ian <steeple...@gmail.com> wrote: > > > 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 <chris...@gmail.com> 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 <balloonxoom...@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. >>> >>>> 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 >>> weewx-user+unsubscr...@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. >> >> -- >> 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/78563004-93B2-4BD6-AA88-8E8A9B3489FE%40gmail.com. > > -- > 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+unsubscr...@googlegroups.com. > To view this discussion on the web visit > https://groups.google.com/d/msgid/weewx-user/CADASSaR1Jg_hUeovHdjRXH9TvNJZHF0_%2BayFa970GMTURzoPbA%40mail.gmail.com. -- 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/C380C622-4930-46B3-B54D-A5A743D4BFC0%40gmail.com.
