The MySQL 5 database server version outdated

[anfedi]

*️⃣ Must open one ticket per issue. If you are experiencing multiple issues don't hesitate to create multiple tickets for each issue.

▶ Reproduction steps

1. Notice (1) Notification
2. The MySQL database server version outdated. You need to upgrade to 8.0.1 or higher.
3. Running PHP verion 8.3

😢 Unexpected result

Image page "blue screen Something Went wrong "

📃 Error log message

 

[Rodolfo]

With Chevereto v4.2.0, MySQL 8.0.1 or later is now required due to the need for Common Table Expressions (CTEs) to efficiently manage hierarchical data. While some parts of Chevereto may still function on MySQL 5, this older version is no longer officially supported, and it’s highly recommended to upgrade.

Using MySQL 8 brings significant performance, security, and compatibility improvements over MySQL 5. Running newer versions ensures you’re getting the most out of your database, with faster queries, better stability, and fewer vulnerabilities. If you’re still on MySQL 5, now is a great time to make the switch to stay up-to-date and fully supported.

While the software will get patched to hide these errors, the fundamental issue here is that you are missing extra functionality when you keep using MySQL 5.

 

[TigerDragon]

@Rodolfo thanks you and i work MySQL 5 upgrade MySQL 8 now thanks you

 

[Rodolfo]

This has been reported at chevereto/chevereto issue 81, there's syntax not valid for MySQL 5 at tags related table indexes. This will be fixed in the next revision.

 

[TigerDragon]

i work MySQL 8 Done there and MySQL 5 Delete now

 

[Rodolfo]

🎉 This has been fixed in Chevereto v4.2.2

Let us know if you encounter any other issues.