Neueste Beiträge

Seiten: [1] 2 3 ... 10
1
Hallo,

ich habe es sicher im Wust überlesen. In der Doku habe ich in der Genauigkeit aber nichts dazu gefunden.

Die HmIP-Wired Jalousien werden etwas anders gesteuert, als ASC es scheinbar erwartet. Wenn man sie bspw. wirklich 100% öffnen möchte, muss man (ja nach aktuellem Stand der Lamellen) folgendes machen:

Ein Attribut eventMap mit Auschnittweise folgendem Inhalt:

datapoint LEVEL_2 1 LEVEL 100:on
und dann

set <DEVICE> on
Es wird also der gesamte Befehl auf on gemapt. Schickt man das Einzeln, fahren die Lamellen nicht in Position und die Jalousie lässt sich nur auf bspw. 96% öffnen. Das gleiche gilt für runter.

Lässt sich das abbilden? Kann man bspw. direkt "on" als openCmd senden?

Danke.
2
Anfängerfragen / Antw:Notify löst seit 2 Tagen nicht mehr aus
« Letzter Beitrag von Helmi55 am Heute um 17:33:51 »
Servus Markus,
das ist alles sehr merkwürdig. In der Produktion kommt kein event - nur im Test.

Ich kann aber von der Produktion die Temperatur ändern - das kommt im Test und im Ofen selbst an ABER nicht in der Produktion im state????
D.h. für mich, eine Verbindung zum Ofen steht?

Was mir jetzt noch aufgefallen ist, in der Produktion habe ich bei den Internals BUSY 1 und im Test 0 ?

Selbstverständlich habe ich die Zugangsdaten alle kontrolliert, die stimmen

Noch eine Idee außer ich starte den Ofen neu?

Gruß
Helmut
3
TabletUI / [FTUI3] Tabview
« Letzter Beitrag von Wolfgang Hochweller am Heute um 17:33:23 »
Was habe ich vergessen, wenn ich nicht einfach zwischen den Tabs umschalten kann, sondern dazwischen einen Pagerefesh brauche ?

Index-Datei :

<!DOCTYPE html>
<html>

<head>
  <!--
    /* FHEM tablet ui - FTUI */
    /**
    * UI builder framework for FHEM
    *
    * Version: 3.0.0
    *
    * Copyright (c) 2015-2021 Mario Stephan <mstephan@shared-files.de>
    * Under MIT License (http://www.opensource.org/licenses/mit-license.php)
    * https://github.com/knowthelist/ftui
    */
    -->
  <script src="ftui.js"></script>

  <link href="ftui.css" rel="stylesheet">
  <link href="themes/ftui-theme.css" rel="stylesheet">
  <link href="favicon.ico" rel="icon" type="image/x-icon" />

  <!-- avoid 300ms delay on click-->
  <meta name="viewport" content="width=device-width">

  <meta name="mobile-web-app-capable" content="yes">
  <meta name="toast_position" content="topLeft">


  <!-- verbose level 0-4 -->
  <meta name="debug" content="0">


  <title>FTUI Home</title>
</head>

<body>
<ftui-grid base-width="50" base-height="43" margin="5" shape="round">

    <ftui-grid-tile row="1" col="1" height="10" width="1">
      <ftui-column>
        <ftui-tab view="View1" >
          <ftui-icon name="home1"></ftui-icon>
        </ftui-tab>
        <ftui-tab view="View4">
          <ftui-icon name="calendar"></ftui-icon>
        </ftui-tab>
      </ftui-column>
    </ftui-grid-tile>

 
    <ftui-tab-view id="View1">
        <ftui-content file="main.html"></ftui-content>
    </ftui-tab-view>
     
    <ftui-tab-view id="View4">
        <ftui-content file="calendar.html"></ftui-content>
    </ftui-tab-view>
     
</ftui-grid> 

</body>

</html>

4
TabletUI / [FTUI3] Chart
« Letzter Beitrag von Wolfgang Hochweller am Heute um 17:22:37 »
Ich brauche einen Tip :

        <ftui-chart  y-label="Grad" y1-label="Prozent" width="500px" height="450px"
             y-min=-20 y-max=40 y1-min=0 y1-max=100>
            <ftui-chart-data  label="Temperatur" log="logdb" file="HISTORY" spec="Eingang:temperature" [update]="Eingang:state:time"
                type="line" unit="°C" color="red" y-axis-id="0" point-radius=1 ></ftui-chart-data>
            <ftui-chart-data  label="Feuchte" log="logdb" file="HISTORY" spec="Eingang:humidity" [update]="Eingang:state:time"
                type="line" unit="%" color="blue" point-radius=1 y-axis-id="1"></ftui-chart-data>
            <ftui-chart-controls units="day, week"></ftui-chart-controls>
        </ftui-chart>

Was ich gerne haette :

Links eine y-Achse  : -20  bis +40
Rechts eine y-Achse : + bis 100

Was ich bekomme :

Wenn ich die beiden  y-axis-id=...    weglasse, bekomme ich genau einen  Graphen der Temperatur, korrekte Beschriftung links
Wenn ich es probiere wie oben oder auch mit y-axis-id = 1,  etc. , bekomme ich zusaetzlich zur richtigen Achse links noch 2 weitere, mit den relativen min/max-Werten fuer die beiden Graphen.

Kann mir jemand die Bedeutung von y-achse-id erklaeren ?

bzw. : Wie ordne ich einem Graphen die korrekte y-Achse zu ?
5
Termine und Veranstaltungen / Antw:Stammtisch Leipzig
« Letzter Beitrag von majorshark am Heute um 17:18:54 »
Ich habe mich nun auch mal für nächste Woche eingetragen. Ich hoffe das ich es dieses Mal wieder schaffe. Sieht aber entspannt aus an diesem Tag.

