Stuck field values

If you're a new user of AppGini, feel free to ask general usage questions, or look for answers here.
Post Reply
mhugh
Posts: 6
Joined: 2019-01-02 20:26

Stuck field values

Post by mhugh » 2019-01-22 13:45

Very strange issue.... (in Appgini 5.12)
Screenshot (1).png
Screenshot (1).png (36.79 KiB) Viewed 1630 times
In screenshot above, the values in the Length field for entries ID 1 & 3 (Clearwater & Whiterock) cannot be changed. Entering a new value and 'save changes' has no effect and the field continues to show the original value.

Worse than that, the Length value for Clearwater did actually change....to the Length value of Whiterock!! So both those length values are stuck on 65535 and won't budge! Other fields such as Alt(itude) and V.range are responsive to changing and saving. All the fields for entry ID 2, Blackrock, are responsive and save correctly.

Weird! The Length values for Clearwater and Whiterock are somehow misbehaving. :?

Any ideas?

User avatar
jsetzer
AppGini Super Hero
AppGini Super Hero
Posts: 1807
Joined: 2018-07-06 06:03
Location: Kiel, Germany
Contact:

Re: Stuck field values

Post by jsetzer » 2019-01-22 15:15

Hi, just ideas:
  1. What is the datatype of those misbehaving fields? Looks like there is an upper limit of 2^16 = 65536. Could it be unsigned small int in MySQL? Try unsigned integer instead!
  2. Is there any server-side validation (for example PHP-code returning FALSE in before...() method)?
Best regards,
Jan

PS: Limits of integer datatypes in MySQL:
https://dev.mysql.com/doc/refman/8.0/en ... types.html
Hope this helps!
Kind regards,
<js />

My AppGini Blog:
https://appgini.bizzworxx.de/blog

You can help us helping you:
Please always put code fragments inside [code]...[/code] blocks for better readability

AppGini 24.10 Revision 1579 + all AppGini Helper tools

mhugh
Posts: 6
Joined: 2019-01-02 20:26

Re: Stuck field values

Post by mhugh » 2019-01-22 16:39

Hi Jan, thanks for response.

They were SMALL INT, yes. I've changed them all to INT and lo behold it works! :)

Thanks! I guess I need to go and do some read up on what all these datatypes mean, what they do, and when to use them! I'm getting there...slowly. ;)

cheers

User avatar
jsetzer
AppGini Super Hero
AppGini Super Hero
Posts: 1807
Joined: 2018-07-06 06:03
Location: Kiel, Germany
Contact:

Re: Stuck field values

Post by jsetzer » 2019-01-22 17:19

:D Great! Glad to hear you got it running!

Best,
Jan
Kind regards,
<js />

My AppGini Blog:
https://appgini.bizzworxx.de/blog

You can help us helping you:
Please always put code fragments inside [code]...[/code] blocks for better readability

AppGini 24.10 Revision 1579 + all AppGini Helper tools

Post Reply