Hi, Welcome to weeWX. You might want to have a look at this thread <https://groups.google.com/d/topic/weewx-user/X7FDi9AHh20/discussion>. I can't speak for the SQL and python scripts in the last post, but I would certainly be trying wee_database <http://weewx.com/docs/utilities.htm#wee_database_utility> with --check-strings and --fix in the first instance.
Gary On Thursday, 11 January 2018 16:31:45 UTC+10, loonsailor wrote: > > I've got weewx running great on my shiny new ubuntu box, but I haven't > been able to start it from my wview database, with 11 years of data. I > copy wview-archive.sdb to /var/lib/weewx/weex.sdb and start weewx, but it > dies immediatlely, with the following in syslog: > > Jan 10 18:41:22 ubu-mini-weather weewx[5090]: wxcalculate: The following > algorithms will be used for calculations: altimeter=aaNOAA, maxSolarRad=RS > > Jan 10 18:41:22 ubu-mini-weather weewx[5090]: engine: Archive will use > data binding wx_binding > > Jan 10 18:41:22 ubu-mini-weather weewx[5090]: engine: Record generation > will be attempted in 'hardware' > > Jan 10 18:41:22 ubu-mini-weather weewx[5090]: engine: Using archive > interval of 600 seconds (specified by hardware) > > Jan 10 18:41:22 ubu-mini-weather weewx[5090]: engine: Using binding > 'wx_binding' to database 'weewx.sdb' > > Jan 10 18:41:22 ubu-mini-weather weewx[5090]: manager: Starting backfill > of daily summaries > > Jan 10 18:41:23 ubu-mini-weather weewx[5090]: engine: Caught unrecoverable > exception in engine: > > Jan 10 18:41:23 ubu-mini-weather weewx[5090]: **** unsupported > operand type(s) for +=: 'float' and 'unicode' > > Jan 10 18:41:23 ubu-mini-weather weewx[5090]: **** Traceback (most > recent call last): > > Jan 10 18:41:23 ubu-mini-weather weewx[5090]: **** File > "/usr/share/weewx/weewx/engine.py", line 865, in main > > Jan 10 18:41:23 ubu-mini-weather weewx[5090]: **** engine = > engine_class(config_dict) > > Jan 10 18:41:23 ubu-mini-weather weewx[5090]: **** File > "/usr/share/weewx/weewx/engine.py", line 77, in __init__ > > Jan 10 18:41:23 ubu-mini-weather weewx[5090]: **** > self.loadServices(config_dict) > > Jan 10 18:41:23 ubu-mini-weather weewx[5090]: **** File > "/usr/share/weewx/weewx/engine.py", line 141, in loadServices > > Jan 10 18:41:23 ubu-mini-weather weewx[5090]: **** > self.service_obj.append(weeutil.weeutil._get_object(svc)(self, > config_dict)) > > Jan 10 18:41:23 ubu-mini-weather weewx[5090]: **** File > "/usr/share/weewx/weewx/engine.py", line 491, in __init__ > > Jan 10 18:41:23 ubu-mini-weather weewx[5090]: **** > self.setup_database(config_dict) > > Jan 10 18:41:23 ubu-mini-weather weewx[5090]: **** File > "/usr/share/weewx/weewx/engine.py", line 604, in setup_database > > Jan 10 18:41:23 ubu-mini-weather weewx[5090]: **** _nrecs, > _ndays = dbmanager.backfill_day_summary() # @UnusedVariable > > Jan 10 18:41:23 ubu-mini-weather weewx[5090]: **** File > "/usr/share/weewx/weewx/manager.py", line 1454, in backfill_day_summary > > Jan 10 18:41:23 ubu-mini-weather weewx[5090]: **** > day_accum.addRecord(rec, > weight=weight) > > Jan 10 18:41:23 ubu-mini-weather weewx[5090]: **** File > "/usr/share/weewx/weewx/accum.py", line 242, in addRecord > > Jan 10 18:41:23 ubu-mini-weather weewx[5090]: **** func(self, > record, obs_type, add_hilo, weight) > > Jan 10 18:41:23 ubu-mini-weather weewx[5090]: **** File > "/usr/share/weewx/weewx/accum.py", line 301, in add_value > > Jan 10 18:41:23 ubu-mini-weather weewx[5090]: **** > self[obs_type].addSum(val, > weight=weight) > > Jan 10 18:41:23 ubu-mini-weather weewx[5090]: **** File > "/usr/share/weewx/weewx/accum.py", line 88, in addSum > > Jan 10 18:41:23 ubu-mini-weather weewx[5090]: **** self.sum += > val > > Jan 10 18:41:23 ubu-mini-weather weewx[5090]: **** TypeError: > unsupported operand type(s) for +=: 'float' and 'unicode' > > Jan 10 18:41:23 ubu-mini-weather weewx[5090]: **** Exiting. > > > I've tried a couple of different database snapshots, always with the same > result. It quits very quickly, so the problem is not deep into the file > (which is about 86MB). > > Where should I start looking? > > Thanks! > > -- 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. For more options, visit https://groups.google.com/d/optout.