Wie sieht es aus mit der Verpflegung? Ist da noch etwas zu organisieren oder Fasten wir?
6
FHEMWEB / Antw:Modul weekprofile + FHEMWEB widget
« Letzter Beitrag von Risiko am Heute um 17:13:33 »
Hallo stolus,

ich habe von dieser Hardware keine Ahnung, bekomme das auch nicht mit und kann daher immer nur hinterher programmieren, wenn es auf der Seite (von Homatic, Raspberymatic, etc.) was Neues gibt. Dazu benötige ich natürlich die Informationen von euch Usern (list vom Device, Readings, Befehl zum setzen des Profils).
Leider hält sich der Homatic-Entwickler aus meiner Sicht nicht an irgend eine Konvention bzw. Logik (jedenfalls mir nicht ersichtlich).

Also wenn du mir die notwendigen Informationen zur Verfügung stellen kannst, dann kann ich mal schauen was sich machen lässt.

Risiko
7
FRITZ!Box / Antw:(Gelöst) FritzBox, mal wieder: Didn't get a session ID
« Letzter Beitrag von Maista am Heute um 17:11:55 »
Moin

FB 6591
Intervall : 300

Musste nach Update der Kabelboxe auf V7.27 (gemietet) nur den User mit angeben welcher mir die Box per E-Mail zugeschickt hatte.

Bisher nie Probleme gehabt

Gruß Gerd
8
Die Idee mit OpenWRT NUT gefällt mir, vielen Dank!
9
Automatisierung / DbLog Fehler wenn YAMAHA_MC enabled
« Letzter Beitrag von juppzupp am Heute um 17:07:37 »
Hi,

wenn ich am folgenden device (YAMAHA_MC) das attr disable von 1 auf 0 setze, bekomme ich ein dblog problem.

ist das ein YAMAHA_MC oder DbLog problem ?

Internals:
   ACTIVE_ZONE main
   API_VERSION 1
   DEF        192.168.0.116
   DEVICEID   0
   FUUID      5ec1016e-f33f-c0e9-209f-81c8c46a8a07d47c
   HOST       192.168.0.116
   LastTtsFile
   NAME       ysp2700
   NOTIFYDEV  global
   NR         519
   OFF_INTERVAL 120
   ON_INTERVAL 60
   PORT       80
   PowerOnInProgress 0
   STATE      on
   TYPE       YAMAHA_MC
   URLCMD     /YamahaExtendedControl
   UdpClientPort 41100
   VERSION    v2.1.1
   ZONE       main
   attemptsToReturnMenu 0
   dist_group_id 00000000000000000000000000000000
   dist_group_name (Linked) Wohnzimmer
   dist_group_role none
   settingChannelInProgress 0
   READINGS:
     2020-12-11 12:28:23   DLNARenderer    unknown
     2021-10-22 12:05:05   FirmwareAvailable 0
     2020-12-11 12:28:23   MediaServer     unknown
     2021-10-22 12:54:02   album_name     
     2021-10-22 12:54:02   albumart_id     1155
     1                     albumart_url    http://192.168.0.116
     2021-10-22 12:54:02   auto_power_standby 0
     2020-05-17 20:15:12   currentFavNetRadioChannel 2
     2020-05-17 20:15:34   currentMenuName NET RADIO
     2020-05-17 20:15:34   currentMenuPlayingIndex -1
     2020-05-17 20:15:34   currentMenumaxItems 2
     2021-10-22 12:54:02   hdmi_out_1      false
     2021-10-22 12:54:02   hdmi_out_2      false
     2021-10-22 12:54:02   headphone       false
     2021-01-23 14:07:51   input           tv
     2021-10-22 12:54:02   ir_sensor       false
     2021-10-22 12:54:02   last_error      Invalid Parameter (Out of range, invalid characters etc.)
     2021-10-22 12:54:02   linkedClients   
     2021-10-22 12:54:02   max_volume      100
     2020-05-17 11:18:39   mute            0
     2021-10-22 12:54:02   party_mode      false
     2021-10-22 12:54:02   play_time       0
     2021-10-22 12:54:02   playback_input  server
     2021-10-22 12:54:02   playback_status stop
     2021-10-22 12:05:05   power           on
     2021-10-22 12:53:58   presence        present
     2021-10-22 12:54:02   repeat_status   off
     2021-10-22 12:54:02   response_code   0
     2021-10-22 12:54:02   shuffle_status  off
     2020-05-17 11:18:39   sound_program   off
     2021-10-22 12:54:02   speaker_a       false
     2021-10-22 12:54:02   speaker_b       false
     2021-10-22 12:54:02   state           on
     2021-10-22 12:54:02   station_name   
     2021-10-22 12:54:02   total_time      0
     2021-10-22 12:54:02   track           
     2021-10-22 12:05:05   volume          52
   helper:
     AVAILABLE  1
     DISABLED   0
     RUNNING_REQUEST 0
     TIMEOUT_COUNT 0
     inputs_comma
     inputs_piped
     menuitems_comma
     menuitems_piped
     soundprograms_comma
     CMD_QUEUE:
     SELECTED_ZONE:
     ZONES:
     client_list:
Attributes:
   disable    1
   room       Wohnzimmer

2021.10.22 12:06:00 2: DbLog logdb -> Error table history - DBD::mysql::st execute_array failed: executing 150 generated 1 errors at ./FHEM/93_DbLog.pm line 2855.

2021.10.22 12:07:00 2: DbLog logdb -> Error table history - DBD::mysql::st execute_array failed: executing 201 generated 1 errors at ./FHEM/93_DbLog.pm line 2855.

