3.20 database update issue (missing requirement)

[imageku]

▶ Reproduction steps

1. 3.20.0 upgrade to 3.20.2
2. Install DB update
3. The message is displayed: Problems executing the SQL update query. It is recommended that you issue the above SQL queries manually.
4. Run SQL query in phpmyadmin:ALTER TABLE chv_importing CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;

📃 Error log message

1071 - Specified key was too long; max key length is 1000 bytes

 

[Rodolfo]

PHP | Chevereto V4 Docs

Image and Video hosting software

chv.to

Add a zero step always for system requirements check.

 

[imageku]

PHP | Chevereto V4 Docs

Image and Video hosting software

chv.to

Add a zero step always for system requirements check.

I have updated the PHP version to 7.4.20 as required, but I still cannot install the database update. I think this is a database problem. Do I need to update MariaDB?

Does my MariaDB version 10.3.27 meet the requirements?

 

[Rodolfo]

Does my MariaDB version 10.3.27 meet the requirements?

YES.

 

[imageku]

View attachment 4053

YES.

Thank you for your prompt, I installed the database update successfully after upgrading MariaDB to 10.5.

But I encountered a new problem, which seems to be the same as reported here: https://chevereto.com/community/threads/3-20-homepage-cover-image-no-longer-responsive.13423/

I reproduced this problem in Safari on my iPhone.

In addition, on Chrome, if the user is not logged in, there is no problem. It will reappear if you log in.

 

[Rodolfo]

I'm sorry but as I said I the other topic, I don't have any apple hardware to test under those devices. Seriously, I'm waiting for some user to provide the CSS patch.

I insist, I won't fix the issues with Apple devices bacause I don't have any of these devices to test! Sorry for not using Apple stuff.

 

[Rodolfo]

I've found a Linux based web browser (Falkon) which works with the same render used in webkit and I can work on this 🥳.