Обновление 006 -> 007

Технические вопросы по UTM 5.0
Ответить
kirush
Сообщения: 699
Зарегистрирован: Пт фев 04, 2005 13:58

Обновление 006 -> 007

Сообщение kirush »

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

&#91;root@xxx /&#93;# mysql -u root -f UTM5 < UTM5_indexes.sql
ERROR 1091 &#40;42000&#41; at line 1&#58; Can't DROP 'charges_index_first'; check that column/key exists
ERROR 1091 &#40;42000&#41; at line 2&#58; Can't DROP 'ip_charges_index_first'; check that column/key exists
ERROR 1091 &#40;42000&#41; at line 3&#58; Can't DROP 'charges_index_second'; check that column/key exists
ERROR 1091 &#40;42000&#41; at line 4&#58; Can't DROP 'services_index_first'; check that column/key exists
ERROR 1091 &#40;42000&#41; at line 5&#58; Can't DROP 'first'; check that column/key exists
ERROR 1091 &#40;42000&#41; at line 6&#58; Can't DROP 'first_set'; check that column/key exists
ERROR 1091 &#40;42000&#41; at line 7&#58; Can't DROP 'first_block'; check that column/key exists
ERROR 1091 &#40;42000&#41; at line 8&#58; Can't DROP 'first_dow'; check that column/key exists
ERROR 1091 &#40;42000&#41; at line 9&#58; Can't DROP 'first_car'; check that column/key exists
ERROR 1064 &#40;42000&#41; at line 27&#58; You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '82e61c4e8130890872ca7d5d2eedcce7 ON discount_transactions_all' at line 1
ERROR 1091 &#40;42000&#41; at line 28&#58; Can't DROP 'b3e12acadb1bbd7f8eb9b8a9ac479e6c'; check that column/key exists
ERROR 1064 &#40;42000&#41; at line 29&#58; You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '92e08f5e788b4bcd2bd08d642d1f16f2 ON discount_transactions_all' at line 1
ERROR 1091 &#40;42000&#41; at line 30&#58; Can't DROP '71be80c932a1d596a863a4f87ba05a03'; check that column/key exists
ERROR 1091 &#40;42000&#41; at line 31&#58; Can't DROP 'a7d0ead92d1cf4a8163d3a14bd1d46f6'; check that column/key exists
ERROR 1091 &#40;42000&#41; at line 32&#58; Can't DROP '8f8204600604c1b15a5072c16ae06092'; check that column/key exists
ERROR 1064 &#40;42000&#41; at line 33&#58; You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '568e4c2b879c970a554a72b09510a746 ON discount_transactions_all' at line 1
ERROR 1091 &#40;42000&#41; at line 34&#58; Can't DROP '65de76c206634875d1728c8993f84885'; check that column/key exists
ERROR 1091 &#40;42000&#41; at line 35&#58; Can't DROP '4b6c17c0fd9f68e3e613d3882ff322a7'; check that column/key exists
ERROR 1091 &#40;42000&#41; at line 36&#58; Can't DROP 'ef21d08012d675959006724ce0a1ecac'; check that column/key exists
ERROR 1091 &#40;42000&#41; at line 37&#58; Can't DROP '204db493907b7f4ddf2336ae78db201d'; check that column/key exists
ERROR 1091 &#40;42000&#41; at line 38&#58; Can't DROP 'b37e82d403f2755b32e4baece65863a7'; check that column/key exists
ERROR 1091 &#40;42000&#41; at line 39&#58; Can't DROP 'dc6f19ab68504e59c9e28ca44c643bdb'; check that column/key exists
ERROR 1091 &#40;42000&#41; at line 40&#58; Can't DROP 'd875d2e79b84e0165fb2e50bc53ce02d'; check that column/key exists
ERROR 1091 &#40;42000&#41; at line 41&#58; Can't DROP 'f5c13400f6c8eb3689044226d5b9a265'; check that column/key exists
ERROR 1091 &#40;42000&#41; at line 42&#58; Can't DROP '045fce234c7df2742ece9efe8864b83f'; check that column/key exists
ERROR 1091 &#40;42000&#41; at line 43&#58; Can't DROP '595a200705c6daa334d1e96e32583ea3'; check that column/key exists
ERROR 1091 &#40;42000&#41; at line 44&#58; Can't DROP 'c35611f93e1dcb1ab505cb1715d5941b'; check that column/key exists
ERROR 1091 &#40;42000&#41; at line 45&#58; Can't DROP '0a6b597fd01af47968faa8fa4d5c3f19'; check that column/key exists
ERROR 1091 &#40;42000&#41; at line 46&#58; Can't DROP '64791de5ab4ea85459319893269706ea'; check that column/key exists
Нормально ли это? Что то меня пугает....
Предваорительно был залит utm5_sql_update

Squirel
Сообщения: 25
Зарегистрирован: Вт авг 26, 2008 06:10