2021.10.22 12:08:00 2: DbLog logdb -> Error table history - DBD::mysql::st execute_array failed: executing 259 generated 1 errors at ./FHEM/93_DbLog.pm line 2855.

2021.10.22 12:09:00 2: DbLog logdb -> Error table history - DBD::mysql::st execute_array failed: executing 353 generated 1 errors at ./FHEM/93_DbLog.pm line 2855.

2021.10.22 12:10:00 2: DbLog logdb -> Error table history - DBD::mysql::st execute_array failed: executing 425 generated 1 errors at ./FHEM/93_DbLog.pm line 2855.

2021.10.22 12:10:32 2: DbLog logdb -> Error table history - DBD::mysql::st execute_array failed: executing 501 generated 1 errors at ./FHEM/93_DbLog.pm line 2855.

2021.10.22 12:10:32 2: DbLog logdb -> Error table history - DBD::mysql::st execute_array failed: executing 504 generated 1 errors at ./FHEM/93_DbLog.pm line 2855.

2021.10.22 12:11:06 2: DbLog logdb -> Error table history - DBD::mysql::st execute_array failed: executing 552 generated 1 errors at ./FHEM/93_DbLog.pm line 2855.

2021.10.22 12:11:07 2: DbLog logdb -> Error table history - DBD::mysql::st execute_array failed: executing 577 generated 1 errors at ./FHEM/93_DbLog.pm line 2855.

2021.10.22 12:11:37 2: DbLog logdb -> Error table history - DBD::mysql::st execute_array failed: executing 627 generated 1 errors at ./FHEM/93_DbLog.pm line 2855.

2021.10.22 12:11:37 2: DbLog logdb -> Error table history - DBD::mysql::st execute_array failed: executing 629 generated 1 errors at ./FHEM/93_DbLog.pm line 2855.

2021.10.22 12:12:09 2: DbLog logdb -> Error table history - DBD::mysql::st execute_array failed: executing 664 generated 1 errors at ./FHEM/93_DbLog.pm line 2855.

2021.10.22 12:12:09 2: DbLog logdb -> Error table history - DBD::mysql::st execute_array failed: executing 666 generated 1 errors at ./FHEM/93_DbLog.pm line 2855.

2021.10.22 12:12:43 2: DbLog logdb -> Error table history - DBD::mysql::st execute_array failed: executing 702 generated 1 errors at ./FHEM/93_DbLog.pm line 2855.

2021.10.22 12:12:43 2: DbLog logdb -> Error table history - DBD::mysql::st execute_array failed: executing 705 generated 1 errors at ./FHEM/93_DbLog.pm line 2855.

2021.10.22 12:13:16 2: DbLog logdb -> Error table history - DBD::mysql::st execute_array failed: executing 740 generated 1 errors at ./FHEM/93_DbLog.pm line 2855.

2021.10.22 12:13:16 2: DbLog logdb -> Error table history - DBD::mysql::st execute_array failed: executing 753 generated 1 errors at ./FHEM/93_DbLog.pm line 2855.

2021.10.22 12:13:50 2: DbLog logdb -> Error table history - DBD::mysql::st execute_array failed: executing 820 generated 1 errors at ./FHEM/93_DbLog.pm line 2855.

2021.10.22 12:13:50 2: DbLog logdb -> Error table history - DBD::mysql::st execute_array failed: executing 823 generated 1 errors at ./FHEM/93_DbLog.pm line 2855.

2021.10.22 12:14:24 2: DbLog logdb -> Error table history - DBD::mysql::st execute_array failed: executing 851 generated 1 errors at ./FHEM/93_DbLog.pm line 2855.

2021.10.22 12:14:24 2: DbLog logdb -> Error table history - DBD::mysql::st execute_array failed: executing 853 generated 1 errors at ./FHEM/93_DbLog.pm line 2855.

2021.10.22 12:15:00 2: DbLog logdb -> Error table history - DBD::mysql::st execute_array failed: executing 922 generated 1 errors at ./FHEM/93_DbLog.pm line 2855.

2021.10.22 12:15:00 2: DbLog logdb -> Error table history - DBD::mysql::st execute_array failed: executing 924 generated 1 errors at ./FHEM/93_DbLog.pm line 2855.

2021.10.22 12:15:30 2: DbLog logdb -> Error table history - DBD::mysql::st execute_array failed: executing 1004 generated 1 errors at ./FHEM/93_DbLog.pm line 2855.

2021.10.22 12:15:31 2: DbLog logdb -> Error table history - DBD::mysql::st execute_array failed: executing 1006 generated 1 errors at ./FHEM/93_DbLog.pm line 2855.

2021.10.22 12:16:01 2: DbLog logdb -> Error table history - DBD::mysql::st execute_array failed: executing 1065 generated 1 errors at ./FHEM/93_DbLog.pm line 2855.

2021.10.22 12:16:02 2: DbLog logdb -> Error table history - DBD::mysql::st execute_array failed: executing 1067 generated 1 errors at ./FHEM/93_DbLog.pm line 2855.

2021.10.22 12:16:35 2: DbLog logdb -> Error table history - DBD::mysql::st execute_array failed: executing 1113 generated 1 errors at ./FHEM/93_DbLog.pm line 2855.

2021.10.22 12:16:35 2: DbLog logdb -> Error table history - DBD::mysql::st execute_array failed: executing 1115 generated 1 errors at ./FHEM/93_DbLog.pm line 2855.

2021.10.22 12:17:06 2: DbLog logdb -> Error table history - DBD::mysql::st execute_array failed: executing 1149 generated 1 errors at ./FHEM/93_DbLog.pm line 2855.

2021.10.22 12:17:07 2: DbLog logdb -> Error table history - DBD::mysql::st execute_array failed: executing 1151 generated 1 errors at ./FHEM/93_DbLog.pm line 2855.

