abills.net.ua

В логах такая ошибка
BIGINT UNSIGNED value is out of range in '(0 - `abills`.`dv_calls`.`acct_input_gigawords`)'

где может быть проблема?

поправил
$db, "SELECT user_name, lupdated, UNIX_TIMESTAMP()-lupdated,
if($RAD->{INBYTE} >= acct_input_octets AND $RAD->{ACCT_INPUT_GIGAWORDS}=acct_input_gigawords,
$RAD->{INBYTE} - acct_input_octets,
4294967296-cast(acct_input_octets as SIGNED)+4294967296*($RAD->{ACCT_INPUT_GIGAWORDS}-cast(acct_input_gigawords as SIGNED)-1)+$RAD->{INBYTE}),
if($RAD->{OUTBYTE} >= acct_output_octets AND $RAD->{ACCT_OUTPUT_GIGAWORDS}=acct_output_gigawords,
$RAD->{OUTBYTE} - acct_output_octets,
4294967296-cast(acct_output_octets as SIGNED)+4294967296*($RAD->{ACCT_OUTPUT_GIGAWORDS}-cast(acct_output_gigawords as SIGNED)-1)+$RAD->{OUTBYTE}),
if($RAD->{INBYTE2} >= ex_input_octets, $RAD->{INBYTE2} - ex_input_octets, ex_input_octets),
if($RAD->{OUTBYTE2} >= ex_output_octets, $RAD->{OUTBYTE2} - ex_output_octets, ex_output_octets),
sum,
tp_id,
uid
FROM dv_calls
WHERE nas_id='$NAS->{NAS_ID}' and acct_session_id='$RAD->{ACCT_SESSION_ID}';"

ошибки прекратились

спасибо поправлено