<html><head><meta http-equiv="content-type" content="text/html; charset=utf-8"></head><body dir="auto">Ich erinnere nochmal daran, dass die Middleware auch ein Löschapi hat 👍🏻<br><br><div dir="ltr">Viele Grüße,<div>Andreas</div></div><div dir="ltr"><br><blockquote type="cite">Am 03.10.2020 um 19:28 schrieb Frank Richter <frank.richter83@gmail.com>:<br><br></blockquote></div><blockquote type="cite"><div dir="ltr"><div dir="auto">Ich vermute eher dass die Uhrzeit vom Logger mal kurzzeitig arg falsch war, es betrifft ja diverse Kanäle, aber nur einen kurzen Zeitraum.</div><br><div class="gmail_quote"><div dir="ltr" class="gmail_attr">Maik Weidemann <m+vz@weidemann.online> schrieb am Sa., 3. Okt. 2020, 19:21:<br></div><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">
  
    
  
  <div>
    Hallo Michael,<br>
    <br>
    der Timestamp ist ein Unixtimestamp * 1000.<br>
    Ein Unix-Timestamp sind die Sekunden seit dem 01.01.1970 00:00:00.<br>
    <br>
    Daraus ergibt sich für deinen Timestamp 948239830000 der Zeitpunkt
    2000-01-18T23:57:10+00:00 (UTC).<br>
    <br>
    Liefiert evtl. der Zähler einen falschen Zeitstempel?<br>
    <br>
    Gruß<br>
    Maik<br>
    <br>
    <br>
    <div>Am 03.10.20 um 18:48 schrieb Michael
      Hartmann:<br>
    </div>
    <blockquote type="cite">
      
      
      
      <div>
        <p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1f497d">Ich
            habe nun die Daten mit dem Zeitstempel < 1588291200000
            (übrigens : Wie berechnet der sich?) abgefragt.<u></u><u></u></span></p>
        <p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1f497d"><u></u> <u></u></span></p>
        <p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1f497d" lang="EN-US">Hier das Ergebis:<u></u><u></u></span></p>
        <p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1f497d" lang="EN-US"><u></u> <u></u></span></p>
        <p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1f497d" lang="EN-US">MariaDB [volkszaehler]> select * from data
            where timestamp < 1588291200000;<u></u><u></u></span></p>
        <p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1f497d" lang="EN-US">+---------+------------+--------------+-----------------+<u></u><u></u></span></p>
        <p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1f497d" lang="EN-US">| id      | channel_id | timestamp    |
            value           |<u></u><u></u></span></p>
        <p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1f497d">+---------+------------+--------------+-----------------+<u></u><u></u></span></p>
        <p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1f497d">|
            3521890 |          3 | 948239830000 |            1910 |<u></u><u></u></span></p>
        <p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1f497d">|
            3521891 |          2 | 948239830000 |       1185382.4 |<u></u><u></u></span></p>
        <p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1f497d">|
            3521892 |          6 | 948239830000 |             226 |<u></u><u></u></span></p>
        <p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1f497d">|
            3521893 |          7 | 948239830000 |             226 |<u></u><u></u></span></p>
        <p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1f497d">|
            3521894 |          8 | 948239830000 |           227.9 |<u></u><u></u></span></p>
        <p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1f497d">|
            3521895 |          9 | 948239830000 |              50 |<u></u><u></u></span></p>
        <p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1f497d">|
            3521896 |          2 | 948239835000 |         1185385 |<u></u><u></u></span></p>
        <p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1f497d">|
            3521897 |          3 | 948239835000 |  1915.338745687 |<u></u><u></u></span></p>
        <p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1f497d">|
            3521898 |          6 | 948239835000 |           225.9 |<u></u><u></u></span></p>
        <p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1f497d">|
            3521899 |          7 | 948239835000 | 226.06681550639 |<u></u><u></u></span></p>
        <p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1f497d">|
            3521900 |          8 | 948239835000 | 227.86647046885 |<u></u><u></u></span></p>
        <p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1f497d">|
            3521901 |          9 | 948239835000 |              50 |<u></u><u></u></span></p>
        <p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1f497d">|
            3521902 |          6 | 948239840000 |  225.9016823553 |<u></u><u></u></span></p>
        <p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1f497d">|
            3521903 |          2 | 948239840000 |       1185387.7 |<u></u><u></u></span></p>
        <p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1f497d">|
            3521904 |          3 | 948239840000 | 1919.1273783297 |<u></u><u></u></span></p>
        <p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1f497d">|
            3521905 |          7 | 948239840000 | 225.96569196876 |<u></u><u></u></span></p>
        <p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1f497d">|
            3521906 |          8 | 948239840000 | 227.83262567595 |<u></u><u></u></span></p>
        <p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1f497d">|
            3521907 |          9 | 948239840000 | 49.965691968756 |<u></u><u></u></span></p>
        <p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1f497d">|
            3521908 |          1 | 948239844958 |               0 |<u></u><u></u></span></p>
        <p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1f497d">+---------+------------+--------------+-----------------+<u></u><u></u></span></p>
        <p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1f497d">19
            rows in set (41.838 sec)<u></u><u></u></span></p>
        <p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1f497d"><u></u> <u></u></span></p>
        <p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1f497d">Fällt
            euch da irgendetwas auf? Wie ordne ich die hier gelistete
            channel id der UUID zu?<u></u><u></u></span></p>
        <p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1f497d"><u></u> <u></u></span></p>
        <p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1f497d">Grüße<u></u><u></u></span></p>
        <p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1f497d"><u></u> <u></u></span></p>
        <p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1f497d">Micha<u></u><u></u></span></p>
        <p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1f497d"><u></u> <u></u></span></p>
        <p class="MsoNormal"><b><span style="font-size:10.0pt;font-family:"Tahoma","sans-serif"">Von:</span></b><span style="font-size:10.0pt;font-family:"Tahoma","sans-serif"">
            volkszaehler-users
            [<a href="mailto:volkszaehler-users-bounces@demo.volkszaehler.org" target="_blank" rel="noreferrer">mailto:volkszaehler-users-bounces@demo.volkszaehler.org</a>] <b>Im
              Auftrag von </b>Frank Richter<br>
            <b>Gesendet:</b> Samstag, 3. Oktober 2020 17:49<br>
            <b>An:</b> <a href="http://volkszaehler.org" target="_blank" rel="noreferrer">volkszaehler.org</a> - users<br>
            <b>Betreff:</b> Re: [vz-users] Fehlerhafte Daten in der DB
            löschen/korrigieren<u></u><u></u></span></p>
        <p class="MsoNormal"><u></u> <u></u></p>
        <div>
          <p class="MsoNormal">Nach jeder Zeile SQL, so wie von mir
            geschrieben. "use volkszaehler" klappt anscheinend auch
            ohne.<u></u><u></u></p>
          <div>
            <p class="MsoNormal"><u></u> <u></u></p>
          </div>
          <div>
            <p class="MsoNormal">Steht übrigens auch im Hinweistext von
              MariaDB in deinem Screenshot ;-)<u></u><u></u></p>
          </div>
          <div>
            <p class="MsoNormal"><u></u> <u></u></p>
          </div>
          <div>
            <p class="MsoNormal">Grüße<u></u><u></u></p>
          </div>
          <div>
            <p class="MsoNormal">Frank<u></u><u></u></p>
          </div>
        </div>
        <p class="MsoNormal"><u></u> <u></u></p>
        <div>
          <div>
            <p class="MsoNormal">Michael Hartmann <<a href="mailto:hartmann-micha@web.de" target="_blank" rel="noreferrer">hartmann-micha@web.de</a>>
              schrieb am Sa., 3. Okt. 2020, 17:43:<u></u><u></u></p>
          </div>
          <blockquote style="border:none;border-left:solid #cccccc 1.0pt;padding:0cm 0cm 0cm 6.0pt;margin-left:4.8pt;margin-right:0cm">
            <div>
              <p class="MsoNormal" style="margin-bottom:12.0pt">Frank,
                das Semikolon nach der gesamten Syntax?<u></u><u></u></p>
              <div>
                <p class="MsoNormal">Am 3. Oktober 2020 16:40:54 MESZ
                  schrieb Frank Richter <<a href="mailto:frank.richter83@gmail.com" target="_blank" rel="noreferrer">frank.richter83@gmail.com</a>>:<u></u><u></u></p>
                <div>
                  <p class="MsoNormal"> Hallo Micha,<u></u><u></u></p>
                  <div>
                    <p class="MsoNormal"><u></u> <u></u></p>
                  </div>
                  <div>
                    <p class="MsoNormal">SQL-Queries immer mit einem
                      Semikolon ";" abschließen. Und nicht "select"
                      sondern "select *".<u></u><u></u></p>
                  </div>
                  <div>
                    <p class="MsoNormal"><u></u> <u></u></p>
                  </div>
                  <div>
                    <p class="MsoNormal">Grüße<u></u><u></u></p>
                  </div>
                  <div>
                    <p class="MsoNormal">Frank<u></u><u></u></p>
                  </div>
                </div>
                <p class="MsoNormal"><u></u> <u></u></p>
                <div>
                  <div>
                    <p class="MsoNormal">Michael Hartmann <<a href="mailto:hartmann-micha@web.de" target="_blank" rel="noreferrer">hartmann-micha@web.de</a>>
                      schrieb am Sa., 3. Okt. 2020, 16:33:<u></u><u></u></p>
                  </div>
                  <blockquote style="border:none;border-left:solid #cccccc 1.0pt;padding:0cm 0cm 0cm 6.0pt;margin-left:4.8pt;margin-right:0cm">
                    <div>
                      <div>
                        <p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1f497d">Hallo
                            Frank,</span><u></u><u></u></p>
                        <p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1f497d"> </span><u></u><u></u></p>
                        <p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1f497d">ich
                            habe das gemäß deiner Anleitung
                            abgearbeitet, ende aber an einer
                            „Eingabeaufforderung“ (->). Unabhängig ob
                            ich den Befehl select oder delete
                            voranstelle. Die Daten sind unverändert.</span><u></u><u></u></p>
                        <p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1f497d"> </span><u></u><u></u></p>
                        <p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1f497d">Grüße</span><u></u><u></u></p>
                        <p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1f497d"> </span><u></u><u></u></p>
                        <p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1f497d">Micha</span><u></u><u></u></p>
                        <p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1f497d"> </span><u></u><u></u></p>
                        <p class="MsoNormal"><b><span style="font-size:10.0pt;font-family:"Tahoma","sans-serif"">Von:</span></b><span style="font-size:10.0pt;font-family:"Tahoma","sans-serif"">
                            volkszaehler-users [mailto:<a href="mailto:volkszaehler-users-bounces@demo.volkszaehler.org" target="_blank" rel="noreferrer">volkszaehler-users-bounces@demo.volkszaehler.org</a>]
                            <b>Im Auftrag von </b>Frank Richter<br>
                            <b>Gesendet:</b> Donnerstag, 1. Oktober 2020
                            19:01<br>
                            <b>An:</b> <a href="http://volkszaehler.org" target="_blank" rel="noreferrer">volkszaehler.org</a>
                            - users<br>
                            <b>Betreff:</b> Re: [vz-users] Fehlerhafte
                            Daten in der DB löschen/korrigieren</span><u></u><u></u></p>
                        <p class="MsoNormal"> <u></u><u></u></p>
                        <div>
                          <p class="MsoNormal">Hallo
                            Micha,<u></u><u></u></p>
                          <div>
                            <p class="MsoNormal"> <u></u><u></u></p>
                          </div>
                          <div>
                            <p class="MsoNormal">finden
                              musst du ihn gar nicht zwingend, nur
                              löschen. Wenn du dir sicher bist, dass du
                              vor Mai nix sinnvolles in der DB hast,
                              kannst du folgendes machen:<u></u><u></u></p>
                          </div>
                          <div>
                            <p class="MsoNormal"> <u></u><u></u></p>
                          </div>
                          <div>
                            <p class="MsoNormal">sudo
                              mysql<u></u><u></u></p>
                          </div>
                          <div>
                            <p class="MsoNormal">use
                              volkszaehler;<u></u><u></u></p>
                          </div>
                          <div>
                            <p class="MsoNormal">delete
                              from data where timestamp <
                              1588291200000;<u></u><u></u></p>
                          </div>
                          <div>
                            <p class="MsoNormal">exit<u></u><u></u></p>
                          </div>
                          <div>
                            <p class="MsoNormal"> <u></u><u></u></p>
                          </div>
                          <div>
                            <p class="MsoNormal">Der
                              Timestamp ist der 01. Mai 20 00:00 UTC.<u></u><u></u></p>
                          </div>
                          <div>
                            <p class="MsoNormal"> <u></u><u></u></p>
                          </div>
                          <div>
                            <p class="MsoNormal">Wenn
                              du vorher sehen willst, welche Datensätze
                              betroffen sind, ersetze delete durch
                              select *<u></u><u></u></p>
                          </div>
                          <div>
                            <p class="MsoNormal"> <u></u><u></u></p>
                          </div>
                          <div>
                            <p class="MsoNormal">Viele
                              Grüße<u></u><u></u></p>
                          </div>
                          <div>
                            <p class="MsoNormal">Frank<u></u><u></u></p>
                          </div>
                        </div>
                        <p class="MsoNormal"> <u></u><u></u></p>
                        <div>
                          <div>
                            <p class="MsoNormal">Michael
                              Hartmann <<a href="mailto:hartmann-micha@web.de" target="_blank" rel="noreferrer">hartmann-micha@web.de</a>>
                              schrieb am Do., 1. Okt. 2020, 18:54:<u></u><u></u></p>
                          </div>
                          <blockquote style="border:none;border-left:solid #cccccc 1.0pt;padding:0cm 0cm 0cm 6.0pt;margin-left:4.8pt;margin-top:5.0pt;margin-right:0cm;margin-bottom:5.0pt">
                            <div>
                              <p class="MsoNormal" style="margin-bottom:12.0pt">Hallo
                                Frank,<br>
                                <br>
                                wie finde ich den? Ich bitte die
                                Anfängerfragen zu entschuldigen.<br>
                                <br>
                                Grüße<br>
                                <br>
                                Micha<u></u><u></u></p>
                              <div>
                                <p class="MsoNormal">Am
                                  1. Oktober 2020 17:56:34 MESZ schrieb
                                  Frank Richter <<a href="mailto:frank.richter83@gmail.com" target="_blank" rel="noreferrer">frank.richter83@gmail.com</a>>:<u></u><u></u></p>
                                <div>
                                  <div>
                                    <p class="MsoNormal">Hallo
                                      Micha,<u></u><u></u></p>
                                    <div>
                                      <p class="MsoNormal"> <u></u><u></u></p>
                                    </div>
                                    <div>
                                      <p class="MsoNormal">wahrscheinlich
                                        hast du einen Wert mit Timestamp
                                        0 oder nahe 0 in der DB, also
                                        ca. 1970. Der muss raus.<u></u><u></u></p>
                                    </div>
                                    <div>
                                      <p class="MsoNormal"> <u></u><u></u></p>
                                    </div>
                                    <div>
                                      <p class="MsoNormal">Grüße<u></u><u></u></p>
                                    </div>
                                    <div>
                                      <p class="MsoNormal">Frank<u></u><u></u></p>
                                    </div>
                                    <p class="MsoNormal" style="margin-bottom:12.0pt"> <u></u><u></u></p>
                                    <div>
                                      <div>
                                        <p class="MsoNormal">Michael
                                          Hartmann <<a href="mailto:hartmann-micha@web.de" target="_blank" rel="noreferrer">hartmann-micha@web.de</a>>
                                          schrieb am Do., 1. Okt. 2020,
                                          14:36:<u></u><u></u></p>
                                      </div>
                                      <blockquote style="border:none;border-left:solid #cccccc 1.0pt;padding:0cm 0cm 0cm 6.0pt;margin-left:4.8pt;margin-top:5.0pt;margin-right:0cm;margin-bottom:5.0pt">
                                        <div>
                                          <p class="MsoNormal" style="margin-bottom:12.0pt">Ich
                                            habe nur die Situation, dass
                                            für alle Zeiträume vor der
                                            Inbetriebnahme -2,1W im
                                            Frontend angezeigt werden.
                                            Egal, wie weit ich
                                            zurückgehe.<u></u><u></u></p>
                                          <div>
                                            <p class="MsoNormal">Am
                                              1. Oktober 2020 10:43:21
                                              MESZ schrieb "Thomas
                                              Höpfner" <<a href="mailto:thomas@thhoe.de" target="_blank" rel="noreferrer">thomas@thhoe.de</a>>:<u></u><u></u></p>
                                            <p style="margin:0cm;margin-bottom:.0001pt"><span style="font-family:"Tahoma","sans-serif"">Hallo,</span><u></u><u></u></p>
                                            <p style="margin:0cm;margin-bottom:.0001pt"><span style="font-family:"Tahoma","sans-serif""> </span><u></u><u></u></p>
                                            <p style="margin:0cm;margin-bottom:.0001pt"><span style="font-family:"Tahoma","sans-serif"">man kann
                                                die Daten auch über das
                                                Frondent löschen. </span><u></u><u></u></p>
                                            <p style="margin:0cm;margin-bottom:.0001pt"><span style="font-family:"Tahoma","sans-serif"">-
                                                Zeitbereich eingrenzen
                                                auf die zu löschten
                                                Daten </span><u></u><u></u></p>
                                            <p style="margin:0cm;margin-bottom:.0001pt"><span style="font-family:"Tahoma","sans-serif"">- in der
                                                Auswertung auf deas
                                                blaue "I" klicken</span><u></u><u></u></p>
                                            <p style="margin:0cm;margin-bottom:.0001pt"><span style="font-family:"Tahoma","sans-serif"">- in den
                                                sich öffnenten Fenster
                                                auf "Daten" klicken</span><u></u><u></u></p>
                                            <p style="margin:0cm;margin-bottom:.0001pt"><span style="font-family:"Tahoma","sans-serif""> </span><u></u><u></u></p>
                                            <p style="margin:0cm;margin-bottom:.0001pt"><span style="font-family:"Tahoma","sans-serif"">jetz
                                                öffnet sich eine Seite
                                                mit den in der Graphik
                                                angezeigten Daten .json
                                                formatiert </span><u></u><u></u></p>
                                            <p style="margin:0cm;margin-bottom:.0001pt"><span style="font-family:"Tahoma","sans-serif"">- an die
                                                URL dieser Seite hängst
                                                du folgendes
                                                an: &operation=delete</span><u></u><u></u></p>
                                            <p style="margin:0cm;margin-bottom:.0001pt"><span style="font-family:"Tahoma","sans-serif""> </span><u></u><u></u></p>
                                            <p style="margin:0cm;margin-bottom:.0001pt"><span style="font-family:"Tahoma","sans-serif"">Bei den
                                                Syntax bin ich mir nicht
                                                sicher, habe es schon
                                                länger nicht mehr
                                                gemacht.</span><u></u><u></u></p>
                                            <p style="margin:0cm;margin-bottom:.0001pt"><span style="font-family:"Tahoma","sans-serif"">Deshalb
                                                das Ganze ohne Gewähr.</span><u></u><u></u></p>
                                            <pre style="white-space:pre-wrap"><span style="font-size:12.0pt;font-family:"Tahoma","sans-serif"">Mit freundlichen Grüßen,</span><span style="font-size:11.0pt;font-family:"Tahoma","sans-serif"">

