AppGini Community Forums

Very strange issue.... (in Appgini 5.12)
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?

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!

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

Great! Glad to hear you got it running!

Best,
Jan