taskGNU remotecontrol - Tasks: task #12625, Modify COUNT for Maximum #...

 
 

You are not allowed to post comments on this tracker with your current authentication level.

task #12625: Modify COUNT for Maximum # Thermostats

Submitter:  Stephen H. Dawson DSL <shdawson>
Submitted:  Tue 21 May 2013 05:53:23 PM UTC
   
 
Should Start On:  Tue 21 May 2013 04:00:00 AM UTC Should be Finished on:  Sun 23 Jun 2013 04:00:00 AM UTC
Category:  MySQL Priority:  5 - Normal
Item Group:  Operation Status:  Done
Privacy:  Public Assigned to:  None
Open/Closed:  Closed Fixed Release:  1.1
Percent Complete:  100% Planned Release:  1.1

Jump to the original submission

Sat 23 Apr 2016 04:23:53 PM UTC, comment #9: 

I bear witness and certify I have personally tested these changes made to GNU remotecontrol. I affirm the changes made to the code:
-achieve the functionality of the stated requirements;
-succeed during operation; and
-cause no anxiety.

I approve this code.


Thank you to everyone for working on this modification.


Respectfully,
SHD//
Stephen H. Dawson

Stephen H. Dawson DSL <shdawson>
Group administrator
Tue 24 Sep 2013 04:26:56 PM UTC, comment #8: 

I bear witness and certify I have personally tested these changes made to GNU remotecontrol. I affirm the changes made to the code:
-achieve the functionality of the stated requirements;
-succeed during operation; and
-cause no anxiety.

I approve this code.


Thank you to everyone for working on this modification.


Very Respectfully,
SHD//
Stephen H. Dawson

Stephen H. Dawson DSL <shdawson>
Group administrator
Sun 30 Jun 2013 11:30:18 AM UTC, comment #7: 

Please post the version of Windows and Internet Explorer you tested with this code,or if you did not test against Windows and Internet Explorer.

Stephen H. Dawson DSL <shdawson>
Group administrator
Mon 24 Jun 2013 09:52:13 PM UTC, comment #6: 

Hi,


Can you please send me the cleaned up iptstat.sql to try?


Kindly,
SHD

Stephen H. Dawson DSL <shdawson>
Group administrator
Sun 16 Jun 2013 06:04:03 AM UTC, comment #5: 

Hi Stephen, with my update it's possible to handle thousands, In the requested format. Just change your value, 255 to a bigger one. Now, in your setup appears 255 because before my update the field were handled in one byte unsigned, and every higher value were cut to it's maximun, 255. If you just update this value you'll see, also the format, after thousands, 1000 will appear as 1,000.
The type i used, for compatibility in other table on were the same field is used, is Medium Int Unsigned, this means you can handle up to 16777215

Virgilio Lino <virgiliolino>
Group Member
Sat 15 Jun 2013 09:58:39 PM UTC, comment #4: 

Hi,


Just emailed you about this. Please review data type, going for thousands and thousands of thermostats, and for display format for index.php and admin.php.

".....Also, make sure we comma-separate the Maximum # Thermostats value by thousands.

We do not want to render:
1000
54000
325000

We do want to render:
1,500
54,000
325,000....."


-SHD

Stephen H. Dawson DSL <shdawson>
Group administrator
Sat 15 Jun 2013 08:31:01 PM UTC, comment #3: 

Hi Stephen, i've done the modifications requested on this ticket. There are mostly updates on the mysql stored procedures, so it's enough to import on the database the sql i'm attaching and update the class lib/User.php. There are no modifications on data, but if you have important information on your db please make a backup before.
After this, you have to overwrite the old lib/User.php.
It should work, please tell me if there are some problems,
thanks
Virgilio

After we find everything is ok, i can attach also the initial import ipstat.sql with the updated data.

(file #28323, file #28324)

Virgilio Lino <virgiliolino>
Group Member
Fri 24 May 2013 11:18:11 AM UTC, comment #2: 

http://dev.mysql.com/doc/refman/5.6/en/integer-types.html

Let's discuss the integer type we need to modify this field with.

Stephen H. Dawson DSL <shdawson>
Group administrator
Tue 21 May 2013 05:56:32 PM UTC, comment #1: 

Also, make sure we comma-separate the Maximum # Thermostats value by thousands.


We do not want to render:
1000
54000
325000


We do want to render:
1,500
54,000
325,000

Stephen H. Dawson DSL <shdawson>
Group administrator
Tue 21 May 2013 05:53:23 PM UTC, original submission:  

This is currently set to a maximum of 127. We need to increase this so large scale deployments can use more thermostats.

Stephen H. Dawson DSL <shdawson>
Group administrator

 

(Note: upload size limit is set to 16384 kB, after insertion of the required escape characters.)

Attached Files
file #28324:  User.php added by virgiliolino (2KiB - application/x-php)

 

Depends on the following items: None found

Items that depend on this one: None found

 

Carbon-Copy List
  • -email is unavailable- added by virgiliolino (Updated the item)
  • -email is unavailable- added by shdawson (Submitted the item)
  •  

    There are 0 votes so far. Votes easily highlight which items people would like to see resolved in priority, independently of the priority of the item set by tracker managers.

     

    Follow 25 latest changes.

    Date Changed by Updated Field Previous Value => Replaced by
    2016-04-23 shdawson Open/ClosedOpen Closed
    2013-09-24 shdawson Open/ClosedClosed Open
    2013-09-24 shdawson Open/ClosedOpen Closed
    2013-09-24 shdawson Assigned tovirgiliolino None
    2013-09-24 shdawson StatusReady For Test Done
    2013-09-24 shdawson StatusDone Ready For Test
    2013-09-24 shdawson StatusNone Done
        Open/ClosedClosed Open
    2013-09-24 shdawson StatusDone None
        Open/ClosedOpen Closed
    2013-09-24 shdawson Open/ClosedClosed Open
    2013-09-24 shdawson Assigned toNone virgiliolino
    2013-09-24 shdawson Assigned toremotecontrol-published None
    2013-09-24 shdawson Assigned toNone remotecontrol-published
    2013-09-24 shdawson StatusReady For Test Done
        Assigned tovirgiliolino None
        Open/ClosedOpen Closed
        Percent Complete80% 100%
    2013-06-18 shdawson CategoryNone MySQL
    2013-06-18 shdawson Fixed ReleaseNone 1.1
    2013-06-16 shdawson Should be Finished on2013-06-30 2013-06-23
        Assigned toshdawson virgiliolino
    2013-06-15 virgiliolino Attached File- Added update_thermostats.sql, #28323
        Attached File- Added User.php, #28324
        StatusNeed Info Ready For Test

    Back to the top

    Powered by Savane 3.13-d3ae.
    Corresponding source code