Hello
is not working,:
[lokomotiv@h1 public_html]$ /usr/bin/php81 app/bin/legacy -C update
Chevere\Throwable\Exceptions\LogicException thrown in /home/lokomotiv/domains/tst.lokomotiv.ro/public_html/app/legacy/install/installer.php:1936
# Message
Problems executing the update query, must run the following statements directly in your SQL console. <pre style="overflow:auto;"><code>ALTER TABLE chi5_requests
MODIFY request_type
enum('upload','signup','account-edit','account-password-forgot','account-password-reset','account-resend-activation','account-email-needed','account-change-email','account-activate','login','content-password', 'account-two-factor') NOT NULL;
INSERT IGNORE INTO chi5_login_passwords
(login_password_user_id, login_password_date_gmt, login_password_hash)
SELECT login_user_id, max(login_date_gmt), login_secret
FROM chi5_logins
WHERE login_type = "password"
GROUP BY login_user_id;
INSERT IGNORE INTO chi5_login_cookies
(login_cookie_user_id, login_cookie_connection_id, login_cookie_date_gmt,
login_cookie_ip, login_cookie_user_agent, login_cookie_hash)
SELECT login_user_id, 0, login_date_gmt, login_ip, login_hostname, login_secret
FROM chi5_logins
WHERE login_type = "cookie"
GROUP BY login_date_gmt
ORDER BY login_date_gmt DESC;
INSERT IGNORE INTO chi5_login_connections
(login_connection_user_id, login_connection_provider_id, login_connection_date_gmt,
login_connection_resource_id, login_connection_resource_name,
login_connection_token)
SELECT login_user_id, login_provider_id, max(login_date_gmt), login_resource_id, login_resource_name, '' token
FROM chi5_logins
JOIN chi5_login_providers
ON login_provider_name = login_type
WHERE login_type IN ('facebook', 'twitter', 'google', 'vk')
GROUP BY login_user_id, login_provider_id;
UPDATE chi5_login_providers
SET login_provider_key_id
= '', login_provider_key_secret
= '', login_provider_is_enabled
= '0'
WHERE login_provider_name
= 'facebook';UPDATE chi5_login_providers
SET login_provider_key_id
= '', login_provider_key_secret
= '', login_provider_is_enabled
= '0'
WHERE login_provider_name
= 'twitter';UPDATE chi5_login_providers
SET login_provider_key_id
= '', login_provider_key_secret
= '', login_provider_is_enabled
= '0'
WHERE login_provider_name
= 'google';UPDATE chi5_login_providers
SET login_provider_key_id
= '', login_provider_key_secret
= '', login_provider_is_enabled
= '0'
WHERE login_provider_name
= 'Vkontakte';
ALTER TABLE chi5_users
ADD KEY user_palette_id
(user_palette_id
);
INSERT INTO chi5_settings
(setting_name, setting_value, setting_default, setting_typeset) VALUES ('logo_type', 'vector', 'vector', 'string');
INSERT INTO chi5_settings
(setting_name, setting_value, setting_default, setting_typeset) VALUES ('theme_palette', '0', '0', 'string');
INSERT INTO chi5_settings
(setting_name, setting_value, setting_default, setting_typeset) VALUES ('enable_xr', '0', '0', 'bool');
INSERT INTO chi5_settings
(setting_name, setting_value, setting_default, setting_typeset) VALUES ('xr_host', 'localhost', 'localhost', 'string');
INSERT INTO chi5_settings
(setting_name, setting_value, setting_default, setting_typeset) VALUES ('xr_port', '27420', '27420', 'string');
INSERT INTO chi5_settings
(setting_name, setting_value, setting_default, setting_typeset) VALUES ('xr_key', '', '', 'string');
INSERT INTO chi5_settings
(setting_name, setting_value, setting_default, setting_typeset) VALUES ('route_user', 'user', 'user', 'string');
INSERT INTO chi5_settings
(setting_name, setting_value, setting_default, setting_typeset) VALUES ('root_route', 'user', 'user', 'string');
INSERT INTO chi5_settings
(setting_name, setting_value, setting_default, setting_typeset) VALUES ('arachnid', '0', '0', 'bool');
INSERT INTO chi5_settings
(setting_name, setting_value, setting_default, setting_typeset) VALUES ('arachnid_key', '', '', 'string');
INSERT INTO chi5_settings
(setting_name, setting_value, setting_default, setting_typeset) VALUES ('image_first_tab', 'info', 'info', 'string');
INSERT INTO chi5_settings
(setting_name, setting_value, setting_default, setting_typeset) VALUES ('website_random_guest', '1', '1', 'bool');
INSERT INTO chi5_settings
(setting_name, setting_value, setting_default, setting_typeset) VALUES ('website_search_guest', '1', '1', 'bool');
INSERT INTO chi5_settings
(setting_name, setting_value, setting_default, setting_typeset) VALUES ('debug_errors', '0', '0', 'bool');
INSERT INTO chi5_settings
(setting_name, setting_value, setting_default, setting_typeset) VALUES ('news_check_datetimegmt', '', '', 'string');
DELETE FROM chi5_settings
WHERE setting_name
= 'theme_main_color';
DELETE FROM chi5_settings
WHERE setting_name
= 'theme_top_bar_button_color';
UPDATE chi5_settings
SET setting_value
= "4.0.0" WHERE setting_name
= "chevereto_version_installed";</code></pre>
# Incident ID:6336f0176e3e9
# Time
2022-09-30T13:33:11+00:00 [1664544791]
# Stack trace
------------------------------------------------------------
#0 /home/lokomotiv/domains/tst.lokomotiv.ro/public_html/app/legacy/install/installer.php:1936
{main}()
------------------------------------------------------------
#1 /home/lokomotiv/domains/tst.lokomotiv.ro/public_html/app/legacy/commands/update.php:18
require_once()
------------------------------------------------------------
#2 /home/lokomotiv/domains/tst.lokomotiv.ro/public_html/app/legacy/entrypoints/cli.php:53
require_once(string(length=83))
------------------------------------------------------------
#3 /home/lokomotiv/domains/tst.lokomotiv.ro/public_html/app/bin/legacy:13
require_once(string(length=83))
------------------------------------------------------------