I am not able to update.

[user_e5286]

I have a Pro license, and I am getting a notification saying there is a newer version available (4.2), but when I go to the dashboard it says I have the latest version. I checked my account and it says my license is active, but there is no button for 4.2. However, if I manually type in the 4.2 url, the zip file downloads. How can I get the dashboard update button to work? Thank you.

 

[Rodolfo]

Thread 'Distribution of v4.2.0 is paused'

Oct 26, 2024

Hello everyone,

I regret to inform you that I need to pause the distribution of v4.2.0 due to compatibility issues with the new Tags feature, which only works with MariaDB. I mistakenly assumed the SQL syntax would be compatible with both MySQL and MariaDB.

I’m currently reviewing all SQL in this update to ensure compatibility with both databases, which should be completed within a week.

I’m also looking into other issues. If you’ve already upgraded, the best course of action is to roll back to version 4.1.4.

For those experiencing a “white screen” please note that v4.2.0 requires PHP...

• Rodolfo
• Replies: 5
• Forum: [Archive] Announcements and news

• 

 

[user_e5286]

Ah thank you, Rodolofo.

 

[user_e5286]

Strange, I just updated to 4.2.1, and now the website doesn't work when I login. If I am logged out, it works fine, all the pics and homepage shows up, but once I login, the screen is just blank with the purple/blue background and nothing else. other than the header bar.

It is a php installation on cpanel.

 

[user_e5286]

Whoops, I forgot to run the database update. All good now.

 

[rsunny2012]

Strange, I just updated to 4.2.1, and now the website doesn't work when I login. If I am logged out, it works fine, all the pics and homepage shows up, but once I login, the screen is just blank with the purple/blue background and nothing else. other than the header bar.

It is a php installation on cpanel.

i had the same issue. After i entered the below command it worked

https://www.websitename.com/update

just replace your site name with websitename

 

[mar]

Did you upgrade the database too? I wasn't able to upgrade through the administrator panel. I got the error "page not found"

I had to do it through the terminal
cd /home/chevereto/mysite/uploader/app
php upgrading.php

then update database

/home/chevereto/mysite/uploader/app/bin/legacy -C update

done!

 

[allwebs]

Again it is not possible to update the database. First request - ok. Second - Lots of error Warning: #1062
MySQL 8.0.35
php 8.3

 

[aware]

Hello
I have the same problem.
php 8.1.29-0103
Have you found a solution ?

Edit :

I've found it, you'll need to update the database :
At the end of the url: /update

 

[Rodolfo]

@allwebs We could help if you share a bit of those errors.

 

[allwebs]

@allwebs We could help if you share a bit of those errors.

Spoiler: on this

# Dumped update query (to manually run in the database console)

UPDATE `chv_settings` SET `setting_value` = 1 WHERE `setting_name` = 'maintenance';
ALTER TABLE `chv_albums` MODIFY `album_user_id` bigint(32) DEFAULT NULL;
ALTER TABLE `chv_images` MODIFY `image_size` bigint(11) UNSIGNED NOT NULL;
ALTER TABLE `chv_images` MODIFY `image_type` tinyint(3) UNSIGNED as (case
 when `image_extension` in ('pdf','doc','md') then 4
 when `image_extension` in ('mp3','m4a','wav') then 3
 when `image_extension` in ('mp4','webm','mov') then 2
 when `image_extension` in ('avif','jpg','jpeg','gif','png','webp') then 1
 else 0 end) stored;
INSERT IGNORE INTO `chv_variables` (variable_name, variable_value, variable_type)
VALUES('crypt_salt', (SELECT `setting_value` FROM `chv_settings` WHERE `setting_name` = 'crypt_salt'), 'string');
INSERT IGNORE INTO `chv_variables` (variable_name, variable_value, variable_type)
VALUES('chevereto_version_installed', (SELECT `setting_value` FROM `chv_settings` WHERE `setting_name` = 'chevereto_version_installed'), 'string');
INSERT IGNORE INTO `chv_variables` (variable_name, variable_value, variable_type)
VALUES('last_used_storage', (SELECT `setting_value` FROM `chv_settings` WHERE `setting_name` = 'last_used_storage'), 'int');
INSERT IGNORE INTO `chv_variables` (variable_name, variable_value, variable_type)
[/SPOILER]
VALUES('id_padding', (SELECT `setting_value` FROM `chv_settings` WHERE `setting_name` = 'id_padding'), 'int');
INSERT IGNORE INTO `chv_variables` (variable_name, variable_value, variable_type)
VALUES('update_check_datetimegmt', (SELECT `setting_value` FROM `chv_settings` WHERE `setting_name` = 'update_check_datetimegmt'), 'string');
INSERT IGNORE INTO `chv_variables` (variable_name, variable_value, variable_type)
VALUES('update_check_notified_release', (SELECT `setting_value` FROM `chv_settings` WHERE `setting_name` = 'update_check_notified_release'), 'string');
INSERT IGNORE INTO `chv_variables` (variable_name, variable_value, variable_type)
VALUES('chevereto_news', (SELECT `setting_value` FROM `chv_settings` WHERE `setting_name` = 'chevereto_news'), 'array');
INSERT IGNORE INTO `chv_variables` (variable_name, variable_value, variable_type)
VALUES('cron_last_ran', (SELECT `setting_value` FROM `chv_settings` WHERE `setting_name` = 'cron_last_ran'), 'string');
INSERT IGNORE INTO `chv_variables` (variable_name, variable_value, variable_type)
VALUES('news_check_datetimegmt', (SELECT `setting_value` FROM `chv_settings` WHERE `setting_name` = 'news_check_datetimegmt'), 'string');
UPDATE `chv_settings` SET `setting_value` = 0 WHERE `setting_name` = "maintenance";

everything didn't fit on the screen, but all errors have the same code Warning: #1062 Duplicate entry
and Warning: #1681 Integer display width is deprecated and will be removed in a future release.

 

[Rodolfo]

That warning should be just a notice. It is saying that the engine ignores the INT width which has no consequence at all.

Don't worry about it.

 

[TigerDragon]

MySQL 5.7
PHP 8.3

 

[allwebs]

I'm worried that the update is not complete.

That warning should be just a notice. It is saying that the engine ignores the INT width which has no consequence at all.

Don't worry about it.

 

[Rodolfo]

@TigerDragon MySQL 5 is becoming no longer officially supported. https://chevereto.com/community/threads/the-mysql-database-server-version-outdated.15690/#post-77593

 

[Rodolfo]

@allwebs Are you sure you ran all the queries? Which MySQL server is this?

 

[user_d99c7]

Hello
I have the same problem.
php 8.1.29-0103
Have you found a solution ?

Edit :

I've found it, you'll need to update the database :
At the end of the url: /update

Im new here and your comment helped me! really appreciate it, thank you!!

 

[allwebs]

@allwebs Are you sure you ran all the queries? Which MySQL server is this?

the first thing that was in /update was updated without errors, the second (on the screenshot earlier) MySQL 8.0.35 does not accept, giving errors, which I also already showed

 

[Rodolfo]

@allwebs At this point I think that your database may require support to investigate the situation there.

If you find any other relevant information please share.

 

[allwebs]

I tried to move the site to another server, with another database, absolutely the same. Apparently, you need to roll back and wait, I don’t see any other way out for myself because I don’t understand what the error is, and the other sites work fine.