Getting Numeric value out of range, but I've created it BigInt

Question

I have a table, and one of the columns is request_id, which is defined in a migration like this:

$table->bigInteger('request_id')->index()->unsigned()->nullable();

And when I look on phpmyadmin at the table structure, it says

bigint(20)      UNSIGNED

I'm making a request to my api, and sending through this value: 1562247865319

$requestLog = new RequestLog();
$requestLog->request_id = 1562247865319;
$requestLog->save();

This code is erroring and sending back Numeric value out of range: 1264 Out of range

What's really strange is that when I'm in phpmyadmin, I can manually set the value of that column to much bigger values than 1562247865319, but when I do it through my laravel model it doesn't like it.

edit

error message is

SQLSTATE[22003]: Numeric value out of range: 1264 Out of range value for column 'request_id' at row 1 (SQL: insert into `request_logs` (`ip`, `submitted_user_name`, `url`, `full_url`, `method`, `request_id`, `request_data`, `api_user_id`, `updated_at`, `created_at`) values (..., ..., ..., http://..../api/..., POST, 1562247865319, {"request_id":"1562248616206"}, 2, 2019-07-04 14:57:00, 2019-07-04 14:57:00))

Please can we ALWAYS see the full and complete error message! Not a summary of it — RiggsFolly, Jul 04 '19 at 13:50

score 0 · Answer 1 · answered Jul 04 '19 at 13:51

0

I think this issue is the same than this.

Try to change any UNSIGNED ints to SIGNED.

answered Jul 04 '19 at 13:51

Alexandre Paiva

987
2
10
24

When I changed it to signed and added it to the column, it made the value negative for some reason... – TKoL Jul 04 '19 at 13:53
Is it the same number though? – Alexandre Paiva Jul 04 '19 at 13:57
sorry, NO, it is not the same value – TKoL Jul 04 '19 at 14:15
I try to assign 1562247865319 and it's stored as -1120230425 – TKoL Jul 04 '19 at 14:16

Getting Numeric value out of range, but I've created it BigInt

1 Answers1