нерекомендуемый верификатор и несгорающие платежи.

[agach]

Коллеги, подскажите пожалуйста, вот верификатор выдал ошибки закомментированные и не рекомендованные. судя по сообщениям в форуме, все зависит от конкретного случая - применять или нет эти исправления.


На данный момент у меня одна большая проблема с биллингом - не сгорают платежи по карточкам, срок действия платежа которых 30 дней. т.е. по истечении 30 дней платеж не сгорает. что делать - пока не знаю. либо сторонний скрипт мутить для проверки и блокировки юзеров. либо копать - в чем проблема. второе предпочтительнее, но не знаю куда копать. может у кого была такая проблема.

точно не скажу, но скорее всего появилась после обновления с 5.2.1-004 до 5.2.1-006.

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

-- Verificator
-- You have to backup UTM5 database!
-- Affected tables list at the end of file

-- ERROR tariff 4 doesn't exist, but exist in accounts_tariff_link id 163
-- SQL DESC delete broken account tariff link (NOT RECOMMENED!)
-- UPDATE account_tariff_link SET is_deleted=1 WHERE id='163';

-- ERROR broken ip traffic link 1004, ip group 0 not exist
-- SQL DESC delete slink (NOT RECOMMENDED)
-- UPDATE service_links SET is_deleted=1 WHERE id='1004';
-- UPDATE periodic_service_links SET is_deleted=1 WHERE id='1004';
-- UPDATE iptraffic_service_links SET is_deleted=1 WHERE id='1004';

-- ERROR broken ip traffic link 1212, ip group 0 not exist
-- SQL DESC delete slink (NOT RECOMMENDED)
-- UPDATE service_links SET is_deleted=1 WHERE id='1212';
-- UPDATE periodic_service_links SET is_deleted=1 WHERE id='1212';
-- UPDATE iptraffic_service_links SET is_deleted=1 WHERE id='1212';

-- ERROR broken ip traffic link 1223, ip group 944 not exist
-- SQL DESC delete slink (NOT RECOMMENDED)
-- UPDATE service_links SET is_deleted=1 WHERE id='1223';
-- UPDATE periodic_service_links SET is_deleted=1 WHERE id='1223';
-- UPDATE iptraffic_service_links SET is_deleted=1 WHERE id='1223';

-- ERROR broken ip traffic link 1321, ip group 0 not exist
-- SQL DESC delete slink (NOT RECOMMENDED)
-- UPDATE service_links SET is_deleted=1 WHERE id='1321';
-- UPDATE periodic_service_links SET is_deleted=1 WHERE id='1321';
-- UPDATE iptraffic_service_links SET is_deleted=1 WHERE id='1321';

-- ERROR broken ip traffic link 1874, ip group 1148 not exist
-- SQL DESC delete slink (NOT RECOMMENDED)
-- UPDATE service_links SET is_deleted=1 WHERE id='1874';
-- UPDATE periodic_service_links SET is_deleted=1 WHERE id='1874';
-- UPDATE iptraffic_service_links SET is_deleted=1 WHERE id='1874';

-- ERROR broken ip traffic link 2067, ip group 1337 not exist
-- SQL DESC delete slink (NOT RECOMMENDED)
-- UPDATE service_links SET is_deleted=1 WHERE id='2067';
-- UPDATE periodic_service_links SET is_deleted=1 WHERE id='2067';
-- UPDATE iptraffic_service_links SET is_deleted=1 WHERE id='2067';

-- ERROR broken ip traffic link 2965, ip group 2228 not exist
-- SQL DESC delete slink (NOT RECOMMENDED)
-- UPDATE service_links SET is_deleted=1 WHERE id='2965';
-- UPDATE periodic_service_links SET is_deleted=1 WHERE id='2965';
-- UPDATE iptraffic_service_links SET is_deleted=1 WHERE id='2965';

-- ERROR link 1004, wrong tariff id
-- SQL DESC delete broken link (NOT RECOMMENDED)
-- UPDATE service_links SET is_deleted=1 WHERE id='1004';
-- UPDATE periodic_service_links SET is_deleted=1 WHERE id='1004';
-- UPDATE iptraffic_service_links SET is_deleted=1 WHERE id='1004';

-- ERROR link 1212, wrong tariff id
-- SQL DESC delete broken link (NOT RECOMMENDED)
-- UPDATE service_links SET is_deleted=1 WHERE id='1212';
-- UPDATE periodic_service_links SET is_deleted=1 WHERE id='1212';
-- UPDATE iptraffic_service_links SET is_deleted=1 WHERE id='1212';

-- ERROR link 1223, tariff_link_id 949 not exist
-- SQL DESC delete broken link (NOT RECOMMENDED)
-- UPDATE service_links SET is_deleted=1 WHERE id='1223';
-- UPDATE periodic_service_links SET is_deleted=1 WHERE id='1223';
-- UPDATE iptraffic_service_links SET is_deleted=1 WHERE id='1223';

