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