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

Ошибка при обновлении
http://forum.bitel.ru/viewtopic.php?f=51&t=12128
Страница 1 из 1

Автор:  spectrum [ 24 ноя 2016, 16:04 ]
Заголовок сообщения:  Ошибка при обновлении

Добрый день!

При обновлении до версии update_3.0_1166 В консоль вывалились ошибки. что это и что с этим делать? CRM вроде нормально работает.
Код:
Update starting..
Update from ftp://ftp.bgcrm.ru/pub/bgcrm
Version is 3.0
Set passive mode..
Changing dir to /pub/bgcrm/3.0
Checking update for 'update'..
Found update for 'update' build 1150 updating to build 1166
Checking update for 'update_lib'..
Downloading update_3.0_1166.zip OK!
Start installing..
Executing call ExecuteSQL; param: patch.sql
OK (1 ms.) => CREATE TABLE IF NOT EXISTS `address_house` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `area_id` int(11) NOT NULL,
  `quarter_id` int(11) NOT NULL,
  `street_id` int(11) NOT NULL,
  `house` int(11) NOT NULL,
  `frac` varchar(50) NOT NULL,
  `post_index` varchar(10) NOT NULL,
  `comment` text NOT NULL,
  `last_update` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`),
  UNIQUE KEY `street_number` (`street_id`,`house`,`frac`)
)
OK (0 ms.) => CREATE  TABLE IF NOT EXISTS address_quarter_distribution (
  `distr_id` INT(10) NOT NULL ,
  `quarter_id` INT(10) NOT NULL ,
  `group_id` INT(10) NOT NULL ,
  PRIMARY KEY (`distr_id`, `quarter_id`, `group_id`)
)
ERROR (1305) PROCEDURE bgcrm.add_key_if_not_exists does not exist => CALL add_key_if_not_exists('address_house', 'street_id', '(street_id)')
ERROR (1305) PROCEDURE bgcrm.add_key_if_not_exists does not exist => CALL add_key_if_not_exists('address_street', 'city_id', '(city_id)')
ERROR (1305) PROCEDURE bgcrm.add_key_if_not_exists does not exist => CALL add_key_if_not_exists('address_quarter', 'city_id', '(city_id)')
ERROR (1305) PROCEDURE bgcrm.add_key_if_not_exists does not exist => CALL add_key_if_not_exists('address_area', 'city_id', '(city_id)')
ERROR (1305) PROCEDURE bgcrm.add_key_if_not_exists does not exist => CALL add_key_if_not_exists('address_distribution', 'user_index', '(user_id)')
ERROR (1305) PROCEDURE bgcrm.add_key_if_not_exists does not exist => CALL add_key_if_not_exists('process_group', 'group_id', '(group_id)')
ERROR (1305) PROCEDURE bgcrm.add_column_if_not_exists does not exist => CALL add_column_if_not_exists('process_message_state', 'in_last_id', 'INT NOT NULL, ADD out_last_id INT NOT NULL')
Executing database update...OK
Result => true
Executing call RemoveFile; param: action/pl_bgbilling.xml
Result => true
Executing call RemoveFile; param: action/pl_document.xml
Result => true
Executing call RemoveFile; param: action/pl_ufanet.xml
Result => true
Executing call RemoveFile; param: action/pl_report.xml
Result => true
Executing call RemoveFile; param: plugin/documentCirculation.xml
Removing file: plugin/documentCirculation.xml
Result => true
Execute calls => OK
File doesn't changed webapps/WEB-INF/jspf/process_color.jsp
File's copy finished...
File copy => OK
Module update was successfull installed!
Please, restart BGCRM server.
REPLACED FILES:
action/bgbilling.xml
action/kernel.xml
lib/app/bgcrm.jar
webapps/WEB-INF/jspf/script_css.jsp
webapps/WEB-INF/jspf/select_interface.jsp
webapps/WEB-INF/jspf/user/directory/address/house/update.jsp
webapps/WEB-INF/jspf/user/message/list.jsp
webapps/WEB-INF/jspf/user/message/process_message_list.jsp
webapps/WEB-INF/jspf/user/plugin/report/report/example.jsp
webapps/WEB-INF/jspf/user/process/process/editor_executors.jsp
webapps/WEB-INF/jspf/user/process/process/process_description.jsp
webapps/WEB-INF/jspf/user/process/process/process_editor.jsp
webapps/WEB-INF/jspf/user/process/process/process_executors.jsp
webapps/WEB-INF/jspf/user/process/queue/filter.jsp
webapps/WEB-INF/jspf/user/process/tree/process_type_tree.jsp
webapps/WEB-INF/jspf/user/process/tree/process_type_tree_item.jsp
webapps/WEB-INF/jspf/user/search/search.jsp
webapps/css/style.indent.css.jsp
webapps/js/crm.process.js
webapps/js/ui.js
webapps/test.jsp

Автор:  Администратор [ 28 ноя 2016, 03:29 ]
Заголовок сообщения:  Re: Ошибка при обновлении

Попробуйте выполнить:
Код:
./installer.sh killhash

и после применить снова обновление.
Объявления хранимых процедур расположены в начале скрипта.

Страница 1 из 1 Часовой пояс: UTC + 5 часов [ Летнее время ]
Powered by phpBB® Forum Software © phpBB Group
http://www.phpbb.com/