2021.10.22 12:17:37 2: DbLog logdb -> Error table history - DBD::mysql::st execute_array failed: executing 1205 generated 1 errors at ./FHEM/93_DbLog.pm line 2855.

2021.10.22 12:17:37 2: DbLog logdb -> Error table history - DBD::mysql::st execute_array failed: executing 1210 generated 1 errors at ./FHEM/93_DbLog.pm line 2855.

2021.10.22 12:18:11 2: DbLog logdb -> Error table history - DBD::mysql::st execute_array failed: executing 1226 generated 1 errors at ./FHEM/93_DbLog.pm line 2855.

2021.10.22 12:18:11 2: DbLog logdb -> Error table history - DBD::mysql::st execute_array failed: executing 1232 generated 1 errors at ./FHEM/93_DbLog.pm line 2855.

2021.10.22 12:18:42 2: DbLog logdb -> Error table history - DBD::mysql::st execute_array failed: executing 1299 generated 1 errors at ./FHEM/93_DbLog.pm line 2855.

2021.10.22 12:18:43 2: DbLog logdb -> Error table history - DBD::mysql::st execute_array failed: executing 1302 generated 1 errors at ./FHEM/93_DbLog.pm line 2855.

2021.10.22 12:19:16 2: DbLog logdb -> Error table history - DBD::mysql::st execute_array failed: executing 1334 generated 1 errors at ./FHEM/93_DbLog.pm line 2855.

2021.10.22 12:19:16 2: DbLog logdb -> Error table history - DBD::mysql::st execute_array failed: executing 1336 generated 1 errors at ./FHEM/93_DbLog.pm line 2855.

2021.10.22 12:19:49 2: DbLog logdb -> Error table history - DBD::mysql::st execute_array failed: executing 1374 generated 1 errors at ./FHEM/93_DbLog.pm line 2855.

2021.10.22 12:19:50 2: DbLog logdb -> Error table history - DBD::mysql::st execute_array failed: executing 1376 generated 1 errors at ./FHEM/93_DbLog.pm line 2855.

2021.10.22 12:20:28 2: DbLog logdb -> Error table history - DBD::mysql::st execute_array failed: executing 1414 generated 1 errors at ./FHEM/93_DbLog.pm line 2855.

2021.10.22 12:20:28 2: DbLog logdb -> Error table history - DBD::mysql::st execute_array failed: executing 1430 generated 1 errors at ./FHEM/93_DbLog.pm line 2855.

2021.10.22 12:21:00 2: DbLog logdb -> Error table history - DBD::mysql::st execute_array failed: executing 1481 generated 1 errors at ./FHEM/93_DbLog.pm line 2855.

2021.10.22 12:21:00 2: DbLog logdb -> Error table history - DBD::mysql::st execute_array failed: executing 1496 generated 1 errors at ./FHEM/93_DbLog.pm line 2855.

2021.10.22 12:21:30 2: DbLog logdb -> Error table history - DBD::mysql::st execute_array failed: executing 1550 generated 1 errors at ./FHEM/93_DbLog.pm line 2855.

2021.10.22 12:21:31 2: DbLog logdb -> Error table history - DBD::mysql::st execute_array failed: executing 1561 generated 1 errors at ./FHEM/93_DbLog.pm line 2855.

2021.10.22 12:22:04 2: DbLog logdb -> Error table history - DBD::mysql::st execute_array failed: executing 1612 generated 1 errors at ./FHEM/93_DbLog.pm line 2855.

2021.10.22 12:22:05 2: DbLog logdb -> Error table history - DBD::mysql::st execute_array failed: executing 1614 generated 1 errors at ./FHEM/93_DbLog.pm line 2855.

2021.10.22 12:22:37 2: DbLog logdb -> Error table history - DBD::mysql::st execute_array failed: executing 1673 generated 1 errors at ./FHEM/93_DbLog.pm line 2855.

2021.10.22 12:22:38 2: DbLog logdb -> Error table history - DBD::mysql::st execute_array failed: executing 1676 generated 1 errors at ./FHEM/93_DbLog.pm line 2855.

2021.10.22 12:23:09 2: DbLog logdb -> Error table history - DBD::mysql::st execute_array failed: executing 1692 generated 1 errors at ./FHEM/93_DbLog.pm line 2855.

2021.10.22 12:23:10 2: DbLog logdb -> Error table history - DBD::mysql::st execute_array failed: executing 1706 generated 1 errors at ./FHEM/93_DbLog.pm line 2855.

2021.10.22 12:23:40 2: DbLog logdb -> Error table history - DBD::mysql::st execute_array failed: executing 1754 generated 1 errors at ./FHEM/93_DbLog.pm line 2855.

2021.10.22 12:23:41 2: DbLog logdb -> Error table history - DBD::mysql::st execute_array failed: executing 1760 generated 1 errors at ./FHEM/93_DbLog.pm line 2855.

2021.10.22 12:24:19 2: DbLog logdb -> Error table history - DBD::mysql::st execute_array failed: executing 1820 generated 1 errors at ./FHEM/93_DbLog.pm line 2855.

2021.10.22 12:24:19 2: DbLog logdb -> Error table history - DBD::mysql::st execute_array failed: executing 1829 generated 1 errors at ./FHEM/93_DbLog.pm line 2855.

2021.10.22 12:24:52 2: DbLog logdb -> Error table history - DBD::mysql::st execute_array failed: executing 1872 generated 1 errors at ./FHEM/93_DbLog.pm line 2855.

2021.10.22 12:24:53 2: DbLog logdb -> Error table history - DBD::mysql::st execute_array failed: executing 1874 generated 1 errors at ./FHEM/93_DbLog.pm line 2855.

