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/ |