abills-error.log:
Код: Выделить всё
[Wed Mar 05 18:48:59 2014] [error] [client xx.xxx.xxx.xx] DBD::mysql::st execute failed: Unknown column '10' in 'order clause' at ../../Abills/mysql//main.pm line 190., referer: https://Код: Выделить всё
[Fri Mar 07 11:58:05 2014] [error] [client xx.xxx.xxx.xx] DBD::mysql::st execute failed: Unknown column '9' in 'order clause' at ../../Abills/mysql//main.pm line 190., referer: https://Код: Выделить всё
2014-03-07 11:58:05 LOG_ERR: []
SELECT n.id AS nas_id,
n.name AS nas_name, n.ip AS nas_ip, n.nas_type,
sum(if (c.status=1 or c.status>=3, 1, 0)) AS nas_total_sessions,
count(distinct c.uid) AS nas_total_users,
sum(if (c.status=2, 1, 0)) AS nas_zaped,
sum(if (c.status>3, 1, 0)) AS nas_error_sessions
FROM dv_calls c
INNER JOIN nas n ON (c.nas_id=n.id)
GROUP BY c.nas_id
ORDER BY 9 DESC;
--1054
--Unknown column '9' in 'order clause'
--AutoCommit: 1