• Welcome to the Chevereto User Community!

    Here, users from all over the world come together to learn, share, and collaborate on everything related to Chevereto. It's a place to exchange ideas, ask questions, and help improve the software.

    Please keep in mind:

    • This community is user-driven. Always be polite and respectful to others.
    • Support development by purchasing a Chevereto license, which also gives you priority support.
    • Go further by joining the Community Subscription for even faster response times and to help sustain this space
  • Chevereto Support CLST

    Support response

    Support checklist

    • Got a Something went wrong message? Read this guide and provide the actual error. Do not skip this.
    • Confirm that the server meets the System Requirements
    • Check for any available Hotfix - your issue could be already reported/fixed
    • Read documentation - It will be required to Debug and understand Errors for a faster support response

App stuck after update on maintenace mode page

B

bojko

Chevereto Member
🎯Description of the issue

The system failed after automatic update to 3.14.1

▶🚶‍Reproduction steps
Dashboard > Settings > Update

😢Unexpected result
Site does not work

📃Error log message
2020-01-29 15:00:42.826808 [INFO] [266974] [127.0.0.1:56052-1#APVH_www.bojko.net.pl:443] File not found [/home/bojkostr/domains/bojko.net.pl/private_html/404.shtml]
2020-01-29 15:17:46.803132 [INFO] [266974] [127.0.0.1:55528-1#APVH_www.bojko.net.pl:443] File not found [/home/bojkostr/domains/bojko.net.pl/private_html/robots.txt]
2020-01-29 15:17:46.803187 [INFO] [266974] [127.0.0.1:55528-1#APVH_www.bojko.net.pl:443] File not found [/home/bojkostr/domains/bojko.net.pl/private_html/404.shtml]
2020-01-29 16:08:25.549246 [INFO] [266974] [159.69.189.210:50118-1#APVH_www.bojko.net.pl:443] File not found [/home/bojkostr/domains/bojko.net.pl/private_html/robots.txt]
2020-01-29 16:08:25.549290 [INFO] [266974] [159.69.189.210:50118-1#APVH_www.bojko.net.pl:443] File not found [/home/bojkostr/domains/bojko.net.pl/private_html/404.shtml]
2020-01-29 16:24:39.720538 [INFO] [266974] [127.0.0.1:11934-1#APVH_www.bojko.net.pl:443] File not found [/home/bojkostr/domains/bojko.net.pl/private_html/404.shtml]
2020-01-29 16:48:35.272234 [INFO] [266974] [188.146.64.254:37277:HTTP2-21-1#APVH_www.bojko.net.pl] File not found [/home/bojkostr/domains/bojko.net.pl/public_html/robots.txt]
2020-01-29 16:48:35.272292 [INFO] [266974] [188.146.64.254:37277:HTTP2-21-1#APVH_www.bojko.net.pl] File not found [/home/bojkostr/domains/bojko.net.pl/public_html/404.shtml]
2020-01-29 17:31:42.761710 [INFO] [266974] [127.0.0.1:14686-1>207.46.13.195#APVH_www.bojko.net.pl:443] File not found [/home/bojkostr/domains/bojko.net.pl/private_html/robots.txt]
2020-01-29 17:31:42.761783 [INFO] [266974] [127.0.0.1:14686-1>207.46.13.195#APVH_www.bojko.net.pl:443] File not found [/home/bojkostr/domains/bojko.net.pl/private_html/404.shtml]
 
Sort by date Sort by votes
Kindly attach relevant logs (PHP process), these errors you are showing are about missing default 4XX pages in your server.

https://chevereto.com/docs/debug

If it is not feasible to retrieve any log or debug information, send me server access to REDACTED linking back to this topic to take a look.

Cheers,
Rodolfo.
 
Upvote 0 Downvote
I managed to remove the maintenance mode, it took me a while (everything was in Polish without the ability to toggle the language). I ended up installing adminer in your Chevereto root.

I've edited the system settings so next time you attempt the update it will dump the update queries so you can manually issue these in your MySQL console. Chances are that something in your database is preventing the installation from complete as it left the maintenance mode turned on.

Carry the DB update, post back here the MySQL issues.
 
Upvote 0 Downvote
Long story short - database update went smoothly, here goes log after query (sorry, but it is in polish):

Pokaż okno zapytań
dot.gif
Zmodyfikowanych rekordów: 1. (Wykonanie zapytania trwało 0.0031 sekund(y).)
UPDATE `chv_settings` SET `setting_value` = 1 WHERE `setting_name` = 'maintenance'
[Edytuj w linii] [ Edytuj ] [ Utwórz kod PHP ]
dot.gif
MySQL zwrócił pusty wynik (zero wierszy). (Wykonanie zapytania trwało 0.0442 sekund(y).)
ALTER TABLE `chv_logins` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci
[Edytuj w linii] [ Edytuj ] [ Utwórz kod PHP ]
dot.gif
MySQL zwrócił pusty wynik (zero wierszy). (Wykonanie zapytania trwało 0.0025 sekund(y).)
ALTER TABLE `chv_deletions` MODIFY `deleted_content_original_filename` varchar(255) DEFAULT NULL
[Edytuj w linii] [ Edytuj ] [ Utwórz kod PHP ]
dot.gif
MySQL zwrócił pusty wynik (zero wierszy). (Wykonanie zapytania trwało 0.0023 sekund(y).)
ALTER TABLE `chv_logins` MODIFY `login_type` enum('password','session','cookie','facebook','twitter','google','vk','cookie_facebook','cookie_twitter','cookie_google','cookie_vk') NOT NULL
[Edytuj w linii] [ Edytuj ] [ Utwórz kod PHP ]
dot.gif
Wstawionych rekordów: 1.
Id wstawionego wiersza: 218 (Wykonanie zapytania trwało 0.0017 sekund(y).)
INSERT INTO `chv_settings` (setting_name, setting_value, setting_default, setting_typeset) VALUES ('enable_powered_by', '1', '1', 'bool')
[Edytuj w linii] [ Edytuj ] [ Utwórz kod PHP ]
dot.gif
Wstawionych rekordów: 1.
Id wstawionego wiersza: 219 (Wykonanie zapytania trwało 0.0040 sekund(y).)
INSERT INTO `chv_settings` (setting_name, setting_value, setting_default, setting_typeset) VALUES ('akismet', '0', '0', 'bool')
[Edytuj w linii] [ Edytuj ] [ Utwórz kod PHP ]
dot.gif
Wstawionych rekordów: 1.
Id wstawionego wiersza: 220 (Wykonanie zapytania trwało 0.0026 sekund(y).)
INSERT INTO `chv_settings` (setting_name, setting_value, setting_default, setting_typeset) VALUES ('akismet_api_key', NULL, NULL, 'string')
[Edytuj w linii] [ Edytuj ] [ Utwórz kod PHP ]
dot.gif
Wstawionych rekordów: 1.
Id wstawionego wiersza: 221 (Wykonanie zapytania trwało 0.0106 sekund(y).)
INSERT INTO `chv_settings` (setting_name, setting_value, setting_default, setting_typeset) VALUES ('stopforumspam', '0', '0', 'bool')
[Edytuj w linii] [ Edytuj ] [ Utwórz kod PHP ]
dot.gif
Zmodyfikowanych rekordów: 1. (Wykonanie zapytania trwało 0.0033 sekund(y).)
UPDATE `chv_settings` SET `setting_value` = "3.14.1" WHERE `setting_name` = "chevereto_version_installed"
[Edytuj w linii] [ Edytuj ] [ Utwórz kod PHP ]
dot.gif
Zmodyfikowanych rekordów: 1. (Wykonanie zapytania trwało 0.0021 sekund(y).)
UPDATE `chv_settings` SET `setting_value` = 0 WHERE `setting_name` = "maintenance"
[Edytuj w linii] [ Edytuj ] [ Utwórz kod PHP ]
 
Upvote 0 Downvote
If everything went fine then the problem was that *something* failed in the previous process, perhaps the update carried too many rows to modify or the server simply went away.

I suggest you to keep the dump query setting on to have a fine control on your system database with consecutive updates. It should avoid any potential issue in the future.

I'm glad that it worked and that you can enjoy the software again.

Cheers,
Rodolfo.
 
Upvote 0 Downvote
I have tried upgrade twice. In meantime between your replays I have changed "maitenace" flag in database and there was no upgrade at all. Second, when you did it there was only wrong database version. So probably something went wrong at the very begining of the process.
 
Upvote 0 Downvote
You must log in or register to reply here.
Back
Top