dcapslock / weewx-responsive-skin

Weewx Responsive Skin using the Bootstrap framework
22 stars 9 forks source link

Cannot run skin appTemp not in DB #10

Closed glenosAU closed 5 years ago

glenosAU commented 5 years ago

I've tried to apply this skin to my existing default install and have hit a wall. I am sure it is not too dificult, but I cannot figure out what I am missing. With your skin set to run in weewx.conf when I try to generate reports I get the following:

root@pi:/var/lib/weewx# wee_reports /etc/weewx/weewx.conf Using configuration file /etc/weewx/weewx.conf Generating for all time Traceback (most recent call last): File "/usr/share/weewx/weewx/reportengine.py", line 204, in run obj.start() File "/usr/share/weewx/weewx/reportengine.py", line 300, in start self.run() File "/usr/share/weewx/weewx/cheetahgenerator.py", line 157, in run self.initExtensions(gen_dict[sectionname]) File "/usr/share/weewx/weewx/cheetahgenerator.py", line 199, in initExtensions class = weeutil.weeutil._get_object(x) File "/usr/share/weewx/weeutil/weeutil.py", line 1107, in _get_object mod = import(module) File "/usr/share/weewx/user/aussearch.py", line 2, in import pytz ImportError: No module named pytz Traceback (most recent call last): File "/usr/share/weewx/weewx/reportengine.py", line 204, in run obj.start() File "/usr/share/weewx/weewx/reportengine.py", line 300, in start self.run() File "/usr/share/weewx/weewx/imagegenerator.py", line 33, in run self.genImages(self.gen_ts) File "/usr/share/weewx/weewx/imagegenerator.py", line 170, in genImages aggregate_interval=aggregate_interval) File "/usr/share/weewx/weewx/manager.py", line 513, in getSqlVectors aggregate_type, aggregate_interval) File "/usr/share/weewx/weewx/manager.py", line 790, in _getSqlVectors for _rec in _cursor.execute(sql_str, (startstamp, stopstamp)): File "/usr/share/weewx/weedb/sqlite.py", line 41, in guarded_fn raise weedb.NoColumnError(e) NoColumnError: no such column: appTemp

I assume this means I need to add appTemp to the database schema, but I cannot figure how to do it. I tried to understand the wiki but I don't get it.

Are you able to offer any help?

dcapslock commented 5 years ago

Hi There,

Yes, appTemp required. See general weeex guide on updating schema. https://github.com/poblabs/weewx-belchertown/wiki/Adding-a-new-observation-type-to-the-WeeWX-database

Cheers

Darryn


From: glenosAU notifications@github.com Sent: Sunday, November 17, 2019 8:37:03 PM To: dcapslock/weewx-responsive-skin weewx-responsive-skin@noreply.github.com Cc: Subscribed subscribed@noreply.github.com Subject: [dcapslock/weewx-responsive-skin] Cannot run skin appTemp not in DB (#10)

I've tried to apply this skin to my existing default install and have hit a wall. I am sure it is not too dificult, but I cannot figure out what I am missing. With your skin set to run in weewx.conf when I try to generate reports I get the following:

root@pi:/var/lib/weewx# wee_reports /etc/weewx/weewx.conf Using configuration file /etc/weewx/weewx.conf Generating for all time Traceback (most recent call last): File "/usr/share/weewx/weewx/reportengine.py", line 204, in run obj.start() File "/usr/share/weewx/weewx/reportengine.py", line 300, in start self.run() File "/usr/share/weewx/weewx/cheetahgenerator.py", line 157, in run self.initExtensions(gen_dict[sectionname]) File "/usr/share/weewx/weewx/cheetahgenerator.py", line 199, in initExtensions class = weeutil.weeutil._get_object(x) File "/usr/share/weewx/weeutil/weeutil.py", line 1107, in _get_object mod = import(module) File "/usr/share/weewx/user/aussearch.py", line 2, in import pytz ImportError: No module named pytz Traceback (most recent call last): File "/usr/share/weewx/weewx/reportengine.py", line 204, in run obj.start() File "/usr/share/weewx/weewx/reportengine.py", line 300, in start self.run() File "/usr/share/weewx/weewx/imagegenerator.py", line 33, in run self.genImages(self.gen_ts) File "/usr/share/weewx/weewx/imagegenerator.py", line 170, in genImages aggregate_interval=aggregate_interval) File "/usr/share/weewx/weewx/manager.py", line 513, in getSqlVectors aggregate_type, aggregate_interval) File "/usr/share/weewx/weewx/manager.py", line 790, in _getSqlVectors for _rec in _cursor.execute(sql_str, (startstamp, stopstamp)): File "/usr/share/weewx/weedb/sqlite.py", line 41, in guarded_fn raise weedb.NoColumnError(e) NoColumnError: no such column: appTemp

I assume this means I need to add appTemp to the database schema, but I cannot figure how to do it. I tried to understand the wiki but I don't get it.

Are you able to offer any help?

— You are receiving this because you are subscribed to this thread. Reply to this email directly, view it on GitHubhttps://apc01.safelinks.protection.outlook.com/?url=https%3A%2F%2Fgithub.com%2Fdcapslock%2Fweewx-responsive-skin%2Fissues%2F10%3Femail_source%3Dnotifications%26email_token%3DADLXZBVRAWLT7DO4XPJHQ43QUEGD7A5CNFSM4JOJAGWKYY3PNVWWK3TUL52HS4DFUVEXG43VMWVGG33NNVSW45C7NFSM4HZ277UQ&data=02%7C01%7C%7C62873d266e5e4a22126408d76b41b5c7%7C84df9e7fe9f640afb435aaaaaaaaaaaa%7C1%7C0%7C637095802274127427&sdata=Y8MbTbZ5NiV6O0XuInf%2FG8SQuu6Vn6I5Z0ONOwOoaJo%3D&reserved=0, or unsubscribehttps://apc01.safelinks.protection.outlook.com/?url=https%3A%2F%2Fgithub.com%2Fnotifications%2Funsubscribe-auth%2FADLXZBTRQYAATV24656ILATQUEGD7ANCNFSM4JOJAGWA&data=02%7C01%7C%7C62873d266e5e4a22126408d76b41b5c7%7C84df9e7fe9f640afb435aaaaaaaaaaaa%7C1%7C0%7C637095802274137438&sdata=BZWXoh5%2F9jPttIrsolYExLIcSx07CZ3d%2BK2jVyoibtU%3D&reserved=0.

glenosAU commented 5 years ago

Thanks Darryn, Got it working. Strated the day as a clean up of bad data due to a shaking rain bucket, ended up with a new skin. I did have a problem running the rports initially, index.html.tmpl would not run. There was an error about dateutils.parser module not found.

Next trick is to get ET and GDD calculated, I only have a WH1080 so need to assume solar radiation for ET an approximate ET will do its for irrigation scheduling on a farm.

Cheers Glen