abills.net.ua

/usr/abills/libexec/billd -all DEBUG=7
Debug mode 7
<pre><code>
DELETE FROM dv_calls WHERE acct_session_id in ( 'IP' );
</code></pre>
<pre><code>
SELECT c.user_name, c.nas_port_id, SEC_TO_TIME(UNIX_TIMESTAMP() - UNIX_TIMESTAMP(c.started)) AS duration, INET_NTOA(c.framed_ip_address) AS client_ip, c.acct_input_octets + 4294967296 * acct_input_gigawords AS acct_input_octets, c.acct_output_octets + 4294967296 * acct_output_gigawords AS acct_output_octets, c.ex_input_octets, c.ex_output_octets, c.CID, INET_NTOA(service.netmask) AS netmask, c.sum AS session_sum, c.tp_id AS calls_tp_id, c.status, service.tp_id, c.guest, c.join_service, UNIX_TIMESTAMP() - UNIX_TIMESTAMP(c.started) AS acct_session_time, if(c.lupdated>0, c.lupdated - UNIX_TIMESTAMP(c.started), 0) AS duration_sec, if(service.filter_id<>'', service.filter_id, tp.filter_id) AS filter_id, service.disable AS service_status, tp.bills_priority, tp.credit AS tp_credit, tp.credit_tresshold, if(u.expire>'0000-00-00' AND u.expire <= curdate(), 1, 0) AS expired, u.expire, if(service.expire>'0000-00-00' AND service.expire <= curdate(), 1, 0) AS dv_expired, service.expire AS dv_expire, INET_NTOA(service.netmask) AS netmask, service.filter_id, service.disable AS service_status, c.acct_session_id, UNIX_TIMESTAMP() - c.lupdated AS last_alive, if(company.id IS NULL, b.deposit, cb.deposit) AS deposit, u.credit, u.expire, u.disable AS login_status, c.uid,c.nas_id,c.acct_session_id
FROM dv_calls c
LEFT JOIN users u ON (u.uid=c.uid)
LEFT JOIN dv_main service ON (service.uid=u.uid)
LEFT JOIN tarif_plans tp ON (tp.id=service.tp_id AND MODULE='Dv') LEFT JOIN bills b ON (u.bill_id = b.id)
LEFT JOIN companies company ON (u.company_id=company.id)
LEFT JOIN bills cb ON (company.bill_id=cb.id)

ORDER BY 1 ;
</code></pre>
DBD::mysql::st execute failed: BIGINT UNSIGNED value is out of range in '(`abills`.`c`.`lupdated` - unix_timestamp(`abills`.`c`.`started`))' at /usr/abills/libexec/../Abills/mysql/main.pm line 190.
==> check_lines
GT: 0.09341

DBD::mysql::st execute failed: BIGINT UNSIGNED value is out of range in '(`abills`.`c`.`lupdated` - unix_timestamp(`abills`.`c`.`started`))' at /usr/abills/libexec/../Abills/mysql/main.pm line 190.

Кузьменко писал(а):Так в чому проблема?
в мене аналогічна ситуація

# ./billd
DBD::mysql::st execute failed: BIGINT UNSIGNED value is out of range in '(`abills`.`c`.`lupdated` - unix_timestamp(`abills`.`c`.`started`))' at /usr/abills/libexec/../Abills/mysql/main.pm line 156.
mikrotik

~AsmodeuS~ писал(а):

Кузьменко писал(а):Так в чому проблема?
в мене аналогічна ситуація

# ./billd
DBD::mysql::st execute failed: BIGINT UNSIGNED value is out of range in '(`abills`.`c`.`lupdated` - unix_timestamp(`abills`.`c`.`started`))' at /usr/abills/libexec/../Abills/mysql/main.pm line 156.
mikrotik

обновите до 0.56

~AsmodeuS~ писал(а):ченжлог вносите

http://abills.net.ua/wiki/doku.php/abil ... elogs:0.5x