This is an archived copy of the forum for reference purposes

fValidation, Maximum Integer Issue in Mysql Bigint

posted by o 10 years ago

Im using bigint in some rows in mysql. I cant submit integers more than max int value with validation to bigint rows.

I must declare bigint integer is string in validation class. Do you have a different solution for this problem ?

Are you using fActiveRecord, or just fDatabase? Did you ever figure out if anything was casting the bigint to regular ints?

To my knowledge, fDatabase doesn't cast integer or float values, specifically to prevent issues with them being outside the range of 32bit OSes. I can't think of anything that should be casting these bigints to integers instead of strings.

posted by wbond 10 years ago

Im debugged this issue. Im using only fDatabase.

fRequest makes this problem. fRequest::get('phone', 'integer') casts to maximum integer. and it sends maximum int val to database.

posted by o 10 years ago

Thanks for the report - I'm adding a ticket right now to make sure this gets fixed - sorry for the delay

posted by wbond 9 years ago