2021.10.22 12:25:27 2: DbLog logdb -> Error table history - DBD::mysql::st execute_array failed: executing 1937 generated 1 errors at ./FHEM/93_DbLog.pm line 2855.

2021.10.22 12:25:27 2: DbLog logdb -> Error table history - DBD::mysql::st execute_array failed: executing 1956 generated 1 errors at ./FHEM/93_DbLog.pm line 2855.

2021.10.22 12:26:01 2: DbLog logdb -> Error table history - DBD::mysql::st execute_array failed: executing 1999 generated 1 errors at ./FHEM/93_DbLog.pm line 2855.

2021.10.22 12:26:02 2: DbLog logdb -> Error table history - DBD::mysql::st execute_array failed: executing 2009 generated 1 errors at ./FHEM/93_DbLog.pm line 2855.

2021.10.22 12:26:33 2: DbLog logdb -> Error table history - DBD::mysql::st execute_array failed: executing 2064 generated 1 errors at ./FHEM/93_DbLog.pm line 2855.

2021.10.22 12:26:34 2: DbLog logdb -> Error table history - DBD::mysql::st execute_array failed: executing 2067 generated 1 errors at ./FHEM/93_DbLog.pm line 2855.

2021.10.22 12:27:07 2: DbLog logdb -> Error table history - DBD::mysql::st execute_array failed: executing 2127 generated 1 errors at ./FHEM/93_DbLog.pm line 2855.

2021.10.22 12:27:08 2: DbLog logdb -> Error table history - DBD::mysql::st execute_array failed: executing 2135 generated 1 errors at ./FHEM/93_DbLog.pm line 2855.

2021.10.22 12:27:41 2: DbLog logdb -> Error table history - DBD::mysql::st execute_array failed: executing 2173 generated 1 errors at ./FHEM/93_DbLog.pm line 2855.

2021.10.22 12:27:41 2: DbLog logdb -> Error table history - DBD::mysql::st execute_array failed: executing 2182 generated 1 errors at ./FHEM/93_DbLog.pm line 2855.

2021.10.22 12:28:21 2: DbLog logdb -> Error table history - DBD::mysql::st execute_array failed: executing 2231 generated 1 errors at ./FHEM/93_DbLog.pm line 2855.

2021.10.22 12:28:22 2: DbLog logdb -> Error table history - DBD::mysql::st execute_array failed: executing 2233 generated 1 errors at ./FHEM/93_DbLog.pm line 2855.

2021.10.22 12:29:00 2: DbLog logdb -> Error table history - DBD::mysql::st execute_array failed: executing 2299 generated 1 errors at ./FHEM/93_DbLog.pm line 2855.

2021.10.22 12:29:01 2: DbLog logdb -> Error table history - DBD::mysql::st execute_array failed: executing 2308 generated 1 errors at ./FHEM/93_DbLog.pm line 2855.

2021.10.22 12:29:34 2: DbLog logdb -> Error table history - DBD::mysql::st execute_array failed: executing 2343 generated 1 errors at ./FHEM/93_DbLog.pm line 2855.

2021.10.22 12:29:34 2: DbLog logdb -> Error table history - DBD::mysql::st execute_array failed: executing 2345 generated 1 errors at ./FHEM/93_DbLog.pm line 2855.

2021.10.22 12:30:10 2: DbLog logdb -> Error table history - DBD::mysql::st execute_array failed: executing 2429 generated 1 errors at ./FHEM/93_DbLog.pm line 2855.

2021.10.22 12:30:10 2: DbLog logdb -> Error table history - DBD::mysql::st execute_array failed: executing 2431 generated 1 errors at ./FHEM/93_DbLog.pm line 2855.

2021.10.22 12:30:46 2: DbLog logdb -> Error table history - DBD::mysql::st execute_array failed: executing 2488 generated 1 errors at ./FHEM/93_DbLog.pm line 2855.

2021.10.22 12:30:47 2: DbLog logdb -> Error table history - DBD::mysql::st execute_array failed: executing 2502 generated 1 errors at ./FHEM/93_DbLog.pm line 2855.

2021.10.22 12:31:17 2: DbLog logdb -> Error table history - DBD::mysql::st execute_array failed: executing 2565 generated 1 errors at ./FHEM/93_DbLog.pm line 2855.

2021.10.22 12:31:18 2: DbLog logdb -> Error table history - DBD::mysql::st execute_array failed: executing 2577 generated 1 errors at ./FHEM/93_DbLog.pm line 2855.

2021.10.22 12:31:52 2: DbLog logdb -> Error table history - DBD::mysql::st execute_array failed: executing 2625 generated 1 errors at ./FHEM/93_DbLog.pm line 2855.

2021.10.22 12:31:53 2: DbLog logdb -> Error table history - DBD::mysql::st execute_array failed: executing 2632 generated 1 errors at ./FHEM/93_DbLog.pm line 2855.

2021.10.22 12:32:24 2: DbLog logdb -> Error table history - DBD::mysql::st execute_array failed: executing 2661 generated 1 errors at ./FHEM/93_DbLog.pm line 2855.

2021.10.22 12:32:25 2: DbLog logdb -> Error table history - DBD::mysql::st execute_array failed: executing 2669 generated 1 errors at ./FHEM/93_DbLog.pm line 2855.

2021.10.22 12:32:58 2: DbLog logdb -> Error table history - DBD::mysql::st execute_array failed: executing 2717 generated 1 errors at ./FHEM/93_DbLog.pm line 2855.

2021.10.22 12:32:59 2: DbLog logdb -> Error table history - DBD::mysql::st execute_array failed: executing 2719 generated 1 errors at ./FHEM/93_DbLog.pm line 2855.

2021.10.22 12:33:29 2: DbLog logdb -> Error table history - DBD::mysql::st execute_array failed: executing 2761 generated 1 errors at ./FHEM/93_DbLog.pm line 2855.

