unable to update from 3.20.19 to 4.0.0

[crystyv]

Ticket template:

▶ Reproduction steps
Update from 3.20.19 to 4.0.0

😢 Unexpected result

after applyng below hotfix:

https://chevereto.com/community/threads/sqlstate-42000-syntax-error-or-access-violation-1091-cant-drop-column-user_is_dark_mode.14542/

I have bellow error:


📃 Error log message

Chevere\Throwable\Exceptions\LogicException thrown in /home/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 chv_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; ^M
INSERT IGNORE INTO chv_login_passwords (login_password_user_id, login_password_date_gmt, login_password_hash)
SELECT login_user_id, max(login_date_gmt), login_secret
FROM chv_logins
WHERE login_type = "password"
GROUP BY login_user_id;
INSERT IGNORE INTO chv_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 chv_logins
WHERE login_type = "cookie"
GROUP BY login_date_gmt
ORDER BY login_date_gmt DESC;
INSERT IGNORE INTO chv_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 chv_logins
JOIN chv_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 chv_login_providers
SET login_provider_key_id = '', login_provider_key_secret = '', login_provider_is_enabled = '0'
WHERE login_provider_name = 'facebook';UPDATE chv_login_providers
...................

ALTER TABLE chv_users ADD KEY user_palette_id (user_palette_id);^M
INSERT INTO chv_settings (setting_name, setting_value, setting_default, setting_typeset) VALUES ('logo_type', 'vector', 'vector', 'string');
INSERT INTO chv_settings (setting_name, setting_value, setting_default, setting_typeset) VALUES ('theme_palette', '0', '0', 'string');
^M
INSERT INTO chv_settings (setting_name, setting_value, setting_default, setting_typeset) VALUES ('enable_xr', '0', '0', 'bool');
INSERT INTO chv_settings (setting_name, setting_value, setting_default, setting_typeset) VALUES ('xr_host', 'localhost', 'localhost', 'string');
INSERT INTO chv_settings (setting_name, setting_value, setting_default, setting_typeset) VALUES ('xr_port', '27420', '27420', 'string');
INSERT INTO chv_settings (setting_name, setting_value, setting_default, setting_typeset) VALUES ('xr_key', '', '', 'string');
^M
INSERT INTO chv_settings (setting_name, setting_value, setting_default, setting_typeset) VALUES ('route_user', 'user', 'user', 'string');
INSERT INTO chv_settings (setting_name, setting_value, setting_default, setting_typeset) VALUES ('root_route', 'user', 'user', 'string');
^M
INSERT INTO chv_settings (setting_name, setting_value, setting_default, setting_typeset) VALUES ('arachnid', '0', '0', 'bool');
INSERT INTO chv_settings (setting_name, setting_value, setting_default, setting_typeset) VALUES ('arachnid_key', '', '', 'string');
INSERT INTO chv_settings (setting_name, setting_value, setting_default, setting_typeset) VALUES ('image_first_tab', 'info', 'info', 'string');
^M
INSERT INTO chv_settings (setting_name, setting_value, setting_default, setting_typeset) VALUES ('website_random_guest', '1', '1', 'bool');
INSERT INTO chv_settings (setting_name, setting_value, setting_default, setting_typeset) VALUES ('website_search_guest', '1', '1', 'bool');
INSERT INTO chv_settings (setting_name, setting_value, setting_default, setting_typeset) VALUES ('debug_errors', '0', '0', 'bool');
INSERT INTO chv_settings (setting_name, setting_value, setting_default, setting_typeset) VALUES ('news_check_datetimegmt', '', '', 'string');
^M
DELETE FROM chv_settings WHERE setting_name = 'theme_main_color';^M
DELETE FROM chv_settings WHERE setting_name = 'theme_top_bar_button_color';^M
UPDATE chv_settings SET setting_value = "4.0.0" WHERE setting_name = "chevereto_version_installed";</code></pre>

# Incident ID:6336c7494ca82

# Time
2022-09-30T10:39:05+00:00 [1664534345]

# Stack trace
------------------------------------------------------------
#0 /home/public_html/app/legacy/install/installer.php:1936
{main}()
------------------------------------------------------------
#1 /home/public_html/app/legacy/routes/update.php:30
require_once()
------------------------------------------------------------

------------------------------------------------------------
#2 /home/public_html/app/src/Legacy/G/Handler.php:227
Chevereto\Legacy\G\Handler->{closure}()
------------------------------------------------------------
#3 /home/public_html/app/src/Legacy/G/Handler.php:151
Chevereto\Legacy\G\Handler->processRequest()
------------------------------------------------------------
#4 /home/public_html/app/legacy/load/web.php:448
Chevereto\Legacy\G\Handler->__construct()
------------------------------------------------------------
#5 /home/public_html/app/legacy/entrypoints/index.php:25
require_once(string(length=76))
------------------------------------------------------------
#6 /home/public_html/index.php:12
require_once(string(length=85))
------------------------------------------------------------

 

[Rodolfo]

Revision 4.0.1 improves in the error display when failing to issue the update query. This may not fix your issue, but it will give a more concise explanation about the error for further handling.

 

[Rodolfo]

🎉 Fixed in 4.0.1. If the issue persist don't hesitate to open a new ticket.