Hallo Hartmut,
Apologies for the time I took in getting back to you. I think we have
finally tracked down the issue. When I was running a similar setup to yours
on a VM using SQLite everything worked as expected, extraTemp1 and
extraTemp2 were set correctly. I then migrated over to MySQL and then
observed the behaviour you have been experiencing. The issue as it turns
out is due to python package MySQLdb turning off autocommit by default.
This means we need to manually commit after making changes to the db. I had
incorrectly assumed this was occurring when we exited the with statement.
Try adding the highlighted line to def clear-v2-data() (about line 589):
dbmanager_wx.updateValue(_rec['dateTime'],
'extraTemp1', None)
dbmanager_wx.updateValue(_rec['dateTime'],
'extraTemp2', None)
nrecs += 1
dbmanager_wx.connection.commit()
# all done, say so and give some stats
print "Done. 'extraTemp1' and 'extraTemp2' cleared in
%d records (approx %d days)." %(nrecs, ndays)
Let us know how you go. Oh, and if it works you can thank Tom, it was
beyond me so I emailed for some help!
Gary
On Thursday, 16 March 2017 02:56:41 UTC+10, Hartmut Schweidler wrote:
>
> Hallo Gary,
>
> the result
>
> root@acer:/home/weewx/bin/user# ./weewxwd_config --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 [266092, 264180]
> 'extraTemp1' and 'extraTemp2' data in database 'weewxAlt' from 2013-10-31
> 22:19:00 CET (1383254340) to 2017-03-15 17:05:00 CET (1489593900) (approx
> 1231 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 352560 records (approx 1231
> days).
> Let's check our results in database weewxAlt
> 352560 rows found where extraTemp1 is NULL
> 352560 rows found where extraTemp2 is NULL
>
> and now phpmyadmin 14103 bei 25 row
>
> by database weewxAlt
>
> Zeige Datensätze 352550 - 352567 (352568 insgesamt, Die Abfrage dauerte
> 0.0002 Sekunden.)
>
> [image: Vollständige Texte]
> <http://amd350/phpmyadmin/sql.php?db=weewxAlt&table=archive&sql_query=SELECT+%60dateTime%60%2C+%60extraTemp1%60%2C+%60extraTemp2%60+FROM+%60archive%60+&goto=tbl_sql.php&full_text_button=1&pftext=F&token=cc24e0088d26a00baeed12fe834d5726>
>
> dateTime
> <http://amd350/phpmyadmin/sql.php?db=weewxAlt&table=archive&sql_query=SELECT+%60dateTime%60%2C+%60extraTemp1%60%2C+%60extraTemp2%60+FROM+%60archive%60%0AORDER+BY+%60archive%60.%60dateTime%60+ASC&session_max_rows=25&token=cc24e0088d26a00baeed12fe834d5726>
>
> extraTemp1
> <http://amd350/phpmyadmin/sql.php?db=weewxAlt&table=archive&sql_query=SELECT+%60dateTime%60%2C+%60extraTemp1%60%2C+%60extraTemp2%60+FROM+%60archive%60%0AORDER+BY+%60archive%60.%60extraTemp1%60+ASC&session_max_rows=25&token=cc24e0088d26a00baeed12fe834d5726>
>
> extraTemp2
> <http://amd350/phpmyadmin/sql.php?db=weewxAlt&table=archive&sql_query=SELECT+%60dateTime%60%2C+%60extraTemp1%60%2C+%60extraTemp2%60+FROM+%60archive%60%0AORDER+BY+%60archive%60.%60extraTemp2%60+ASC&session_max_rows=25&token=cc24e0088d26a00baeed12fe834d5726>
>
> [image: Bearbeiten] Bearbeiten
> <http://amd350/phpmyadmin/tbl_change.php?db=weewxAlt&table=archive&where_clause=%60archive%60.%60dateTime%60+%3D+1489591200&clause_is_unique=1&sql_query=SELECT+%60dateTime%60%2C+%60extraTemp1%60%2C+%60extraTemp2%60+FROM+%60archive%60+&goto=sql.php&default_action=update&token=cc24e0088d26a00baeed12fe834d5726>
> [image:
> Kopieren] Kopieren
> <http://amd350/phpmyadmin/tbl_change.php?db=weewxAlt&table=archive&where_clause=%60archive%60.%60dateTime%60+%3D+1489591200&clause_is_unique=1&sql_query=SELECT+%60dateTime%60%2C+%60extraTemp1%60%2C+%60extraTemp2%60+FROM+%60archive%60+&goto=sql.php&default_action=insert&token=cc24e0088d26a00baeed12fe834d5726>
> [image:
> Löschen] Löschen
> <http://amd350/phpmyadmin/sql.php?db=weewxAlt&table=archive&sql_query=DELETE+FROM+%60weewxAlt%60.%60archive%60+WHERE+%60archive%60.%60dateTime%60+%3D+1489591200&message_to_show=Der+Datensatz+wurde+gel%C3%B6scht.&goto=sql.php%3Fdb%3DweewxAlt%26table%3Darchive%26sql_query%3DSELECT%2B%2560dateTime%2560%252C%2B%2560extraTemp1%2560%252C%2B%2560extraTemp2%2560%2BFROM%2B%2560archive%2560%2B%26message_to_show%3DDer%2BDatensatz%2Bwurde%2Bgel%25C3%25B6scht.%26goto%3Dtbl_sql.php%26token%3Dcc24e0088d26a00baeed12fe834d5726&token=cc24e0088d26a00baeed12fe834d5726>
>
> 1489591200 7.93245825531825 13.9417930834273
> [image: Bearbeiten] Bearbeiten
> <http://amd350/phpmyadmin/tbl_change.php?db=weewxAlt&table=archive&where_clause=%60archive%60.%60dateTime%60+%3D+1489591500&clause_is_unique=1&sql_query=SELECT+%60dateTime%60%2C+%60extraTemp1%60%2C+%60extraTemp2%60+FROM+%60archive%60+&goto=sql.php&default_action=update&token=cc24e0088d26a00baeed12fe834d5726>
> [image:
> Kopieren] Kopieren
> <http://amd350/phpmyadmin/tbl_change.php?db=weewxAlt&table=archive&where_clause=%60archive%60.%60dateTime%60+%3D+1489591500&clause_is_unique=1&sql_query=SELECT+%60dateTime%60%2C+%60extraTemp1%60%2C+%60extraTemp2%60+FROM+%60archive%60+&goto=sql.php&default_action=insert&token=cc24e0088d26a00baeed12fe834d5726>
> [image:
> Löschen] Löschen
> <http://amd350/phpmyadmin/sql.php?db=weewxAlt&table=archive&sql_query=DELETE+FROM+%60weewxAlt%60.%60archive%60+WHERE+%60archive%60.%60dateTime%60+%3D+1489591500&message_to_show=Der+Datensatz+wurde+gel%C3%B6scht.&goto=sql.php%3Fdb%3DweewxAlt%26table%3Darchive%26sql_query%3DSELECT%2B%2560dateTime%2560%252C%2B%2560extraTemp1%2560%252C%2B%2560extraTemp2%2560%2BFROM%2B%2560archive%2560%2B%26message_to_show%3DDer%2BDatensatz%2Bwurde%2Bgel%25C3%25B6scht.%26goto%3Dtbl_sql.php%26token%3Dcc24e0088d26a00baeed12fe834d5726&token=cc24e0088d26a00baeed12fe834d5726>
>
> 1489591500 7.78199553157776 13.8184127927065
> [image: Bearbeiten] Bearbeiten
> <http://amd350/phpmyadmin/tbl_change.php?db=weewxAlt&table=archive&where_clause=%60archive%60.%60dateTime%60+%3D+1489591800&clause_is_unique=1&sql_query=SELECT+%60dateTime%60%2C+%60extraTemp1%60%2C+%60extraTemp2%60+FROM+%60archive%60+&goto=sql.php&default_action=update&token=cc24e0088d26a00baeed12fe834d5726>
> [image:
> Kopieren] Kopieren
> <http://amd350/phpmyadmin/tbl_change.php?db=weewxAlt&table=archive&where_clause=%60archive%60.%60dateTime%60+%3D+1489591800&clause_is_unique=1&sql_query=SELECT+%60dateTime%60%2C+%60extraTemp1%60%2C+%60extraTemp2%60+FROM+%60archive%60+&goto=sql.php&default_action=insert&token=cc24e0088d26a00baeed12fe834d5726>
> [image:
> Löschen] Löschen
> <http://amd350/phpmyadmin/sql.php?db=weewxAlt&table=archive&sql_query=DELETE+FROM+%60weewxAlt%60.%60archive%60+WHERE+%60archive%60.%60dateTime%60+%3D+1489591800&message_to_show=Der+Datensatz+wurde+gel%C3%B6scht.&goto=sql.php%3Fdb%3DweewxAlt%26table%3Darchive%26sql_query%3DSELECT%2B%2560dateTime%2560%252C%2B%2560extraTemp1%2560%252C%2B%2560extraTemp2%2560%2BFROM%2B%2560archive%2560%2B%26message_to_show%3DDer%2BDatensatz%2Bwurde%2Bgel%25C3%25B6scht.%26goto%3Dtbl_sql.php%26token%3Dcc24e0088d26a00baeed12fe834d5726&token=cc24e0088d26a00baeed12fe834d5726>
>
> 1489591800 7.63258845783752 13.6979746027028
> [image: Bearbeiten] Bearbeiten
> <http://amd350/phpmyadmin/tbl_change.php?db=weewxAlt&table=archive&where_clause=%60archive%60.%60dateTime%60+%3D+1489592100&clause_is_unique=1&sql_query=SELECT+%60dateTime%60%2C+%60extraTemp1%60%2C+%60extraTemp2%60+FROM+%60archive%60+&goto=sql.php&default_action=update&token=cc24e0088d26a00baeed12fe834d5726>
> [image:
> Kopieren] Kopieren
> <http://amd350/phpmyadmin/tbl_change.php?db=weewxAlt&table=archive&where_clause=%60archive%60.%60dateTime%60+%3D+1489592100&clause_is_unique=1&sql_query=SELECT+%60dateTime%60%2C+%60extraTemp1%60%2C+%60extraTemp2%60+FROM+%60archive%60+&goto=sql.php&default_action=insert&token=cc24e0088d26a00baeed12fe834d5726>
> [image:
> Löschen] Löschen
> <http://amd350/phpmyadmin/sql.php?db=weewxAlt&table=archive&sql_query=DELETE+FROM+%60weewxAlt%60.%60archive%60+WHERE+%60archive%60.%60dateTime%60+%3D+1489592100&message_to_show=Der+Datensatz+wurde+gel%C3%B6scht.&goto=sql.php%3Fdb%3DweewxAlt%26table%3Darchive%26sql_query%3DSELECT%2B%2560dateTime%2560%252C%2B%2560extraTemp1%2560%252C%2B%2560extraTemp2%2560%2BFROM%2B%2560archive%2560%2B%26message_to_show%3DDer%2BDatensatz%2Bwurde%2Bgel%25C3%25B6scht.%26goto%3Dtbl_sql.php%26token%3Dcc24e0088d26a00baeed12fe834d5726&token=cc24e0088d26a00baeed12fe834d5726>
>
> 1489592100 7.48430814377277 13.5805358354716
> [image: Bearbeiten] Bearbeiten
> <http://amd350/phpmyadmin/tbl_change.php?db=weewxAlt&table=archive&where_clause=%60archive%60.%60dateTime%60+%3D+1489592400&clause_is_unique=1&sql_query=SELECT+%60dateTime%60%2C+%60extraTemp1%60%2C+%60extraTemp2%60+FROM+%60archive%60+&goto=sql.php&default_action=update&token=cc24e0088d26a00baeed12fe834d5726>
> [image:
> Kopieren] Kopieren
> <http://amd350/phpmyadmin/tbl_change.php?db=weewxAlt&table=archive&where_clause=%60archive%60.%60dateTime%60+%3D+1489592400&clause_is_unique=1&sql_query=SELECT+%60dateTime%60%2C+%60extraTemp1%60%2C+%60extraTemp2%60+FROM+%60archive%60+&goto=sql.php&default_action=insert&token=cc24e0088d26a00baeed12fe834d5726>
> [image:
> Löschen] Löschen
> <http://amd350/phpmyadmin/sql.php?db=weewxAlt&table=archive&sql_query=DELETE+FROM+%60weewxAlt%60.%60archive%60+WHERE+%60archive%60.%60dateTime%60+%3D+1489592400&message_to_show=Der+Datensatz+wurde+gel%C3%B6scht.&goto=sql.php%3Fdb%3DweewxAlt%26table%3Darchive%26sql_query%3DSELECT%2B%2560dateTime%2560%252C%2B%2560extraTemp1%2560%252C%2B%2560extraTemp2%2560%2BFROM%2B%2560archive%2560%2B%26message_to_show%3DDer%2BDatensatz%2Bwurde%2Bgel%25C3%25B6scht.%26goto%3Dtbl_sql.php%26token%3Dcc24e0088d26a00baeed12fe834d5726&token=cc24e0088d26a00baeed12fe834d5726>
>
> 1489592400 7.33722516278218 13.4661523855058
> [image: Bearbeiten] Bearbeiten
> <http://amd350/phpmyadmin/tbl_change.php?db=weewxAlt&table=archive&where_clause=%60archive%60.%60dateTime%60+%3D+1489592700&clause_is_unique=1&sql_query=SELECT+%60dateTime%60%2C+%60extraTemp1%60%2C+%60extraTemp2%60+FROM+%60archive%60+&goto=sql.php&default_action=update&token=cc24e0088d26a00baeed12fe834d5726>
> [image:
> Kopieren] Kopieren
> <http://amd350/phpmyadmin/tbl_change.php?db=weewxAlt&table=archive&where_clause=%60archive%60.%60dateTime%60+%3D+1489592700&clause_is_unique=1&sql_query=SELECT+%60dateTime%60%2C+%60extraTemp1%60%2C+%60extraTemp2%60+FROM+%60archive%60+&goto=sql.php&default_action=insert&token=cc24e0088d26a00baeed12fe834d5726>
> [image:
> Löschen] Löschen
> <http://amd350/phpmyadmin/sql.php?db=weewxAlt&table=archive&sql_query=DELETE+FROM+%60weewxAlt%60.%60archive%60+WHERE+%60archive%60.%60dateTime%60+%3D+1489592700&message_to_show=Der+Datensatz+wurde+gel%C3%B6scht.&goto=sql.php%3Fdb%3DweewxAlt%26table%3Darchive%26sql_query%3DSELECT%2B%2560dateTime%2560%252C%2B%2560extraTemp1%2560%252C%2B%2560extraTemp2%2560%2BFROM%2B%2560archive%2560%2B%26message_to_show%3DDer%2BDatensatz%2Bwurde%2Bgel%25C3%25B6scht.%26goto%3Dtbl_sql.php%26token%3Dcc24e0088d26a00baeed12fe834d5726&token=cc24e0088d26a00baeed12fe834d5726>
>
> 1489592700 7.19140951839869 13.3548786931324
> [image: Bearbeiten] Bearbeiten
> <http://amd350/phpmyadmin/tbl_change.php?db=weewxAlt&table=archive&where_clause=%60archive%60.%60dateTime%60+%3D+1489593000&clause_is_unique=1&sql_query=SELECT+%60dateTime%60%2C+%60extraTemp1%60%2C+%60extraTemp2%60+FROM+%60archive%60+&goto=sql.php&default_action=update&token=cc24e0088d26a00baeed12fe834d5726>
> [image:
> Kopieren] Kopieren
> <http://amd350/phpmyadmin/tbl_change.php?db=weewxAlt&table=archive&where_clause=%60archive%60.%60dateTime%60+%3D+1489593000&clause_is_unique=1&sql_query=SELECT+%60dateTime%60%2C+%60extraTemp1%60%2C+%60extraTemp2%60+FROM+%60archive%60+&goto=sql.php&default_action=insert&token=cc24e0088d26a00baeed12fe834d5726>
> [image:
> Löschen] Löschen
> <http://amd350/phpmyadmin/sql.php?db=weewxAlt&table=archive&sql_query=DELETE+FROM+%60weewxAlt%60.%60archive%60+WHERE+%60archive%60.%60dateTime%60+%3D+1489593000&message_to_show=Der+Datensatz+wurde+gel%C3%B6scht.&goto=sql.php%3Fdb%3DweewxAlt%26table%3Darchive%26sql_query%3DSELECT%2B%2560dateTime%2560%252C%2B%2560extraTemp1%2560%252C%2B%2560extraTemp2%2560%2BFROM%2B%2560archive%2560%2B%26message_to_show%3DDer%2BDatensatz%2Bwurde%2Bgel%25C3%25B6scht.%26goto%3Dtbl_sql.php%26token%3Dcc24e0088d26a00baeed12fe834d5726&token=cc24e0088d26a00baeed12fe834d5726>
>
> 1489593000 7.0469306109717 13.2467677186025
> [image: Bearbeiten] Bearbeiten
> <http://amd350/phpmyadmin/tbl_change.php?db=weewxAlt&table=archive&where_clause=%60archive%60.%60dateTime%60+%3D+1489593300&clause_is_unique=1&sql_query=SELECT+%60dateTime%60%2C+%60extraTemp1%60%2C+%60extraTemp2%60+FROM+%60archive%60+&goto=sql.php&default_action=update&token=cc24e0088d26a00baeed12fe834d5726>
> [image:
> Kopieren] Kopieren
> <http://amd350/phpmyadmin/tbl_change.php?db=weewxAlt&table=archive&where_clause=%60archive%60.%60dateTime%60+%3D+1489593300&clause_is_unique=1&sql_query=SELECT+%60dateTime%60%2C+%60extraTemp1%60%2C+%60extraTemp2%60+FROM+%60archive%60+&goto=sql.php&default_action=insert&token=cc24e0088d26a00baeed12fe834d5726>
> [image:
> Löschen] Löschen
> <http://amd350/phpmyadmin/sql.php?db=weewxAlt&table=archive&sql_query=DELETE+FROM+%60weewxAlt%60.%60archive%60+WHERE+%60archive%60.%60dateTime%60+%3D+1489593300&message_to_show=Der+Datensatz+wurde+gel%C3%B6scht.&goto=sql.php%3Fdb%3DweewxAlt%26table%3Darchive%26sql_query%3DSELECT%2B%2560dateTime%2560%252C%2B%2560extraTemp1%2560%252C%2B%2560extraTemp2%2560%2BFROM%2B%2560archive%2560%2B%26message_to_show%3DDer%2BDatensatz%2Bwurde%2Bgel%25C3%25B6scht.%26goto%3Dtbl_sql.php%26token%3Dcc24e0088d26a00baeed12fe834d5726&token=cc24e0088d26a00baeed12fe834d5726>
>
> 1489593300 6.90385720463619 13.1418709168848
> [image: Bearbeiten] Bearbeiten
> <http://amd350/phpmyadmin/tbl_change.php?db=weewxAlt&table=archive&where_clause=%60archive%60.%60dateTime%60+%3D+1489593600&clause_is_unique=1&sql_query=SELECT+%60dateTime%60%2C+%60extraTemp1%60%2C+%60extraTemp2%60+FROM+%60archive%60+&goto=sql.php&default_action=update&token=cc24e0088d26a00baeed12fe834d5726>
> [image:
> Kopieren] Kopieren
> <http://amd350/phpmyadmin/tbl_change.php?db=weewxAlt&table=archive&where_clause=%60archive%60.%60dateTime%60+%3D+1489593600&clause_is_unique=1&sql_query=SELECT+%60dateTime%60%2C+%60extraTemp1%60%2C+%60extraTemp2%60+FROM+%60archive%60+&goto=sql.php&default_action=insert&token=cc24e0088d26a00baeed12fe834d5726>
> [image:
> Löschen] Löschen
> <http://amd350/phpmyadmin/sql.php?db=weewxAlt&table=archive&sql_query=DELETE+FROM+%60weewxAlt%60.%60archive%60+WHERE+%60archive%60.%60dateTime%60+%3D+1489593600&message_to_show=Der+Datensatz+wurde+gel%C3%B6scht.&goto=sql.php%3Fdb%3DweewxAlt%26table%3Darchive%26sql_query%3DSELECT%2B%2560dateTime%2560%252C%2B%2560extraTemp1%2560%252C%2B%2560extraTemp2%2560%2BFROM%2B%2560archive%2560%2B%26message_to_show%3DDer%2BDatensatz%2Bwurde%2Bgel%25C3%25B6scht.%26goto%3Dtbl_sql.php%26token%3Dcc24e0088d26a00baeed12fe834d5726&token=cc24e0088d26a00baeed12fe834d5726>
>
> 1489593600 6.76225739458474 13.0402382131756
> [image: Bearbeiten] Bearbeiten
> <http://amd350/phpmyadmin/tbl_change.php?db=weewxAlt&table=archive&where_clause=%60archive%60.%60dateTime%60+%3D+1489593900&clause_is_unique=1&sql_query=SELECT+%60dateTime%60%2C+%60extraTemp1%60%2C+%60extraTemp2%60+FROM+%60archive%60+&goto=sql.php&default_action=update&token=cc24e0088d26a00baeed12fe834d5726>
> [image:
> Kopieren] Kopieren
> <http://amd350/phpmyadmin/tbl_change.php?db=weewxAlt&table=archive&where_clause=%60archive%60.%60dateTime%60+%3D+1489593900&clause_is_unique=1&sql_query=SELECT+%60dateTime%60%2C+%60extraTemp1%60%2C+%60extraTemp2%60+FROM+%60archive%60+&goto=sql.php&default_action=insert&token=cc24e0088d26a00baeed12fe834d5726>
> [image:
> Löschen] Löschen
> <http://amd350/phpmyadmin/sql.php?db=weewxAlt&table=archive&sql_query=DELETE+FROM+%60weewxAlt%60.%60archive%60+WHERE+%60archive%60.%60dateTime%60+%3D+1489593900&message_to_show=Der+Datensatz+wurde+gel%C3%B6scht.&goto=sql.php%3Fdb%3DweewxAlt%26table%3Darchive%26sql_query%3DSELECT%2B%2560dateTime%2560%252C%2B%2560extraTemp1%2560%252C%2B%2560extraTemp2%2560%2BFROM%2B%2560archive%2560%2B%26message_to_show%3DDer%2BDatensatz%2Bwurde%2Bgel%25C3%25B6scht.%26goto%3Dtbl_sql.php%26token%3Dcc24e0088d26a00baeed12fe834d5726&token=cc24e0088d26a00baeed12fe834d5726>
>
> 1489593900 6.62219857465792 12.9419179791375
> [image: Bearbeiten] Bearbeiten
> <http://amd350/phpmyadmin/tbl_change.php?db=weewxAlt&table=archive&where_clause=%60archive%60.%60dateTime%60+%3D+1489594200&clause_is_unique=1&sql_query=SELECT+%60dateTime%60%2C+%60extraTemp1%60%2C+%60extraTemp2%60+FROM+%60archive%60+&goto=sql.php&default_action=update&token=cc24e0088d26a00baeed12fe834d5726>
> [image:
> Kopieren] Kopieren
> <http://amd350/phpmyadmin/tbl_change.php?db=weewxAlt&table=archive&where_clause=%60archive%60.%60dateTime%60+%3D+1489594200&clause_is_unique=1&sql_query=SELECT+%60dateTime%60%2C+%60extraTemp1%60%2C+%60extraTemp2%60+FROM+%60archive%60+&goto=sql.php&default_action=insert&token=cc24e0088d26a00baeed12fe834d5726>
> [image:
> Löschen] Löschen
> <http://amd350/phpmyadmin/sql.php?db=weewxAlt&table=archive&sql_query=DELETE+FROM+%60weewxAlt%60.%60archive%60+WHERE+%60archive%60.%60dateTime%60+%3D+1489594200&message_to_show=Der+Datensatz+wurde+gel%C3%B6scht.&goto=sql.php%3Fdb%3DweewxAlt%26table%3Darchive%26sql_query%3DSELECT%2B%2560dateTime%2560%252C%2B%2560extraTemp1%2560%252C%2B%2560extraTemp2%2560%2BFROM%2B%2560archive%2560%2B%26message_to_show%3DDer%2BDatensatz%2Bwurde%2Bgel%25C3%25B6scht.%26goto%3Dtbl_sql.php%26token%3Dcc24e0088d26a00baeed12fe834d5726&token=cc24e0088d26a00baeed12fe834d5726>
>
> 1489594200 6.48374740526844 12.8469570098769
> [image: Bearbeiten] Bearbeiten
> <http://amd350/phpmyadmin/tbl_change.php?db=weewxAlt&table=archive&where_clause=%60archive%60.%60dateTime%60+%3D+1489594500&clause_is_unique=1&sql_query=SELECT+%60dateTime%60%2C+%60extraTemp1%60%2C+%60extraTemp2%60+FROM+%60archive%60+&goto=sql.php&default_action=update&token=cc24e0088d26a00baeed12fe834d5726>
> [image:
> Kopieren] Kopieren
> <http://amd350/phpmyadmin/tbl_change.php?db=weewxAlt&table=archive&where_clause=%60archive%60.%60dateTime%60+%3D+1489594500&clause_is_unique=1&sql_query=SELECT+%60dateTime%60%2C+%60extraTemp1%60%2C+%60extraTemp2%60+FROM+%60archive%60+&goto=sql.php&default_action=insert&token=cc24e0088d26a00baeed12fe834d5726>
> [image:
> Löschen] Löschen
> <http://amd350/phpmyadmin/sql.php?db=weewxAlt&table=archive&sql_query=DELETE+FROM+%60weewxAlt%60.%60archive%60+WHERE+%60archive%60.%60dateTime%60+%3D+1489594500&message_to_show=Der+Datensatz+wurde+gel%C3%B6scht.&goto=sql.php%3Fdb%3DweewxAlt%26table%3Darchive%26sql_query%3DSELECT%2B%2560dateTime%2560%252C%2B%2560extraTemp1%2560%252C%2B%2560extraTemp2%2560%2BFROM%2B%2560archive%2560%2B%26message_to_show%3DDer%2BDatensatz%2Bwurde%2Bgel%25C3%25B6scht.%26goto%3Dtbl_sql.php%26token%3Dcc24e0088d26a00baeed12fe834d5726&token=cc24e0088d26a00baeed12fe834d5726>
>
> 1489594500 6.34696978167446 12.755400501672
> [image: Bearbeiten] Bearbeiten
> <http://amd350/phpmyadmin/tbl_change.php?db=weewxAlt&table=archive&where_clause=%60archive%60.%60dateTime%60+%3D+1489594800&clause_is_unique=1&sql_query=SELECT+%60dateTime%60%2C+%60extraTemp1%60%2C+%60extraTemp2%60+FROM+%60archive%60+&goto=sql.php&default_action=update&token=cc24e0088d26a00baeed12fe834d5726>
> [image:
> Kopieren] Kopieren
> <http://amd350/phpmyadmin/tbl_change.php?db=weewxAlt&table=archive&where_clause=%60archive%60.%60dateTime%60+%3D+1489594800&clause_is_unique=1&sql_query=SELECT+%60dateTime%60%2C+%60extraTemp1%60%2C+%60extraTemp2%60+FROM+%60archive%60+&goto=sql.php&default_action=insert&token=cc24e0088d26a00baeed12fe834d5726>
> [image:
> Löschen] Löschen
> <http://amd350/phpmyadmin/sql.php?db=weewxAlt&table=archive&sql_query=DELETE+FROM+%60weewxAlt%60.%60archive%60+WHERE+%60archive%60.%60dateTime%60+%3D+1489594800&message_to_show=Der+Datensatz+wurde+gel%C3%B6scht.&goto=sql.php%3Fdb%3DweewxAlt%26table%3Darchive%26sql_query%3DSELECT%2B%2560dateTime%2560%252C%2B%2560extraTemp1%2560%252C%2B%2560extraTemp2%2560%2BFROM%2B%2560archive%2560%2B%26message_to_show%3DDer%2BDatensatz%2Bwurde%2Bgel%25C3%25B6scht.%26goto%3Dtbl_sql.php%26token%3Dcc24e0088d26a00baeed12fe834d5726&token=cc24e0088d26a00baeed12fe834d5726>
>
> 1489594800 6.21193080261695 12.6672920304622
> [image: Bearbeiten] Bearbeiten
> <http://amd350/phpmyadmin/tbl_change.php?db=weewxAlt&table=archive&where_clause=%60archive%60.%60dateTime%60+%3D+1489595100&clause_is_unique=1&sql_query=SELECT+%60dateTime%60%2C+%60extraTemp1%60%2C+%60extraTemp2%60+FROM+%60archive%60+&goto=sql.php&default_action=update&token=cc24e0088d26a00baeed12fe834d5726>
> [image:
> Kopieren] Kopieren
> <http://amd350/phpmyadmin/tbl_change.php?db=weewxAlt&table=archive&where_clause=%60archive%60.%60dateTime%60+%3D+1489595100&clause_is_unique=1&sql_query=SELECT+%60dateTime%60%2C+%60extraTemp1%60%2C+%60extraTemp2%60+FROM+%60archive%60+&goto=sql.php&default_action=insert&token=cc24e0088d26a00baeed12fe834d5726>
> [image:
> Löschen] Löschen
> <http://amd350/phpmyadmin/sql.php?db=weewxAlt&table=archive&sql_query=DELETE+FROM+%60weewxAlt%60.%60archive%60+WHERE+%60archive%60.%60dateTime%60+%3D+1489595100&message_to_show=Der+Datensatz+wurde+gel%C3%B6scht.&goto=sql.php%3Fdb%3DweewxAlt%26table%3Darchive%26sql_query%3DSELECT%2B%2560dateTime%2560%252C%2B%2560extraTemp1%2560%252C%2B%2560extraTemp2%2560%2BFROM%2B%2560archive%2560%2B%26message_to_show%3DDer%2BDatensatz%2Bwurde%2Bgel%25C3%25B6scht.%26goto%3Dtbl_sql.php%26token%3Dcc24e0088d26a00baeed12fe834d5726&token=cc24e0088d26a00baeed12fe834d5726>
>
> 1489595100 6.07869473933625 12.5826735311078
> [image: Bearbeiten] Bearbeiten
> <http://amd350/phpmyadmin/tbl_change.php?db=weewxAlt&table=archive&where_clause=%60archive%60.%60dateTime%60+%3D+1489595400&clause_is_unique=1&sql_query=SELECT+%60dateTime%60%2C+%60extraTemp1%60%2C+%60extraTemp2%60+FROM+%60archive%60+&goto=sql.php&default_action=update&token=cc24e0088d26a00baeed12fe834d5726>
> [image:
> Kopieren] Kopieren
> <http://amd350/phpmyadmin/tbl_change.php?db=weewxAlt&table=archive&where_clause=%60archive%60.%60dateTime%60+%3D+1489595400&clause_is_unique=1&sql_query=SELECT+%60dateTime%60%2C+%60extraTemp1%60%2C+%60extraTemp2%60+FROM+%60archive%60+&goto=sql.php&default_action=insert&token=cc24e0088d26a00baeed12fe834d5726>
> [image:
> Löschen] Löschen
> <http://amd350/phpmyadmin/sql.php?db=weewxAlt&table=archive&sql_query=DELETE+FROM+%60weewxAlt%60.%60archive%60+WHERE+%60archive%60.%60dateTime%60+%3D+1489595400&message_to_show=Der+Datensatz+wurde+gel%C3%B6scht.&goto=sql.php%3Fdb%3DweewxAlt%26table%3Darchive%26sql_query%3DSELECT%2B%2560dateTime%2560%252C%2B%2560extraTemp1%2560%252C%2B%2560extraTemp2%2560%2BFROM%2B%2560archive%2560%2B%26message_to_show%3DDer%2BDatensatz%2Bwurde%2Bgel%25C3%25B6scht.%26goto%3Dtbl_sql.php%26token%3Dcc24e0088d26a00baeed12fe834d5726&token=cc24e0088d26a00baeed12fe834d5726>
> <td
> data-decimals="0" data-type="int" class="right data grid_edit click2 no
>
