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?
Stuck field values
Re: Stuck field values
Hi, just ideas:
Jan
PS: Limits of integer datatypes in MySQL:
https://dev.mysql.com/doc/refman/8.0/en ... types.html
Hope this helps!
- 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!
- Is there any server-side validation (for example PHP-code returning FALSE in before...() method)?
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
AppGini 24.10 Revision 1579 + all AppGini Helper tools
<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 readabilityAppGini 24.10 Revision 1579 + all AppGini Helper tools
Re: Stuck field values
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
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
Re: Stuck field values
Great! Glad to hear you got it running!
Best,
Jan
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
AppGini 24.10 Revision 1579 + all AppGini Helper tools
<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 readabilityAppGini 24.10 Revision 1579 + all AppGini Helper tools