CMSB v3.64 Beta (Maintenance Release - MySQL 5.7+ now required)

Hi all,

We just released v3.64 beta. This is mainly a maintenance release.

Note that there's no urgency to upgrade unless you want to try out these features or ensure they run on your server.  During beta tests, we're often happy to adapt the code for you if there are any reported issues.

Here are some of the highlights: 

• MySQL 5.7.32+ is now required: We've increased the MySQL version from 5.5 to 5.7, this is still a very old version, but lets us use some features that aren't available in 5.5.  We're always looking to strike a balance between performance and compatibility.  You can check your current MySQL version under: Admin > General > Server Info
• Ignore PHP Developer Warnings: This option (under Admin > Security) is enabled by default and prevents PHP unneeded developer warnings from being displayed or logged.  During development, these warnings alert developers to PHP features that might be removed or changed in future versions, but on a production or live site you never need these displayed, they're only important when you're developing a site or upgrading it to a newer PHP version.  In practice this option lets you upgrade PHP on a server without as many code changes.  Note that actual errors (not warnings) are still displayed and logged.
• MySQL column defaults: When creating new sections or columns the createdDate/updatedDate fields now default to the current datetime.  This means that when you write custom code to add a record you don't need to manually specify the default values for all those columns, and adding a column after the fact won't break existing code that doesn't have a hardcoded default value for it.

Here's the complete changelog:

*** November 29, 2023 - Version 3.64 (Maintenance Release)

SERVER REQUIREMENTS: PHP 8.0+ and MySQL 5.7+ (or MariaDB 10.2+)

*** NEW DATABASE REQUIREMENTS
- This version now requires: MySQL 5.7.32+ or MariaDB 10.2+ (increased from MySQL 5.5+)
- Please check with your hosting provider to ensure you have these installed BEFORE upgrading.

MINOR CHANGES
- Admin Menu > Security: Added option to ignore PHP development warnings (E_STRICT, E_DEPRECATED)
- Admin Menu > Server Info: Display PHP Caching Modules to help debug caching issues
- Admin Menu > Server Info: Display CMS Folder and chroot status (to help debug filesystem issues)
- Section Editors: Renamed "Section Editors" to "Database" in CMS Setup menu
- Database: Newly created fields have default values in MySQL now so values don't have to be specified on INSERT
- Database: New createdDate and updatedDate fields now default to current datetime (not 0000-00-00 00:00:00)
- Database: "MySQL Type" is now displayed in its own column under: Admin > Database

ZenDB Improvements
- ZenDB: Added DB::identifier() for `quoting` and escaping MySQL identifiers such as table and column names
- ZenDB: Added $row->toArray() to get an array structure of HTML-encoded values
- ZenDB: Added $resultSet->toArray() to get an array structure of HTML-encoded values
- ZenDB: Added $resultSet->getColumn() to get values from a single column
- ZenDB: Added $resultSet->indexBy() for a column to record map, e.g. $emailToRecord = $resultSet->indexBy('email')
- ZenDB: Added $resultSet->groupBy() for a nested column to record map, e.g. $cityToUsers = $resultSet->groupBy('city')
- ZenDB: Brackets and "get" prefix are now optional for chainable methods, e.g. ->getValues() can be called as ->values

BUG FIXES & Minor Changes
- PHP 8.2 compatibility fixes
- Install: Fixed issue where restoring from backup on install required new admin account info to be entered
- MySQL 8.0: Fixed error when SET innodb_strict_mode was called without SESSION_VARIABLES_ADMIN access
- Error Logging: Improved how error logging catches and logs fatal errors that halt script execution
- Misc Code and other minor improvements.

You can download the latest beta here: https://www.interactivetools.com/order/download.php

Please post any feedback, questions, or bugs you find!

Thanks! :)