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 > <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 > <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] > <mailto:[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.
