Saturday, 31 August 2013

MySQL really unexpected error. BIGINT out of range

MySQL really unexpected error. BIGINT out of range

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..

No comments:

Post a Comment