SQL error in models/m_devices_components.php

 
1
0
-1

Hello,

at line 1013 the SQL statement:

UPDATE system SET ip = ? WHERE id = ?

seems outdatet and gives error in my OA instance, I've fix it as follows

UPDATE ip SET ip = ? WHERE system_id = ?

is it correct?

 

Thanks for your great job.

Francesco

    CommentAdd your comment...

    2 answers

    1.  
      1
      0
      -1

      Hello Mark,

      thanks for the answer,

      My first try was the code that you have suggested, but I saw that many computers were insert without IP (it was a fresh install, with a fresh db), then I changed to

      UPDATE ip SET ip = ? WHERE system_id = ?

      Is this wrong right? Because it's working for me...

       

      1. Mark Unwin

        My $sql below is correct. {code} $sql = "UPDATE system SET man_ip_address = ? WHERE system_id = ?"; {code}

      CommentAdd your comment...
    2.  
      1
      0
      -1

      The $sql should be as below. Apologies for the inconvenience.

      $sql = "UPDATE system SET man_ip_address = ? WHERE system_id = ?";
        CommentAdd your comment...