Almost the exact procedure followed.
Not that it should matter, /var/lib/weewx is symlinked to a different
location (to make backups a bit easier). A Config file change also sets
SQLITE_ROOT to that location as well.
Retrying again (with wee_debug before start)
Commands issued (as root):
*systemctl stop weewx cd /data/weewx/lib mv weewx.sdb weewx-backup.sdb cp
wview-history.sdb weewx.sdbcd /data/weewx/htmlrm -R * ### clear out
generated reportswee_debug --info --output*
*results in these messages:wee_debug output will be written to
/var/tmp/weewx.debugTraceback (most recent call last): File
"/usr/bin/wee_debug", line 420, in <module> main() File
"/usr/bin/wee_debug", line 160, in main options.verbosity) File
"/usr/bin/wee_debug", line 232, in generateDebugInfo manager_info_dict =
getManagerInfo(config_dict, db_binding_wx) File "/usr/bin/wee_debug", line
365, in getManagerInfo with
weewx.manager.open_manager_with_config(config_dict, db_binding_wx) as
dbmanager_wx: File "/usr/share/weewx/weewx/manager.py", line 1032, in
open_manager_with_config return open_manager(manager_dict, initialize)
File "/usr/share/weewx/weewx/manager.py", line 1024, in open_manager
manager_dict['table_name']) File "/usr/share/weewx/weewx/manager.py", line
105, in open dbmanager = cls(connection, table_name) File
"/usr/share/weewx/weewx/manager.py", line 1157, in __init__
super(DaySummaryManager, self).__init__(connection, table_name, schema)
File "/usr/share/weewx/weewx/manager.py", line 73, in __init__
self.sqlkeys = self.connection.columnsOf(self.table_name) File
"/usr/share/weewx/weedb/sqlite.py", line 171, in columnsOf raise
weedb.ProgrammingError("No such table %s" % table)weedb.ProgrammingError:
No such table archive*
Richard Rosa
On Wednesday, July 31, 2019 at 10:53:47 AM UTC-4, gjr80 wrote:
>
> Ok, so wee_ debug says there is only 54 odd days of data in your archive,
> expect these records are the history downloaded from the logger. So we are
> not going to get any reports using your historical wview data from that
> database.
>
> Not convinced this a schema issue.
>
> Just to step back a bit, when you copied the wview database did you make a
> copy and rename it weewx.sdb? Was it saved to /var/lib/weewx? If not that
> is what you need to do. If you did do this then stop WeeWX if it is
> running, move /var/lib/weewx/weewx.sdb aside and make a fresh copy of your
> wview history database, rename it weewx.sdb and save it to /var/lib/weewx.
> Run wee_debug again, what does it show under ‘Archive info’?
>
> 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 [email protected].
To view this discussion on the web visit
https://groups.google.com/d/msgid/weewx-user/7ba4113f-e236-4bc5-91ff-4bedb38c7bdf%40googlegroups.com.