2021.10.22 12:33:30 2: DbLog logdb -> Error table history - DBD::mysql::st execute_array failed: executing 2767 generated 1 errors at ./FHEM/93_DbLog.pm line 2855.

2021.10.22 12:34:02 2: DbLog logdb -> Error table history - DBD::mysql::st execute_array failed: executing 2850 generated 1 errors at ./FHEM/93_DbLog.pm line 2855.

2021.10.22 12:34:03 2: DbLog logdb -> Error table history - DBD::mysql::st execute_array failed: executing 2866 generated 1 errors at ./FHEM/93_DbLog.pm line 2855.

2021.10.22 12:34:35 2: DbLog logdb -> Error table history - DBD::mysql::st execute_array failed: executing 2883 generated 1 errors at ./FHEM/93_DbLog.pm line 2855.

2021.10.22 12:34:36 2: DbLog logdb -> Error table history - DBD::mysql::st execute_array failed: executing 2892 generated 1 errors at ./FHEM/93_DbLog.pm line 2855.

2021.10.22 12:35:09 2: DbLog logdb -> Error table history - DBD::mysql::st execute_array failed: executing 2974 generated 1 errors at ./FHEM/93_DbLog.pm line 2855.

2021.10.22 12:35:10 2: DbLog logdb -> Error table history - DBD::mysql::st execute_array failed: executing 2989 generated 1 errors at ./FHEM/93_DbLog.pm line 2855.

2021.10.22 12:35:43 2: DbLog logdb -> Error table history - DBD::mysql::st execute_array failed: executing 3045 generated 1 errors at ./FHEM/93_DbLog.pm line 2855.

2021.10.22 12:35:44 2: DbLog logdb -> Error table history - DBD::mysql::st execute_array failed: executing 3047 generated 1 errors at ./FHEM/93_DbLog.pm line 2855.

2021.10.22 12:36:16 2: DbLog logdb -> Error table history - DBD::mysql::st execute_array failed: executing 3128 generated 1 errors at ./FHEM/93_DbLog.pm line 2855.

2021.10.22 12:36:17 2: DbLog logdb -> Error table history - DBD::mysql::st execute_array failed: executing 3148 generated 1 errors at ./FHEM/93_DbLog.pm line 2855.

2021.10.22 12:36:48 2: DbLog logdb -> Error table history - DBD::mysql::st execute_array failed: executing 3193 generated 1 errors at ./FHEM/93_DbLog.pm line 2855.

2021.10.22 12:36:49 2: DbLog logdb -> Error table history - DBD::mysql::st execute_array failed: executing 3195 generated 1 errors at ./FHEM/93_DbLog.pm line 2855.

2021.10.22 12:37:20 2: DbLog logdb -> Error table history - DBD::mysql::st execute_array failed: executing 3255 generated 1 errors at ./FHEM/93_DbLog.pm line 2855.

2021.10.22 12:37:21 2: DbLog logdb -> Error table history - DBD::mysql::st execute_array failed: executing 3269 generated 1 errors at ./FHEM/93_DbLog.pm line 2855.

2021.10.22 12:37:51 2: DbLog logdb -> Error table history - DBD::mysql::st execute_array failed: executing 3317 generated 1 errors at ./FHEM/93_DbLog.pm line 2855.

2021.10.22 12:37:53 2: DbLog logdb -> Error table history - DBD::mysql::st execute_array failed: executing 3319 generated 1 errors at ./FHEM/93_DbLog.pm line 2855.

2021.10.22 12:38:25 2: DbLog logdb -> Error table history - DBD::mysql::st execute_array failed: executing 3373 generated 1 errors at ./FHEM/93_DbLog.pm line 2855.

2021.10.22 12:38:26 2: DbLog logdb -> Error table history - DBD::mysql::st execute_array failed: executing 3403 generated 1 errors at ./FHEM/93_DbLog.pm line 2855.

2021.10.22 12:38:56 2: DbLog logdb -> Error table history - DBD::mysql::st execute_array failed: executing 3447 generated 1 errors at ./FHEM/93_DbLog.pm line 2855.

2021.10.22 12:38:57 2: DbLog logdb -> Error table history - DBD::mysql::st execute_array failed: executing 3453 generated 1 errors at ./FHEM/93_DbLog.pm line 2855.

2021.10.22 12:39:28 2: DbLog logdb -> Error table history - DBD::mysql::st execute_array failed: executing 3469 generated 1 errors at ./FHEM/93_DbLog.pm line 2855.

2021.10.22 12:39:29 2: DbLog logdb -> Error table history - DBD::mysql::st execute_array failed: executing 3472 generated 1 errors at ./FHEM/93_DbLog.pm line 2855.

2021.10.22 12:40:00 2: DbLog logdb -> Error table history - DBD::mysql::st execute_array failed: executing 3525 generated 1 errors at ./FHEM/93_DbLog.pm line 2855.

2021.10.22 12:40:01 2: DbLog logdb -> Error table history - DBD::mysql::st execute_array failed: executing 3534 generated 1 errors at ./FHEM/93_DbLog.pm line 2855.

2021.10.22 12:40:32 2: DbLog logdb -> Error table history - DBD::mysql::st execute_array failed: executing 3591 generated 1 errors at ./FHEM/93_DbLog.pm line 2855.

2021.10.22 12:40:33 2: DbLog logdb -> Error table history - DBD::mysql::st execute_array failed: executing 3593 generated 1 errors at ./FHEM/93_DbLog.pm line 2855.

2021.10.22 12:41:04 2: DbLog logdb -> Error table history - DBD::mysql::st execute_array failed: executing 3661 generated 1 errors at ./FHEM/93_DbLog.pm line 2855.

