hier the attachement -- 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]. To view this discussion on the web visit https://groups.google.com/d/msgid/weewx-user/5c888b2c-f222-4c5e-bdc8-2797695ddd9b%40googlegroups.com. For more options, visit https://groups.google.com/d/optout.
This fixes the database if there are any wrong entries -e If you just press enter for the next two prompts you will get all the rainfall for the day -e -e Input the date in this format YYYY-MM-DD Press enter for the current date.
./raindel.sh: 44: ./raindel.sh: [[: not found -e The date selected is -e -e Input the time you want to find in this format HH:MM:SS Press enter to select midnight. ./raindel.sh: 55: ./raindel.sh: [[: not found -e The time selected is -e -e Input the rain amount you want to change in this format MM.M Press enter to select zero. ./raindel.sh: 65: ./raindel.sh: [[: not found -e -e The rain amount is and the reporting interval is 5 minutes. -e (standard_in) 2: syntax error ./raindel.sh: 78: ./raindel.sh: [[: not found -e The epoch date you want to find in the list below is 1557525600 -e -e Next day epoch date is 1557612000 -e Midnight time is: 1557525600 -e -e +------------+------+----------+ | dateTime | rain | rainRate | +------------+------+----------+ | 1557568080 | 1.1 | 0.4 | +------------+------+----------+ -e -e Rain value is and rain rate value is -e If there are no records above then that means there are no rain rates for -e Select the first and last record you want updated Usually pick the first record with rain and then the records below it that have rain rates but do not have rain records. Hope that makes sense. -e Select the FIRST dateTime you want to update --- Select the FIRST dateTime you want to update 1557568080 -e The FISRT date you chose is Sa 11. Mai 11:48:00 CEST 2019 -e Select the LAST dateTime you want to update --- Select the LAST dateTime you want to update 1557568080 -e The LAST date you chose is Sa 11. Mai 11:48:00 CEST 2019 -e -e This is the Rain total and will be deleted -e this is the rain rate and will be deleted +------------+------+------------+------+------------+------+-------+------+---------+ | dateTime | min | mintime | max | maxtime | sum | count | wsum | sumtime | +------------+------+------------+------+------------+------+-------+------+---------+ | 1557525600 | 0 | 1557525601 | 0 | 1557525601 | 0 | 360 | 0 | 43200 | +------------+------+------------+------+------------+------+-------+------+---------+ -e -e The rain amount selected is -e The Rain rate will be calculated as: -e Press y to update the database. The changes will take effect if you press y. Press CTRL-C to cancel updates. Do you wish to update the database? --- Press y to update the database. The changes will take effect if you press y. Press CTRL-C to cancel updates. Do you wish to update the database?y Stop weewx [ ok ] Stopping weewx (via systemctl): weewx.service. Back up database to /tmp then set the data to 0 ERROR 1064 (42000) at line 1: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'WHERE (dateTime = 1557568080)' at line 1 ERROR 1064 (42000) at line 1: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'WHERE (dateTime = 1557568080)' at line 1 -e -e Number of records to process: count(*) 2466 -e Rebuild the dailiy stats for the date Using configuration file /etc/weewx/weewx.conf Using database binding 'wx_binding', which is bound to database 'archive_mysql' All daily summaries will be rebuilt. Proceed (y/n)? --- Proceed (y/n)? y Rebuilding daily summaries in database 'weewx' ... Daily summaries up to date in 'weewx' Start weewx [ ok ] Starting weewx (via systemctl): weewx.service. regenerate the web pages Using configuration file /etc/weewx/weewx.conf Generating for all time pi @ q4os-raspi ~ └─ $
