Thanks for your fast reply :)
I've previously used phpLiteAdmin to make modifications to the database (is
that what you mean?) but it doesn't seem to have caused an issue in the
past.
I had a look back at my user guide, but it's actually the user guide for
v2.4 and it doesn't have the section about Strings in the database. I don't
suppose you have a user guide relevant to v2.6.4 that you could send me,
please?
Thanks.
On Monday, 21 November 2016 22:36:47 UTC, Tom Keffer wrote:
>
> Version 3 does use a different database setup (the old "stats" database is
> gone), but that does not appear to be your problem.
>
> By any chance, did you open up your database using one of the sqlite
> visual editing tools? They frequently substitute an empty string ('') for
> null values. See your old V2.6.4 User's Guide and look for the
> troubleshooting section "Strings in the database." I'd supply a link, but
> the older User's Guide are not online. It provides directions on how to get
> rid of these empty strings.
>
> -tk
>
> On Mon, Nov 21, 2016 at 2:24 PM, David Watts <[email protected]
> <javascript:>> wrote:
>
>> Hi
>>
>> I have weewx v2.6.4 running on an older Raspberry Pi and I'm preparing a
>> new Raspberry Pi to use which has weewx v3.6.2.
>>
>> I tried backing up the weewx database from the old Pi and loading it on
>> to the new one, but I got an error (see below) when loading weewx.
>>
>> Is it because the newer weewx version deals with the database
>> differently? If so, is there a way to convert the older database so it
>> works with the newer weewx?
>>
>> Thanks!
>>
>>
>> Nov 21 22:19:42 gosigweather weewx[3377]: engine: Caught unrecoverable
>> exception in engine:
>> Nov 21 22:19:42 gosigweather weewx[3377]: **** unsupported operand
>> type(s) for +=: 'float' and 'unicode'
>> Nov 21 22:19:42 gosigweather weewx[3377]: **** Traceback (most
>> recent call last):
>> Nov 21 22:19:42 gosigweather weewx[3377]: **** File
>> "/usr/share/weewx/weewx/engine.py", line 841, in main
>> Nov 21 22:19:42 gosigweather weewx[3377]: **** engine =
>> engine_class(config_dict)
>> Nov 21 22:19:42 gosigweather weewx[3377]: **** File
>> "/usr/share/weewx/weewx/engine.py", line 76, in __init__
>> Nov 21 22:19:42 gosigweather weewx[3377]: ****
>> self.loadServices(config_dict)
>> Nov 21 22:19:42 gosigweather weewx[3377]: **** File
>> "/usr/share/weewx/weewx/engine.py", line 140, in loadServices
>> Nov 21 22:19:42 gosigweather weewx[3377]: ****
>> self.service_obj.append(weeutil.weeutil._get_object(svc)(self, config_dict))
>> Nov 21 22:19:42 gosigweather weewx[3377]: **** File
>> "/usr/share/weewx/weewx/engine.py", line 486, in __init__
>> Nov 21 22:19:42 gosigweather weewx[3377]: ****
>> self.setup_database(config_dict)
>> Nov 21 22:19:42 gosigweather weewx[3377]: **** File
>> "/usr/share/weewx/weewx/engine.py", line 588, in setup_database
>> Nov 21 22:19:42 gosigweather weewx[3377]: **** _nrecs, _ndays =
>> dbmanager.backfill_day_summary() # @UnusedVariable
>> Nov 21 22:19:42 gosigweather weewx[3377]: **** File
>> "/usr/share/weewx/weewx/manager.py", line 1374, in backfill_day_summary
>> Nov 21 22:19:42 gosigweather weewx[3377]: ****
>> _day_accum.addRecord(_rec)
>> Nov 21 22:19:42 gosigweather weewx[3377]: **** File
>> "/usr/share/weewx/weewx/accum.py", line 240, in addRecord
>> Nov 21 22:19:42 gosigweather weewx[3377]: **** func(self,
>> record, obs_type, add_hilo)
>> Nov 21 22:19:42 gosigweather weewx[3377]: **** File
>> "/usr/share/weewx/weewx/accum.py", line 310, in add_value
>> Nov 21 22:19:42 gosigweather weewx[3377]: ****
>> self[obs_type].addSum(val)
>> Nov 21 22:19:42 gosigweather weewx[3377]: **** File
>> "/usr/share/weewx/weewx/accum.py", line 87, in addSum
>> Nov 21 22:19:42 gosigweather weewx[3377]: **** self.sum +=
>> val
>> Nov 21 22:19:42 gosigweather weewx[3377]: **** TypeError:
>> unsupported operand type(s) for +=: 'float' and 'unicode'
>> Nov 21 22:19:42 gosigweather weewx[3377]: **** Exiting.
>>
>> --
>> 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] <javascript:>.
>> For more options, visit https://groups.google.com/d/optout.
>>
>
>
--
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].
For more options, visit https://groups.google.com/d/optout.