2021.10.22 12:41:05 2: DbLog logdb -> Error table history - DBD::mysql::st execute_array failed: executing 3676 generated 1 errors at ./FHEM/93_DbLog.pm line 2855.

2021.10.22 12:41:37 2: DbLog logdb -> Error table history - DBD::mysql::st execute_array failed: executing 3731 generated 1 errors at ./FHEM/93_DbLog.pm line 2855.

2021.10.22 12:41:38 2: DbLog logdb -> Error table history - DBD::mysql::st execute_array failed: executing 3740 generated 1 errors at ./FHEM/93_DbLog.pm line 2855.

2021.10.22 12:42:12 2: DbLog logdb -> Error table history - DBD::mysql::st execute_array failed: executing 3797 generated 1 errors at ./FHEM/93_DbLog.pm line 2855.

2021.10.22 12:42:14 2: DbLog logdb -> Error table history - DBD::mysql::st execute_array failed: executing 3811 generated 1 errors at ./FHEM/93_DbLog.pm line 2855.

2021.10.22 12:42:47 2: DbLog logdb -> Error table history - DBD::mysql::st execute_array failed: executing 3842 generated 1 errors at ./FHEM/93_DbLog.pm line 2855.

2021.10.22 12:42:48 2: DbLog logdb -> Error table history - DBD::mysql::st execute_array failed: executing 3846 generated 1 errors at ./FHEM/93_DbLog.pm line 2855.

2021.10.22 12:43:18 2: DbLog logdb -> Error table history - DBD::mysql::st execute_array failed: executing 3923 generated 1 errors at ./FHEM/93_DbLog.pm line 2855.

2021.10.22 12:43:20 2: DbLog logdb -> Error table history - DBD::mysql::st execute_array failed: executing 3932 generated 1 errors at ./FHEM/93_DbLog.pm line 2855.

2021.10.22 12:43:51 2: DbLog logdb -> Error table history - DBD::mysql::st execute_array failed: executing 3978 generated 1 errors at ./FHEM/93_DbLog.pm line 2855.

2021.10.22 12:43:52 2: DbLog logdb -> Error table history - DBD::mysql::st execute_array failed: executing 3983 generated 1 errors at ./FHEM/93_DbLog.pm line 2855.

2021.10.22 12:44:29 2: DbLog logdb -> Error table history - DBD::mysql::st execute_array failed: executing 4074 generated 1 errors at ./FHEM/93_DbLog.pm line 2855.

2021.10.22 12:44:31 2: DbLog logdb -> Error table history - DBD::mysql::st execute_array failed: executing 4083 generated 1 errors at ./FHEM/93_DbLog.pm line 2855.

2021.10.22 12:45:02 2: DbLog logdb -> Error table history - DBD::mysql::st execute_array failed: executing 4125 generated 1 errors at ./FHEM/93_DbLog.pm line 2855.

2021.10.22 12:45:03 2: DbLog logdb -> Error table history - DBD::mysql::st execute_array failed: executing 4153 generated 1 errors at ./FHEM/93_DbLog.pm line 2855.

2021.10.22 12:45:38 2: DbLog logdb -> Error table history - DBD::mysql::st execute_array failed: executing 4194 generated 1 errors at ./FHEM/93_DbLog.pm line 2855.

2021.10.22 12:45:39 2: DbLog logdb -> Error table history - DBD::mysql::st execute_array failed: executing 4196 generated 1 errors at ./FHEM/93_DbLog.pm line 2855.

2021.10.22 12:46:10 2: DbLog logdb -> Error table history - DBD::mysql::st execute_array failed: executing 4267 generated 1 errors at ./FHEM/93_DbLog.pm line 2855.

2021.10.22 12:46:11 2: DbLog logdb -> Error table history - DBD::mysql::st execute_array failed: executing 4276 generated 1 errors at ./FHEM/93_DbLog.pm line 2855.

2021.10.22 12:46:42 2: DbLog logdb -> Error table history - DBD::mysql::st execute_array failed: executing 4312 generated 1 errors at ./FHEM/93_DbLog.pm line 2855.

2021.10.22 12:46:43 2: DbLog logdb -> Error table history - DBD::mysql::st execute_array failed: executing 4327 generated 1 errors at ./FHEM/93_DbLog.pm line 2855.

2021.10.22 12:47:14 2: DbLog logdb -> Error table history - DBD::mysql::st execute_array failed: executing 4386 generated 1 errors at ./FHEM/93_DbLog.pm line 2855.

2021.10.22 12:47:15 2: DbLog logdb -> Error table history - DBD::mysql::st execute_array failed: executing 4394 generated 1 errors at ./FHEM/93_DbLog.pm line 2855.

2021.10.22 12:47:46 2: DbLog logdb -> Error table history - DBD::mysql::st execute_array failed: executing 4436 generated 1 errors at ./FHEM/93_DbLog.pm line 2855.

2021.10.22 12:47:48 2: DbLog logdb -> Error table history - DBD::mysql::st execute_array failed: executing 4468 generated 1 errors at ./FHEM/93_DbLog.pm line 2855.

2021.10.22 12:48:19 2: DbLog logdb -> Error table history - DBD::mysql::st execute_array failed: executing 4522 generated 1 errors at ./FHEM/93_DbLog.pm line 2855.

2021.10.22 12:48:21 2: DbLog logdb -> Error table history - DBD::mysql::st execute_array failed: executing 4531 generated 1 errors at ./FHEM/93_DbLog.pm line 2855.

2021.10.22 12:48:53 2: DbLog logdb -> Error table history - DBD::mysql::st execute_array failed: executing 4598 generated 1 errors at ./FHEM/93_DbLog.pm line 2855.

