Hallo Hartmut,

I have been unable to reproduce your error, even using the files you 
posted. I have adedd a few debug lines into weewxwd_config, it will do a 
couple of queries after removing the extraTemp1 and extraTemp2 data and 
print out some info  on the state of extraTemp1 and extraTemp2. Could you 
try it in place of your version and post back the resulting out in its 
entritey.

I did not that the file posted was named weewxwd_config.py whereas the file 
actually does not have the .py extension. 

Gary

On Sunday, 12 March 2017 00:26:32 UTC+10, gjr80 wrote:
>
> Hallo Hartmut,
>
> Thanks. I have run that --clear-v2-data code and it behaved as it should 
> though my setup was not quite the same as yours (SQLite vs MySQL for 
> starters). I will have to call it a night now, I will sit down tomorrow and 
> better replicate your setup to see if we can work out the problem.
>
> Gary
>
> On Saturday, 11 March 2017 23:14:03 UTC+10, Hartmut Schweidler wrote:
>>
>> Hallo Gary,
>>
>> have at test01.txt
>> root@acer:/home/weewx/bin/user# date
>> Sa 11. Mär 13:34:38 CET 2017
>> root@acer:/home/weewx/bin/user# ./weewxwd_config.py --clear-v2-data 
>> --wx-binding=wx_binding
>> Using configuration file /home/weewx/weewx.conf
>> Using database binding 'wx_binding', which is bound to database 
>> 'archive_mysql'
>> Using database binding 'wd_binding', which is bound to database 'wd_mysql'
>> row [264897, 262985]
>> 'extraTemp1' and 'extraTemp2' data in database 'weewxAlt' from 2013-10-31 
>> 22:19:00 CET (1383254340) to 2017-03-11 13:30:00 CET (14892
>> 35400) (approx 1227 days) is about to be cleared. Any data in these 
>> fields will be irretrievably lost.
>> Are you sure you wish to proceed (y/n)? y
>> Done. 'extraTemp1' and 'extraTemp2' cleared in 351365 records (approx 
>> 1227 days).
>> root@acer:/home/weewx/bin/user# date
>> Sa 11. Mär 13:50:26 CET 2017
>> Hartmut
>>
>

Reply via email to