OK here it is
Last login: Tue Jun 2 23:32:02 2020 from 192.168.0.54
*pi@raspberrypi*:*~ $* cd /home/weewx/bin
*pi@raspberrypi*:*/home/weewx/bin $* ./wee_database /home/weewx/weewx.conf
--drop-daily
Using configuration file /home/weewx/weewx.conf
Using database binding 'wx_binding', which is bound to database
'archive_mysql'
Proceeding will delete all your daily summaries from database 'weewx'
Are you sure you want to proceed (y/n)? y
Dropping daily summary tables from 'weewx' ...
No daily summaries found in database 'weewx'. Nothing done.
*pi@raspberrypi*:*/home/weewx/bin $* ./wee_database /home/weewx/weewx.conf
--rebuild-daily
Using configuration file /home/weewx/weewx.conf
Using database binding 'wx_binding', which is bound to database
'archive_mysql'
All daily summaries will be rebuilt.
Proceed (y/n)? y
Traceback (most recent call last):
File "/home/weewx/bin/weedb/mysql.py", line 52, in guarded_fn
return fn(*args, **kwargs)
File "/home/weewx/bin/weedb/mysql.py", line 262, in execute
self.cursor.execute(mysql_string, tuple(sql_tuple))
File "/usr/lib/python3/dist-packages/MySQLdb/cursors.py", line 250, in
execute
self.errorhandler(self, exc, value)
File "/usr/lib/python3/dist-packages/MySQLdb/connections.py", line 50, in
defaulterrorhandler
raise errorvalue
File "/usr/lib/python3/dist-packages/MySQLdb/cursors.py", line 247, in
execute
res = self._query(query)
File "/usr/lib/python3/dist-packages/MySQLdb/cursors.py", line 411, in
_query
rowcount = self._do_query(q)
File "/usr/lib/python3/dist-packages/MySQLdb/cursors.py", line 374, in
_do_query
db.query(q)
File "/usr/lib/python3/dist-packages/MySQLdb/connections.py", line 292,
in query
_mysql.connection.query(self, query)
_mysql_exceptions.OperationalError: (1050, "Table 'archive_day_altimeter'
already exists")
During handling of the above exception, another exception occurred:
Traceback (most recent call last):
File "./wee_database", line 974, in <module>
main()
File "./wee_database", line 169, in main
rebuildDaily(config_dict, db_binding, options)
File "./wee_database", line 264, in rebuildDaily
with weewx.manager.open_manager_with_config(config_dict, db_binding,
initialize=True) as dbmanager:
File "/home/weewx/bin/weewx/manager.py", line 692, in
open_manager_with_config
return open_manager(manager_dict, initialize)
File "/home/weewx/bin/weewx/manager.py", line 680, in open_manager
manager_dict['schema'])
File "/home/weewx/bin/weewx/manager.py", line 163, in open_with_create
dbmanager = cls(connection, table_name=table_name, schema=schema)
File "/home/weewx/bin/weewx/manager.py", line 818, in __init__
self._initialize_day_tables(schema)
File "/home/weewx/bin/weewx/manager.py", line 867, in
_initialize_day_tables
cursor.execute(sql_create_str)
File "/home/weewx/bin/weedb/mysql.py", line 61, in guarded_fn
raise klass(e)
weedb.TableExistsError: (1050, "Table 'archive_day_altimeter' already
exists")
*pi@raspberrypi*:*/home/weewx/bin $*
On Wednesday, June 3, 2020 at 6:34:56 AM UTC+10, gjr80 wrote:
>
> Ok, could you please run those two wee_database commands again one after
> each other and post the console output making sure you include the commands
> entered as well as the output.
>
> 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/e4e53844-94d1-40d3-915d-2cf13f2c05d5%40googlegroups.com.
