Announcement

Collapse
No announcement yet.

Problem with missing devices / associations in 5.15.7.0

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

    Problem with missing devices / associations in 5.15.7.0

    I installed 5.15.7.0 tonight and now I am missing devices / associations. Please see the attached screenshots. I reverted back to a previous database file with no luck. I checked the db integrity with db browswer for sql lite and the file checks out and I can see entries in the database that show records for devices beyond number 532.
    Attached Files

    #2
    There are multiple days of backup mcsMQTT.db created. The one you are showing has no topics for 530, 531 or 532 and of course the Accept checkbox is unchecked. The HS4 updater has 5.15.11.0 available. Since you are installing more recent version I suggest using 5.15.11.0. There were some issues with initialization after the Broadlink support was added in the prior version.

    Comment


      #3
      I am updating to 5.15.11.0 now. I have devices with ID's in the 800's so it is odd that nothing past the 530's was showing even though the paging buttons showed many more pages available.

      Originally posted by Michael McSharry View Post
      There are multiple days of backup mcsMQTT.db created. The one you are showing has no topics for 530, 531 or 532 and of course the Accept checkbox is unchecked. The HS4 updater has 5.15.11.0 available. Since you are installing more recent version I suggest using 5.15.11.0. There were some issues with initialization after the Broadlink support was added in the prior version.

      Comment


        #4
        Same problem after upgrading. No devices past the 530's are showing. Notice (1) how only 2 are showing for the 2nd page and none are showing thereafter?
        Attached Files

        Comment


          #5
          The associations come from the database so changing plugin version will not affect it. To get them back you need to go to an earlier version of the database. Working with most current plugin version is still preferred.

          Comment


            #6
            Originally posted by Michael McSharry View Post
            The associations come from the database so changing plugin version will not affect it. To get them back you need to go to an earlier version of the database. Working with most current plugin version is still preferred.
            Michael, I checked 10 known good copies of the database back more than 3 years and not a single one behaves any differently. What I do know is that prior to updating to the newest builds from 5.3.x.x (I think that is correct), this behavior is exactly the same across all known good copies of the database. I believe that something in the new builds is causing this. FYI, when I view the database using db browser for SQL Lite, I see the devices associations for device ID's up to the 800's.

            Comment


              #7
              I restored back to 5.3.0.4 and the problem is gone. Something in the new builds doesn't like my database.

              Comment


                #8
                email your database to mcsSolutions at centurytel dot net. The excerpt you are showing in #1 does not have device 530 as an associated device.

                Comment


                  #9
                  Originally posted by Michael McSharry View Post
                  email your database to mcsSolutions at centurytel dot net. The excerpt you are showing in #1 does not have device 530 as an associated device.
                  Email with attached file sent.

                  Comment


                    #10
                    Originally posted by Michael McSharry View Post
                    email your database to mcsSolutions at centurytel dot net. The excerpt you are showing in #1 does not have device 530 as an associated device.
                    FYI, numerous associated devices above the 520's are missing. Oddly, if I filter on those devices specifically, they show up in the listing. However, if I do not filter, the listing stops as demonstrated.

                    Comment


                      #11
                      Never did see an email with an attachment. Also looked on the email server of my ISP and not there either. The email address is correct with "at" replaced by @ and "dot" replaced with period (.)

                      5.3 came out about the time the HS4 version of the plugin was being introduced and transition to Device/Feature relationship was being introduced to the plugin so it operated the same under HS3 and HS4. This is the most likely area that affects what you are seeing. Since that time the pluign tries to create both a parent Device and child Feature for each associated topic. The mcsMQTT debug file and the HS log file could have information about device associations missing or similar.

                      To really reproduce the behavior the HS devices and the plugin topics will be needed. The devices are in Data\HomeSeerData.json\devices.json and the topics are in \Data\mcsMQTT\mcsMQTT.db. The filtering for display on MQTT page is contained in \Config\mcsMQTT.ini

                      Comment

                      Working...
                      X