При обновлении с 22:
Fatal error
2023-08-04 09:46
SQL error 42000: Syntax error or access violation: 1071 Specified key was too long; max key length is 1000 bytes
#0 cot_diefatal(SQL error 42000: Syntax error or access violation: 1071 Specified key was too long; max key length is 1000 bytes) called at [/home/user123/www/site.com/system/database.php:372]
#1 CotDB->query(CREATE UNIQUE INDEX config_owner_cat_name_subcat_key ON `cot_config` (config_owner, config_cat, config_name, config_subcat)) called at [/home/user123/www/site.com/setup/siena/patch_0.9.24.inc:33]
#2 include(/home/user123/www/site.com/setup/siena/patch_0.9.24.inc) called at [/home/user123/www/site.com/system/extensions.php:99]
#3 cot_apply_patches(./setup/siena, 0.9.22) called at [/home/user123/www/site.com/modules/install/inc/install.update.php:246]
#4 include(/home/user123/www/site.com/modules/install/inc/install.update.php) called at [/home/user123/www/site.com/install.php:159]
и потом
Fatal error
2023-08-04 09:48
SQL error 42S21: Column already exists: 1060 Duplicate column name 'log_uid'
#0 cot_diefatal(SQL error 42S21: Column already exists: 1060 Duplicate column name 'log_uid') called at [/home/user123/www/site.com/system/database.php:372]
#1 CotDB->query(ALTER TABLE `cot_logger` ADD `log_uid` int UNSIGNED NOT NULL DEFAULT '0') called at [/home/user123/www/site.com/system/database.php:804]
#2 CotDB->runScript(
INSERT INTO `cot_config` (`config_owner`, `config_cat`, `config_order`, `config_name`, `config_type`, `config_value`, `config_default`, `config_variants`, `config_text`) VALUES
('core','main','08','loggerlevel',2,'sec+adm+ext','sec+adm+ext','none,sec,adm,ext,sec+adm,sec+ext,adm+ext,sec+adm+ext,all','');
ALTER TABLE `cot_logger` MODIFY `log_group` varchar(64) DEFAULT 'adm';
ALTER TABLE `cot_logger` ADD `log_uid` int UNSIGNED NOT NULL DEFAULT '0';
ALTER TABLE `cot_logger` ADD `log_type` varchar(32) DEFAULT '';
ALTER TABLE `cot_logger` ADD `log_status` varchar(24) DEFAULT '';
ALTER TABLE `cot_logger` ADD `log_uri` varchar(255) DEFAULT '';
UPDATE `cot_logger` SET `log_group` = 'forums' WHERE `log_group` = 'for';
UPDATE `cot_logger` SET `log_group` = 'users' WHERE `log_group` = 'usr';
UPDATE `cot_logger` SET `log_group` = 'page' WHERE `log_group` = 'pag';
UPDATE `cot_config` SET `config_default` = 'UTC' WHERE `config_owner` = 'core' AND `config_cat` = 'locale' AND `config_name` = 'defaulttimezone';
UPDATE `cot_config` SET `config_value` = 'UTC'
WHERE `config_owner` = 'core' AND `config_cat` = 'locale' AND `config_name` = 'defaulttimezone'
AND (`config_value` = 'GMT' OR `config_value` = '0' OR `config_value` IS NULL);
UPDATE `cot_config` SET `config_value` = 'Europe/Kiev'
WHERE `config_owner` = 'core' AND `config_cat` = 'locale' AND `config_name` = 'defaulttimezone' AND `config_value` = 'Europe/Kyiv';) called at [/home/user123/www/site.com/system/extensions.php:88]
#3 cot_apply_patches(./setup/siena, 0.9.22) called at [/home/user123/www/site.com/modules/install/inc/install.update.php:246]
#4 include(/home/user123/www/site.com/modules/install/inc/install.update.php) called at [/home/user123/www/site.com/install.php:159]