-- ERROR link 1223, wrong tariff id
-- SQL DESC delete broken link (NOT RECOMMENDED)
-- UPDATE service_links SET is_deleted=1 WHERE id='1223';
-- UPDATE periodic_service_links SET is_deleted=1 WHERE id='1223';
-- UPDATE iptraffic_service_links SET is_deleted=1 WHERE id='1223';

-- ERROR link 1223, account tariff link id 949, not equal discount period ids
-- SQL DESC delete broken link (NOT RECOMMENDED)
-- UPDATE service_links SET is_deleted=1 WHERE id='1223';
-- UPDATE periodic_service_links SET is_deleted=1 WHERE id='1223';
-- UPDATE iptraffic_service_links SET is_deleted=1 WHERE id='1223';

-- ERROR link 1321, wrong tariff id
-- SQL DESC delete broken link (NOT RECOMMENDED)
-- UPDATE service_links SET is_deleted=1 WHERE id='1321';
-- UPDATE periodic_service_links SET is_deleted=1 WHERE id='1321';
-- UPDATE iptraffic_service_links SET is_deleted=1 WHERE id='1321';

-- ERROR link 1874, tariff_link_id 1165 not exist
-- SQL DESC delete broken link (NOT RECOMMENDED)
-- UPDATE service_links SET is_deleted=1 WHERE id='1874';
-- UPDATE periodic_service_links SET is_deleted=1 WHERE id='1874';
-- UPDATE iptraffic_service_links SET is_deleted=1 WHERE id='1874';

-- ERROR link 1874, wrong tariff id
-- SQL DESC delete broken link (NOT RECOMMENDED)
-- UPDATE service_links SET is_deleted=1 WHERE id='1874';
-- UPDATE periodic_service_links SET is_deleted=1 WHERE id='1874';
-- UPDATE iptraffic_service_links SET is_deleted=1 WHERE id='1874';

-- ERROR link 1874, account tariff link id 1165, not equal discount period ids
-- SQL DESC delete broken link (NOT RECOMMENDED)
-- UPDATE service_links SET is_deleted=1 WHERE id='1874';
-- UPDATE periodic_service_links SET is_deleted=1 WHERE id='1874';
-- UPDATE iptraffic_service_links SET is_deleted=1 WHERE id='1874';

-- ERROR link 2067, tariff_link_id 1355 not exist
-- SQL DESC delete broken link (NOT RECOMMENDED)
-- UPDATE service_links SET is_deleted=1 WHERE id='2067';
-- UPDATE periodic_service_links SET is_deleted=1 WHERE id='2067';
-- UPDATE iptraffic_service_links SET is_deleted=1 WHERE id='2067';

-- ERROR link 2067, wrong tariff id
-- SQL DESC delete broken link (NOT RECOMMENDED)
-- UPDATE service_links SET is_deleted=1 WHERE id='2067';
-- UPDATE periodic_service_links SET is_deleted=1 WHERE id='2067';
-- UPDATE iptraffic_service_links SET is_deleted=1 WHERE id='2067';

-- ERROR link 2067, account tariff link id 1355, not equal discount period ids
-- SQL DESC delete broken link (NOT RECOMMENDED)
-- UPDATE service_links SET is_deleted=1 WHERE id='2067';
-- UPDATE periodic_service_links SET is_deleted=1 WHERE id='2067';
-- UPDATE iptraffic_service_links SET is_deleted=1 WHERE id='2067';

-- ERROR link 2965, tariff_link_id 2268 not exist
-- SQL DESC delete broken link (NOT RECOMMENDED)
-- UPDATE service_links SET is_deleted=1 WHERE id='2965';
-- UPDATE periodic_service_links SET is_deleted=1 WHERE id='2965';
-- UPDATE iptraffic_service_links SET is_deleted=1 WHERE id='2965';

-- ERROR link 2965, wrong tariff id
-- SQL DESC delete broken link (NOT RECOMMENDED)
-- UPDATE service_links SET is_deleted=1 WHERE id='2965';
-- UPDATE periodic_service_links SET is_deleted=1 WHERE id='2965';
-- UPDATE iptraffic_service_links SET is_deleted=1 WHERE id='2965';

-- ERROR link 2965, account tariff link id 2268, not equal discount period ids
-- SQL DESC delete broken link (NOT RECOMMENDED)
-- UPDATE service_links SET is_deleted=1 WHERE id='2965';
-- UPDATE periodic_service_links SET is_deleted=1 WHERE id='2965';
-- UPDATE iptraffic_service_links SET is_deleted=1 WHERE id='2965';

-- 23 errors
-- 0 warnings
-- affected tables: account_tariff_link iptraffic_service_links periodic_service_links service_links
-- RESTART utm5_core!

[/quote]

[Chris]

Много у вас расчетных периодов...

[bear]

2Автор
эти ошибки не применяй через базу, лучше лечи их через админку, поиск по ID сервисной связки
найдеш поймеш почему