2021.10.22 12:48:54 2: DbLog logdb -> Error table history - DBD::mysql::st execute_array failed: executing 4607 generated 1 errors at ./FHEM/93_DbLog.pm line 2855.

2021.10.22 12:49:30 2: DbLog logdb -> Error table history - DBD::mysql::st execute_array failed: executing 4643 generated 1 errors at ./FHEM/93_DbLog.pm line 2855.

2021.10.22 12:49:32 2: DbLog logdb -> Error table history - DBD::mysql::st execute_array failed: executing 4645 generated 1 errors at ./FHEM/93_DbLog.pm line 2855.

2021.10.22 12:50:02 2: DbLog logdb -> Error table history - DBD::mysql::st execute_array failed: executing 4687 generated 1 errors at ./FHEM/93_DbLog.pm line 2855.

2021.10.22 12:50:04 2: DbLog logdb -> Error table history - DBD::mysql::st execute_array failed: executing 4727 generated 1 errors at ./FHEM/93_DbLog.pm line 2855.

2021.10.22 12:50:40 2: DbLog logdb -> Error table history - DBD::mysql::st execute_array failed: executing 4747 generated 1 errors at ./FHEM/93_DbLog.pm line 2855.

2021.10.22 12:50:42 2: DbLog logdb -> Error table history - DBD::mysql::st execute_array failed: executing 4756 generated 1 errors at ./FHEM/93_DbLog.pm line 2855.

2021.10.22 12:51:16 2: DbLog logdb -> Error table history - DBD::mysql::st execute_array failed: executing 4850 generated 1 errors at ./FHEM/93_DbLog.pm line 2855.

2021.10.22 12:51:18 2: DbLog logdb -> Error table history - DBD::mysql::st execute_array failed: executing 4852 generated 1 errors at ./FHEM/93_DbLog.pm line 2855.

2021.10.22 12:51:49 2: DbLog logdb -> Error table history - DBD::mysql::st execute_array failed: executing 4890 generated 1 errors at ./FHEM/93_DbLog.pm line 2855.

2021.10.22 12:51:51 2: DbLog logdb -> Error table history - DBD::mysql::st execute_array failed: executing 4898 generated 1 errors at ./FHEM/93_DbLog.pm line 2855.

2021.10.22 12:52:22 2: DbLog logdb -> Error table history - DBD::mysql::st execute_array failed: executing 4963 generated 1 errors at ./FHEM/93_DbLog.pm line 2855.

2021.10.22 12:52:23 2: DbLog logdb -> Error table history - DBD::mysql::st execute_array failed: executing 4965 generated 1 errors at ./FHEM/93_DbLog.pm line 2855.

2021.10.22 12:52:59 2: DbLog logdb -> Error table history - DBD::mysql::st execute_array failed: executing 4999 generated 1 errors at ./FHEM/93_DbLog.pm line 2855.

2021.10.22 12:53:01 2: DbLog logdb -> Error table history - DBD::mysql::st execute_array failed: executing 5008 generated 1 errors at ./FHEM/93_DbLog.pm line 2855.

2021.10.22 12:53:32 2: DbLog logdb -> Error table history - DBD::mysql::st execute_array failed: executing 5083 generated 1 errors at ./FHEM/93_DbLog.pm line 2855.

2021.10.22 12:53:34 2: DbLog logdb -> Error table history - DBD::mysql::st execute_array failed: executing 5097 generated 1 errors at ./FHEM/93_DbLog.pm line 2855.


Internals:
   COLUMNS    field length used for Device: 64, Type: 64, Event: 512, Reading: 64, Value: 128, Unit: 32
   CONFIGURATION ./db.conf
   DEF        ./db.conf .*:.*
   FUUID      5c7ff2ee-f33f-c0e9-5666-b23d05e8cbd44787
   FVERSION   93_DbLog.pm:v4.12.3-s24440/2021-05-15
   MODE       asynchronous
   MODEL      MYSQL
   NAME       logdb
   NR         21
   NTFY_ORDER 50-logdb
   PID        15816
   REGEXP     .*:.*
   STATE      connected
   TYPE       DbLog
   UTF8       0
   dbconn     mysql:database=fhem;host=localhost;port=3306
   dbuser     fhemuser
   HELPER:
     COLSET     1
     DEVICECOL  64
     EVENTCOL   512
     OLDSTATE   connected
     PACKAGE    main
     READINGCOL 64
     TC         current
     TH         history
     TYPECOL    64
     UNITCOL    32
     VALUECOL   128
     VERSION    4.12.3
   Helper:
     DBLOG:
       CacheOverflowLastNum:
         logdb:
           TIME       1634915239.20104
           VALUE      0
       CacheOverflowLastState:
         logdb:
           TIME       1634900114.95193
           VALUE      normal
       state:
         logdb:
           TIME       1634900041.60095
           VALUE      connected
   READINGS:
     2021-10-22 17:07:19   CacheOverflowLastNum 0
     2021-10-22 12:55:14   CacheOverflowLastState normal
     2021-10-22 17:08:04   CacheUsage      91
     2021-10-22 17:07:19   NextSync        2021-10-22 17:08:19 or if CacheUsage 500 reached
     2017-07-29 15:08:31   countCurrent    0
     2017-07-29 15:08:30   countHistory    21
     2021-01-01 12:16:47   lastRowsDeleted 24835071
     2021-10-22 17:07:19   state           connected
Attributes:
   DbLogSelectionMode Exclude/Include
   asyncMode  1
   room       Server
   syncInterval 60
grüße
10
Eine große Herausforderung für mich wird sicherlich das ansteuern des Relais aus FHEM werden.

Für ESPEasy hab ich dir den Lösungsweg gepostet. ;-)
Seiten: [1] 2 3 ... 10
decade-submarginal