[weewx-user] table archive_day_barometer already exists
Hi, Try the following: 1. Stop weeWX 2. Use the wee_database utility to drop the daily summaries 3. Use the wee_database utuilit to rebuild the daily summaries 4. Restart WeeWX wee_database usage is documented in the Utilities Guide (http://weewx.com/docs/utilities.htm#wee_database_utility) Gary -- 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.
[weewx-user] table archive_day_barometer already exists
Over the past year I've had numerous cases of a corrupted database. I learned early on to have a good backup scheme in place and it has served me well - up until today. After I noticed that the web page was no longer updating I checked the /var/sys/logfile and found the message "DatabaseError: database disk image is malformed". Shortly after that I discovered my backups for the past month were not working, so I've been faced with trying to repair the weewx.sdb file. I've found several posts describing how to recover from problems like this and ended up using the repairsdb.sh script that I found in one of them. That fixed the "malformed" error and I am now able to load the database but when weewx starts it now aborts with the error that "table archive_day_barometer already exists". I had never used sqlite3 prior to weewx and am not really familiar with what to try now. Anybody have any ideas I can try? Thanks Dave -- 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.