Re: [weewx-user] weewx[5570]: engine: Caught database OperationalError: (1054, "Unknown column 'usUnits' in 'field list'")

2017-01-19 Thread Dan'l B
On Thursday, January 19, 2017 at 7:37:43 AM UTC-5, Tom Keffer wrote: > > I have been unable to get these to work with any debug message on my copy > of Sierra. For example, try this: > > > Clunky non-intuitive interface. This is an improvement? > > Any Mac experts out there? The inability to read

Re: [weewx-user] weewx[5570]: engine: Caught database OperationalError: (1054, "Unknown column 'usUnits' in 'field list'")

2017-01-19 Thread Thomas Keffer
I have been unable to get these to work with any debug message on my copy of Sierra. For example, try this: Log a message: logger -p user.debug "Hello weewx" Now try to find it: log show --debug --start "2017-01-19" |grep weewx Nothing... Clunky non-intuitive interface. This is an improvem

Re: [weewx-user] weewx[5570]: engine: Caught database OperationalError: (1054, "Unknown column 'usUnits' in 'field list'")

2017-01-18 Thread mwall
for those running macos sierra: the 'unified logging system' has replaced asl and syslog: https://developer.apple.com/library/content/releasenotes/MacOSX/WhatsNewInOSX/Articles/OSXv10.html this has some useful details for using the new 'log' command to read the new binary logs: https://www.mac

Re: [weewx-user] weewx[5570]: engine: Caught database OperationalError: (1054, "Unknown column 'usUnits' in 'field list'")

2017-01-16 Thread mwall
On Monday, January 16, 2017 at 9:52:57 AM UTC-5, Dan'l B wrote: > > When I go to the actual system.log in /var/log and run > cat system.log | grep weewx > it shows only what I have posted here. > you probably need to adjust the log settings in macos so that it emits DEBUG and INFO log levels in

Re: [weewx-user] weewx[5570]: engine: Caught database OperationalError: (1054, "Unknown column 'usUnits' in 'field list'")

2017-01-16 Thread Dan'l B
When I go to the actual system.log in /var/log and run cat system.log | grep weewx it shows only what I have posted here. This being OSX there must be something else going on. I took me ages to work out how to remedy the "No module named MySQL.db" error, which required this install: https://py

Re: [weewx-user] weewx[5570]: engine: Caught database OperationalError: (1054, "Unknown column 'usUnits' in 'field list'")

2017-01-16 Thread Dan'l B
It's El Cap, not Sierra. I'll see what I can find. On Monday, January 16, 2017 at 9:28:44 AM UTC-5, Tom Keffer wrote: > > Daniel, > > I think you're missing part of your log. Weewx should be reporting much > more information than this. Are you by any chance running 10.12.2 (Sierra)? > It has kno

Re: [weewx-user] weewx[5570]: engine: Caught database OperationalError: (1054, "Unknown column 'usUnits' in 'field list'")

2017-01-16 Thread Thomas Keffer
Daniel, I think you're missing part of your log. Weewx should be reporting much more information than this. Are you by any chance running 10.12.2 (Sierra)? It has known problems with logging. Try the $log show c

Re: [weewx-user] weewx[5570]: engine: Caught database OperationalError: (1054, "Unknown column 'usUnits' in 'field list'")

2017-01-16 Thread Dan'l B
Debug is set to 1, and the console (log display) contents are what I posted; I also reset the MySQL user/pwd to the root user, with no effect. 16/1/2017 08:13:46.567 sudo[9865]:house : TTY=ttys000 ; >> PWD=/Users/house/Documents/weewx-orig ; USER=root ; COMMAND=./bin/weewxd >> weewx.conf >

Re: [weewx-user] weewx[5570]: engine: Caught database OperationalError: (1054, "Unknown column 'usUnits' in 'field list'")

2017-01-16 Thread Dan'l B
Yes, error on my part typing that, apologies. On Monday, January 16, 2017 at 12:50:05 AM UTC-5, Andrew Milner wrote: > > Your answer confuses me. .sdb files are related to SQLite and not MySQL - > which are you trying to use?? > > > > On Monday, 16 January 2017 07:38:59 UTC+2, Dan'l B wrote: > >

Re: [weewx-user] weewx[5570]: engine: Caught database OperationalError: (1054, "Unknown column 'usUnits' in 'field list'")

2017-01-15 Thread gjr80
On Monday, 16 January 2017 15:38:59 UTC+10, Dan'l B wrote: > > Yes, and in the eight minutes after I started it it created no .sdb files > nor any reports in public_html > How about showing the log for what happened in the 8 minutes since startup? As Tom said we need some context for the error.

Re: [weewx-user] weewx[5570]: engine: Caught database OperationalError: (1054, "Unknown column 'usUnits' in 'field list'")

2017-01-15 Thread Andrew Milner
Your answer confuses me. .sdb files are related to SQLite and not MySQL - which are you trying to use?? On Monday, 16 January 2017 07:38:59 UTC+2, Dan'l B wrote: > Yes, and in the eight minutes after I started it it created no .sdb files > nor any reports in public_html > > On Monday, Januar

Re: [weewx-user] weewx[5570]: engine: Caught database OperationalError: (1054, "Unknown column 'usUnits' in 'field list'")

2017-01-15 Thread Dan'l B
Yes, and in the eight minutes after I started it it created no .sdb files nor any reports in public_html On Monday, January 16, 2017 at 12:36:45 AM UTC-5, Andrew Milner wrote: > > When you removed the installation did you also remove and delete the > archive database and let weewx create the dat

Re: [weewx-user] weewx[5570]: engine: Caught database OperationalError: (1054, "Unknown column 'usUnits' in 'field list'")

2017-01-15 Thread Andrew Milner
When you removed the installation did you also remove and delete the archive database and let weewx create the database and necessary tables when it first runs? On Monday, 16 January 2017 06:51:03 UTC+2, Dan'l B wrote: > On Sunday, January 15, 2017 at 9:19:57 PM UTC-5, Tom Keffer wrote: >>

Re: [weewx-user] weewx[5570]: engine: Caught database OperationalError: (1054, "Unknown column 'usUnits' in 'field list'")

2017-01-15 Thread Dan'l B
On Sunday, January 15, 2017 at 9:19:57 PM UTC-5, Tom Keffer wrote: > > Hello, Daniel > > Could you include more of the log? It would help to understand the context > of the error. Include it from the initial weewx startup. > > -tk > > On Sun, Jan 15, 2017 at 5:50 PM, Dan'l B > wrote: > >> Trying

Re: [weewx-user] weewx[5570]: engine: Caught database OperationalError: (1054, "Unknown column 'usUnits' in 'field list'")

2017-01-15 Thread Thomas Keffer
Hello, Daniel Could you include more of the log? It would help to understand the context of the error. Include it from the initial weewx startup. -tk On Sun, Jan 15, 2017 at 5:50 PM, Dan'l B wrote: > Trying to get the MySQL DB working in WeeWx on a Mac. > Is this a known error? The related top

[weewx-user] weewx[5570]: engine: Caught database OperationalError: (1054, "Unknown column 'usUnits' in 'field list'")

2017-01-15 Thread Dan'l B
Trying to get the MySQL DB working in WeeWx on a Mac. Is this a known error? The related topics here in the group were way too complex for my circumstances. 15/1/2017 20:41:49.326 sudo[5627]:house : TTY=ttys002 ; >> PWD=/Users/Shared/weewx ; USER=root ; COMMAND=bin/weewxd weewx.conf > > 15/1