Не передаются атрибуты шейпера accel-ppp

Установка, настройка, поддержка
Ответить
dimka88
Сообщения: 14
Зарегистрирован: Вт фев 25, 2014 8:38 am

Re: Не передаются атрибуты шейпера accel-ppp

Сообщение dimka88 »

А в /tmp/sql_error ничего нет?
Вернуться к началу
fet4
Сообщения: 133
Зарегистрирован: Пт мар 04, 2011 10:25 am

Re: Не передаются атрибуты шейпера accel-ppp

Сообщение fet4 »

Есть чета но вроде не связано с интервалами.

Код: Выделить всё

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
Вернуться к началу
~AsmodeuS~
Site Admin
Сообщения: 5746
Зарегистрирован: Пт янв 28, 2005 3:11 pm
Контактная информация:
Контактная информация пользователя ~AsmodeuS~

Re: Не передаются атрибуты шейпера accel-ppp

Сообщение ~AsmodeuS~ »

тип сервера доступа проверте
скорее всего вы его изменили на дефалтный
Вернуться к началу
fet4
Сообщения: 133
Зарегистрирован: Пт мар 04, 2011 10:25 am

Re: Не передаются атрибуты шейпера accel-ppp

Сообщение fet4 »

Да нет же :(
Вложения
scrn.jpg
scrn.jpg (39.79 КБ) 10664 просмотра
Вернуться к началу
~AsmodeuS~
Site Admin
Сообщения: 5746
Зарегистрирован: Пт янв 28, 2005 3:11 pm
Контактная информация:
Контактная информация пользователя ~AsmodeuS~

Re: Не передаются атрибуты шейпера accel-ppp

Сообщение ~AsmodeuS~ »

проверил на тестовом все хорошо, нужно смотреть у Вас на месте что сделано
Вернуться к началу
fet4
Сообщения: 133
Зарегистрирован: Пт мар 04, 2011 10:25 am

Re: Не передаются атрибуты шейпера accel-ppp

Сообщение fet4 »

Что посоветуете? Может глянете?
Вернуться к началу
~AsmodeuS~
Site Admin
Сообщения: 5746
Зарегистрирован: Пт янв 28, 2005 3:11 pm
Контактная информация:
Контактная информация пользователя ~AsmodeuS~

Re: Не передаются атрибуты шейпера accel-ppp

Сообщение ~AsmodeuS~ »

fet4 писал(а):Что посоветуете? Может глянете?
пишите в саппорт будем смотреть
Вернуться к началу
fet4
Сообщения: 133
Зарегистрирован: Пт мар 04, 2011 10:25 am

Re: Не передаются атрибуты шейпера accel-ppp

Сообщение fet4 »

Проблема решилась обновлением системы.
Вернуться к началу
Ответить

Вернуться в «Linux»