Connect to database

[Nirjonadda]

Done

• Remove app/vendor from your Chevereto V3 installation
• Provide Chevereto V4 files on top of Chevereto V3 installation
• Switch to PHP 8

Now showing this for /install

 

[Rodolfo]

That's normal.

When you provided the V4 files the system was expecting the configuration values. The V4 Upgrading documentation mentions that you need to update from app/settings.php to app/env.php.

You can do this manually, or simple provide the connection info. The system will detect the existing installation, just mind to use the exact same database with the same table prefix.

 

[Nirjonadda]

Done, But can not update database via CLI or HTTP

 

[Friendbg]

Hi,

I've the same problem like @Nirjonadda . I've tried to upgrade from 3.20.19 but got mysql query errors :

snimka@hosting:/var/www/snimka.org/web$ ./app/bin/legacy -C update
Chevere\Throwable\Exceptions\LogicException thrown in /var/www/snimka.org/web/app/legacy/install/installer.php:1935

# 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;
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`
SET `login_provider_key_id` = '...', `login_provider_key_secret` = '...', `login_provider_is_enabled` = '0'
WHERE `login_provider_name` = 'twitter';UPDATE `chv_login_providers`
SET `login_provider_key_id` = '...', `login_provider_key_secret` = '...', `login_provider_is_enabled` = '1'
WHERE `login_provider_name` = 'google';UPDATE `chv_login_providers`
SET `login_provider_key_id` = '...', `login_provider_key_secret` = '...', `login_provider_is_enabled` = '0'
WHERE `login_provider_name` = 'Vkontakte';

ALTER TABLE `chv_users` ADD KEY `user_palette_id` (`user_palette_id`);
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');

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');

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');

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');

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');

DELETE FROM `chv_settings` WHERE `setting_name` = 'theme_main_color';
DELETE FROM `chv_settings` WHERE `setting_name` = 'theme_top_bar_button_color';
UPDATE `chv_settings` SET `setting_value` = "4.0.0" WHERE `setting_name` = "chevereto_version_installed";</code></pre>

# Incident ID:63369ddd665c8

# Time
2022-09-30T07:42:21+00:00 [1664523741]

# Stack trace
------------------------------------------------------------
#0 /var/www/snimka.org/web/app/legacy/install/installer.php:1935
{main}()
------------------------------------------------------------
#1 /var/www/snimka.org/web/app/legacy/commands/update.php:18
require_once()
------------------------------------------------------------
#2 /var/www/snimka.org/web/app/legacy/entrypoints/cli.php:53
require_once(string(length=54))
------------------------------------------------------------
#3 /var/www/snimka.org/web/app/bin/legacy:13
require_once(string(length=54))
------------------------------------------------------------

# Server
Linux hosting 5.4.0-125-generic #141-Ubuntu SMP Wed Aug 10 13:42:03 UTC 2022 x86_64

I've reverted to 3.20.19 and tried to hit manually /update but with no luck. Is there any way to update the database from cli when I'm still at version 3 ? I think there is some missing db updates on my database and thats the reason for this error.

Thanks @Rodolfo

 

[Rodolfo]

@Nirjonadda Check the hotfix.

@Friendbg Read the error and follow the instructions.

 

[Friendbg]

Thanks @Rodolfo ,

I've manually run the queries against db and the db update finished successfully!

 

[Nirjonadda]

@Rodolfo I have already followed this hot fix but errors are still same.

 

[Rodolfo]

@Rodolfo I have already followed this hot fix but errors are still same.

I'm afraid that your case needs Extra Support.

 

[Nirjonadda]

I'm afraid that your case needs Extra Support.

OK but only SQL query Error with this.

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;
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` = 'u4v+CWgd3zHVEJoFVA01gOZNDKYlEcDo4OAQ7g==', `login_provider_key_secret` = 'Q+w8HBc3QZh/B0PKtQycifRgd3ghyHK5aqWhNuyW9/j60Cczz+hRukCUFnQ=', `login_provider_is_enabled` = '1'
WHERE `login_provider_name` = 'facebook';UPDATE `chv_login_providers`
SET `login_provider_key_id` = 'p1sXn16RN6+N7eG0tfV9ZyjhjoqEzhVqPnj839/QkWGftnqegw==', `login_provider_key_secret` = '6I6HRGephyOrEY6Qh7hRumJ79EB3Ygq9rI7O6E41Z/at+LY7FXX4yL4BXUfHwf7j/OQbI7IGsc3V13+i814=', `login_provider_is_enabled` = '1'
WHERE `login_provider_name` = 'twitter';UPDATE `chv_login_providers`
SET `login_provider_key_id` = 'U6gcRAzBOIsCfmPN9WZZw0f4F2J/j/LQk0ioYncWUc5x5AE72L6SCCXdBwazXwCu9Me/xQ6qfOLw8wcG/uYrmvbM22qgHeYMqbdiFmEuWry1FZaQ', `login_provider_key_secret` = 'O1tcoIidpTRs1x+U2GVCWqzaDgzob17ErrPGhdqKFhRk4ea1', `login_provider_is_enabled` = '1'
WHERE `login_provider_name` = 'google';UPDATE `chv_login_providers`
SET `login_provider_key_id` = 'F9Dq6Db+sXDNHuQW2F9nqMzbhA==', `login_provider_key_secret` = 'NSvsCO4Q2rZXVxLZlTKlDr1ag+/GMJmznNTEVI2tlrk=', `login_provider_is_enabled` = '1'
WHERE `login_provider_name` = 'Vkontakte';

Error

SQL query: Documentation

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

MySQL said: Documentation
#1055 - Expression #3 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'nmela_imagehosts.chv_logins.login_secret' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by

#1055 - Expression #3 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'nmela_imagehosts.chv_logins.login_secret' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by