bggann
Active Member
I'm using the time plugin (field) extensively in my aviation forms - and sometimes (intermittent) it stores the "hours" as "seconds" in the database. This seems to only happen on one form/group/field.
This plugin stores time as a string "hh:mm:ss" and in the failed cases it is storing "00:00:hh"
In all cases, I'm setting the format for list and for details as 'hh:mm' meaning I do not enter or record seconds.
Recording to 15 minute increment
Separator ":"
24 hr dropdown
Enhance Dropdown no
All other things are default.
In one case, it seems to be working fine.
In a second case (same element, but in different group and NOT child) it is, sometimes, recording the "hours" as "seconds" in the database.
I'm calculating (ajax and on save) the number of hours between times - and that is correct, so at AJAX and on save, they are correct. Otherwise I could not calculate based on them. But, if you look at the database (php admin), the data is stored correctly.
For example:
Start time: "10:00:00"
Stop time: "00:00:00" <- midnight
Hours: 14 <- correct, 10am to midnight is 14 hours.
In the database is stored
Start Time: "00:00:10"
Stop Time: "00:00:00"
Hours: 14
Note - the hours in the database is correct. So the calculation I do for hours is working - which means the data I get from the placeholders is correct. (I parse the string).
This is working on one instance of the time plugin, but not the other (in a different group).
The names of the working are the same, but they are not parent/child.
-Bob
This plugin stores time as a string "hh:mm:ss" and in the failed cases it is storing "00:00:hh"
In all cases, I'm setting the format for list and for details as 'hh:mm' meaning I do not enter or record seconds.
Recording to 15 minute increment
Separator ":"
24 hr dropdown
Enhance Dropdown no
All other things are default.
In one case, it seems to be working fine.
In a second case (same element, but in different group and NOT child) it is, sometimes, recording the "hours" as "seconds" in the database.
I'm calculating (ajax and on save) the number of hours between times - and that is correct, so at AJAX and on save, they are correct. Otherwise I could not calculate based on them. But, if you look at the database (php admin), the data is stored correctly.
For example:
Start time: "10:00:00"
Stop time: "00:00:00" <- midnight
Hours: 14 <- correct, 10am to midnight is 14 hours.
In the database is stored
Start Time: "00:00:10"
Stop Time: "00:00:00"
Hours: 14
Note - the hours in the database is correct. So the calculation I do for hours is working - which means the data I get from the placeholders is correct. (I parse the string).
This is working on one instance of the time plugin, but not the other (in a different group).
The names of the working are the same, but they are not parent/child.
-Bob