VERSION 3.14 AND DATABASE ERROR FIX - AUGUST 22, 2018 (HTML5 MULTI-FILE UPLOADER) - Sep 4th, 2018

Before listing all the improvements in this version, I wanted to share Greg's solution to a database error that was thrown afer install when trying to access the Section Editor. According to Greg: "The issue seems to happen when you have multiple databases setup in MySQL that have CMS Builder installed with the same prefix. This causes the first statement below to select the same column more than once, which invalidated the next MySQL update statement. I'll push this change to our dev copy of CMS Builder so that the fix is in the next release." He went on to say: To fix the issue, in version 3.14 only, you'll need to change line 417 of the file your_cmsb_install_directory/lib/mysql_functions.php from this: WHERE table_name = '" .mysql_escape($mysqlTable). "' AND character_set_name IS NOT NULL AND collation_name IS NOT NULL"; // check for NULL to skip numeric/date fields that don't have charset/collation To this: WHERE table_name = '" .mysql_escape($mysqlTable). "' AND table_schema = '{$GLOBALS['SETTINGS']['mysql']['database']}' AND character_set_name IS NOT NULL AND collation_name IS NOT NULL"; // check for NULL to skip numeric/date fields that don't have charset/collation *** August 22, 2018 - Version 3.14 (HTML5 Multi-File Uploader) SERVER REQUIREMENTS - This software version REQUIRES: PHP 5.6+ and MySQL 5.5+ - NOTE: Some plugins may need to be updated when upgrading from v2.xx NEW FEATURES - File Uploader: Implemented new HTML5 uploader for easier multi-file uploading. - Security: Added new option under Admin > General > Security "Encrypt Database Connections" for using SSL with MySQL - Security: Added new option in Field Editor > Advanced Options > Data Encryption - Automatically encrypt data stored in database - Security: /data/ folder can now be stored outside of the web root. See /data/how_to_move_data_folder.txt for details - Backup & Restore: Restore operations are now incremental and reload the browser to avoid timeouts with large backups BUG FIXES & MINOR CHANGES - Email Delivery: Added tips to "Email Settings" on how to resolve delivery issues with Microsoft email services (hotmail, etc) - Database: Fixed issue where not all fields would get converted to 4-byte UTF8 (utf8mb4) - Field Editor: Added new 'MySQL Column Type' of MEDIUMBLOB (max: 16 megs) - Backup Menu: Skipped tables are now listed under Backup pulldown - Programmers: Added new plugin filters: loginExpirySeconds - Programmers: Added utility function: makeWritable - Misc Code and other minor improvements

Terms of Service