</span><span style="font-size:12.0pt;font-family:"Tahoma","sans-serif"">Thomas</span><span style="font-size:11.0pt;font-family:"Tahoma","sans-serif""> </span><u></u><u></u></pre>
                                            <p style="margin:0cm;margin-bottom:.0001pt;min-height:12pt"><span style="font-family:"Tahoma","sans-serif""> </span><u></u><u></u></p>
                                            <blockquote style="border:none;border-left:solid #325fba 1.5pt;padding:0cm 0cm 0cm 4.0pt;margin-left:3.75pt;margin-top:5.0pt;margin-right:3.75pt;margin-bottom:5.0pt">
                                              <p class="MsoNormal" style="margin-bottom:12.0pt"><span style="font-size:10.0pt;font-family:"Tahoma","sans-serif"">-----Ursprüngliche
                                                  Nachricht-----<br>
                                                  <strong><span style="font-family:"Tahoma","sans-serif"">Von:</span></strong>
                                                  Ralf Wismann <<a href="mailto:ralf.wismann@gmx.de" target="_blank" rel="noreferrer">ralf.wismann@gmx.de</a>><br>
                                                  <strong><span style="font-family:"Tahoma","sans-serif"">Gesendet:</span></strong>
                                                  Donnerstag 1 Oktober
                                                  2020 10:09<br>
                                                  <strong><span style="font-family:"Tahoma","sans-serif"">An:</span></strong>
                                                  '<a href="http://volkszaehler.org" target="_blank" rel="noreferrer">volkszaehler.org</a>
                                                  - users' <<a href="mailto:volkszaehler-users@demo.volkszaehler.org" target="_blank" rel="noreferrer">volkszaehler-users@demo.volkszaehler.org</a>><br>
                                                  <strong><span style="font-family:"Tahoma","sans-serif"">Betreff:</span></strong>
                                                  Re: [vz-users]
                                                  Fehlerhafte Daten in
                                                  der DB
                                                  löschen/korrigieren</span><u></u><u></u></p>
                                              <div>
                                                <div>
                                                  <p class="MsoNormal"><strong> </strong><u></u><u></u></p>
                                                  <p class="MsoNormal">Hallo<u></u><u></u></p>
                                                  <p class="MsoNormal">>Wie
                                                    kann ich die Daten
                                                    des Kanals vom Monat
                                                    Mai aus der DB
                                                    >löschen/korrigieren?<u></u><u></u></p>
                                                  <p class="MsoNormal"> <u></u><u></u></p>
                                                  <p class="MsoNormal">Lösche
                                                    bei mir fehlerhafte
                                                    Daten über ein
                                                    Skript raus. Dazu
                                                    nutze ich den
                                                    „harten“ delete
                                                    Befehle wie er hier
                                                    beschrieben ist:<u></u><u></u></p>
                                                  <p class="MsoNormal"> <u></u><u></u></p>
                                                  <p class="MsoNormal"><a href="https://wiki.volkszaehler.org/howto/datenmengen" title="https://wiki.volkszaehler.org/howto/datenmengen
                                                      Klicken Sie auf
                                                      den Link, um die
                                                      URL in einem neuen
                                                      Fenster zu
                                                      öffnen." target="_blank" rel="noreferrer">https://wiki.volkszaehler.org/howto/datenmengen</a><u></u><u></u></p>
                                                  <p class="MsoNormal"> <u></u><u></u></p>
                                                  <p class="MsoNormal">Ich
                                                    würde die Befehle
                                                    aber dringend raten
                                                    im phpmyAdmin zu
                                                    simulieren und zu
                                                    testen bevor nachher
                                                    was falsches
                                                    gelöscht wird.<u></u><u></u></p>
                                                  <p class="MsoNormal"> <u></u><u></u></p>
                                                  <p class="MsoNormal">VG<u></u><u></u></p>
                                                  <p class="MsoNormal">Ralf<u></u><u></u></p>
                                                </div>
                                              </div>
                                            </blockquote>
                                          </div>
                                          <p class="MsoNormal"><br>
                                            -- <br>
                                            Diese Nachricht wurde von
                                            meinem Android-Gerät mit K-9
                                            Mail gesendet.<u></u><u></u></p>
                                        </div>
                                      </blockquote>
                                    </div>
                                  </div>
                                </div>
                              </div>
                              <p class="MsoNormal"><br>
                                -- <br>
                                Diese Nachricht wurde von meinem
                                Android-Gerät mit K-9 Mail gesendet.<u></u><u></u></p>
                            </div>
                          </blockquote>
                        </div>
                      </div>
                    </div>
                  </blockquote>
                </div>
              </div>
              <p class="MsoNormal"><br>
                -- <br>
                Diese Nachricht wurde von meinem Android-Gerät mit K-9
                Mail gesendet.<u></u><u></u></p>
            </div>
          </blockquote>
        </div>
      </div>
    </blockquote>
    <br>
  </div>

</blockquote></div>
</div></blockquote></body></html>