MySQL really unexpected error. BIGINT out of range

Question

I have this kinda complicated query that is well explained in this question. I haven't changed anything in the query or anything relating to this system , however I suddenly started getting this error

BIGINT UNSIGNED value is out of range in '(_db.ads.impressions_total - (cast(((curdate()) - cast(_db.ads.start as date)) as unsigned) * _db.ads.impressions_perday))'

I'm really confused, I guess something is not caching right but what can I do? I really need help..

What you need to do is go and learn about [integer ranges in MySQL](http://dev.mysql.com/doc/refman/5.0/en/integer-types.html) or do some research instead of lazily posting this question here — Bojangles, Aug 31 '13 at 21:38
So I changed it to signed as suggested in the question from the first comment, but I still get the error — php_nub_qq, Aug 31 '13 at 21:46

score 1 · Accepted Answer · answered Aug 31 '13 at 21:53

1

This appears to be your

(_db.ads.impressions_total - (cast(((curdate()) - cast(_db.ads.start as date)) as unsigned) * _db.ads.impressions_perday

The proper way to get the difference between two dates is to use datediff(). So I wonder if this will solve your problem:

_db.ads.impressions_total - datediff(curdate(), cast(_db.ads.start as date))*_db.ads.impressions_per_day

answered Aug 31 '13 at 21:53

Gordon Linoff

1,242,037
58
646
786

Not only did solve my problem, but I believe simplified the query a great lot! – php_nub_qq Aug 31 '13 at 21:58

MySQL really unexpected error. BIGINT out of range

1 Answers1