Page 2 of 2

Re: Function with MAX bugs

Posted: 06 May 2018, 18:47
by fahmisalim
fahmisalim wrote:Hi sergey,

Please see my attachment, in field_191 I put data from number 1 to number 15 and in the other field I'm using a function Max to show highest value from field_191 and the highest value show number 9 not 15. Its should be 15
Screen Shot 2018-05-06 at 21.44.23.png
I try to make SQL from PHPmyadmin, and the result is 9 please see attachment below
Screen Shot 2018-05-06 at 21.44.23.png
what is something wrong with my data?

Re: Function with MAX bugs

Posted: 06 May 2018, 18:55
by support
Which mysql type field 191 is used? TEXT or Varchar?

Re: Function with MAX bugs

Posted: 06 May 2018, 19:01
by fahmisalim
support wrote:Which mysql type field 191 is used? TEXT or Varchar?
VARCHAR

Re: Function with MAX bugs

Posted: 06 May 2018, 19:04
by support
Ok, I think I have found issue. Replace attached file to plugins\ext\classes\
Let me know if it fixed.

Re: Function with MAX bugs

Posted: 06 May 2018, 19:13
by fahmisalim
Yes its works!!

Thanks sergey