BiTel

Форум BiTel
bgbilling.ru     docs.bitel.ru     wiki.bitel.ru     dbinfo.bitel.ru     bgcrm.ru     billing.bitel.ru     bitel.ru    
Текущее время: 29 мар 2024, 12:51

Часовой пояс: UTC + 5 часов [ Летнее время ]




Начать новую тему Ответить на тему  [ Сообщений: 3 ] 
Автор Сообщение
 Заголовок сообщения: update 1028
СообщениеДобавлено: 19 май 2015, 17:57 
Не в сети
Клиент
Аватара пользователя

Зарегистрирован: 27 мар 2012, 11:59
Сообщения: 2676
Карма: 72
Обновился и конечно не паникую, но интересно SQL syntax error то же нормально в выводе?
Код:
Executing call ExecuteSQL; param: patch.sql
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 'delimiter $$
CREATE PROCEDURE drop_column_if_exists(IN tbl CHAR(64), IN col CHA' at line 1
Can't create more than max_prepared_stmt_count statements (current value: 16382)
Unknown prepared statement handler (stmt) given to EXECUTE
Unknown prepared statement handler (stmt) given to DEALLOCATE PREPARE
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 'IF (@cnt > 0) THEN
      SET @s = CONCAT("ALTER TABLE ", tbl, " DROP COLUMN ", col)' at line 1
Can't create more than max_prepared_stmt_count statements (current value: 16382)
Unknown prepared statement handler (stmt) given to EXECUTE
Unknown prepared statement handler (stmt) given to DEALLOCATE PREPARE
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 'END IF' at line 1
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 'END$$
delimiter' at line 1
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 'delimiter $$
CREATE PROCEDURE add_column_if_not_exists(IN tbl CHAR(64), IN col ' at line 1
Can't create more than max_prepared_stmt_count statements (current value: 16382)
Unknown prepared statement handler (stmt) given to EXECUTE
Unknown prepared statement handler (stmt) given to DEALLOCATE PREPARE
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 'IF (@cnt = 0) THEN
      SET @s = CONCAT("ALTER TABLE ", tbl, " ADD COLUMN ", col, ' at line 1
Can't create more than max_prepared_stmt_count statements (current value: 16382)
Unknown prepared statement handler (stmt) given to EXECUTE
Unknown prepared statement handler (stmt) given to DEALLOCATE PREPARE
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 'END IF' at line 1
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 'END$$
delimiter' at line 1
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 'delimiter $$
CREATE PROCEDURE drop_key_if_exists(IN tbl CHAR(64), IN name CHAR(' at line 1
Can't create more than max_prepared_stmt_count statements (current value: 16382)
Unknown prepared statement handler (stmt) given to EXECUTE
Unknown prepared statement handler (stmt) given to DEALLOCATE PREPARE
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 'IF (@cnt > 0) THEN
      SET @s = CONCAT("ALTER TABLE ", tbl,
         IF(name = 'PRIMAR' at line 1
Can't create more than max_prepared_stmt_count statements (current value: 16382)
Unknown prepared statement handler (stmt) given to EXECUTE
Unknown prepared statement handler (stmt) given to DEALLOCATE PREPARE
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 'END IF' at line 1
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 'END$$
delimiter' at line 1
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 'delimiter $$
CREATE PROCEDURE add_key_if_not_exists_base(IN tbl CHAR(64), IN na' at line 1
Can't create more than max_prepared_stmt_count statements (current value: 16382)
Unknown prepared statement handler (stmt) given to EXECUTE
Unknown prepared statement handler (stmt) given to DEALLOCATE PREPARE
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 'IF (@cnt = 0) THEN
      IF (LENGTH(command) > 0) THEN
         SET @s = CONCAT("ALTER TA' at line 1
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 'ELSE
         SET @s = CONCAT("ALTER TABLE ", tbl,  " ",
            IF(name ='PRIMARY', "ADD ' at line 1
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 'END IF' at line 1
Can't create more than max_prepared_stmt_count statements (current value: 16382)
Unknown prepared statement handler (stmt) given to EXECUTE
Unknown prepared statement handler (stmt) given to DEALLOCATE PREPARE
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 'END IF' at line 1
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 'END$$
delimiter' at line 1
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 'delimiter $$
CREATE PROCEDURE add_key_if_not_exists(IN tbl CHAR(64), IN name CH' at line 1
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 'END$$
delimiter' at line 1
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 'delimiter $$
CREATE PROCEDURE add_unique_key_if_not_exists(IN tbl CHAR(64), IN ' at line 1
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 'END$$
delimiter' at line 1
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 'delimiter $$
CREATE PROCEDURE alter_table_if_not_column_exists(IN tbl CHAR(64),' at line 1
Can't create more than max_prepared_stmt_count statements (current value: 16382)
Unknown prepared statement handler (stmt) given to EXECUTE
Unknown prepared statement handler (stmt) given to DEALLOCATE PREPARE
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 'IF (@cnt = 0) THEN
      SET @s = CONCAT("ALTER TABLE ", tbl, " ", def)' at line 1
Can't create more than max_prepared_stmt_count statements (current value: 16382)
Unknown prepared statement handler (stmt) given to EXECUTE
Unknown prepared statement handler (stmt) given to DEALLOCATE PREPARE
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 'END IF' at line 1
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 'END$$
delimiter' at line 1
(1305) PROCEDURE bgcrm.add_key_if_not_exists does not exist
(1305) PROCEDURE bgcrm.add_key_if_not_exists does not exist
(1305) PROCEDURE bgcrm.drop_key_if_exists does not exist
(1305) PROCEDURE bgcrm.add_column_if_not_exists does not exist
(1305) PROCEDURE bgcrm.alter_table_if_not_column_exists does not exist
(1305) PROCEDURE bgcrm.drop_key_if_exists does not exist
(1305) PROCEDURE bgcrm.add_key_if_not_exists does not exist
(1305) PROCEDURE bgcrm.add_key_if_not_exists does not exist
(1305) PROCEDURE bgcrm.add_key_if_not_exists does not exist
(1305) PROCEDURE bgcrm.drop_key_if_exists does not exist
(1305) PROCEDURE bgcrm.add_key_if_not_exists does not exist
(1305) PROCEDURE bgcrm.add_key_if_not_exists does not exist
(1305) PROCEDURE bgcrm.add_key_if_not_exists does not exist
(1305) PROCEDURE bgcrm.add_unique_key_if_not_exists does not exist
(1305) PROCEDURE bgcrm.add_unique_key_if_not_exists does not exist
(1305) PROCEDURE bgcrm.add_unique_key_if_not_exists does not exist
(1305) PROCEDURE bgcrm.add_unique_key_if_not_exists does not exist
(1305) PROCEDURE bgcrm.add_unique_key_if_not_exists does not exist
(1305) PROCEDURE bgcrm.add_unique_key_if_not_exists does not exist
(1305) PROCEDURE bgcrm.drop_key_if_exists does not exist
(1305) PROCEDURE bgcrm.add_column_if_not_exists does not exist
(1305) PROCEDURE bgcrm.add_column_if_not_exists does not exist
(1305) PROCEDURE bgcrm.add_column_if_not_exists does not exist
(1305) PROCEDURE bgcrm.add_column_if_not_exists does not exist
(1305) PROCEDURE bgcrm.add_column_if_not_exists does not exist
(1305) PROCEDURE bgcrm.add_column_if_not_exists does not exist
(1305) PROCEDURE bgcrm.add_column_if_not_exists does not exist
(1305) PROCEDURE bgcrm.add_column_if_not_exists does not exist
(1305) PROCEDURE bgcrm.add_key_if_not_exists does not exist
(1305) PROCEDURE bgcrm.add_key_if_not_exists does not exist
(1305) PROCEDURE bgcrm.add_column_if_not_exists does not exist
(1305) PROCEDURE bgcrm.add_column_if_not_exists does not exist
(1305) PROCEDURE bgcrm.add_column_if_not_exists does not exist
(1305) PROCEDURE bgcrm.add_unique_key_if_not_exists does not exist
(1305) PROCEDURE bgcrm.add_unique_key_if_not_exists does not exist
(1305) PROCEDURE bgcrm.drop_key_if_exists does not exist
(1305) PROCEDURE bgcrm.add_key_if_not_exists does not exist
(1305) PROCEDURE bgcrm.add_column_if_not_exists does not exist
(1305) PROCEDURE bgcrm.drop_key_if_exists does not exist
(1305) PROCEDURE bgcrm.add_key_if_not_exists does not exist
(1305) PROCEDURE bgcrm.drop_key_if_exists does not exist
(1305) PROCEDURE bgcrm.add_key_if_not_exists does not exist
(1305) PROCEDURE bgcrm.drop_key_if_exists does not exist
(1305) PROCEDURE bgcrm.add_key_if_not_exists does not exist
(1305) PROCEDURE bgcrm.add_column_if_not_exists does not exist
(1305) PROCEDURE bgcrm.add_column_if_not_exists does not exist
(1305) PROCEDURE bgcrm.add_column_if_not_exists does not exist
(1305) PROCEDURE bgcrm.add_column_if_not_exists does not exist
(1305) PROCEDURE bgcrm.add_column_if_not_exists does not exist
(1305) PROCEDURE bgcrm.add_column_if_not_exists does not exist
(1305) PROCEDURE bgcrm.add_column_if_not_exists does not exist
(1305) PROCEDURE bgcrm.add_column_if_not_exists does not exist
(1305) PROCEDURE bgcrm.add_column_if_not_exists does not exist
(1305) PROCEDURE bgcrm.add_column_if_not_exists does not exist
(1305) PROCEDURE bgcrm.add_column_if_not_exists does not exist
(1305) PROCEDURE bgcrm.add_key_if_not_exists does not exist
(1305) PROCEDURE bgcrm.add_key_if_not_exists does not exist
(1305) PROCEDURE bgcrm.add_column_if_not_exists does not exist
(1305) PROCEDURE bgcrm.drop_key_if_exists does not exist
(1305) PROCEDURE bgcrm.add_key_if_not_exists does not exist
(1305) PROCEDURE bgcrm.add_column_if_not_exists does not exist
(1305) PROCEDURE bgcrm.add_column_if_not_exists does not exist
(1305) PROCEDURE bgcrm.add_column_if_not_exists does not exist
(1305) PROCEDURE bgcrm.add_column_if_not_exists does not exist
(1305) PROCEDURE bgcrm.add_column_if_not_exists does not exist
(1305) PROCEDURE bgcrm.add_column_if_not_exists does not exist
(1305) PROCEDURE bgcrm.add_column_if_not_exists does not exist
(1305) PROCEDURE bgcrm.add_column_if_not_exists does not exist
(1305) PROCEDURE bgcrm.drop_column_if_exists does not exist
(1305) PROCEDURE bgcrm.add_column_if_not_exists does not exist
(1305) PROCEDURE bgcrm.add_column_if_not_exists does not exist
(1305) PROCEDURE bgcrm.add_key_if_not_exists does not exist
(1305) PROCEDURE bgcrm.alter_table_if_not_column_exists does not exist
(1305) PROCEDURE bgcrm.add_column_if_not_exists does not exist
(1305) PROCEDURE bgcrm.add_column_if_not_exists does not exist
(1305) PROCEDURE bgcrm.add_column_if_not_exists does not exist
(1305) PROCEDURE bgcrm.add_column_if_not_exists does not exist
(1305) PROCEDURE bgcrm.add_column_if_not_exists does not exist
(1305) PROCEDURE bgcrm.add_column_if_not_exists does not exist
(1305) PROCEDURE bgcrm.add_column_if_not_exists does not exist
(1305) PROCEDURE bgcrm.add_column_if_not_exists does not exist
(1305) PROCEDURE bgcrm.add_column_if_not_exists does not exist
(1305) PROCEDURE bgcrm.add_key_if_not_exists does not exist
(1305) PROCEDURE bgcrm.add_column_if_not_exists does not exist
(1305) PROCEDURE bgcrm.add_column_if_not_exists does not exist
(1305) PROCEDURE bgcrm.add_column_if_not_exists does not exist
(1305) PROCEDURE bgcrm.add_key_if_not_exists does not exist
(1305) PROCEDURE bgcrm.add_column_if_not_exists does not exist
(1305) PROCEDURE bgcrm.drop_column_if_exists does not exist
(1305) PROCEDURE bgcrm.add_column_if_not_exists does not exist
(1305) PROCEDURE bgcrm.add_key_if_not_exists does not exist
(1305) PROCEDURE bgcrm.add_key_if_not_exists does not exist
(1305) PROCEDURE bgcrm.add_column_if_not_exists does not exist
(1305) PROCEDURE bgcrm.add_column_if_not_exists does not exist
(1305) PROCEDURE bgcrm.drop_key_if_exists does not exist
(1305) PROCEDURE bgcrm.drop_column_if_exists does not exist
(1305) PROCEDURE bgcrm.add_column_if_not_exists does not exist
(1305) PROCEDURE bgcrm.add_column_if_not_exists does not exist
(1305) PROCEDURE bgcrm.add_column_if_not_exists does not exist
(1305) PROCEDURE bgcrm.add_column_if_not_exists does not exist
(1305) PROCEDURE bgcrm.add_column_if_not_exists does not exist
(1305) PROCEDURE bgcrm.add_key_if_not_exists does not exist
(1305) PROCEDURE bgcrm.add_key_if_not_exists does not exist
(1305) PROCEDURE bgcrm.add_key_if_not_exists does not exist
(1305) PROCEDURE bgcrm.add_column_if_not_exists does not exist
(1305) PROCEDURE bgcrm.add_column_if_not_exists does not exist
(1305) PROCEDURE bgcrm.add_column_if_not_exists does not exist
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
Execute calls => OK
File's copy finished...
File copy => OK
Module update was successfull installed!
Please, restart BGCRM server.
REPLACED FILES:
lib/app/bgcrm.jar
log4j.properties
webapps/WEB-INF/jspf/user/profile/default.jsp


Вернуться к началу
 Профиль  
 
 Заголовок сообщения: Re: update 1028
СообщениеДобавлено: 19 май 2015, 18:38 
Не в сети
Разработчик

Зарегистрирован: 27 ноя 2006, 20:36
Сообщения: 5715
Карма: 93
Это нормально. Описано в changes. Не нашли способ как без ошибок подсунуть процедуры старому инсталлятору SQL обновлений. В результате при первом обновлении он ругается, в дальнейшем должно быть всё корректно.


Вернуться к началу
 Профиль  
 
 Заголовок сообщения: Re: update 1028 (CRM)
СообщениеДобавлено: 19 май 2015, 18:41 
Не в сети
Клиент
Аватара пользователя

Зарегистрирован: 27 мар 2012, 11:59
Сообщения: 2676
Карма: 72
Да я видел, но не думал что на столько будет страшно обновлять:-)


Вернуться к началу
 Профиль  
 
Показать сообщения за:  Поле сортировки  
Начать новую тему Ответить на тему  [ Сообщений: 3 ] 

Часовой пояс: UTC + 5 часов [ Летнее время ]


Кто сейчас на конференции

Сейчас этот форум просматривают: нет зарегистрированных пользователей и гости: 1


Вы не можете начинать темы
Вы не можете отвечать на сообщения
Вы не можете редактировать свои сообщения
Вы не можете удалять свои сообщения
Вы не можете добавлять вложения

Найти:
Перейти:  
cron
POWERED_BY
Русская поддержка phpBB
[ Time : 0.096s | 24 Queries | GZIP : On ]