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

update 1028 (CRM)
http://forum.bitel.ru/viewtopic.php?f=51&t=10529
Страница 1 из 1

Автор:  zavndw [ 19 май 2015, 17:57 ]
Заголовок сообщения:  update 1028

Обновился и конечно не паникую, но интересно 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

Автор:  Администратор [ 19 май 2015, 18:38 ]
Заголовок сообщения:  Re: update 1028

Это нормально. Описано в changes. Не нашли способ как без ошибок подсунуть процедуры старому инсталлятору SQL обновлений. В результате при первом обновлении он ругается, в дальнейшем должно быть всё корректно.

Автор:  zavndw [ 19 май 2015, 18:41 ]
Заголовок сообщения:  Re: update 1028 (CRM)

Да я видел, но не думал что на столько будет страшно обновлять:-)

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