1) попробывали
Код:
DROP DATABASE IF EXISTS bgcrm;
CREATE DATABASE bgcrm DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci;
USE bgcrm;
INSERT INTO user ( title, login, pswd, description ) VALUES ("Администратор", "admin", "admin", "Администратор" );
INSERT INTO user_group_title ( title, description, roles ) VALUES ( "Администраторы", "Администраторы", "admin user" );
INSERT INTO user_group ( user_id, group_id ) VALUES ( 1, 1 );
GRANT ALL PRIVILEGES ON bgcrm.* TO 'bgcrm'@'localhost' IDENTIFIED BY 'crm';
GRANT ALL PRIVILEGES ON bgcrm.* TO 'bgcrm'@'%' IDENTIFIED BY 'crm';
Код:
ERROR 1146 (42S02) at line 4: Table 'bgcrm.user' doesn't exist
ERROR 1146 (42S02) at line 5: Table 'bgcrm.user_group_title' doesn't exist
ERROR 1146 (42S02) at line 6: Table 'bgcrm.user_group' doesn't exist
Запуск patch.sql из 238 update.
Код:
ERROR 1146 (42S02) at line 1: Table 'bgcrm.param_address' doesn't exist
ERROR 1146 (42S02) at line 3: Table 'bgcrm.param_address' doesn't exist
ERROR 1146 (42S02) at line 15: Table 'bgcrm.process_link' doesn't exist
ERROR 1146 (42S02) at line 24: Table 'bgcrm.param_email_log' doesn't exist
ERROR 1146 (42S02) at line 25: Table 'bgcrm.param_email_log' doesn't exist
ERROR 1146 (42S02) at line 26: Table 'bgcrm.param_email_log' doesn't exist
ERROR 1146 (42S02) at line 27: Table 'bgcrm.param_email_log' doesn't exist
ERROR 1146 (42S02) at line 29: Table 'bgcrm.param_text_log' doesn't exist
ERROR 1146 (42S02) at line 30: Table 'bgcrm.param_text_log' doesn't exist
ERROR 1146 (42S02) at line 32: Table 'bgcrm.param_list_log' doesn't exist
ERROR 1146 (42S02) at line 33: Table 'bgcrm.param_list_log' doesn't exist
ERROR 1146 (42S02) at line 35: Table 'bgcrm.param_address_log' doesn't exist
ERROR 1146 (42S02) at line 36: Table 'bgcrm.param_address_log' doesn't exist
ERROR 1051 (42S02) at line 38: Unknown table 'config_global'
ERROR 1146 (42S02) at line 40: Table 'bgcrm.address_house' doesn't exist
ERROR 1146 (42S02) at line 41: Table 'bgcrm.address_house' doesn't exist
ERROR 1146 (42S02) at line 42: Table 'bgcrm.address_house' doesn't exist
ERROR 1146 (42S02) at line 43: Table 'bgcrm.address_house' doesn't exist
ERROR 1146 (42S02) at line 44: Table 'bgcrm.address_house' doesn't exist
ERROR 1146 (42S02) at line 45: Table 'bgcrm.address_house' doesn't exist
ERROR 1146 (42S02) at line 47: Table 'bgcrm.address_quarter' doesn't exist
ERROR 1146 (42S02) at line 48: Table 'bgcrm.address_country' doesn't exist
ERROR 1146 (42S02) at line 49: Table 'bgcrm.address_city' doesn't exist
ERROR 1146 (42S02) at line 50: Table 'bgcrm.address_street' doesn't exist
ERROR 1146 (42S02) at line 51: Table 'bgcrm.address_house' doesn't exist
ERROR 1146 (42S02) at line 52: Table 'bgcrm.address_house' doesn't exist
ERROR 1146 (42S02) at line 53: Table 'bgcrm.address_street' doesn't exist
ERROR 1146 (42S02) at line 54: Table 'bgcrm.address_quarter' doesn't exist
ERROR 1146 (42S02) at line 55: Table 'bgcrm.address_area' doesn't exist
ERROR 1146 (42S02) at line 103: Table 'bgcrm.param_list' doesn't exist
ERROR 1146 (42S02) at line 104: Table 'bgcrm.param_list' doesn't exist
ERROR 1146 (42S02) at line 106: Table 'bgcrm.process' doesn't exist
ERROR 1146 (42S02) at line 107: Table 'bgcrm.process' doesn't exist
ERROR 1146 (42S02) at line 108: Table 'bgcrm.process' doesn't exist
ERROR 1146 (42S02) at line 109: Table 'bgcrm.process' doesn't exist
ERROR 1146 (42S02) at line 110: Table 'bgcrm.process' doesn't exist
ERROR 1146 (42S02) at line 112: Table 'bgcrm.process_status' doesn't exist
ERROR 1146 (42S02) at line 133: Table 'bgcrm.address_country' doesn't exist
ERROR 1146 (42S02) at line 134: Table 'bgcrm.address_city' doesn't exist
ERROR 1146 (42S02) at line 136: Table 'bgcrm.address_street' doesn't exist
ERROR 1146 (42S02) at line 137: Table 'bgcrm.address_quarter' doesn't exist
ERROR 1146 (42S02) at line 138: Table 'bgcrm.address_area' doesn't exist
ERROR 1146 (42S02) at line 139: Table 'bgcrm.address_house' doesn't exist
ERROR 1146 (42S02) at line 141: Table 'bgcrm.address_street' doesn't exist
ERROR 1146 (42S02) at line 142: Table 'bgcrm.address_quarter' doesn't exist
ERROR 1146 (42S02) at line 143: Table 'bgcrm.address_area' doesn't exist
ERROR 1146 (42S02) at line 144: Table 'bgcrm.address_area' doesn't exist
ERROR 1146 (42S02) at line 146: Table 'bgcrm.customer' doesn't exist
ERROR 1146 (42S02) at line 148: Table 'bgcrm.param_address' doesn't exist
ERROR 1146 (42S02) at line 149: Table 'bgcrm.param_address' doesn't exist
ERROR 1146 (42S02) at line 151: Table 'bgcrm.param_list' doesn't exist
ERROR 1146 (42S02) at line 153: Table 'bgcrm.param_address' doesn't exist
ERROR 1146 (42S02) at line 154: Table 'bgcrm.param_address' doesn't exist
ERROR 1146 (42S02) at line 156: Table 'bgcrm.param_address' doesn't exist
ERROR 1146 (42S02) at line 158: Table 'bgcrm.param_address' doesn't exist
ERROR 1146 (42S02) at line 191: Table 'bgcrm.process_link' doesn't exist
ERROR 1146 (42S02) at line 194: Table 'bgcrm.process_type' doesn't exist
ERROR 1146 (42S02) at line 208: Table 'bgcrm.process_link' doesn't exist
ERROR 1146 (42S02) at line 221: Table 'bgcrm.user_group_title' doesn't exist
ERROR 1146 (42S02) at line 223: Table 'bgcrm.param_pref' doesn't exist
ERROR 1146 (42S02) at line 225: Table 'bgcrm.process_executor' doesn't exist
ERROR 1146 (42S02) at line 226: Table 'bgcrm.process_executor' doesn't exist
ERROR 1146 (42S02) at line 228: Table 'bgcrm.param_pref' doesn't exist
2) 05-22/10:47:53 ERROR [main] Setup - Table 'bgcrm.n_config_global' doesn't exist