isactive column in clients prevents statistics from loading

[Srini]

1.  I added a client and it is Active.  However there are 2 columns in the table clients: whil 'status' is 'active', the column 'isactive' = 0.

2.  The query run by the SNMP stats poller cron job is: SELECT farms.*, clients.* FROM farms INNER JOIN clients ON clients.id = farms.clientid WHERE farms.status='1' AND clients.isactive='1'

3.  This always returns 0 farms and hence there are never any statistics shown.

4.  I updated the column 'isactive' to 1 and the cron job recognizes the client and the farm.

Either the status column should be used for the where clause, or the isactive column should be set to 1.

Regards

Srini

[Srini]

Hi Scalr Dev

Any updates on this?  If what I report below is correct, this should hopefully get fixed in the next build?

Srini