Не передаются атрибуты шейпера accel-ppp
Re: Не передаются атрибуты шейпера accel-ppp
А в /tmp/sql_error ничего нет?
Re: Не передаются атрибуты шейпера accel-ppp
Есть чета но вроде не связано с интервалами.
Код: Выделить всё
2014-11-05 16:39:25 LOG_ERR: []
SELECT at.id,
at.name,
if(ul.comments <> '', ul.comments, '') AS comments,
at.price,
at.period,
sum(ul.service_count) AS service_count,
max(ul.date) AS date,
if (at.nonfix_period = 1,
if (at.period = 0, ul.date+ INTERVAL 1 DAY,
if (at.period = 1, ul.date + INTERVAL 1 MONTH,
if (at.period = 2, ul.date + INTERVAL 3 MONTH,
if (at.period = 3, ul.date + INTERVAL 6 MONTH,
if (at.period = 4, ul.date + INTERVAL 1 YEAR,
'-'
)
)
)
)
),
@next_abon := if (at.period = 0, ul.date+ INTERVAL 1 DAY,
if (at.period = 1, DATE_FORMAT(ul.date + INTERVAL 1 MONTH, '%Y-%m-01'),
if (at.period = 2, CONCAT(YEAR(ul.date + INTERVAL 3 MONTH), '-' ,(QUARTER((ul.date + INTERVAL 3 MONTH))*3-2), '-01'),
if (at.period = 3, CONCAT(YEAR(ul.date + INTERVAL 6 MONTH), '-', if(MONTH(ul.date + INTERVAL 6 MONTH) > 6, '06', '01'), '-01'),
if (at.period = 4, DATE_FORMAT(ul.date + INTERVAL 1 YEAR, '%Y-01-01'),
'-'
)
)
)
)
)
) AS next_abon,
ul.manual_fee,
max(ul.discount) AS discount,
count(ul.uid) AS active_service,
ul.notification1,
ul.notification1_account_id,
ul.notification2,
ul.create_docs,
ul.send_docs,
at.manual_activate,
if (@next_abon < curdate(), 1, 0) AS missing
FROM abon_tariffs at
LEFT JOIN abon_user_list ul ON (at.id=ul.tp_id and ul.uid='139')
WHERE at.domain_id='0'
GROUP BY at.id
ORDER BY c.framed_ip_address+0 ;
--1054
--Unknown column 'c.framed_ip_address' in 'order clause'
--AutoCommit: 1
2014-11-05 18:58:52 LOG_ERR: []
SELECT at.id,
at.name,
if(ul.comments <> '', ul.comments, '') AS comments,
at.price,
at.period,
sum(ul.service_count) AS service_count,
max(ul.date) AS date,
if (at.nonfix_period = 1,
if (at.period = 0, ul.date+ INTERVAL 1 DAY,
if (at.period = 1, ul.date + INTERVAL 1 MONTH,
if (at.period = 2, ul.date + INTERVAL 3 MONTH,
if (at.period = 3, ul.date + INTERVAL 6 MONTH,
if (at.period = 4, ul.date + INTERVAL 1 YEAR,
'-'
)
)
)
)
),
@next_abon := if (at.period = 0, ul.date+ INTERVAL 1 DAY,
if (at.period = 1, DATE_FORMAT(ul.date + INTERVAL 1 MONTH, '%Y-%m-01'),
if (at.period = 2, CONCAT(YEAR(ul.date + INTERVAL 3 MONTH), '-' ,(QUARTER((ul.date + INTERVAL 3 MONTH))*3-2), '-01'),
if (at.period = 3, CONCAT(YEAR(ul.date + INTERVAL 6 MONTH), '-', if(MONTH(ul.date + INTERVAL 6 MONTH) > 6, '06', '01'), '-01'),
if (at.period = 4, DATE_FORMAT(ul.date + INTERVAL 1 YEAR, '%Y-01-01'),
'-'
)
)
)
)
)
) AS next_abon,
ul.manual_fee,
max(ul.discount) AS discount,
count(ul.uid) AS active_service,
ul.notification1,
ul.notification1_account_id,
ul.notification2,
ul.create_docs,
ul.send_docs,
at.manual_activate,
if (@next_abon < curdate(), 1, 0) AS missing
FROM abon_tariffs at
LEFT JOIN abon_user_list ul ON (at.id=ul.tp_id and ul.uid='102')
WHERE at.domain_id='0'
GROUP BY at.id
ORDER BY c.framed_ip_address+0 ;
--1054
--Unknown column 'c.framed_ip_address' in 'order clause'
--AutoCommit: 1
2014-11-05 18:58:52 LOG_ERR: []
SELECT at.id,
at.name,
if(ul.comments <> '', ul.comments, '') AS comments,
at.price,
at.period,
sum(ul.service_count) AS service_count,
max(ul.date) AS date,
if (at.nonfix_period = 1,
if (at.period = 0, ul.date+ INTERVAL 1 DAY,
if (at.period = 1, ul.date + INTERVAL 1 MONTH,
if (at.period = 2, ul.date + INTERVAL 3 MONTH,
if (at.period = 3, ul.date + INTERVAL 6 MONTH,
if (at.period = 4, ul.date + INTERVAL 1 YEAR,
'-'
)
)
)
)
),
@next_abon := if (at.period = 0, ul.date+ INTERVAL 1 DAY,
if (at.period = 1, DATE_FORMAT(ul.date + INTERVAL 1 MONTH, '%Y-%m-01'),
if (at.period = 2, CONCAT(YEAR(ul.date + INTERVAL 3 MONTH), '-' ,(QUARTER((ul.date + INTERVAL 3 MONTH))*3-2), '-01'),
if (at.period = 3, CONCAT(YEAR(ul.date + INTERVAL 6 MONTH), '-', if(MONTH(ul.date + INTERVAL 6 MONTH) > 6, '06', '01'), '-01'),
if (at.period = 4, DATE_FORMAT(ul.date + INTERVAL 1 YEAR, '%Y-01-01'),
'-'
)
)
)
)
)
) AS next_abon,
ul.manual_fee,
max(ul.discount) AS discount,
count(ul.uid) AS active_service,
ul.notification1,
ul.notification1_account_id,
ul.notification2,
ul.create_docs,
ul.send_docs,
at.manual_activate,
if (@next_abon < curdate(), 1, 0) AS missing
FROM abon_tariffs at
LEFT JOIN abon_user_list ul ON (at.id=ul.tp_id and ul.uid='102')
WHERE at.domain_id='0'
GROUP BY at.id
ORDER BY c.framed_ip_address+0 ;
--1054
--Unknown column 'c.framed_ip_address' in 'order clause'
--AutoCommit: 1
2014-11-05 18:58:52 LOG_ERR: []
SELECT at.id,
at.name,
if(ul.comments <> '', ul.comments, '') AS comments,
at.price,
at.period,
sum(ul.service_count) AS service_count,
max(ul.date) AS date,
if (at.nonfix_period = 1,
if (at.period = 0, ul.date+ INTERVAL 1 DAY,
if (at.period = 1, ul.date + INTERVAL 1 MONTH,
if (at.period = 2, ul.date + INTERVAL 3 MONTH,
if (at.period = 3, ul.date + INTERVAL 6 MONTH,
if (at.period = 4, ul.date + INTERVAL 1 YEAR,
'-'
)
)
)
)
),
@next_abon := if (at.period = 0, ul.date+ INTERVAL 1 DAY,
if (at.period = 1, DATE_FORMAT(ul.date + INTERVAL 1 MONTH, '%Y-%m-01'),
if (at.period = 2, CONCAT(YEAR(ul.date + INTERVAL 3 MONTH), '-' ,(QUARTER((ul.date + INTERVAL 3 MONTH))*3-2), '-01'),
if (at.period = 3, CONCAT(YEAR(ul.date + INTERVAL 6 MONTH), '-', if(MONTH(ul.date + INTERVAL 6 MONTH) > 6, '06', '01'), '-01'),
if (at.period = 4, DATE_FORMAT(ul.date + INTERVAL 1 YEAR, '%Y-01-01'),
'-'
)
)
)
)
)
) AS next_abon,
ul.manual_fee,
max(ul.discount) AS discount,
count(ul.uid) AS active_service,
ul.notification1,
ul.notification1_account_id,
ul.notification2,
ul.create_docs,
ul.send_docs,
at.manual_activate,
if (@next_abon < curdate(), 1, 0) AS missing
FROM abon_tariffs at
LEFT JOIN abon_user_list ul ON (at.id=ul.tp_id and ul.uid='102')
WHERE at.domain_id='0'
GROUP BY at.id
ORDER BY c.framed_ip_address+0 ;
--1054
--Unknown column 'c.framed_ip_address' in 'order clause'
--AutoCommit: 1
2014-11-05 18:59:51 LOG_ERR: []
SELECT at.id,
at.name,
if(ul.comments <> '', ul.comments, '') AS comments,
at.price,
at.period,
sum(ul.service_count) AS service_count,
max(ul.date) AS date,
if (at.nonfix_period = 1,
if (at.period = 0, ul.date+ INTERVAL 1 DAY,
if (at.period = 1, ul.date + INTERVAL 1 MONTH,
if (at.period = 2, ul.date + INTERVAL 3 MONTH,
if (at.period = 3, ul.date + INTERVAL 6 MONTH,
if (at.period = 4, ul.date + INTERVAL 1 YEAR,
'-'
)
)
)
)
),
@next_abon := if (at.period = 0, ul.date+ INTERVAL 1 DAY,
if (at.period = 1, DATE_FORMAT(ul.date + INTERVAL 1 MONTH, '%Y-%m-01'),
if (at.period = 2, CONCAT(YEAR(ul.date + INTERVAL 3 MONTH), '-' ,(QUARTER((ul.date + INTERVAL 3 MONTH))*3-2), '-01'),
if (at.period = 3, CONCAT(YEAR(ul.date + INTERVAL 6 MONTH), '-', if(MONTH(ul.date + INTERVAL 6 MONTH) > 6, '06', '01'), '-01'),
if (at.period = 4, DATE_FORMAT(ul.date + INTERVAL 1 YEAR, '%Y-01-01'),
'-'
)
)
)
)
)
) AS next_abon,
ul.manual_fee,
max(ul.discount) AS discount,
count(ul.uid) AS active_service,
ul.notification1,
ul.notification1_account_id,
ul.notification2,
ul.create_docs,
ul.send_docs,
at.manual_activate,
if (@next_abon < curdate(), 1, 0) AS missing
FROM abon_tariffs at
LEFT JOIN abon_user_list ul ON (at.id=ul.tp_id and ul.uid='102')
WHERE at.domain_id='0'
GROUP BY at.id
ORDER BY c.framed_ip_address+0 ;
--1054
--Unknown column 'c.framed_ip_address' in 'order clause'
--AutoCommit: 1
2014-11-05 19:19:46 LOG_ERR: []
SELECT at.id,
at.name,
if(ul.comments <> '', ul.comments, '') AS comments,
at.price,
at.period,
sum(ul.service_count) AS service_count,
max(ul.date) AS date,
if (at.nonfix_period = 1,
if (at.period = 0, ul.date+ INTERVAL 1 DAY,
if (at.period = 1, ul.date + INTERVAL 1 MONTH,
if (at.period = 2, ul.date + INTERVAL 3 MONTH,
if (at.period = 3, ul.date + INTERVAL 6 MONTH,
if (at.period = 4, ul.date + INTERVAL 1 YEAR,
'-'
)
)
)
)
),
@next_abon := if (at.period = 0, ul.date+ INTERVAL 1 DAY,
if (at.period = 1, DATE_FORMAT(ul.date + INTERVAL 1 MONTH, '%Y-%m-01'),
if (at.period = 2, CONCAT(YEAR(ul.date + INTERVAL 3 MONTH), '-' ,(QUARTER((ul.date + INTERVAL 3 MONTH))*3-2), '-01'),
if (at.period = 3, CONCAT(YEAR(ul.date + INTERVAL 6 MONTH), '-', if(MONTH(ul.date + INTERVAL 6 MONTH) > 6, '06', '01'), '-01'),
if (at.period = 4, DATE_FORMAT(ul.date + INTERVAL 1 YEAR, '%Y-01-01'),
'-'
)
)
)
)
)
) AS next_abon,
ul.manual_fee,
max(ul.discount) AS discount,
count(ul.uid) AS active_service,
ul.notification1,
ul.notification1_account_id,
ul.notification2,
ul.create_docs,
ul.send_docs,
at.manual_activate,
if (@next_abon < curdate(), 1, 0) AS missing
FROM abon_tariffs at
LEFT JOIN abon_user_list ul ON (at.id=ul.tp_id and ul.uid='102')
WHERE at.domain_id='0'
GROUP BY at.id
ORDER BY c.framed_ip_address+0 ;
--1054
--Unknown column 'c.framed_ip_address' in 'order clause'
--AutoCommit: 1
2014-11-05 19:19:46 LOG_ERR: []
SELECT at.id,
at.name,
if(ul.comments <> '', ul.comments, '') AS comments,
at.price,
at.period,
sum(ul.service_count) AS service_count,
max(ul.date) AS date,
if (at.nonfix_period = 1,
if (at.period = 0, ul.date+ INTERVAL 1 DAY,
if (at.period = 1, ul.date + INTERVAL 1 MONTH,
if (at.period = 2, ul.date + INTERVAL 3 MONTH,
if (at.period = 3, ul.date + INTERVAL 6 MONTH,
if (at.period = 4, ul.date + INTERVAL 1 YEAR,
'-'
)
)
)
)
),
@next_abon := if (at.period = 0, ul.date+ INTERVAL 1 DAY,
if (at.period = 1, DATE_FORMAT(ul.date + INTERVAL 1 MONTH, '%Y-%m-01'),
if (at.period = 2, CONCAT(YEAR(ul.date + INTERVAL 3 MONTH), '-' ,(QUARTER((ul.date + INTERVAL 3 MONTH))*3-2), '-01'),
if (at.period = 3, CONCAT(YEAR(ul.date + INTERVAL 6 MONTH), '-', if(MONTH(ul.date + INTERVAL 6 MONTH) > 6, '06', '01'), '-01'),
if (at.period = 4, DATE_FORMAT(ul.date + INTERVAL 1 YEAR, '%Y-01-01'),
'-'
)
)
)
)
)
) AS next_abon,
ul.manual_fee,
max(ul.discount) AS discount,
count(ul.uid) AS active_service,
ul.notification1,
ul.notification1_account_id,
ul.notification2,
ul.create_docs,
ul.send_docs,
at.manual_activate,
if (@next_abon < curdate(), 1, 0) AS missing
FROM abon_tariffs at
LEFT JOIN abon_user_list ul ON (at.id=ul.tp_id and ul.uid='102')
WHERE at.domain_id='0'
GROUP BY at.id
ORDER BY c.framed_ip_address+0 ;
--1054
--Unknown column 'c.framed_ip_address' in 'order clause'
--AutoCommit: 1
2014-11-10 05:44:37 LOG_ERR: []
SELECT at.id,
at.name,
if(ul.comments <> '', ul.comments, '') AS comments,
at.price,
at.period,
sum(ul.service_count) AS service_count,
max(ul.date) AS date,
if (at.nonfix_period = 1,
if (at.period = 0, ul.date+ INTERVAL 1 DAY,
if (at.period = 1, ul.date + INTERVAL 1 MONTH,
if (at.period = 2, ul.date + INTERVAL 3 MONTH,
if (at.period = 3, ul.date + INTERVAL 6 MONTH,
if (at.period = 4, ul.date + INTERVAL 1 YEAR,
'-'
)
)
)
)
),
@next_abon := if (at.period = 0, ul.date+ INTERVAL 1 DAY,
if (at.period = 1, DATE_FORMAT(ul.date + INTERVAL 1 MONTH, '%Y-%m-01'),
if (at.period = 2, CONCAT(YEAR(ul.date + INTERVAL 3 MONTH), '-' ,(QUARTER((ul.date + INTERVAL 3 MONTH))*3-2), '-01'),
if (at.period = 3, CONCAT(YEAR(ul.date + INTERVAL 6 MONTH), '-', if(MONTH(ul.date + INTERVAL 6 MONTH) > 6, '06', '01'), '-01'),
if (at.period = 4, DATE_FORMAT(ul.date + INTERVAL 1 YEAR, '%Y-01-01'),
'-'
)
)
)
)
)
) AS next_abon,
ul.manual_fee,
max(ul.discount) AS discount,
count(ul.uid) AS active_service,
ul.notification1,
ul.notification1_account_id,
ul.notification2,
ul.create_docs,
ul.send_docs,
at.manual_activate,
if (@next_abon < curdate(), 1, 0) AS missing
FROM abon_tariffs at
LEFT JOIN abon_user_list ul ON (at.id=ul.tp_id and ul.uid='223')
WHERE at.domain_id='0'
GROUP BY at.id
ORDER BY c.framed_ip_address+0 ;
--1054
--Unknown column 'c.framed_ip_address' in 'order clause'
--AutoCommit: 1
2014-11-16 16:55:12 LOG_ERR: []
SELECT at.id,
at.name,
if(ul.comments <> '', ul.comments, '') AS comments,
at.price,
at.period,
sum(ul.service_count) AS service_count,
max(ul.date) AS date,
if (at.nonfix_period = 1,
if (at.period = 0, ul.date+ INTERVAL 1 DAY,
if (at.period = 1, ul.date + INTERVAL 1 MONTH,
if (at.period = 2, ul.date + INTERVAL 3 MONTH,
if (at.period = 3, ul.date + INTERVAL 6 MONTH,
if (at.period = 4, ul.date + INTERVAL 1 YEAR,
'-'
)
)
)
)
),
@next_abon := if (at.period = 0, ul.date+ INTERVAL 1 DAY,
if (at.period = 1, DATE_FORMAT(ul.date + INTERVAL 1 MONTH, '%Y-%m-01'),
if (at.period = 2, CONCAT(YEAR(ul.date + INTERVAL 3 MONTH), '-' ,(QUARTER((ul.date + INTERVAL 3 MONTH))*3-2), '-01'),
if (at.period = 3, CONCAT(YEAR(ul.date + INTERVAL 6 MONTH), '-', if(MONTH(ul.date + INTERVAL 6 MONTH) > 6, '06', '01'), '-01'),
if (at.period = 4, DATE_FORMAT(ul.date + INTERVAL 1 YEAR, '%Y-01-01'),
'-'
)
)
)
)
)
) AS next_abon,
ul.manual_fee,
max(ul.discount) AS discount,
count(ul.uid) AS active_service,
ul.notification1,
ul.notification1_account_id,
ul.notification2,
ul.create_docs,
ul.send_docs,
at.manual_activate,
if (@next_abon < curdate(), 1, 0) AS missing
FROM abon_tariffs at
LEFT JOIN abon_user_list ul ON (at.id=ul.tp_id and ul.uid='28')
WHERE at.domain_id='0'
GROUP BY at.id
ORDER BY c.framed_ip_address+0 ;
--1054
--Unknown column 'c.framed_ip_address' in 'order clause'
--AutoCommit: 1
-
- Site Admin
- Сообщения: 5746
- Зарегистрирован: Пт янв 28, 2005 3:11 pm
- Контактная информация:
Re: Не передаются атрибуты шейпера accel-ppp
тип сервера доступа проверте
скорее всего вы его изменили на дефалтный
скорее всего вы его изменили на дефалтный
Re: Не передаются атрибуты шейпера accel-ppp
Да нет же
- Вложения
-
- scrn.jpg (39.79 КБ) 10676 просмотров
-
- Site Admin
- Сообщения: 5746
- Зарегистрирован: Пт янв 28, 2005 3:11 pm
- Контактная информация:
Re: Не передаются атрибуты шейпера accel-ppp
проверил на тестовом все хорошо, нужно смотреть у Вас на месте что сделано
Re: Не передаются атрибуты шейпера accel-ppp
Что посоветуете? Может глянете?
-
- Site Admin
- Сообщения: 5746
- Зарегистрирован: Пт янв 28, 2005 3:11 pm
- Контактная информация:
Re: Не передаются атрибуты шейпера accel-ppp
пишите в саппорт будем смотретьfet4 писал(а):Что посоветуете? Может глянете?
Re: Не передаются атрибуты шейпера accel-ppp
Проблема решилась обновлением системы.