Announcement

Collapse
No announcement yet.

Lot of Log-discrete in MCStemperature

Collapse
X
 
  • Filter
  • Time
  • Show
Clear All
new posts

    Lot of Log-discrete in MCStemperature

    Hello,

    I have mcs temp for a while.
    31/07/2007 1:09:08 - Info - HomeSeer version is: 2.2.0.11
    31/07/2007 1:09:32 - Info - Found plug-in: mcsTemperature, version: 5.7.0.0

    In the log file I can see :

    <TABLE cellSpacing=2 cellPadding=0 width="100%" border=0><TBODY><TR><TD class=LOGDateTime0 noWrap align=left>31/07/2007 2:14:54 </TD><TD class=LOGType0 align=left colSpan=3>mcsTemperature </TD><TD class=LOGEntry0 align=left colSpan=8>Log_Discrete: INSERT INTO d9323_DONAAT_____ (SampleDate,Discrete) SELECT #2007-07-31 2:14:54# AS QT,0 AS Q1 on line 250 Kan de uitvoertabel d9323_DONAAT_____ niet vinden.</TD></TR><TR><TD class=LOGDateTime1 noWrap align=left>31/07/2007 2:14:55 </TD><TD class=LOGType1 align=left colSpan=3>mcsTemperature </TD><TD class=LOGEntry1 align=left colSpan=8>Log_Discrete: INSERT INTO d351_DONAAT______ (SampleDate,Discrete) SELECT #2007-07-31 2:14:55# AS QT,0 AS Q1 on line 250 Kan de uitvoertabel d351_DONAAT______ niet vinden.</TD></TR><TR><TD class=LOGDateTime0 noWrap align=left>31/07/2007 2:14:55 </TD><TD class=LOGType0 align=left colSpan=3>mcsTemperature </TD><TD class=LOGEntry0 align=left colSpan=8>Log_Discrete: INSERT INTO d9323_DONAAT_____ (SampleDate,Discrete) SELECT #2007-07-31 2:14:55# AS QT,1 AS Q1 on line 250 Kan de uitvoertabel d9323_DONAAT_____ niet vinden.</TD></TR><TR><TD class=LOGDateTime1 noWrap align=left>31/07/2007 2:14:56 </TD><TD class=LOGType1 align=left colSpan=3>mcsTemperature </TD><TD class=LOGEntry1 align=left colSpan=8>Log_Discrete: INSERT INTO d351_DONAAT______ (SampleDate,Discrete) SELECT #2007-07-31 2:14:56# AS QT,1 AS Q1 on line 250 Kan de uitvoertabel d351_DONAAT______ niet vinden.</TD></TR><TR><TD class=LOGDateTime0 noWrap align=left>31/07/2007 2:14:57 </TD><TD class=LOGType0 align=left colSpan=3>mcsTemperature </TD><TD class=LOGEntry0 align=left colSpan=8>Log_Discrete: INSERT INTO d9323_DONAAT_____ (SampleDate,Discrete) SELECT #2007-07-31 2:14:57# AS QT,0 AS Q1 on line 250 Kan de uitvoertabel d9323_DONAAT_____ niet vinden.</TD></TR><TR><TD class=LOGDateTime1 noWrap align=left>31/07/2007 2:14:58 </TD><TD class=LOGType1 align=left colSpan=3>mcsTemperature </TD><TD class=LOGEntry1 align=left colSpan=8>Log_Discrete: INSERT INTO d351_DONAAT______ (SampleDate,Discrete) SELECT #2007-07-31 2:14:58# AS QT,0 AS Q1 on line 250 Kan de uitvoertabel d351_DONAAT______ niet vinden.</TD></TR><TR><TD class=LOGDateTime0 noWrap align=left>31/07/2007 2:14:58 </TD><TD class=LOGType0 align=left colSpan=3>mcsTemperature </TD><TD class=LOGEntry0 align=left colSpan=8>Log_Discrete: INSERT INTO d9323_DONAAT_____ (SampleDate,Discrete) SELECT #2007-07-31 2:14:58# AS QT,1 AS Q1 on line 250 Kan de uitvoertabel d9323_DONAAT_____ niet vinden.</TD></TR><TR><TD class=LOGDateTime1 noWrap align=left>31/07/2007 2:14:58 </TD><TD class=LOGType1 align=left colSpan=3>mcsTemperature </TD><TD class=LOGEntry1 align=left colSpan=8>Log_Discrete: INSERT INTO d351_DONAAT______ (SampleDate,Discrete) SELECT #2007-07-31 2:14:58# AS QT,1 AS Q1 on line 250 Kan de uitvoertabel d351_DONAAT______ niet vinden.</TD></TR><TR><TD class=LOGDateTime0 noWrap align=left>31/07/2007 2:14:58 </TD><TD class=LOGType0 align=left colSpan=3>mcsTemperature </TD><TD class=LOGEntry0 align=left colSpan=8>Log_Discrete: INSERT INTO d9323_DONAAT_____ (SampleDate,Discrete) SELECT #2007-07-31 2:14:58# AS QT,0 AS Q1 on line 250 Kan de uitvoertabel d9323_DONAAT_____ niet vinden.</TD></TR><TR><TD class=LOGDateTime1 noWrap align=left>31/07/2007 2:14:58 </TD><TD class=LOGType1 align=left colSpan=3>mcsTemperature </TD><TD class=LOGEntry1 align=left colSpan=8>Log_Discrete: INSERT INTO d351_DONAAT______ (SampleDate,Discrete) SELECT #2007-07-31 2:14:58# AS QT,0 AS Q1 on line 250 Kan de uitvoertabel d351_DONAAT______ niet vinden.</TD></TR><TR><TD class=LOGDateTime0 noWrap align=left>31/07/2007 2:14:58 </TD><TD class=LOGType0 align=left colSpan=3>mcsTemperature </TD><TD class=LOGEntry0 align=left colSpan=8>Log_Discrete: INSERT INTO d9323_DONAAT_____ (SampleDate,Discrete) SELECT #2007-07-31 2:14:58# AS QT,1 AS Q1 on line 250 Kan de uitvoertabel d9323_DONAAT_____ niet vinden.</TD></TR><TR><TD class=LOGDateTime1 noWrap align=left>31/07/2007 2:14:58 </TD><TD class=LOGType1 align=left colSpan=3>mcsTemperature </TD><TD class=LOGEntry1 align=left colSpan=8>Log_Discrete: INSERT INTO d351_DONAAT______ (SampleDate,Discrete) SELECT #2007-07-31 2:14:58# AS QT,1 AS Q1 on line 250 Kan de uitvoertabel


    </TD></TR></TBODY></TABLE>
    What is here the problem?

    Thanks,

    Renaatdb

    #2
    I dont undestand the language, but it looks to me as if d9323_DONAAT_____ does not exist as a table in the database. This would correspond to virtual device \23. Look at the Sensor page for this device and confirm the database field is specified. You can also do a Save from that page to assure all fields are created in the database. Look at the HS log during the Save to see if any errors appear.

    Comment


      #3
      log descrete

      Problem solved.

      In mcsmovement setup. Record in mcstemp DB was selected for one movement sensor.

      Thanks anyway,

      Renaatdb

      Comment

      Working...
      X