forum.bitel.ru
http://forum.bitel.ru/

mysql import error
http://forum.bitel.ru/viewtopic.php?f=51&t=10314		 Страница 1 из 1
Автор:  borin [ 23 мар 2015, 12:25 ]
Заголовок сообщения:  mysql import error
Добрый день!

bgcrm_3.0_1152.zip
В документации сказано:
Код:
mysql --default-character-set=utf8 -uroot < /tmp/bgcrm.sql

При загрузке дампа вылезают ошибки:
Код:
mysql --default-character-set=utf8 -uroot -p -f <bgcrm.sql
Enter password:
ERROR 1061 (42000) at line 858: Duplicate key name 'object_id'
ERROR 1061 (42000) at line 859: Duplicate key name 'object_id'
ERROR 1091 (42000) at line 873: Can't DROP 'house'; check that column/key exists
ERROR 1060 (42S21) at line 879: Duplicate column name 'secret'
ERROR 1054 (42S22) at line 880: Unknown column 'value' in 'n_param_list_value'
ERROR 1091 (42000) at line 882: Can't DROP 'PRIMARY'; check that column/key exists
ERROR 1061 (42000) at line 883: Duplicate key name 'id_param'
ERROR 1061 (42000) at line 885: Duplicate key name 'status'
ERROR 1061 (42000) at line 886: Duplicate key name 'type'
ERROR 1091 (42000) at line 887: Can't DROP 'type_status'; check that column/key exists
ERROR 1061 (42000) at line 888: Duplicate key name 'create_dt'
ERROR 1061 (42000) at line 889: Duplicate key name 'close_dt'
ERROR 1061 (42000) at line 891: Duplicate key name 'process_id'
ERROR 1061 (42000) at line 893: Duplicate key name 'title'
ERROR 1061 (42000) at line 894: Duplicate key name 'country_title'
ERROR 1061 (42000) at line 896: Duplicate key name 'city_title'
ERROR 1061 (42000) at line 898: Duplicate key name 'city_title'
ERROR 1061 (42000) at line 899: Duplicate key name 'street_number'
ERROR 1091 (42000) at line 904: Can't DROP 'street_id'; check that column/key exists
ERROR 1060 (42S21) at line 916: Duplicate column name 'n'
ERROR 1060 (42S21) at line 920: Duplicate column name 'config'
ERROR 1060 (42S21) at line 921: Duplicate column name 'config'
ERROR 1060 (42S21) at line 923: Duplicate column name 'config'
ERROR 1060 (42S21) at line 929: Duplicate column name 'pswd'
ERROR 1060 (42S21) at line 930: Duplicate column name 'date_from'
ERROR 1060 (42S21) at line 932: Duplicate column name 'date_to'
ERROR 1060 (42S21) at line 934: Duplicate column name 'config'
ERROR 1061 (42000) at line 938: Duplicate key name 'process_id'
ERROR 1061 (42000) at line 939: Duplicate key name 'user_id'
ERROR 1060 (42S21) at line 941: Duplicate column name 'comment'
ERROR 1060 (42S21) at line 943: Duplicate column name 'comment'
ERROR 1060 (42S21) at line 944: Duplicate column name 'n'
ERROR 1050 (42S01) at line 950: Table 'user_permset_permission' already exists
ERROR 1054 (42S22) at line 951: Unknown column 'group_id' in 'user_permset_permission'
ERROR 1054 (42S22) at line 953: Unknown column 'group_id' in 'user_permset'
ERROR 1054 (42S22) at line 955: Unknown column 'user_id' in 'user_group_queue'
ERROR 1061 (42000) at line 957: Duplicate key name 'user_permset'
ERROR 1068 (42000) at line 961: Multiple primary key defined
ERROR 1060 (42S21) at line 968: Duplicate column name 'n'
ERROR 1091 (42000) at line 973: Can't DROP 'id_param'; check that column/key exists
ERROR 1068 (42000) at line 974: Multiple primary key defined
ERROR 1091 (42000) at line 979: Can't DROP 'PRIMARY'; check that column/key exists
ERROR 1060 (42S21) at line 982: Duplicate column name 'post_index'
ERROR 1060 (42S21) at line 985: Duplicate column name 'last_modify_dt'
ERROR 1060 (42S21) at line 987: Duplicate column name 'last_modify_user_id'
ERROR 1060 (42S21) at line 989: Duplicate column name 'pos'
ERROR 1060 (42S21) at line 991: Duplicate column name 'create_user_id'
ERROR 1060 (42S21) at line 992: Duplicate column name 'close_user_id'
ERROR 1060 (42S21) at line 994: Duplicate column name 'last_modify_dt'
ERROR 1060 (42S21) at line 996: Duplicate column name 'last_modify_user_id'
ERROR 1060 (42S21) at line 998: Duplicate column name 'last_modify_dt'
ERROR 1060 (42S21) at line 1000: Duplicate column name 'last_modify_user_id'
ERROR 1060 (42S21) at line 1003: Duplicate column name 'status_user_id'
ERROR 1050 (42S01) at line 1005: Table 'news_user' already exists
ERROR 1146 (42S02) at line 1007: Table 'bgcrm.n_news_user' doesn't exist
ERROR 1146 (42S02) at line 1008: Table 'bgcrm.n_news_user' doesn't exist
ERROR 1061 (42000) at line 1011: Duplicate key name 'user_id'
ERROR 1061 (42000) at line 1012: Duplicate key name 'group_id'
ERROR 1060 (42S21) at line 1014: Duplicate column name 'role_id'
ERROR 1060 (42S21) at line 1018: Duplicate column name 'date_from'
ERROR 1060 (42S21) at line 1020: Duplicate column name 'parent_id'
ERROR 1060 (42S21) at line 1021: Duplicate column name 'archive'
ERROR 1060 (42S21) at line 1022: Duplicate column name 'child_count'
ERROR 1060 (42S21) at line 1024: Duplicate column name 'personalization'
ERROR 1060 (42S21) at line 1026: Duplicate column name 'read_time'
ERROR 1060 (42S21) at line 1028: Duplicate column name 'last'
ERROR 1091 (42000) at line 1029: Can't DROP 'id'; check that column/key exists
ERROR 1060 (42S21) at line 1036: Duplicate column name 'group_id'
ERROR 1060 (42S21) at line 1037: Duplicate column name 'role_id'
ERROR 1061 (42000) at line 1038: Duplicate key name 'group_id'
ERROR 1054 (42S22) at line 1040: Unknown column 'custom' in 'param_list'
ERROR 1060 (42S21) at line 1041: Duplicate column name 'comment'
ERROR 1146 (42S02) at line 1043: Table 'bgcrm.n_param_tree_value' doesn't exist
ERROR 1146 (42S02) at line 1044: Table 'bgcrm.n_param_listcount_value' doesn't exist
ERROR 1060 (42S21) at line 1046: Duplicate column name 'comment'
ERROR 1060 (42S21) at line 1050: Duplicate column name 'category'
ERROR 1060 (42S21) at line 1051: Duplicate column name 'category'
ERROR 1060 (42S21) at line 1052: Duplicate column name 'color'
ERROR 1060 (42S21) at line 1053: Duplicate column name 'shift'
ERROR 1060 (42S21) at line 1056: Duplicate column name 'non_work_hours'
ERROR 1061 (42000) at line 1059: Duplicate key name 'from'
ERROR 1060 (42S21) at line 1063: Duplicate column name 'user_id'
ERROR 1060 (42S21) at line 1073: Duplicate column name 'type'
ERROR 1091 (42000) at line 1075: Can't DROP 'owner_id'; check that column/key exists
ERROR 1060 (42S21) at line 1079: Duplicate column name 'system_id'
ERROR 1061 (42000) at line 1080: Duplicate key name 'system_id'
ERROR 1061 (42000) at line 1084: Duplicate key name 'date'
ERROR 1064 (42000) at line 1085: 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 '--ALTER TABLE callboard_work_type MODIFY shortcut VARCHAR(100) NOT NULL' at line 1
ERROR 1060 (42S21) at line 1087: Duplicate column name 'in_unread_count'
ERROR 1060 (42S21) at line 1092: Duplicate column name 'rule_config'
ERROR 1091 (42000) at line 1096: Can't DROP 'PRIMARY'; check that column/key exists
ERROR 1060 (42S21) at line 1111: Duplicate column name 'groups'
Автор:  vkulakov [ 23 мар 2015, 12:27 ]
Заголовок сообщения:  Re: mysql import error
Недавно тоже с этим столкнулся:
viewtopic.php?f=51&t=10252
Автор:  stark [ 23 мар 2015, 12:58 ]
Заголовок сообщения:  Re: mysql import error
Сделайте так
Код:
mysql --default-character-set=utf8 -f -uroot < /tmp/bgcrm.sql


В ближайшее время постараемся это исправить.
Автор:  borin [ 23 мар 2015, 13:00 ]
Заголовок сообщения:  Re: mysql import error
stark писал(а):
Сделайте так
Код:
mysql --default-character-set=utf8 -f -uroot < /tmp/bgcrm.sql


В ближайшее время постараемся это исправить.


Так и сделал, просто интересно было, можно ли пропускать ошибки :)
Автор:  Администратор [ 21 июн 2015, 17:01 ]
Заголовок сообщения:  Re: mysql import error
В последнем обновлении это исправлено. Изменение структуры производится с помощью хранимых процедур с предварительной проверкой наличия поля, индекса.
Страница 1 из 1 Часовой пояс: UTC + 5 часов [ Летнее время ]
Powered by phpBB® Forum Software © phpBB Group
http://www.phpbb.com/