Сообщение Squirel »

Такая-же история, сейчас на тестовом сервере делаю обновление. Тоже очень интересует, нормально ли это + у меня ещё такие сообщения:

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


#mysql -f UTM5 < /netup/utm5/UTM5_MYSQL_update.sql 
ERROR 1060 &#40;42S21&#41; at line 842&#58; Duplicate column name 'id'
ERROR 1060 &#40;42S21&#41; at line 843&#58; Duplicate column name 'discount_date'
ERROR 1060 &#40;42S21&#41; at line 844&#58; Duplicate column name 'is_deleted'
ERROR 1091 &#40;42000&#41; at line 845&#58; Can't DROP 'zzzzz'; check that column/key exists
ERROR 1060 &#40;42S21&#41; at line 847&#58; Duplicate column name 'id'
ERROR 1060 &#40;42S21&#41; at line 848&#58; Duplicate column name 'variable'
ERROR 1060 &#40;42S21&#41; at line 849&#58; Duplicate column name 'value'
ERROR 1060 &#40;42S21&#41; at line 850&#58; Duplicate column name 'change_date'
ERROR 1091 &#40;42000&#41; at line 851&#58; Can't DROP 'zzzzz'; check that column/key exists
ERROR 1060 &#40;42S21&#41; at line 853&#58; Duplicate column name 'id'
ERROR 1060 &#40;42S21&#41; at line 854&#58; Duplicate column name 't_class_name'
ERROR 1060 &#40;42S21&#41; at line 855&#58; Duplicate column name 'graph_color'
ERROR 1060 &#40;42S21&#41; at line 856&#58; Duplicate column name 'is_display'
ERROR 1060 &#40;42S21&#41; at line 857&#58; Duplicate column name 'is_fill'
ERROR 1060 &#40;42S21&#41; at line 858&#58; Duplicate column name 'time_range_id'
ERROR 1060 &#40;42S21&#41; at line 859&#58; Duplicate column name 'dont_save'
ERROR 1060 &#40;42S21&#41; at line 860&#58; Duplicate column name 'local_traf_policy'
ERROR 1060 &#40;42S21&#41; at line 861&#58; Duplicate column name 'is_deleted'
ERROR 1091 &#40;42000&#41; at line 862&#58; Can't DROP 'zzzzz'; check that column/key exists
ERROR 1060 &#40;42S21&#41; at line 864&#58; Duplicate column name 'id'
ERROR 1060 &#40;42S21&#41; at line 865&#58; Duplicate column name 't_class_id'
ERROR 1060 &#40;42S21&#41; at line 866&#58; Duplicate column name 'saddr'
ERROR 1060 &#40;42S21&#41; at line 867&#58; Duplicate column name 'saddr_mask'
ERROR 1060 &#40;42S21&#41; at line 868&#58; Duplicate column name 'daddr'
ERROR 1060 &#40;42S21&#41; at line 869&#58; Duplicate column name 'daddr_mask'
ERROR 1060 &#40;42S21&#41; at line 870&#58; Duplicate column name 'sport'
ERROR 1060 &#40;42S21&#41; at line 871&#58; Duplicate column name 'dport'
ERROR 1060 &#40;42S21&#41; at line 872&#58; Duplicate column name 'input'
ERROR 1060 &#40;42S21&#41; at line 873&#58; Duplicate column name 'output'
ERROR 1060 &#40;42S21&#41; at line 874&#58; Duplicate column name 'src_as'
ERROR 1060 &#40;42S21&#41; at line 875&#58; Duplicate column name 'dst_as'
ERROR 1060 &#40;42S21&#41; at line 876&#58; Duplicate column name 'nexthop'
ERROR 1060 &#40;42S21&#41; at line 877&#58; Duplicate column name 'tcp_flags'
ERROR 1060 &#40;42S21&#41; at line 878&#58; Duplicate column name 'proto'
ERROR 1060 &#40;42S21&#41; at line 879&#58; Duplicate column name 'tos'
ERROR 1060 &#40;42S21&#41; at line 880&#58; Duplicate column name 'use_sport'
ERROR 1060 &#40;42S21&#41; at line 881&#58; Duplicate column name 'use_dport'

dwemer
Сообщения: 276
Зарегистрирован: Чт янв 25, 2007 05:59

Сообщение dwemer »

это нормально.
просто посмотрите внутрь .sql файлов

kirush
Сообщения: 699
Зарегистрирован: Пт фев 04, 2005 13:58

Сообщение kirush »

Обновился. отчеты (услуги/трафик) стали еще медленнее формироваться ;(

JAO
Сообщения: 1153
Зарегистрирован: Вт дек 11, 2007 08:17

Сообщение JAO »

DROP zzz не страшно, а вот индексы я наверно потом перепроверю, как до этого дело дойдет. Буду знать.

Ответить