CMSB v3.65 Beta (New Field Types)
Hi All,
Beta version 5 is now available for download. Here's a list of fixes:
- Wysiwyg fields now show a notice if /lib/wysiwyg_custom.php is out of date and needs updating
- Wysiwyg fields now display content correctly with CDN and local libraries
- Backup & Restore now handles Generated Columns without errors
- Backup & Restore now restores tables with foreign keys without errors
- Permalinks plugin menu options now display correctly
- Database Editor no longer shows delete links for "accounts" and "_media" tables
- Foreign Keys now show links to target tables and warnings if unlinked
- We removed some invalid dynamic date-based examples for Generated Columns in MySQL
- Improved error messages and reporting
- Misc fixes and optimizations
I've attached some test schemas to help test the new features. Unzip them and upload to /data/schema/, then click "Database Editor" to import:
- Test Customers
- Test Projects (SET NULL)
- Test Projects (RESTRICT)
- Test Projects (CASCADE)
These sections are configured to demonstrate Generated Columns and Foreign Keys.
Steps to try:
- Deleting "Test Customers" will error due to Foreign Keys linking to that table
- Note the "Full Name", "Discount Level", and "Last Contacted Quarter" Generated Columns derived from other fields
- Customers and Projects with matching numbers are linked using Foreign Keys (configured differently for each project section)
- Delete Test User #2 and see Project 2's "Customer Id" set to null. Ensures you are never left with an invalid id.
- Delete Test User #8 and see Project 8 erased (CASCADE). Ensures orphan records are not left behind.
- Delete Test User #5 and see error (RESTRICT). Ensures data isn't accidentally erased when it's still needed by other records.
These features utilize advanced MySQL functionality to enforce data integrity without manual coding. Don't worry if you don't immediately see where you can put them to use, over time they will become very useful, especially for complex sites.
Post any questions or feedback. You can get the latest beta here: https://www.interactivetools.com/download/
Let us know about any final fixes or issues before we release.
Thanks!
Dave Edis - Senior Developer
interactivetools.com