UTM5 работал более года а тут свалился

Технические вопросы по UTM 5.0
Ответить
vlad111
Сообщения: 5
Зарегистрирован: Пн июн 29, 2009 07:58

UTM5 работал более года а тут свалился

Сообщение vlad111 »

Прошу помочь, как поправить таблицы и какие. Чтобы запустить UTM.
Собственно запуск.
MySQL работает, другие приложения не ругаются. А вот UTM
linux:/netup/utm5/bin# ./utm5_core
?Debug : Jun 29 13:06:41 Rehash: Rehash manager started
Notice: Jun 29 13:06:41 ModMap: Sub-Module 'rehash' inserted...
Notice: Jun 29 13:06:41 UTM5 Config: Processing config file: /netup/utm5/utm5.cfg
Notice: Jun 29 13:06:41 UTM5 Config: Pid file found: /var/run/utm5_core.pid; Overwriting
?Debug : Jun 29 13:06:41 ModMap: Module <rehash> exist
Notice: Jun 29 13:06:41 ModMap: Sub-Module 'config' inserted...
?Debug : Jun 29 13:06:41 ModMap: Module <config> exist
?Debug : Jun 29 13:06:41 ModMap: Module <rehash> exist
Notice: Jun 29 13:06:41 ModMap: Sub-Module 'logger' inserted...
Далее логи.
Info : Jun 29 12:57:29 UTM5 Logger: New ` Info : ' stream: /var/log/utm/log/main.log
Info : Jun 29 12:57:29 UTM5 Logger: New `*CRIT : ' stream: /var/log/utm/log/main.log
Info : Jun 29 12:57:29 UTMCtx: ctx_init_file not specified. Database encription not enabled ...
Notice: Jun 29 12:57:29 ModMap: Sub-Module 'utmctx' inserted...
Info : Jun 29 12:57:29 DBA:Ctx: Creating 6 DB connections
Info : Jun 29 12:57:29 DBA:Ctx: DB Transactions are disabled
Notice: Jun 29 12:57:29 ModMap: Sub-Module 'dba:ctx' inserted...
Info : Jun 29 12:57:29 UTM5 DBA: X509 sign verification succeded
Info : Jun 29 12:57:29 UTMCtx: Decrypt: No ctx found
Warn : Jun 29 12:57:29 UTMCtx: Unencrypted message passed!
Info : Jun 29 12:57:29 UTMCtx: Decrypt: No ctx found
Warn : Jun 29 12:57:29 UTMCtx: Unencrypted message passed!
Info : Jun 29 12:57:29 UTMCtx: Decrypt: No ctx found
Warn : Jun 29 12:57:29 UTMCtx: Unencrypted message passed!
Notice: Jun 29 12:57:29 UTM5 DBA: Summary sys users fetched: 3
Info : Jun 29 12:57:29 UTMCtx: Decrypt: No ctx found
Warn : Jun 29 12:57:29 UTMCtx: Unencrypted message passed!
Info : Jun 29 12:57:29 UTMCtx: Decrypt: No ctx found
Warn : Jun 29 12:57:29 UTMCtx: Unencrypted message passed!
Info : Jun 29 12:57:29 UTMCtx: Decrypt: No ctx found
Warn : Jun 29 12:57:29 UTMCtx: Unencrypted message passed!
Notice: Jun 29 12:57:29 UTM5 DBA: Summary sys users fetched: 3
Notice: Jun 29 12:57:29 UTM5 DBA: Summary discount periods fetched:4
Notice: Jun 29 12:57:29 UTM5 DBA: Summary users fetched: 333
Info : Jun 29 12:57:29 UTM5 DBA: parsed 1.000000 notification border
Info : Jun 29 12:57:29 UTM5 DBA: block_recalc_abon = 0
Info : Jun 29 12:57:29 UTM5 DBA: block_recalc_prepaid = 0
Info : Jun 29 12:57:29 UTM5 DBA: discount_traffic_comission = 0
Info : Jun 29 12:57:29 UTM5 DBA: default_vat_rate = 0.000000
Info : Jun 29 12:57:29 UTM5 DBA: fw_rule_offset = 5000
Info : Jun 29 12:57:29 UTM5 DBA: check_abon_on_payment = 0
Info : Jun 29 12:57:29 UTM5 DBA: login_prefix_separator = :
Info : Jun 29 12:57:29 UTM5 DBA: null_prepaid_traffic_if_tarif_change = 0
Info : Jun 29 12:57:29 UTM5 DBA: www_prefix </var/www/>
Info : Jun 29 12:57:29 UTM5 DBA: hosting_ip <127.0.0.1>
Info : Jun 29 12:57:29 UTM5 DBA: hosting_uid_number <10001>
Info : Jun 29 12:57:29 UTM5 DBA: hosting_gid_number <10001>
Info : Jun 29 12:57:29 UTM5 DBA: mail_server_ip <127.0.0.1>
Info : Jun 29 12:57:29 UTM5 DBA: force_prepaid_change <0>
Info : Jun 29 12:57:29 UTM5 DBA: email_exec_register <>
Info : Jun 29 12:57:29 UTM5 DBA: email_exec_unregister <>
Info : Jun 29 12:57:29 UTM5 DBA: special_write <0>
Info : Jun 29 12:57:29 UTM5 DBA: tel_attrs_write <0>
Info : Jun 29 12:57:29 UTM5 DBA: dialup_attrs_write <0>
Info : Jun 29 12:57:29 UTM5 DBA: access_attrs_write <0>
Info : Jun 29 12:57:29 UTM5 DBA: use_utm_towlower <1>
ERROR : Jun 29 12:57:29 DTAgg: duplicate entry in dtagg_iptraffic for slink 18
ERROR : Jun 29 12:57:29 DTAgg: duplicate entry in dtagg_iptraffic for slink 5
ERROR : Jun 29 12:57:29 DBAExistingError: get_discount_period_iter: no such disc per 1042
*ALERT : Jun 29 12:57:29 UTM5 DBA: Exception caught on startup. See debug log for detail
*CRIT : Jun 29 12:57:29 UTM5 Core: ModMap fatal init exception. Aborting
Info : Jun 29 12:57:29 UTM5 Logger: New `?Debug : ' stream: /var/log/utm/log/debug.log
Info : Jun 29 12:57:29 UTM5 Logger: New ` Info : ' stream: /var/log/utm/log/main.log
Info : Jun 29 12:57:29 UTM5 Logger: New `*CRIT : ' stream: /var/log/utm/log/main.log
Info : Jun 29 12:57:29 UTMCtx: ctx_init_file not specified. Database encription not enabled ...
?Debug : Jun 29 12:57:29 ModMap: Module <config> exist
?Debug : Jun 29 12:57:29 ModMap: Module <logger> exist
?Debug : Jun 29 12:57:29 ModMap: Module <rehash> exist
?Debug : Jun 29 12:57:29 UTMCtx: Initialization started...
Notice: Jun 29 12:57:29 ModMap: Sub-Module 'utmctx' inserted...
?Debug : Jun 29 12:57:29 ModMap: Module <config> exist
?Debug : Jun 29 12:57:29 ModMap: Module <logger> exist
?Debug : Jun 29 12:57:29 ModMap: Module <rehash> exist
?Debug : Jun 29 12:57:29 ModMap: Module <utmctx> exist
Info : Jun 29 12:57:29 DBA:Ctx: Creating 6 DB connections
Info : Jun 29 12:57:29 DBA:Ctx: DB Transactions are disabled
?Debug : Jun 29 12:57:29 DBCtx: Connecting to MySQL database
?Debug : Jun 29 12:57:29 DBCtx: Connection parameters username: root; dbname: utm host: localhost
?Debug : Jun 29 12:57:29 DBCtx: MySQL connection opened
?Debug : Jun 29 12:57:29 DBCtx: Connecting to MySQL database
?Debug : Jun 29 12:57:29 DBCtx: Connection parameters username: root; dbname: utm host: localhost
?Debug : Jun 29 12:57:29 DBCtx: MySQL connection opened
?Debug : Jun 29 12:57:29 DBCtx: Connecting to MySQL database
?Debug : Jun 29 12:57:29 DBCtx: Connection parameters username: root; dbname: utm host: localhost
?Debug : Jun 29 12:57:29 DBCtx: MySQL connection opened
?Debug : Jun 29 12:57:29 DBCtx: Connecting to MySQL database
?Debug : Jun 29 12:57:29 DBCtx: Connection parameters username: root; dbname: utm host: localhost
?Debug : Jun 29 12:57:29 DBCtx: MySQL connection opened
?Debug : Jun 29 12:57:29 DBCtx: Connecting to MySQL database
?Debug : Jun 29 12:57:29 DBCtx: Connection parameters username: root; dbname: utm host: localhost
?Debug : Jun 29 12:57:29 DBCtx: MySQL connection opened
?Debug : Jun 29 12:57:29 DBCtx: Connecting to MySQL database
?Debug : Jun 29 12:57:29 DBCtx: Connection parameters username: root; dbname: utm host: localhost
?Debug : Jun 29 12:57:29 DBCtx: MySQL connection opened
Notice: Jun 29 12:57:29 ModMap: Sub-Module 'dba:ctx' inserted...
?Debug : Jun 29 12:57:29 UTM5 DBA: DBAccess instance created
?Debug : Jun 29 12:57:29 ModMap: Module <config> exist
?Debug : Jun 29 12:57:29 ModMap: Module <dba:ctx> exist
?Debug : Jun 29 12:57:29 ModMap: Module <logger> exist
?Debug : Jun 29 12:57:29 ModMap: Module <rehash> exist
?Debug : Jun 29 12:57:29 ModMap: Module <utmctx> exist
?Debug : Jun 29 12:57:29 DBCtx: SQL SELECT query: SELECT name,country,region,city,address,email,tel,web FROM registration_info
?Debug : Jun 29 12:57:29 DBCtx: SQL SELECT query: SELECT value FROM utm5_settings WHERE variable='certificate'
Info : Jun 29 12:57:29 UTM5 DBA: X509 sign verification succeded
?Debug : Jun 29 12:57:29 DBCtx: SQL SELECT query: SELECT id,login,password,ip,mask FROM system_accounts WHERE is_deleted=0
Info : Jun 29 12:57:29 UTMCtx: Decrypt: No ctx found
Warn : Jun 29 12:57:29 UTMCtx: Unencrypted message passed!
Info : Jun 29 12:57:29 UTMCtx: Decrypt: No ctx found
Warn : Jun 29 12:57:29 UTMCtx: Unencrypted message passed!
Info : Jun 29 12:57:29 UTMCtx: Decrypt: No ctx found
Warn : Jun 29 12:57:29 UTMCtx: Unencrypted message passed!
Notice: Jun 29 12:57:29 UTM5 DBA: Summary sys users fetched: 3
?Debug : Jun 29 12:57:29 DBCtx: SQL SELECT query: SELECT id,name,info FROM system_group_info
?Debug : Jun 29 12:57:29 DBCtx: SQL SELECT query: SELECT user_id FROM system_groups WHERE group_id='1'
?Debug : Jun 29 12:57:29 DBCtx: SQL SELECT query: SELECT fid FROM system_rights WHERE group_id='1'
?Debug : Jun 29 12:57:29 DBCtx: SQL SELECT query: SELECT user_id FROM system_groups WHERE group_id='2'
?Debug : Jun 29 12:57:29 DBCtx: SQL SELECT query: SELECT fid FROM system_rights WHERE group_id='2'
?Debug : Jun 29 12:57:29 DBCtx: SQL SELECT query: SELECT user_id FROM system_groups WHERE group_id='3'
?Debug : Jun 29 12:57:29 DBCtx: SQL SELECT query: SELECT fid FROM system_rights WHERE group_id='3'
-Stats : Jun 29 12:57:29 DBA Groups: Stats: Uptime: 00:00:00. Events: 0; Errors: 0
?Debug : Jun 29 12:57:29 UTM5 DBA: DBA fill mega storages called
?Debug : Jun 29 12:57:29 DBCtx: SQL SELECT query: SELECT id,login,password,ip,mask FROM system_accounts WHERE is_deleted=0
Info : Jun 29 12:57:29 UTMCtx: Decrypt: No ctx found
Warn : Jun 29 12:57:29 UTMCtx: Unencrypted message passed!
Info : Jun 29 12:57:29 UTMCtx: Decrypt: No ctx found
Warn : Jun 29 12:57:29 UTMCtx: Unencrypted message passed!
Info : Jun 29 12:57:29 UTMCtx: Decrypt: No ctx found
Warn : Jun 29 12:57:29 UTMCtx: Unencrypted message passed!
Notice: Jun 29 12:57:29 UTM5 DBA: Summary sys users fetched: 3
?Debug : Jun 29 12:57:29 DBCtx: SQL SELECT query: SELECT id,name,info FROM system_group_info
?Debug : Jun 29 12:57:29 DBCtx: SQL SELECT query: SELECT user_id FROM system_groups WHERE group_id='1'
?Debug : Jun 29 12:57:29 DBCtx: SQL SELECT query: SELECT fid FROM system_rights WHERE group_id='1'
?Debug : Jun 29 12:57:29 DBCtx: SQL SELECT query: SELECT user_id FROM system_groups WHERE group_id='2'
?Debug : Jun 29 12:57:29 DBCtx: SQL SELECT query: SELECT fid FROM system_rights WHERE group_id='2'
?Debug : Jun 29 12:57:29 DBCtx: SQL SELECT query: SELECT user_id FROM system_groups WHERE group_id='3'
?Debug : Jun 29 12:57:29 DBCtx: SQL SELECT query: SELECT fid FROM system_rights WHERE group_id='3'
?Debug : Jun 29 12:57:29 DBCtx: SQL SELECT query: SELECT id, time_range_name FROM time_range
?Debug : Jun 29 12:57:29 DBCtx: SQL SELECT query: SELECT id, time_range_id, sec_start, sec_stop, min_start, min_stop, hour_start, hour_stop, wday_start, wday_stop FROM time_range_detail
?Debug : Jun 29 12:57:29 DBCtx: SQL SELECT query: SELECT id,time_range_id,mday,month FROM time_range_days WHERE is_deleted=0
?Debug : Jun 29 12:57:29 DBCtx: SQL SELECT query: SELECT id,start_date,end_date,periodic_type,next_discount_period_id,canonical_len, custom_duration, discount_interval, static_id FROM discount_periods WHERE is_expired=0
Notice: Jun 29 12:57:29 UTM5 DBA: Summary discount periods fetched:4
?Debug : Jun 29 12:57:29 DBCtx: SQL SELECT query: SELECT id,name,create_date,who_create,change_date,who_change,expire_date,is_blocked,balance_rollover FROM tariffs WHERE is_deleted=0
?Debug : Jun 29 12:57:29 DBCtx: SQL SELECT query: SELECT id,balance,account_name,credit,discount_period_id,is_blocked,dealer_account_id,comission_coef,default_comission_value,is_dealer,vat_rate,sale_tax_rate, flags, int_status, block_recalc_abon, block_recalc_prepaid, unlimited FROM accounts WHERE is_deleted=0
?Debug : Jun 29 12:57:29 DBCtx: SQL SELECT query: SELECT id, account_id, tariff_id, next_tariff_id, discount_period_id FROM account_tariff_link WHERE is_deleted=0
?Debug : Jun 29 12:57:29 DBCtx: SQL SELECT query: SELECT id FROM discount_periods WHERE id='7'

?Debug : Jun 29 12:57:29 DBCtx: SQL SELECT query: SELECT id FROM discount_periods WHERE id='7'
?Debug : Jun 29 12:57:29 DBCtx: SQL SELECT query: SELECT id FROM discount_periods WHERE id='7'
?Debug : Jun 29 12:57:29 DBCtx: SQL SELECT query: SELECT user_id,group_id FROM users_groups_link
?Debug : Jun 29 12:57:29 DBCtx: SQL SELECT query: SELECT id,login,password,basic_account,is_blocked,discount_period_id,full_name,email,advance_payment FROM users WHERE is_deleted='0'
?Debug : Jun 29 12:57:29 DBCtx: SQL SELECT query: SELECT value FROM utm5_settings WHERE variable='card_user_prefix'
?Debug : Jun 29 12:57:29 UTM5 DBA: utm_towlower wchar support disabled, using simple implementation
?Debug : Jun 29 12:57:29 UTM5 DBA: utm_towlower wchar support disabled, using simple implementation
?Debug : Jun 29 12:57:29 UTM5 DBA: utm_towlower wchar support disabled, using simple implementation
?Debug : Jun 29 12:57:29 UTM5 DBA: utm_towlower wchar support disabled, using simple implementation
Notice: Jun 29 12:57:29 UTM5 DBA: Summary users fetched: 333
?Debug : Jun 29 12:57:29 DBCtx: SQL SELECT query: SELECT uid,account_id FROM users_accounts WHERE is_deleted=0
?Debug : Jun 29 12:57:29 DBCtx: SQL SELECT query: SELECT id,router_type,router_ip,login,password,router_comments,router_bin_ip FROM routers_info WHERE is_deleted='0'
?Debug : Jun 29 12:57:29 DBCtx: SQL SELECT query: SELECT ip_group_id,ip,mask,uname,upass,mac,ip_groups.id,allowed_cid,ip_type,router_id FROM ip_groups WHERE ip_groups.is_deleted=0
?Debug : Jun 29 12:57:29 DBCtx: SQL SELECT query: SELECT id, ip_group_id FROM iptraffic_service_links WHERE is_deleted=0
?Debug : Jun 29 12:57:29 DBA_IPgroups: ---- ip_group_id = 5, slink_id = 5
?Debug : Jun 29 12:57:29 DBA_IPgroups: ---- ip_group_id = 9, slink_id = 9
?Debug : Jun 29 12:57:29 DBA_IPgroups: ---- ip_group_id = 10, slink_id = 10
?Debug : Jun 29 12:57:29 DBA_IPgroups: ---- ip_group_id = 11, slink_id = 11
?Debug : Jun 29 12:57:29 DBA_IPgroups: ---- ip_group_id = 12, slink_id = 12
?Debug :
Последний раз редактировалось vlad111 Пн июн 29, 2009 09:27, всего редактировалось 1 раз.
Вернуться к началу
vlad111
Сообщения: 5
Зарегистрирован: Пн июн 29, 2009 07:58

Сообщение vlad111 »

ERROR : Jun 29 12:57:29 DBAExistingError: get_discount_period_iter: no such disc per 1042
?Trace : Jun 29 12:57:29 trace: Obtained 9 stack frames.
?Trace : Jun 29 12:57:29 trace: ./utm5_core(_Z15print_backtracev+0x1d) [0x83072dd]

?Trace : Jun 29 12:57:29 trace: ./utm5_core(_ZN3UTM8DBAErrorC2ERKSsS2_+0x80) [0x80a9d30]

?Trace : Jun 29 12:57:29 trace: ./utm5_core(_ZN3UTM8DBAccess18verify_consistencyEPNS_8DBACacheE+0x4970) [0x82a9078]

?Trace : Jun 29 12:57:29 trace: ./utm5_core(_ZN3UTM8DBAccess18fill_mega_storagesEv+0x239) [0x80a6589]

?Trace : Jun 29 12:57:29 trace: ./utm5_core(_ZN3UTM8DBAccess11dbamod_initEPNS_6ModTopES2_+0x4a) [0x80a532a]

?Trace : Jun 29 12:57:29 trace: ./utm5_core(_ZN3UTM6ModMap7sub_putEPNS_6ModTopE+0x333) [0x80aa157]

?Trace : Jun 29 12:57:29 trace: ./utm5_core(main+0x1006) [0x82cf69e]

?Trace : Jun 29 12:57:29 trace: /lib/i686/cmov/libc.so.6(__libc_start_main+0xe5) [0xb7bb0775]

?Trace : Jun 29 12:57:29 trace: ./utm5_core(dlopen+0x41) [0x80a4fe1]

-Stats : Jun 29 12:57:29 DBA Groups: Stats: Uptime: 00:00:00. Events: 0; Errors: 0
*ALERT : Jun 29 12:57:29 UTM5 DBA: Exception caught on startup. See debug log for detail
*CRIT : Jun 29 12:57:29 UTM5 Core: ModMap fatal init exception. Aborting
Вернуться к началу
vlad111
Сообщения: 5
Зарегистрирован: Пн июн 29, 2009 07:58

Сообщение vlad111 »

Ща провел эксперимент, поставил тестовую базу utm2 с нуля. И подключил к ней UTM5 все заработало. А с основной базой не работает.
Может скажет кто где ошибочка?
mysqlcheck utm показал что все ОК
Вернуться к началу
Lord Kaho
Сообщения: 22
Зарегистрирован: Чт май 21, 2009 12:41

Сообщение Lord Kaho »

В файле verificator.log что?
Вернуться к началу
vlad111
Сообщения: 5
Зарегистрирован: Пн июн 29, 2009 07:58

Сообщение vlad111 »

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

-- ERROR account tariff link 42 linked to deleted discount period 7
-- SQL DESC undelete discount period
UPDATE discount_periods SET is_expired=0 WHERE id='7';

-- ERROR account tariff link 44 linked to deleted discount period 7
-- SQL DESC undelete discount period
UPDATE discount_periods SET is_expired=0 WHERE id='7';

-- ERROR account tariff link 45 linked to deleted discount period 7
-- SQL DESC undelete discount period
UPDATE discount_periods SET is_expired=0 WHERE id='7';

-- ERROR account tariff link 55 linked to deleted discount period 7
-- SQL DESC undelete discount period
UPDATE discount_periods SET is_expired=0 WHERE id='7';

-- ERROR account tariff link 71 linked to deleted discount period 7
-- SQL DESC undelete discount period
UPDATE discount_periods SET is_expired=0 WHERE id='7';

-- ERROR account tariff link 73 linked to deleted discount period 7
-- SQL DESC undelete discount period
UPDATE discount_periods SET is_expired=0 WHERE id='7';

-- ERROR account tariff link 79 linked to deleted discount period 7
-- SQL DESC undelete discount period
UPDATE discount_periods SET is_expired=0 WHERE id='7';

-- ERROR account tariff link 80 linked to deleted discount period 7
-- SQL DESC undelete discount period
UPDATE discount_periods SET is_expired=0 WHERE id='7';

-- ERROR account tariff link 81 linked to deleted discount period 7
-- SQL DESC undelete discount period
UPDATE discount_periods SET is_expired=0 WHERE id='7';

-- ERROR account tariff link 82 linked to deleted discount period 7
-- SQL DESC undelete discount period
UPDATE discount_periods SET is_expired=0 WHERE id='7';

-- ERROR account tariff link 85 linked to deleted discount period 7
-- SQL DESC undelete discount period
UPDATE discount_periods SET is_expired=0 WHERE id='7';

-- ERROR account tariff link 86 linked to deleted discount period 7
-- SQL DESC undelete discount period
UPDATE discount_periods SET is_expired=0 WHERE id='7';

-- ERROR account tariff link 87 linked to deleted discount period 7
-- SQL DESC undelete discount period
UPDATE discount_periods SET is_expired=0 WHERE id='7';

-- ERROR account tariff link 89 linked to deleted discount period 7
-- SQL DESC undelete discount period
UPDATE discount_periods SET is_expired=0 WHERE id='7';

-- ERROR account tariff link 90 linked to deleted discount period 7
-- SQL DESC undelete discount period
UPDATE discount_periods SET is_expired=0 WHERE id='7';

-- ERROR account tariff link 91 linked to deleted discount period 7
-- SQL DESC undelete discount period
UPDATE discount_periods SET is_expired=0 WHERE id='7';

-- ERROR account tariff link 92 linked to deleted discount period 7
-- SQL DESC undelete discount period
UPDATE discount_periods SET is_expired=0 WHERE id='7';

-- ERROR account tariff link 93 linked to deleted discount period 7
-- SQL DESC undelete discount period
UPDATE discount_periods SET is_expired=0 WHERE id='7';

-- ERROR account tariff link 94 linked to deleted discount period 7
-- SQL DESC undelete discount period
UPDATE discount_periods SET is_expired=0 WHERE id='7';

-- ERROR account tariff link 95 linked to deleted discount period 7
-- SQL DESC undelete discount period
UPDATE discount_periods SET is_expired=0 WHERE id='7';

-- ERROR account tariff link 97 linked to deleted discount period 7
-- SQL DESC undelete discount period
UPDATE discount_periods SET is_expired=0 WHERE id='7';

-- ERROR account tariff link 98 linked to deleted discount period 7
-- SQL DESC undelete discount period
UPDATE discount_periods SET is_expired=0 WHERE id='7';

-- ERROR account tariff link 101 linked to deleted discount period 7
-- SQL DESC undelete discount period
UPDATE discount_periods SET is_expired=0 WHERE id='7';

-- ERROR account tariff link 102 linked to deleted discount period 7
-- SQL DESC undelete discount period
UPDATE discount_periods SET is_expired=0 WHERE id='7';

-- ERROR account tariff link 105 linked to deleted discount period 7
-- SQL DESC undelete discount period
UPDATE discount_periods SET is_expired=0 WHERE id='7';

-- ERROR account tariff link 106 linked to deleted discount period 7
-- SQL DESC undelete discount period
UPDATE discount_periods SET is_expired=0 WHERE id='7';

-- ERROR account tariff link 107 linked to deleted discount period 7
-- SQL DESC undelete discount period
UPDATE discount_periods SET is_expired=0 WHERE id='7';

-- ERROR account tariff link 108 linked to deleted discount period 7
-- SQL DESC undelete discount period
UPDATE discount_periods SET is_expired=0 WHERE id='7';

-- ERROR account tariff link 110 linked to deleted discount period 7
-- SQL DESC undelete discount period
UPDATE discount_periods SET is_expired=0 WHERE id='7';

-- ERROR account tariff link 111 linked to deleted discount period 7
-- SQL DESC undelete discount period
UPDATE discount_periods SET is_expired=0 WHERE id='7';

-- ERROR account tariff link 112 linked to deleted discount period 7
-- SQL DESC undelete discount period
UPDATE discount_periods SET is_expired=0 WHERE id='7';

-- ERROR account tariff link 115 linked to deleted discount period 7
-- SQL DESC undelete discount period
UPDATE discount_periods SET is_expired=0 WHERE id='7';

-- ERROR account tariff link 116 linked to deleted discount period 7
-- SQL DESC undelete discount period
UPDATE discount_periods SET is_expired=0 WHERE id='7';

-- ERROR account tariff link 117 linked to deleted discount period 7
-- SQL DESC undelete discount period
UPDATE discount_periods SET is_expired=0 WHERE id='7';

-- ERROR account tariff link 118 linked to deleted discount period 7
-- SQL DESC undelete discount period
UPDATE discount_periods SET is_expired=0 WHERE id='7';

-- ERROR account tariff link 119 linked to deleted discount period 7
-- SQL DESC undelete discount period
UPDATE discount_periods SET is_expired=0 WHERE id='7';

-- ERROR account tariff link 120 linked to deleted discount period 7
-- SQL DESC undelete discount period
UPDATE discount_periods SET is_expired=0 WHERE id='7';

-- ERROR account tariff link 121 linked to deleted discount period 7
-- SQL DESC undelete discount period
UPDATE discount_periods SET is_expired=0 WHERE id='7';

-- ERROR account tariff link 122 linked to deleted discount period 7
-- SQL DESC undelete discount period
UPDATE discount_periods SET is_expired=0 WHERE id='7';

-- ERROR account tariff link 123 linked to deleted discount period 7
-- SQL DESC undelete discount period
UPDATE discount_periods SET is_expired=0 WHERE id='7';

-- ERROR account tariff link 124 linked to deleted discount period 7
-- SQL DESC undelete discount period
UPDATE discount_periods SET is_expired=0 WHERE id='7';

-- ERROR account tariff link 125 linked to deleted discount period 7
-- SQL DESC undelete discount period
UPDATE discount_periods SET is_expired=0 WHERE id='7';

-- ERROR account tariff link 126 linked to deleted discount period 7
-- SQL DESC undelete discount period
UPDATE discount_periods SET is_expired=0 WHERE id='7';

-- ERROR account tariff link 128 linked to deleted discount period 7
-- SQL DESC undelete discount period
UPDATE discount_periods SET is_expired=0 WHERE id='7';

-- ERROR account tariff link 129 linked to deleted discount period 7
-- SQL DESC undelete discount period
UPDATE discount_periods SET is_expired=0 WHERE id='7';

-- ERROR account tariff link 130 linked to deleted discount period 7
-- SQL DESC undelete discount period
UPDATE discount_periods SET is_expired=0 WHERE id='7';

-- ERROR account tariff link 131 linked to deleted discount period 7
-- SQL DESC undelete discount period
UPDATE discount_periods SET is_expired=0 WHERE id='7';

-- ERROR account tariff link 132 linked to deleted discount period 7
-- SQL DESC undelete discount period
UPDATE discount_periods SET is_expired=0 WHERE id='7';

-- ERROR account tariff link 133 linked to deleted discount period 7
-- SQL DESC undelete discount period
UPDATE discount_periods SET is_expired=0 WHERE id='7';

-- ERROR account tariff link 134 linked to deleted discount period 7
-- SQL DESC undelete discount period
UPDATE discount_periods SET is_expired=0 WHERE id='7';

-- ERROR account tariff link 135 linked to deleted discount period 7
-- SQL DESC undelete discount period
UPDATE discount_periods SET is_expired=0 WHERE id='7';

-- ERROR account tariff link 136 linked to deleted discount period 7
-- SQL DESC undelete discount period
UPDATE discount_periods SET is_expired=0 WHERE id='7';

-- ERROR account tariff link 137 linked to deleted discount period 7
-- SQL DESC undelete discount period
UPDATE discount_periods SET is_expired=0 WHERE id='7';

-- ERROR account tariff link 138 linked to deleted discount period 7
-- SQL DESC undelete discount period
UPDATE discount_periods SET is_expired=0 WHERE id='7';

-- ERROR account tariff link 139 linked to deleted discount period 7
-- SQL DESC undelete discount period
UPDATE discount_periods SET is_expired=0 WHERE id='7';

-- ERROR account tariff link 140 linked to deleted discount period 7
-- SQL DESC undelete discount period
UPDATE discount_periods SET is_expired=0 WHERE id='7';

-- ERROR account tariff link 141 linked to deleted discount period 7
-- SQL DESC undelete discount period
UPDATE discount_periods SET is_expired=0 WHERE id='7';

-- ERROR account tariff link 142 linked to deleted discount period 7
-- SQL DESC undelete discount period
UPDATE discount_periods SET is_expired=0 WHERE id='7';

-- ERROR account tariff link 143 linked to deleted discount period 7
-- SQL DESC undelete discount period
UPDATE discount_periods SET is_expired=0 WHERE id='7';

-- ERROR account tariff link 144 linked to deleted discount period 7
-- SQL DESC undelete discount period
UPDATE discount_periods SET is_expired=0 WHERE id='7';

-- ERROR account tariff link 145 linked to deleted discount period 7
-- SQL DESC undelete discount period
UPDATE discount_periods SET is_expired=0 WHERE id='7';

-- ERROR account tariff link 146 linked to deleted discount period 7
-- SQL DESC undelete discount period
UPDATE discount_periods SET is_expired=0 WHERE id='7';

-- ERROR account tariff link 148 linked to deleted discount period 7
-- SQL DESC undelete discount period
UPDATE discount_periods SET is_expired=0 WHERE id='7';

-- ERROR account tariff link 149 linked to deleted discount period 7
-- SQL DESC undelete discount period
UPDATE discount_periods SET is_expired=0 WHERE id='7';

-- ERROR account tariff link 150 linked to deleted discount period 7
-- SQL DESC undelete discount period
UPDATE discount_periods SET is_expired=0 WHERE id='7';

-- ERROR account tariff link 151 linked to deleted discount period 7
-- SQL DESC undelete discount period
UPDATE discount_periods SET is_expired=0 WHERE id='7';

-- ERROR account tariff link 152 linked to deleted discount period 7
-- SQL DESC undelete discount period
UPDATE discount_periods SET is_expired=0 WHERE id='7';

-- ERROR account tariff link 153 linked to deleted discount period 7
-- SQL DESC undelete discount period
UPDATE discount_periods SET is_expired=0 WHERE id='7';

-- ERROR account tariff link 154 linked to deleted discount period 7
-- SQL DESC undelete discount period
UPDATE discount_periods SET is_expired=0 WHERE id='7';

-- ERROR account tariff link 155 linked to deleted discount period 7
-- SQL DESC undelete discount period
UPDATE discount_periods SET is_expired=0 WHERE id='7';

-- ERROR account tariff link 156 linked to deleted discount period 7
-- SQL DESC undelete discount period
UPDATE discount_periods SET is_expired=0 WHERE id='7';

-- ERROR account tariff link 157 linked to deleted discount period 7
-- SQL DESC undelete discount period
UPDATE discount_periods SET is_expired=0 WHERE id='7';

-- ERROR account tariff link 158 linked to deleted discount period 7
-- SQL DESC undelete discount period
UPDATE discount_periods SET is_expired=0 WHERE id='7';

-- ERROR account tariff link 159 linked to deleted discount period 7
-- SQL DESC undelete discount period
UPDATE discount_periods SET is_expired=0 WHERE id='7';

-- ERROR account tariff link 160 linked to deleted discount period 7
-- SQL DESC undelete discount period
UPDATE discount_periods SET is_expired=0 WHERE id='7';

-- ERROR account tariff link 161 linked to deleted discount period 7
-- SQL DESC undelete discount period
UPDATE discount_periods SET is_expired=0 WHERE id='7';

-- ERROR account tariff link 162 linked to deleted discount period 7
-- SQL DESC undelete discount period
UPDATE discount_periods SET is_expired=0 WHERE id='7';

-- ERROR account tariff link 163 linked to deleted discount period 7
-- SQL DESC undelete discount period
UPDATE discount_periods SET is_expired=0 WHERE id='7';

-- ERROR account tariff link 164 linked to deleted discount period 7
-- SQL DESC undelete discount period
UPDATE discount_periods SET is_expired=0 WHERE id='7';

-- ERROR account tariff link 165 linked to deleted discount period 7
-- SQL DESC undelete discount period
UPDATE discount_periods SET is_expired=0 WHERE id='7';

-- ERROR account tariff link 166 linked to deleted discount period 7
-- SQL DESC undelete discount period
UPDATE discount_periods SET is_expired=0 WHERE id='7';

-- ERROR account tariff link 167 linked to deleted discount period 7
-- SQL DESC undelete discount period
UPDATE discount_periods SET is_expired=0 WHERE id='7';

-- ERROR account tariff link 168 linked to deleted discount period 7
-- SQL DESC undelete discount period
UPDATE discount_periods SET is_expired=0 WHERE id='7';

-- ERROR account tariff link 169 linked to deleted discount period 7
-- SQL DESC undelete discount period
UPDATE discount_periods SET is_expired=0 WHERE id='7';

-- ERROR account tariff link 170 linked to deleted discount period 7
-- SQL DESC undelete discount period
UPDATE discount_periods SET is_expired=0 WHERE id='7';

-- ERROR account tariff link 171 linked to deleted discount period 7
-- SQL DESC undelete discount period
UPDATE discount_periods SET is_expired=0 WHERE id='7';

-- ERROR account tariff link 172 linked to deleted discount period 7
-- SQL DESC undelete discount period
UPDATE discount_periods SET is_expired=0 WHERE id='7';

-- ERROR account tariff link 173 linked to deleted discount period 7
-- SQL DESC undelete discount period
UPDATE discount_periods SET is_expired=0 WHERE id='7';

-- ERROR account tariff link 174 linked to deleted discount period 7
-- SQL DESC undelete discount period
UPDATE discount_periods SET is_expired=0 WHERE id='7';

-- ERROR account tariff link 175 linked to deleted discount period 7
-- SQL DESC undelete discount period
UPDATE discount_periods SET is_expired=0 WHERE id='7';

-- ERROR account tariff link 176 linked to deleted discount period 7
-- SQL DESC undelete discount period
UPDATE discount_periods SET is_expired=0 WHERE id='7';

-- ERROR account tariff link 177 linked to deleted discount period 7
-- SQL DESC undelete discount period
UPDATE discount_periods SET is_expired=0 WHERE id='7';

-- ERROR account tariff link 178 linked to deleted discount period 7
-- SQL DESC undelete discount period
UPDATE discount_periods SET is_expired=0 WHERE id='7';

-- ERROR account tariff link 179 linked to deleted discount period 7
-- SQL DESC undelete discount period
UPDATE discount_periods SET is_expired=0 WHERE id='7';

-- ERROR account tariff link 181 linked to deleted discount period 7
-- SQL DESC undelete discount period
UPDATE discount_periods SET is_expired=0 WHERE id='7';

-- ERROR account tariff link 182 linked to deleted discount period 7
-- SQL DESC undelete discount period
UPDATE discount_periods SET is_expired=0 WHERE id='7';

-- ERROR account tariff link 183 linked to deleted discount period 7
-- SQL DESC undelete discount period
UPDATE discount_periods SET is_expired=0 WHERE id='7';

-- ERROR account tariff link 184 linked to deleted discount period 7
-- SQL DESC undelete discount period
UPDATE discount_periods SET is_expired=0 WHERE id='7';

-- ERROR account tariff link 185 linked to deleted discount period 7
-- SQL DESC undelete discount period
UPDATE discount_periods SET is_expired=0 WHERE id='7';

-- ERROR account tariff link 186 linked to deleted discount period 7
-- SQL DESC undelete discount period
UPDATE discount_periods SET is_expired=0 WHERE id='7';

-- ERROR account tariff link 187 linked to deleted discount period 7
-- SQL DESC undelete discount period
UPDATE discount_periods SET is_expired=0 WHERE id='7';

-- ERROR account tariff link 188 linked to deleted discount period 7
-- SQL DESC undelete discount period
UPDATE discount_periods SET is_expired=0 WHERE id='7';

-- ERROR account tariff link 189 linked to deleted discount period 7
-- SQL DESC undelete discount period
UPDATE discount_periods SET is_expired=0 WHERE id='7';

-- ERROR account tariff link 190 linked to deleted discount period 7
-- SQL DESC undelete discount period
UPDATE discount_periods SET is_expired=0 WHERE id='7';

-- ERROR account tariff link 191 linked to deleted discount period 7
-- SQL DESC undelete discount period
UPDATE discount_periods SET is_expired=0 WHERE id='7';

-- ERROR account tariff link 193 linked to deleted discount period 7
-- SQL DESC undelete discount period
UPDATE discount_periods SET is_expired=0 WHERE id='7';

-- ERROR account tariff link 194 linked to deleted discount period 7
-- SQL DESC undelete discount period
UPDATE discount_periods SET is_expired=0 WHERE id='7';

-- ERROR account tariff link 195 linked to deleted discount period 7
-- SQL DESC undelete discount period
UPDATE discount_periods SET is_expired=0 WHERE id='7';

-- ERROR account tariff link 196 linked to deleted discount period 7
-- SQL DESC undelete discount period
UPDATE discount_periods SET is_expired=0 WHERE id='7';

-- ERROR account tariff link 197 linked to deleted discount period 7
-- SQL DESC undelete discount period
UPDATE discount_periods SET is_expired=0 WHERE id='7';

-- ERROR account tariff link 198 linked to deleted discount period 7
-- SQL DESC undelete discount period
UPDATE discount_periods SET is_expired=0 WHERE id='7';

-- ERROR account tariff link 199 linked to deleted discount period 7
-- SQL DESC undelete discount period
UPDATE discount_periods SET is_expired=0 WHERE id='7';

-- ERROR account tariff link 200 linked to deleted discount period 7
-- SQL DESC undelete discount period
UPDATE discount_periods SET is_expired=0 WHERE id='7';

-- ERROR account tariff link 201 linked to deleted discount period 7
-- SQL DESC undelete discount period
UPDATE discount_periods SET is_expired=0 WHERE id='7';

-- ERROR account tariff link 202 linked to deleted discount period 7
-- SQL DESC undelete discount period
UPDATE discount_periods SET is_expired=0 WHERE id='7';

-- ERROR account tariff link 203 linked to deleted discount period 7
-- SQL DESC undelete discount period
UPDATE discount_periods SET is_expired=0 WHERE id='7';

-- ERROR account tariff link 204 linked to deleted discount period 7
-- SQL DESC undelete discount period
UPDATE discount_periods SET is_expired=0 WHERE id='7';

-- ERROR account tariff link 205 linked to deleted discount period 7
-- SQL DESC undelete discount period
UPDATE discount_periods SET is_expired=0 WHERE id='7';

-- ERROR account tariff link 206 linked to deleted discount period 7
-- SQL DESC undelete discount period
UPDATE discount_periods SET is_expired=0 WHERE id='7';

-- ERROR account tariff link 207 linked to deleted discount period 7
-- SQL DESC undelete discount period
UPDATE discount_periods SET is_expired=0 WHERE id='7';

-- ERROR account tariff link 208 linked to deleted discount period 7
-- SQL DESC undelete discount period
UPDATE discount_periods SET is_expired=0 WHERE id='7';

-- ERROR account tariff link 209 linked to deleted discount period 7
-- SQL DESC undelete discount period
UPDATE discount_periods SET is_expired=0 WHERE id='7';

-- ERROR account tariff link 210 linked to deleted discount period 7
-- SQL DESC undelete discount period
UPDATE discount_periods SET is_expired=0 WHERE id='7';

-- ERROR account tariff link 211 linked to deleted discount period 7
-- SQL DESC undelete discount period
UPDATE discount_periods SET is_expired=0 WHERE id='7';

-- ERROR account tariff link 212 linked to deleted discount period 7
-- SQL DESC undelete discount period
UPDATE discount_periods SET is_expired=0 WHERE id='7';

-- ERROR account tariff link 213 linked to deleted discount period 7
-- SQL DESC undelete discount period
UPDATE discount_periods SET is_expired=0 WHERE id='7';

-- ERROR account tariff link 214 linked to deleted discount period 7
-- SQL DESC undelete discount period
UPDATE discount_periods SET is_expired=0 WHERE id='7';

-- ERROR account tariff link 215 linked to deleted discount period 7
-- SQL DESC undelete discount period
UPDATE discount_periods SET is_expired=0 WHERE id='7';

-- ERROR account tariff link 216 linked to deleted discount period 7
-- SQL DESC undelete discount period
UPDATE discount_periods SET is_expired=0 WHERE id='7';

-- ERROR account tariff link 217 linked to deleted discount period 7
-- SQL DESC undelete discount period
UPDATE discount_periods SET is_expired=0 WHERE id='7';

-- ERROR account tariff link 218 linked to deleted discount period 7
-- SQL DESC undelete discount period
UPDATE discount_periods SET is_expired=0 WHERE id='7';

-- ERROR account tariff link 219 linked to deleted discount period 7
-- SQL DESC undelete discount period
UPDATE discount_periods SET is_expired=0 WHERE id='7';

-- ERROR account tariff link 220 linked to deleted discount period 7
-- SQL DESC undelete discount period
UPDATE discount_periods SET is_expired=0 WHERE id='7';

-- ERROR account tariff link 223 linked to deleted discount period 7
-- SQL DESC undelete discount period
UPDATE discount_periods SET is_expired=0 WHERE id='7';

-- ERROR account tariff link 224 linked to deleted discount period 7
-- SQL DESC undelete discount period
UPDATE discount_periods SET is_expired=0 WHERE id='7';

-- ERROR account tariff link 226 linked to deleted discount period 7
-- SQL DESC undelete discount period
UPDATE discount_periods SET is_expired=0 WHERE id='7';

-- ERROR account tariff link 227 linked to deleted discount period 7
-- SQL DESC undelete discount period
UPDATE discount_periods SET is_expired=0 WHERE id='7';

-- ERROR account tariff link 228 linked to deleted discount period 7
-- SQL DESC undelete discount period
UPDATE discount_periods SET is_expired=0 WHERE id='7';

-- ERROR account tariff link 229 linked to deleted discount period 7
-- SQL DESC undelete discount period
UPDATE discount_periods SET is_expired=0 WHERE id='7';

-- ERROR account tariff link 230 linked to deleted discount period 7
-- SQL DESC undelete discount period
UPDATE discount_periods SET is_expired=0 WHERE id='7';

-- ERROR account tariff link 231 linked to deleted discount period 7
-- SQL DESC undelete discount period
UPDATE discount_periods SET is_expired=0 WHERE id='7';

-- ERROR account tariff link 234 linked to deleted discount period 7
-- SQL DESC undelete discount period
UPDATE discount_periods SET is_expired=0 WHERE id='7';

-- ERROR account tariff link 235 linked to deleted discount period 7
-- SQL DESC undelete discount period
UPDATE discount_periods SET is_expired=0 WHERE id='7';

-- ERROR account tariff link 236 linked to deleted discount period 7
-- SQL DESC undelete discount period
UPDATE discount_periods SET is_expired=0 WHERE id='7';

-- ERROR account tariff link 239 linked to deleted discount period 7
-- SQL DESC undelete discount period
UPDATE discount_periods SET is_expired=0 WHERE id='7';

-- ERROR account tariff link 240 linked to deleted discount period 7
-- SQL DESC undelete discount period
UPDATE discount_periods SET is_expired=0 WHERE id='7';

-- ERROR account tariff link 262 linked to deleted discount period 7
-- SQL DESC undelete discount period
UPDATE discount_periods SET is_expired=0 WHERE id='7';

-- ERROR account tariff link 263 linked to deleted discount period 7
-- SQL DESC undelete discount period
UPDATE discount_periods SET is_expired=0 WHERE id='7';

-- ERROR account tariff link 269 linked to deleted discount period 7
-- SQL DESC undelete discount period
UPDATE discount_periods SET is_expired=0 WHERE id='7';

-- ERROR account tariff link 276 linked to deleted discount period 7
-- SQL DESC undelete discount period
UPDATE discount_periods SET is_expired=0 WHERE id='7';

-- ERROR account tariff link 277 linked to deleted discount period 7
-- SQL DESC undelete discount period
UPDATE discount_periods SET is_expired=0 WHERE id='7';

-- ERROR account tariff link 278 linked to deleted discount period 7
-- SQL DESC undelete discount period
UPDATE discount_periods SET is_expired=0 WHERE id='7';

-- ERROR account tariff link 279 linked to deleted discount period 7
-- SQL DESC undelete discount period
UPDATE discount_periods SET is_expired=0 WHERE id='7';

-- ERROR account tariff link 289 linked to deleted discount period 7
-- SQL DESC undelete discount period
UPDATE discount_periods SET is_expired=0 WHERE id='7';

-- ERROR account tariff link 307 linked to deleted discount period 7
-- SQL DESC undelete discount period
UPDATE discount_periods SET is_expired=0 WHERE id='7';

-- ERROR account tariff link 308 linked to deleted discount period 7
-- SQL DESC undelete discount period
UPDATE discount_periods SET is_expired=0 WHERE id='7';

-- ERROR account tariff link 309 linked to deleted discount period 7
-- SQL DESC undelete discount period
UPDATE discount_periods SET is_expired=0 WHERE id='7';

-- ERROR account tariff link 310 linked to deleted discount period 7
-- SQL DESC undelete discount period
UPDATE discount_periods SET is_expired=0 WHERE id='7';

-- ERROR account tariff link 311 linked to deleted discount period 7
-- SQL DESC undelete discount period
UPDATE discount_periods SET is_expired=0 WHERE id='7';

-- ERROR account tariff link 312 linked to deleted discount period 7
-- SQL DESC undelete discount period
UPDATE discount_periods SET is_expired=0 WHERE id='7';

-- ERROR account tariff link 313 linked to deleted discount period 7
-- SQL DESC undelete discount period
UPDATE discount_periods SET is_expired=0 WHERE id='7';

-- ERROR account tariff link 315 linked to deleted discount period 7
-- SQL DESC undelete discount period
UPDATE discount_periods SET is_expired=0 WHERE id='7';

-- ERROR account tariff link 317 linked to deleted discount period 7
-- SQL DESC undelete discount period
UPDATE discount_periods SET is_expired=0 WHERE id='7';

-- ERROR account tariff link 318 linked to deleted discount period 7
-- SQL DESC undelete discount period
UPDATE discount_periods SET is_expired=0 WHERE id='7';

-- ERROR account tariff link 321 linked to deleted discount period 7
-- SQL DESC undelete discount period
UPDATE discount_periods SET is_expired=0 WHERE id='7';

-- ERROR account tariff link 322 linked to deleted discount period 7
-- SQL DESC undelete discount period
UPDATE discount_periods SET is_expired=0 WHERE id='7';

-- ERROR account tariff link 323 linked to deleted discount period 7
-- SQL DESC undelete discount period
UPDATE discount_periods SET is_expired=0 WHERE id='7';

-- ERROR account tariff link 326 linked to deleted discount period 7
-- SQL DESC undelete discount period
UPDATE discount_periods SET is_expired=0 WHERE id='7';

-- ERROR account tariff link 327 linked to deleted discount period 7
-- SQL DESC undelete discount period
UPDATE discount_periods SET is_expired=0 WHERE id='7';

-- ERROR account tariff link 328 linked to deleted discount period 7
-- SQL DESC undelete discount period
UPDATE discount_periods SET is_expired=0 WHERE id='7';

-- ERROR account tariff link 329 linked to deleted discount period 7
-- SQL DESC undelete discount period
UPDATE discount_periods SET is_expired=0 WHERE id='7';

-- ERROR account tariff link 330 linked to deleted discount period 7
-- SQL DESC undelete discount period
UPDATE discount_periods SET is_expired=0 WHERE id='7';

-- ERROR account tariff link 331 linked to deleted discount period 7
-- SQL DESC undelete discount period
UPDATE discount_periods SET is_expired=0 WHERE id='7';

-- ERROR account tariff link 332 linked to deleted discount period 7
-- SQL DESC undelete discount period
UPDATE discount_periods SET is_expired=0 WHERE id='7';

-- ERROR account tariff link 333 linked to deleted discount period 7
-- SQL DESC undelete discount period
UPDATE discount_periods SET is_expired=0 WHERE id='7';

-- ERROR account tariff link 334 linked to deleted discount period 7
-- SQL DESC undelete discount period
UPDATE discount_periods SET is_expired=0 WHERE id='7';

-- ERROR account tariff link 337 linked to deleted discount period 7
-- SQL DESC undelete discount period
UPDATE discount_periods SET is_expired=0 WHERE id='7';

-- ERROR account tariff link 338 linked to deleted discount period 7
-- SQL DESC undelete discount period
UPDATE discount_periods SET is_expired=0 WHERE id='7';

-- ERROR account tariff link 339 linked to deleted discount period 7
-- SQL DESC undelete discount period
UPDATE discount_periods SET is_expired=0 WHERE id='7';

-- ERROR account tariff link 340 linked to deleted discount period 7
-- SQL DESC undelete discount period
UPDATE discount_periods SET is_expired=0 WHERE id='7';

-- ERROR account tariff link 341 linked to deleted discount period 7
-- SQL DESC undelete discount period
UPDATE discount_periods SET is_expired=0 WHERE id='7';

-- ERROR account tariff link 342 linked to deleted discount period 7
-- SQL DESC undelete discount period
UPDATE discount_periods SET is_expired=0 WHERE id='7';

-- ERROR account tariff link 343 linked to deleted discount period 7
-- SQL DESC undelete discount period
UPDATE discount_periods SET is_expired=0 WHERE id='7';

-- ERROR account tariff link 351 linked to deleted discount period 7
-- SQL DESC undelete discount period
UPDATE discount_periods SET is_expired=0 WHERE id='7';

-- ERROR account tariff link 352 linked to deleted discount period 7
-- SQL DESC undelete discount period
UPDATE discount_periods SET is_expired=0 WHERE id='7';

-- ERROR account tariff link 353 linked to deleted discount period 7
-- SQL DESC undelete discount period
UPDATE discount_periods SET is_expired=0 WHERE id='7';

-- ERROR account tariff link 354 linked to deleted discount period 7
-- SQL DESC undelete discount period
UPDATE discount_periods SET is_expired=0 WHERE id='7';

-- ERROR account tariff link 355 linked to deleted discount period 7
-- SQL DESC undelete discount period
UPDATE discount_periods SET is_expired=0 WHERE id='7';

-- ERROR account tariff link 356 linked to deleted discount period 7
-- SQL DESC undelete discount period
UPDATE discount_periods SET is_expired=0 WHERE id='7';

-- ERROR account tariff link 357 linked to deleted discount period 7
-- SQL DESC undelete discount period
UPDATE discount_periods SET is_expired=0 WHERE id='7';

-- ERROR account tariff link 358 linked to deleted discount period 7
-- SQL DESC undelete discount period
UPDATE discount_periods SET is_expired=0 WHERE id='7';

-- ERROR account tariff link 359 linked to deleted discount period 7
-- SQL DESC undelete discount period
UPDATE discount_periods SET is_expired=0 WHERE id='7';

-- ERROR account tariff link 360 linked to deleted discount period 7
-- SQL DESC undelete discount period
UPDATE discount_periods SET is_expired=0 WHERE id='7';

-- ERROR account tariff link 361 linked to deleted discount period 7
-- SQL DESC undelete discount period
UPDATE discount_periods SET is_expired=0 WHERE id='7';

-- ERROR account tariff link 362 linked to deleted discount period 7
-- SQL DESC undelete discount period
UPDATE discount_periods SET is_expired=0 WHERE id='7';

-- ERROR account tariff link 363 linked to deleted discount period 7
-- SQL DESC undelete discount period
UPDATE discount_periods SET is_expired=0 WHERE id='7';

-- ERROR account tariff link 364 linked to deleted discount period 7
-- SQL DESC undelete discount period
UPDATE discount_periods SET is_expired=0 WHERE id='7';

-- ERROR account tariff link 365 linked to deleted discount period 7
-- SQL DESC undelete discount period
UPDATE discount_periods SET is_expired=0 WHERE id='7';

-- WARNING slink 20 exists enly in dtagg_periodic
-- SQL DESC check slink exists and delete dtagg_periodic entry for deleted slink
UPDATE dtagg_periodic SET is_closed=1 WHERE slink_id=20;

-- WARNING slink 21 exists enly in dtagg_periodic
-- SQL DESC check slink exists and delete dtagg_periodic entry for deleted slink
UPDATE dtagg_periodic SET is_closed=1 WHERE slink_id=21;

-- WARNING slink 1 exists enly in dtagg_iptraffic
-- SQL DESC check slink exists and delete dtagg_iptraffic entry for deleted slink
UPDATE dtagg_iptraffic SET is_closed=1 WHERE slink_id=1;

-- WARNING slink 1 exists enly in dtagg_iptraffic
-- SQL DESC check slink exists and delete dtagg_iptraffic entry for deleted slink
UPDATE dtagg_iptraffic SET is_closed=1 WHERE slink_id=1;

-- WARNING slink 2 exists enly in dtagg_iptraffic
-- SQL DESC check slink exists and delete dtagg_iptraffic entry for deleted slink
UPDATE dtagg_iptraffic SET is_closed=1 WHERE slink_id=2;

-- WARNING slink 2 exists enly in dtagg_iptraffic
-- SQL DESC check slink exists and delete dtagg_iptraffic entry for deleted slink
UPDATE dtagg_iptraffic SET is_closed=1 WHERE slink_id=2;

-- WARNING slink 2 exists enly in dtagg_iptraffic
-- SQL DESC check slink exists and delete dtagg_iptraffic entry for deleted slink
UPDATE dtagg_iptraffic SET is_closed=1 WHERE slink_id=2;

-- WARNING slink 2 exists enly in dtagg_iptraffic
-- SQL DESC check slink exists and delete dtagg_iptraffic entry for deleted slink
UPDATE dtagg_iptraffic SET is_closed=1 WHERE slink_id=2;

-- WARNING slink 2 exists enly in dtagg_iptraffic
-- SQL DESC check slink exists and delete dtagg_iptraffic entry for deleted slink
UPDATE dtagg_iptraffic SET is_closed=1 WHERE slink_id=2;

-- WARNING slink 2 exists enly in dtagg_iptraffic
-- SQL DESC check slink exists and delete dtagg_iptraffic entry for deleted slink
UPDATE dtagg_iptraffic SET is_closed=1 WHERE slink_id=2;

-- WARNING slink 2 exists enly in dtagg_iptraffic
-- SQL DESC check slink exists and delete dtagg_iptraffic entry for deleted slink
UPDATE dtagg_iptraffic SET is_closed=1 WHERE slink_id=2;

-- WARNING slink 2 exists enly in dtagg_iptraffic
-- SQL DESC check slink exists and delete dtagg_iptraffic entry for deleted slink
UPDATE dtagg_iptraffic SET is_closed=1 WHERE slink_id=2;

-- WARNING slink 3 exists enly in dtagg_iptraffic
-- SQL DESC check slink exists and delete dtagg_iptraffic entry for deleted slink
UPDATE dtagg_iptraffic SET is_closed=1 WHERE slink_id=3;

-- WARNING slink 3 exists enly in dtagg_iptraffic
-- SQL DESC check slink exists and delete dtagg_iptraffic entry for deleted slink
UPDATE dtagg_iptraffic SET is_closed=1 WHERE slink_id=3;

-- WARNING slink 3 exists enly in dtagg_iptraffic
-- SQL DESC check slink exists and delete dtagg_iptraffic entry for deleted slink
UPDATE dtagg_iptraffic SET is_closed=1 WHERE slink_id=3;

-- WARNING slink 3 exists enly in dtagg_iptraffic
-- SQL DESC check slink exists and delete dtagg_iptraffic entry for deleted slink
UPDATE dtagg_iptraffic SET is_closed=1 WHERE slink_id=3;

-- WARNING slink 3 exists enly in dtagg_iptraffic
-- SQL DESC check slink exists and delete dtagg_iptraffic entry for deleted slink
UPDATE dtagg_iptraffic SET is_closed=1 WHERE slink_id=3;

-- WARNING slink 3 exists enly in dtagg_iptraffic
-- SQL DESC check slink exists and delete dtagg_iptraffic entry for deleted slink
UPDATE dtagg_iptraffic SET is_closed=1 WHERE slink_id=3;

-- WARNING slink 4 exists enly in dtagg_iptraffic
-- SQL DESC check slink exists and delete dtagg_iptraffic entry for deleted slink
UPDATE dtagg_iptraffic SET is_closed=1 WHERE slink_id=4;

-- WARNING slink 4 exists enly in dtagg_iptraffic
-- SQL DESC check slink exists and delete dtagg_iptraffic entry for deleted slink
UPDATE dtagg_iptraffic SET is_closed=1 WHERE slink_id=4;

-- WARNING slink 4 exists enly in dtagg_iptraffic
-- SQL DESC check slink exists and delete dtagg_iptraffic entry for deleted slink
UPDATE dtagg_iptraffic SET is_closed=1 WHERE slink_id=4;

-- WARNING slink 4 exists enly in dtagg_iptraffic
-- SQL DESC check slink exists and delete dtagg_iptraffic entry for deleted slink
UPDATE dtagg_iptraffic SET is_closed=1 WHERE slink_id=4;

-- WARNING slink 4 exists enly in dtagg_iptraffic
-- SQL DESC check slink exists and delete dtagg_iptraffic entry for deleted slink
UPDATE dtagg_iptraffic SET is_closed=1 WHERE slink_id=4;

-- WARNING slink 4 exists enly in dtagg_iptraffic
-- SQL DESC check slink exists and delete dtagg_iptraffic entry for deleted slink
UPDATE dtagg_iptraffic SET is_closed=1 WHERE slink_id=4;

-- WARNING slink 4 exists enly in dtagg_iptraffic
-- SQL DESC check slink exists and delete dtagg_iptraffic entry for deleted slink
UPDATE dtagg_iptraffic SET is_closed=1 WHERE slink_id=4;

-- WARNING slink 6 exists enly in dtagg_iptraffic
-- SQL DESC check slink exists and delete dtagg_iptraffic entry for deleted slink
UPDATE dtagg_iptraffic SET is_closed=1 WHERE slink_id=6;

-- WARNING slink 6 exists enly in dtagg_iptraffic
-- SQL DESC check slink exists and delete dtagg_iptraffic entry for deleted slink
UPDATE dtagg_iptraffic SET is_closed=1 WHERE slink_id=6;

-- WARNING slink 6 exists enly in dtagg_iptraffic
-- SQL DESC check slink exists and delete dtagg_iptraffic entry for deleted slink
UPDATE dtagg_iptraffic SET is_closed=1 WHERE slink_id=6;

-- WARNING slink 6 exists enly in dtagg_iptraffic
-- SQL DESC check slink exists and delete dtagg_iptraffic entry for deleted slink
UPDATE dtagg_iptraffic SET is_closed=1 WHERE slink_id=6;

-- WARNING slink 8 exists enly in dtagg_iptraffic
-- SQL DESC check slink exists and delete dtagg_iptraffic entry for deleted slink
UPDATE dtagg_iptraffic SET is_closed=1 WHERE slink_id=8;

-- WARNING slink 8 exists enly in dtagg_iptraffic
-- SQL DESC check slink exists and delete dtagg_iptraffic entry for deleted slink
UPDATE dtagg_iptraffic SET is_closed=1 WHERE slink_id=8;

-- WARNING slink 19 exists enly in dtagg_iptraffic
-- SQL DESC check slink exists and delete dtagg_iptraffic entry for deleted slink
UPDATE dtagg_iptraffic SET is_closed=1 WHERE slink_id=19;

-- WARNING slink 19 exists enly in dtagg_iptraffic
-- SQL DESC check slink exists and delete dtagg_iptraffic entry for deleted slink
UPDATE dtagg_iptraffic SET is_closed=1 WHERE slink_id=19;

-- WARNING slink 44 exists enly in dtagg_iptraffic
-- SQL DESC check slink exists and delete dtagg_iptraffic entry for deleted slink
UPDATE dtagg_iptraffic SET is_closed=1 WHERE slink_id=44;

-- WARNING slink 44 exists enly in dtagg_iptraffic
-- SQL DESC check slink exists and delete dtagg_iptraffic entry for deleted slink
UPDATE dtagg_iptraffic SET is_closed=1 WHERE slink_id=44;

-- WARNING slink 58 exists enly in dtagg_iptraffic
-- SQL DESC check slink exists and delete dtagg_iptraffic entry for deleted slink
UPDATE dtagg_iptraffic SET is_closed=1 WHERE slink_id=58;

-- WARNING slink 58 exists enly in dtagg_iptraffic
-- SQL DESC check slink exists and delete dtagg_iptraffic entry for deleted slink
UPDATE dtagg_iptraffic SET is_closed=1 WHERE slink_id=58;

-- WARNING slink 58 exists enly in dtagg_iptraffic
-- SQL DESC check slink exists and delete dtagg_iptraffic entry for deleted slink
UPDATE dtagg_iptraffic SET is_closed=1 WHERE slink_id=58;

-- WARNING slink 58 exists enly in dtagg_iptraffic
-- SQL DESC check slink exists and delete dtagg_iptraffic entry for deleted slink
UPDATE dtagg_iptraffic SET is_closed=1 WHERE slink_id=58;

-- WARNING slink 75 exists enly in dtagg_iptraffic
-- SQL DESC check slink exists and delete dtagg_iptraffic entry for deleted slink
UPDATE dtagg_iptraffic SET is_closed=1 WHERE slink_id=75;

-- WARNING slink 75 exists enly in dtagg_iptraffic
-- SQL DESC check slink exists and delete dtagg_iptraffic entry for deleted slink
UPDATE dtagg_iptraffic SET is_closed=1 WHERE slink_id=75;

-- WARNING traffic classes for slink 83 exists enly in dtagg_iptraffic
-- SQL DESC check traffic class exists and delete dtagg_iptraffic entry for deleted tclass
UPDATE dtagg_iptraffic SET is_closed=1 WHERE tclass=0;

-- WARNING slink 84 exists enly in dtagg_iptraffic
-- SQL DESC check slink exists and delete dtagg_iptraffic entry for deleted slink
UPDATE dtagg_iptraffic SET is_closed=1 WHERE slink_id=84;

-- WARNING slink 84 exists enly in dtagg_iptraffic
-- SQL DESC check slink exists and delete dtagg_iptraffic entry for deleted slink
UPDATE dtagg_iptraffic SET is_closed=1 WHERE slink_id=84;

-- WARNING slink 84 exists enly in dtagg_iptraffic
-- SQL DESC check slink exists and delete dtagg_iptraffic entry for deleted slink
UPDATE dtagg_iptraffic SET is_closed=1 WHERE slink_id=84;

-- WARNING slink 84 exists enly in dtagg_iptraffic
-- SQL DESC check slink exists and delete dtagg_iptraffic entry for deleted slink
UPDATE dtagg_iptraffic SET is_closed=1 WHERE slink_id=84;

-- WARNING slink 85 exists enly in dtagg_iptraffic
-- SQL DESC check slink exists and delete dtagg_iptraffic entry for deleted slink
UPDATE dtagg_iptraffic SET is_closed=1 WHERE slink_id=85;

-- WARNING slink 85 exists enly in dtagg_iptraffic
-- SQL DESC check slink exists and delete dtagg_iptraffic entry for deleted slink
UPDATE dtagg_iptraffic SET is_closed=1 WHERE slink_id=85;

-- WARNING slink 85 exists enly in dtagg_iptraffic
-- SQL DESC check slink exists and delete dtagg_iptraffic entry for deleted slink
UPDATE dtagg_iptraffic SET is_closed=1 WHERE slink_id=85;

-- WARNING slink 85 exists enly in dtagg_iptraffic
-- SQL DESC check slink exists and delete dtagg_iptraffic entry for deleted slink
UPDATE dtagg_iptraffic SET is_closed=1 WHERE slink_id=85;

-- WARNING traffic classes for slink 90 exists enly in dtagg_iptraffic
-- SQL DESC check traffic class exists and delete dtagg_iptraffic entry for deleted tclass
UPDATE dtagg_iptraffic SET is_closed=1 WHERE tclass=0;

-- WARNING traffic classes for slink 90 exists enly in dtagg_iptraffic
-- SQL DESC check traffic class exists and delete dtagg_iptraffic entry for deleted tclass
UPDATE dtagg_iptraffic SET is_closed=1 WHERE tclass=0;

-- WARNING traffic classes for slink 55 exists enly in dtagg_iptraffic
-- SQL DESC check traffic class exists and delete dtagg_iptraffic entry for deleted tclass
UPDATE dtagg_iptraffic SET is_closed=1 WHERE tclass=0;

-- WARNING slink 85 exists enly in dtagg_iptraffic
-- SQL DESC check slink exists and delete dtagg_iptraffic entry for deleted slink
UPDATE dtagg_iptraffic SET is_closed=1 WHERE slink_id=85;

-- WARNING traffic classes for slink 47 exists enly in dtagg_iptraffic
-- SQL DESC check traffic class exists and delete dtagg_iptraffic entry for deleted tclass
UPDATE dtagg_iptraffic SET is_closed=1 WHERE tclass=0;

-- WARNING traffic classes for slink 56 exists enly in dtagg_iptraffic
-- SQL DESC check traffic class exists and delete dtagg_iptraffic entry for deleted tclass
UPDATE dtagg_iptraffic SET is_closed=1 WHERE tclass=0;

-- WARNING slink 84 exists enly in dtagg_iptraffic
-- SQL DESC check slink exists and delete dtagg_iptraffic entry for deleted slink
UPDATE dtagg_iptraffic SET is_closed=1 WHERE slink_id=84;

-- WARNING traffic classes for slink 81 exists enly in dtagg_iptraffic
-- SQL DESC check traffic class exists and delete dtagg_iptraffic entry for deleted tclass
UPDATE dtagg_iptraffic SET is_closed=1 WHERE tclass=0;

-- WARNING traffic classes for slink 76 exists enly in dtagg_iptraffic
-- SQL DESC check traffic class exists and delete dtagg_iptraffic entry for deleted tclass
UPDATE dtagg_iptraffic SET is_closed=1 WHERE tclass=0;

-- WARNING traffic classes for slink 89 exists enly in dtagg_iptraffic
-- SQL DESC check traffic class exists and delete dtagg_iptraffic entry for deleted tclass
UPDATE dtagg_iptraffic SET is_closed=1 WHERE tclass=0;

-- WARNING traffic classes for slink 52 exists enly in dtagg_iptraffic
-- SQL DESC check traffic class exists and delete dtagg_iptraffic entry for deleted tclass
UPDATE dtagg_iptraffic SET is_closed=1 WHERE tclass=0;

-- WARNING traffic classes for slink 17 exists enly in dtagg_iptraffic
-- SQL DESC check traffic class exists and delete dtagg_iptraffic entry for deleted tclass
UPDATE dtagg_iptraffic SET is_closed=1 WHERE tclass=0;

-- WARNING traffic classes for slink 29 exists enly in dtagg_iptraffic
-- SQL DESC check traffic class exists and delete dtagg_iptraffic entry for deleted tclass
UPDATE dtagg_iptraffic SET is_closed=1 WHERE tclass=0;

-- WARNING traffic classes for slink 42 exists enly in dtagg_iptraffic
-- SQL DESC check traffic class exists and delete dtagg_iptraffic entry for deleted tclass
UPDATE dtagg_iptraffic SET is_closed=1 WHERE tclass=0;

-- WARNING traffic classes for slink 37 exists enly in dtagg_iptraffic
-- SQL DESC check traffic class exists and delete dtagg_iptraffic entry for deleted tclass
UPDATE dtagg_iptraffic SET is_closed=1 WHERE tclass=0;

-- WARNING traffic classes for slink 32 exists enly in dtagg_iptraffic
-- SQL DESC check traffic class exists and delete dtagg_iptraffic entry for deleted tclass
UPDATE dtagg_iptraffic SET is_closed=1 WHERE tclass=0;

-- WARNING traffic classes for slink 24 exists enly in dtagg_iptraffic
-- SQL DESC check traffic class exists and delete dtagg_iptraffic entry for deleted tclass
UPDATE dtagg_iptraffic SET is_closed=1 WHERE tclass=0;

-- WARNING traffic classes for slink 9 exists enly in dtagg_iptraffic
-- SQL DESC check traffic class exists and delete dtagg_iptraffic entry for deleted tclass
UPDATE dtagg_iptraffic SET is_closed=1 WHERE tclass=0;

-- WARNING traffic classes for slink 28 exists enly in dtagg_iptraffic
-- SQL DESC check traffic class exists and delete dtagg_iptraffic entry for deleted tclass
UPDATE dtagg_iptraffic SET is_closed=1 WHERE tclass=0;

-- WARNING traffic classes for slink 16 exists enly in dtagg_iptraffic
-- SQL DESC check traffic class exists and delete dtagg_iptraffic entry for deleted tclass
UPDATE dtagg_iptraffic SET is_closed=1 WHERE tclass=0;

-- WARNING traffic classes for slink 10 exists enly in dtagg_iptraffic
-- SQL DESC check traffic class exists and delete dtagg_iptraffic entry for deleted tclass
UPDATE dtagg_iptraffic SET is_closed=1 WHERE tclass=0;

-- WARNING slink 58 exists enly in dtagg_iptraffic
-- SQL DESC check slink exists and delete dtagg_iptraffic entry for deleted slink
UPDATE dtagg_iptraffic SET is_closed=1 WHERE slink_id=58;

-- WARNING traffic classes for slink 46 exists enly in dtagg_iptraffic
-- SQL DESC check traffic class exists and delete dtagg_iptraffic entry for deleted tclass
UPDATE dtagg_iptraffic SET is_closed=1 WHERE tclass=0;

-- WARNING traffic classes for slink 50 exists enly in dtagg_iptraffic
-- SQL DESC check traffic class exists and delete dtagg_iptraffic entry for deleted tclass
UPDATE dtagg_iptraffic SET is_closed=1 WHERE tclass=0;

-- WARNING traffic classes for slink 13 exists enly in dtagg_iptraffic
-- SQL DESC check traffic class exists and delete dtagg_iptraffic entry for deleted tclass
UPDATE dtagg_iptraffic SET is_closed=1 WHERE tclass=0;

-- WARNING traffic classes for slink 63 exists enly in dtagg_iptraffic
-- SQL DESC check traffic class exists and delete dtagg_iptraffic entry for deleted tclass
UPDATE dtagg_iptraffic SET is_closed=1 WHERE tclass=0;

-- WARNING traffic classes for slink 30 exists enly in dtagg_iptraffic
-- SQL DESC check traffic class exists and delete dtagg_iptraffic entry for deleted tclass
UPDATE dtagg_iptraffic SET is_closed=1 WHERE tclass=0;

-- WARNING traffic classes for slink 65 exists enly in dtagg_iptraffic
-- SQL DESC check traffic class exists and delete dtagg_iptraffic entry for deleted tclass
UPDATE dtagg_iptraffic SET is_closed=1 WHERE tclass=0;

-- WARNING traffic classes for slink 22 exists enly in dtagg_iptraffic
-- SQL DESC check traffic class exists and delete dtagg_iptraffic entry for deleted tclass
UPDATE dtagg_iptraffic SET is_closed=1 WHERE tclass=0;

-- WARNING traffic classes for slink 79 exists enly in dtagg_iptraffic
-- SQL DESC check traffic class exists and delete dtagg_iptraffic entry for deleted tclass
UPDATE dtagg_iptraffic SET is_closed=1 WHERE tclass=0;

-- WARNING traffic classes for slink 53 exists enly in dtagg_iptraffic
-- SQL DESC check traffic class exists and delete dtagg_iptraffic entry for deleted tclass
UPDATE dtagg_iptraffic SET is_closed=1 WHERE tclass=0;

-- WARNING traffic classes for slink 31 exists enly in dtagg_iptraffic
-- SQL DESC check traffic class exists and delete dtagg_iptraffic entry for deleted tclass
UPDATE dtagg_iptraffic SET is_closed=1 WHERE tclass=0;

-- WARNING traffic classes for slink 34 exists enly in dtagg_iptraffic
-- SQL DESC check traffic class exists and delete dtagg_iptraffic entry for deleted tclass
UPDATE dtagg_iptraffic SET is_closed=1 WHERE tclass=0;

-- WARNING traffic classes for slink 18 exists enly in dtagg_iptraffic
-- SQL DESC check traffic class exists and delete dtagg_iptraffic entry for deleted tclass
UPDATE dtagg_iptraffic SET is_closed=1 WHERE tclass=0;

-- WARNING traffic classes for slink 82 exists enly in dtagg_iptraffic
-- SQL DESC check traffic class exists and delete dtagg_iptraffic entry for deleted tclass
UPDATE dtagg_iptraffic SET is_closed=1 WHERE tclass=0;

-- WARNING traffic classes for slink 33 exists enly in dtagg_iptraffic
-- SQL DESC check traffic class exists and delete dtagg_iptraffic entry for deleted tclass
UPDATE dtagg_iptraffic SET is_closed=1 WHERE tclass=0;

-- WARNING traffic classes for slink 69 exists enly in dtagg_iptraffic
-- SQL DESC check traffic class exists and delete dtagg_iptraffic entry for deleted tclass
UPDATE dtagg_iptraffic SET is_closed=1 WHERE tclass=0;

-- WARNING traffic classes for slink 26 exists enly in dtagg_iptraffic
-- SQL DESC check traffic class exists and delete dtagg_iptraffic entry for deleted tclass
UPDATE dtagg_iptraffic SET is_closed=1 WHERE tclass=0;

-- WARNING traffic classes for slink 39 exists enly in dtagg_iptraffic
-- SQL DESC check traffic class exists and delete dtagg_iptraffic entry for deleted tclass
UPDATE dtagg_iptraffic SET is_closed=1 WHERE tclass=0;

-- WARNING traffic classes for slink 35 exists enly in dtagg_iptraffic
-- SQL DESC check traffic class exists and delete dtagg_iptraffic entry for deleted tclass
UPDATE dtagg_iptraffic SET is_closed=1 WHERE tclass=0;

-- WARNING traffic classes for slink 27 exists enly in dtagg_iptraffic
-- SQL DESC check traffic class exists and delete dtagg_iptraffic entry for deleted tclass
UPDATE dtagg_iptraffic SET is_closed=1 WHERE tclass=0;

-- WARNING traffic classes for slink 87 exists enly in dtagg_iptraffic
-- SQL DESC check traffic class exists and delete dtagg_iptraffic entry for deleted tclass
UPDATE dtagg_iptraffic SET is_closed=1 WHERE tclass=0;

-- WARNING traffic classes for slink 70 exists enly in dtagg_iptraffic
-- SQL DESC check traffic class exists and delete dtagg_iptraffic entry for deleted tclass
UPDATE dtagg_iptraffic SET is_closed=1 WHERE tclass=0;

-- WARNING traffic classes for slink 41 exists enly in dtagg_iptraffic
-- SQL DESC check traffic class exists and delete dtagg_iptraffic entry for deleted tclass
UPDATE dtagg_iptraffic SET is_closed=1 WHERE tclass=0;

-- WARNING traffic classes for slink 66 exists enly in dtagg_iptraffic
-- SQL DESC check traffic class exists and delete dtagg_iptraffic entry for deleted tclass
UPDATE dtagg_iptraffic SET is_closed=1 WHERE tclass=0;

-- WARNING traffic classes for slink 62 exists enly in dtagg_iptraffic
-- SQL DESC check traffic class exists and delete dtagg_iptraffic entry for deleted tclass
UPDATE dtagg_iptraffic SET is_closed=1 WHERE tclass=0;

-- WARNING traffic classes for slink 68 exists enly in dtagg_iptraffic
-- SQL DESC check traffic class exists and delete dtagg_iptraffic entry for deleted tclass
UPDATE dtagg_iptraffic SET is_closed=1 WHERE tclass=0;

-- WARNING traffic classes for slink 78 exists enly in dtagg_iptraffic
-- SQL DESC check traffic class exists and delete dtagg_iptraffic entry for deleted tclass
UPDATE dtagg_iptraffic SET is_closed=1 WHERE tclass=0;

-- WARNING traffic classes for slink 15 exists enly in dtagg_iptraffic
-- SQL DESC check traffic class exists and delete dtagg_iptraffic entry for deleted tclass
UPDATE dtagg_iptraffic SET is_closed=1 WHERE tclass=0;

-- WARNING traffic classes for slink 67 exists enly in dtagg_iptraffic
-- SQL DESC check traffic class exists and delete dtagg_iptraffic entry for deleted tclass
UPDATE dtagg_iptraffic SET is_closed=1 WHERE tclass=0;

-- WARNING traffic classes for slink 12 exists enly in dtagg_iptraffic
-- SQL DESC check traffic class exists and delete dtagg_iptraffic entry for deleted tclass
UPDATE dtagg_iptraffic SET is_closed=1 WHERE tclass=0;

-- WARNING traffic classes for slink 40 exists enly in dtagg_iptraffic
-- SQL DESC check traffic class exists and delete dtagg_iptraffic entry for deleted tclass
UPDATE dtagg_iptraffic SET is_closed=1 WHERE tclass=0;

-- WARNING traffic classes for slink 80 exists enly in dtagg_iptraffic
-- SQL DESC check traffic class exists and delete dtagg_iptraffic entry for deleted tclass
UPDATE dtagg_iptraffic SET is_closed=1 WHERE tclass=0;

-- WARNING traffic classes for slink 38 exists enly in dtagg_iptraffic
-- SQL DESC check traffic class exists and delete dtagg_iptraffic entry for deleted tclass
UPDATE dtagg_iptraffic SET is_closed=1 WHERE tclass=0;

-- WARNING traffic classes for slink 11 exists enly in dtagg_iptraffic
-- SQL DESC check traffic class exists and delete dtagg_iptraffic entry for deleted tclass
UPDATE dtagg_iptraffic SET is_closed=1 WHERE tclass=0;

-- WARNING traffic classes for slink 14 exists enly in dtagg_iptraffic
-- SQL DESC check traffic class exists and delete dtagg_iptraffic entry for deleted tclass
UPDATE dtagg_iptraffic SET is_closed=1 WHERE tclass=0;

-- WARNING traffic classes for slink 57 exists enly in dtagg_iptraffic
-- SQL DESC check traffic class exists and delete dtagg_iptraffic entry for deleted tclass
UPDATE dtagg_iptraffic SET is_closed=1 WHERE tclass=0;

-- WARNING traffic classes for slink 49 exists enly in dtagg_iptraffic
-- SQL DESC check traffic class exists and delete dtagg_iptraffic entry for deleted tclass
UPDATE dtagg_iptraffic SET is_closed=1 WHERE tclass=0;

-- WARNING traffic classes for slink 43 exists enly in dtagg_iptraffic
-- SQL DESC check traffic class exists and delete dtagg_iptraffic entry for deleted tclass
UPDATE dtagg_iptraffic SET is_closed=1 WHERE tclass=0;

-- WARNING traffic classes for slink 77 exists enly in dtagg_iptraffic
-- SQL DESC check traffic class exists and delete dtagg_iptraffic entry for deleted tclass
UPDATE dtagg_iptraffic SET is_closed=1 WHERE tclass=0;

-- WARNING traffic classes for slink 54 exists enly in dtagg_iptraffic
-- SQL DESC check traffic class exists and delete dtagg_iptraffic entry for deleted tclass
UPDATE dtagg_iptraffic SET is_closed=1 WHERE tclass=0;

-- WARNING traffic classes for slink 36 exists enly in dtagg_iptraffic
-- SQL DESC check traffic class exists and delete dtagg_iptraffic entry for deleted tclass
UPDATE dtagg_iptraffic SET is_closed=1 WHERE tclass=0;

-- WARNING traffic classes for slink 51 exists enly in dtagg_iptraffic
-- SQL DESC check traffic class exists and delete dtagg_iptraffic entry for deleted tclass
UPDATE dtagg_iptraffic SET is_closed=1 WHERE tclass=0;

-- WARNING traffic classes for slink 73 exists enly in dtagg_iptraffic
-- SQL DESC check traffic class exists and delete dtagg_iptraffic entry for deleted tclass
UPDATE dtagg_iptraffic SET is_closed=1 WHERE tclass=0;

-- WARNING traffic classes for slink 74 exists enly in dtagg_iptraffic
-- SQL DESC check traffic class exists and delete dtagg_iptraffic entry for deleted tclass
UPDATE dtagg_iptraffic SET is_closed=1 WHERE tclass=0;

-- WARNING traffic classes for slink 23 exists enly in dtagg_iptraffic
-- SQL DESC check traffic class exists and delete dtagg_iptraffic entry for deleted tclass
UPDATE dtagg_iptraffic SET is_closed=1 WHERE tclass=0;

-- WARNING traffic classes for slink 25 exists enly in dtagg_iptraffic
-- SQL DESC check traffic class exists and delete dtagg_iptraffic entry for deleted tclass
UPDATE dtagg_iptraffic SET is_closed=1 WHERE tclass=0;

-- WARNING traffic classes for slink 96 exists enly in dtagg_iptraffic
-- SQL DESC check traffic class exists and delete dtagg_iptraffic entry for deleted tclass
UPDATE dtagg_iptraffic SET is_closed=1 WHERE tclass=0;

-- WARNING traffic classes for slink 96 exists enly in dtagg_iptraffic
-- SQL DESC check traffic class exists and delete dtagg_iptraffic entry for deleted tclass
UPDATE dtagg_iptraffic SET is_closed=1 WHERE tclass=0;

-- WARNING traffic classes for slink 98 exists enly in dtagg_iptraffic
-- SQL DESC check traffic class exists and delete dtagg_iptraffic entry for deleted tclass
UPDATE dtagg_iptraffic SET is_closed=1 WHERE tclass=0;

-- WARNING traffic classes for slink 101 exists enly in dtagg_iptraffic
-- SQL DESC check traffic class exists and delete dtagg_iptraffic entry for deleted tclass
UPDATE dtagg_iptraffic SET is_closed=1 WHERE tclass=0;

-- WARNING slink 100 exists enly in dtagg_iptraffic
-- SQL DESC check slink exists and delete dtagg_iptraffic entry for deleted slink
UPDATE dtagg_iptraffic SET is_closed=1 WHERE slink_id=100;

-- WARNING slink 100 exists enly in dtagg_iptraffic
-- SQL DESC check slink exists and delete dtagg_iptraffic entry for deleted slink
UPDATE dtagg_iptraffic SET is_closed=1 WHERE slink_id=100;

-- WARNING slink 104 exists enly in dtagg_iptraffic
-- SQL DESC check slink exists and delete dtagg_iptraffic entry for deleted slink
UPDATE dtagg_iptraffic SET is_closed=1 WHERE slink_id=104;

-- WARNING slink 104 exists enly in dtagg_iptraffic
-- SQL DESC check slink exists and delete dtagg_iptraffic entry for deleted slink
UPDATE dtagg_iptraffic SET is_closed=1 WHERE slink_id=104;

-- WARNING slink 104 exists enly in dtagg_iptraffic
-- SQL DESC check slink exists and delete dtagg_iptraffic entry for deleted slink
UPDATE dtagg_iptraffic SET is_closed=1 WHERE slink_id=104;

-- WARNING traffic classes for slink 98 exists enly in dtagg_iptraffic
-- SQL DESC check traffic class exists and delete dtagg_iptraffic entry for deleted tclass
UPDATE dtagg_iptraffic SET is_closed=1 WHERE tclass=0;

-- WARNING traffic classes for slink 96 exists enly in dtagg_iptraffic
-- SQL DESC check traffic class exists and delete dtagg_iptraffic entry for deleted tclass
UPDATE dtagg_iptraffic SET is_closed=1 WHERE tclass=0;

-- WARNING traffic classes for slink 101 exists enly in dtagg_iptraffic
-- SQL DESC check traffic class exists and delete dtagg_iptraffic entry for deleted tclass
UPDATE dtagg_iptraffic SET is_closed=1 WHERE tclass=0;

-- WARNING slink 100 exists enly in dtagg_iptraffic
-- SQL DESC check slink exists and delete dtagg_iptraffic entry for deleted slink
UPDATE dtagg_iptraffic SET is_closed=1 WHERE slink_id=100;

-- WARNING slink 100 exists enly in dtagg_iptraffic
-- SQL DESC check slink exists and delete dtagg_iptraffic entry for deleted slink
UPDATE dtagg_iptraffic SET is_closed=1 WHERE slink_id=100;

-- WARNING traffic classes for slink 96 exists enly in dtagg_iptraffic
-- SQL DESC check traffic class exists and delete dtagg_iptraffic entry for deleted tclass
UPDATE dtagg_iptraffic SET is_closed=1 WHERE tclass=0;

-- WARNING traffic classes for slink 98 exists enly in dtagg_iptraffic
-- SQL DESC check traffic class exists and delete dtagg_iptraffic entry for deleted tclass
UPDATE dtagg_iptraffic SET is_closed=1 WHERE tclass=0;

-- WARNING traffic classes for slink 101 exists enly in dtagg_iptraffic
-- SQL DESC check traffic class exists and delete dtagg_iptraffic entry for deleted tclass
UPDATE dtagg_iptraffic SET is_closed=1 WHERE tclass=0;

-- WARNING traffic classes for slink 99 exists enly in dtagg_iptraffic
-- SQL DESC check traffic class exists and delete dtagg_iptraffic entry for deleted tclass
UPDATE dtagg_iptraffic SET is_closed=1 WHERE tclass=0;

-- WARNING traffic classes for slink 107 exists enly in dtagg_iptraffic
-- SQL DESC check traffic class exists and delete dtagg_iptraffic entry for deleted tclass
UPDATE dtagg_iptraffic SET is_closed=1 WHERE tclass=0;

-- WARNING traffic classes for slink 108 exists enly in dtagg_iptraffic
-- SQL DESC check traffic class exists and delete dtagg_iptraffic entry for deleted tclass
UPDATE dtagg_iptraffic SET is_closed=1 WHERE tclass=0;

-- WARNING traffic classes for slink 106 exists enly in dtagg_iptraffic
-- SQL DESC check traffic class exists and delete dtagg_iptraffic entry for deleted tclass
UPDATE dtagg_iptraffic SET is_closed=1 WHERE tclass=0;

-- WARNING slink 109 exists enly in dtagg_iptraffic
-- SQL DESC check slink exists and delete dtagg_iptraffic entry for deleted slink
UPDATE dtagg_iptraffic SET is_closed=1 WHERE slink_id=109;

-- WARNING slink 109 exists enly in dtagg_iptraffic
-- SQL DESC check slink exists and delete dtagg_iptraffic entry for deleted slink
UPDATE dtagg_iptraffic SET is_closed=1 WHERE slink_id=109;

-- WARNING slink 113 exists enly in dtagg_iptraffic
-- SQL DESC check slink exists and delete dtagg_iptraffic entry for deleted slink
UPDATE dtagg_iptraffic SET is_closed=1 WHERE slink_id=113;

-- WARNING slink 113 exists enly in dtagg_iptraffic
-- SQL DESC check slink exists and delete dtagg_iptraffic entry for deleted slink
UPDATE dtagg_iptraffic SET is_closed=1 WHERE slink_id=113;

-- WARNING slink 113 exists enly in dtagg_iptraffic
-- SQL DESC check slink exists and delete dtagg_iptraffic entry for deleted slink
UPDATE dtagg_iptraffic SET is_closed=1 WHERE slink_id=113;

-- WARNING slink 114 exists enly in dtagg_iptraffic
-- SQL DESC check slink exists and delete dtagg_iptraffic entry for deleted slink
UPDATE dtagg_iptraffic SET is_closed=1 WHERE slink_id=114;

-- WARNING slink 114 exists enly in dtagg_iptraffic
-- SQL DESC check slink exists and delete dtagg_iptraffic entry for deleted slink
UPDATE dtagg_iptraffic SET is_closed=1 WHERE slink_id=114;

-- WARNING traffic classes for slink 116 exists enly in dtagg_iptraffic
-- SQL DESC check traffic class exists and delete dtagg_iptraffic entry for deleted tclass
UPDATE dtagg_iptraffic SET is_closed=1 WHERE tclass=0;

-- WARNING traffic classes for slink 121 exists enly in dtagg_iptraffic
-- SQL DESC check traffic class exists and delete dtagg_iptraffic entry for deleted tclass
UPDATE dtagg_iptraffic SET is_closed=1 WHERE tclass=0;

-- WARNING traffic classes for slink 120 exists enly in dtagg_iptraffic
-- SQL DESC check traffic class exists and delete dtagg_iptraffic entry for deleted tclass
UPDATE dtagg_iptraffic SET is_closed=1 WHERE tclass=0;

-- WARNING traffic classes for slink 124 exists enly in dtagg_iptraffic
-- SQL DESC check traffic class exists and delete dtagg_iptraffic entry for deleted tclass
UPDATE dtagg_iptraffic SET is_closed=1 WHERE tclass=0;

-- WARNING traffic classes for slink 125 exists enly in dtagg_iptraffic
-- SQL DESC check traffic class exists and delete dtagg_iptraffic entry for deleted tclass
UPDATE dtagg_iptraffic SET is_closed=1 WHERE tclass=0;

-- WARNING slink 71 exists enly in dtagg_iptraffic
-- SQL DESC check slink exists and delete dtagg_iptraffic entry for deleted slink
UPDATE dtagg_iptraffic SET is_closed=1 WHERE slink_id=71;

-- WARNING traffic classes for slink 127 exists enly in dtagg_iptraffic
-- SQL DESC check traffic class exists and delete dtagg_iptraffic entry for deleted tclass
UPDATE dtagg_iptraffic SET is_closed=1 WHERE tclass=0;

-- WARNING traffic classes for slink 129 exists enly in dtagg_iptraffic
-- SQL DESC check traffic class exists and delete dtagg_iptraffic entry for deleted tclass
UPDATE dtagg_iptraffic SET is_closed=1 WHERE tclass=0;

-- WARNING traffic classes for slink 131 exists enly in dtagg_iptraffic
-- SQL DESC check traffic class exists and delete dtagg_iptraffic entry for deleted tclass
UPDATE dtagg_iptraffic SET is_closed=1 WHERE tclass=0;

-- WARNING traffic classes for slink 132 exists enly in dtagg_iptraffic
-- SQL DESC check traffic class exists and delete dtagg_iptraffic entry for
Вернуться к началу
Lord Kaho
Сообщения: 22
Зарегистрирован: Чт май 21, 2009 12:41

Сообщение Lord Kaho »

Ну, собственно, по какой-то причине у вас удалили 7-мой период... Делайте бекап базы, потом загоняйте в базу верификатор. И так по кругу, пока не заработает. После запуска проверьте, на что это повлияло.
Вернуться к началу
vlad111
Сообщения: 5
Зарегистрирован: Пн июн 29, 2009 07:58

Сообщение vlad111 »

Lord Kaho писал(а):Ну, собственно, по какой-то причине у вас удалили 7-мой период... Делайте бекап базы, потом загоняйте в базу верификатор. И так по кругу, пока не заработает. После запуска проверьте, на что это повлияло.
Огромное спасибо, помогло.

Тема закрыта.
Вернуться к началу
Munsera
Сообщения: 126
Зарегистрирован: Чт янв 27, 2011 15:29

Сообщение Munsera »

У меня появилась такая же ошибка.
Как запустить верификатор? В мануале не нашел.
Вернуться к началу
kirush
Сообщения: 699
Зарегистрирован: Пт фев 04, 2005 13:58

Сообщение kirush »

mysql -u root -pВаш_пароль название_базы < /путь/до/verificator.log
Вернуться к началу
Ответить

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