Release notes for Preside 10.20

10.20.83

Bug fixes

PRESIDECMS-2962 Very big version numbers: versioned editing interface fails to load versions beyond bigint size

10.20.80

Bug fixes

PRESIDECMS-2953 Browser prefetching action links: leads to the action being performed

10.20.73

Bug fixes

PRESIDECMS-2100 focal point picker goes into a loop if the image 404s
PRESIDECMS-2855 Yesterday filter not filtering yesterday date with 00:00:00 time
PRESIDECMS-2876 Submenu with separator only still render empty menu item
PRESIDECMS-2886 Email logging: show failure events in log view, even when sending eventually successful

10.20.72

The 10.20.72 hotfix addresses a couple of unrelated issues with site tree version numbers when editing, and the admin UI of the crop hint picker. See release notes for details.

Bug fixes

PRESIDECMS-2875 Admin edit site tree version set in request context regardless version is selected or not
PRESIDECMS-2863 UI issues when drawing the crop hint area for image assets

10.20.71

The 10.20.71 release resolves an issue with existing values in some form fields. See release notes for further details.

Bug fix

PRESIDECMS-2874 Unnecessary htmleditformat preventing detection of selected form fields

10.20.67

The 10.20.67 hotfix fixes an issue with the previous work on silently failing adhoc tasks. See release notes for details.

Bug fix

PRESIDECMS-2851 Invalid type error when failing inactive running tasks

10.20.66

The 10.20.66 hotfix addresses a number of issues, including a workaround for a bug in Safari 17.4 when displaying email inputs, and is a recommended update. See release notes for details.

Bug fixes

PRESIDECMS-2849 Issue with email input in Safari 17.4
PRESIDECMS-2461 Email layout default configurations overwritten
PRESIDECMS-2762 Adhoc tasks: can silently fail then never run
PRESIDECMS-2848 Data table action icons: only direct icon children should zoom on hover

10.20.65

Minor enhancements

PRESIDECMS-2676 use inspectTemplates\(\) instead of SystemCacheClear\( "template" \);
PRESIDECMS-2841 File download access control

Bug fixes

PRESIDECMS-2168 CurrentDateBetween expression excludes the dateTo date
PRESIDECMS-2175 Missing 'LoggedInUser' generator
PRESIDECMS-2231 Foreign Key Multiple Cascade Issue In Formbuilder\_Form Table With MSSQL DB
PRESIDECMS-2450 event.getClientIp\(\) - not using x-forwarded-for
PRESIDECMS-2822 Asset download: Inline documents get 301 redirect rather than 302
PRESIDECMS-2834 Missing placeholder in spinner form control
PRESIDECMS-2840 Files uploaded via formbuilder form could be downloaded by public

10.20.63

This hotfix release addresses a pair of minor issues. See release notes for details.

Bug fixes

PRESIDECMS-2827 No way to sort child pages that were set hidden from site tree n.b. a patching error led to this ticket not being correctly released in this version.
PRESIDECMS-2837 HTTP protocol dropdown placeholder is display incorrectly

10.20.62

This hotfix release addresses a number of unrelated minor issues. See release notes for details.

Bug fixes

PRESIDECMS-2777 Tenancy for asset is not working properly
PRESIDECMS-2781 Pages in new sitetree grid view are shown \(wrong\), but not in tree view \(correct\)
PRESIDECMS-2806 Export field sorting different from the default selected options
PRESIDECMS-2820 Datamanager search boxes: object name always singular
PRESIDECMS-2826 Asset download: attempts to create derivative for non-existant asset

10.20.61

The 10.20.61 hotfix release addresses an issue where saving a draft page without changes will publish the page.

Bug fix

PRESIDECMS-2828 Saving a page as draft without changes will publish the page

10.20.60

The 10.20.60 hotfix addresses several bugs and adds a couple of minor enhancements from 10.26.10 and 10.26.11. See release notes for details

Bug fixes

PRESIDECMS-2802 Email stats: Inconsistent click count on graph vs click stat
PRESIDECMS-2819 unscoped variables in errorTemplate.cfm can cause crash
PRESIDECMS-2789 TimePeriodPicker pastOnly futureOnly should set min max dates
PRESIDECMS-2823 cookies: secure not auto set to true for applications that do not make use of sites (i.e. admin only applications)

Enhancements

PRESIDECMS-2813 Option to hide cancel button in createTask
PRESIDECMS-2821 Ability to set a canonical tag in a page

10.20.59

This hotfix address a quartet of unrelated issues. See release notes for details.

PRESIDECMS-2791 Missing pre/post sortRecordsAction data manager customisation
PRESIDECMS-2798 Critical system alerts only shows when logging in as Super Admin
PRESIDECMS-2799 Batch edit missing data manager customisation
PRESIDECMS-2801 Rules engine expression cache: needlessly taking up valuable heap memory

10.20.58

This hotfix address a pair of unrelated issues. Firstly an issue fixing broken links that contain non latin characters in the link picker. Second, a fix for some inconsistent behaviour with site tree page pickers.

Bug fixes

PRESIDECMS-2790 linkPicker throws an error for resource with non latin characters in title etc
PRESIDECMS-2795 Admin site tree page picker missing saved values occasionally

10.20.57

This hotfix addresses four unrelated issues, see release notes for details.

Bug fixes

PRESIDECMS-2765 Formbuilder POST action should check from address against allowed domains
PRESIDECMS-2769 OneToMany rules expressions fail if relationship is self
PRESIDECMS-2787 Fieldsets display even if they have no form content
PRESIDECMS-2788 Devs unable to modify output content after delayed viewlets rendered

10.20.56

This hotfix addresses a bug where deleted asset images may have their private URL result cached in upstream proxies. See release notes for details.

Bug fixes

PRESIDECMS-2786 Deleted assets in trash: cache header means assets might be cached upstream

10.20.55

This hotfix addresses a security issue where deleted assets may be publicly available at a non-guessable URL. See release notes for details.

Bug fixes

PRESIDECMS-2783 Deleted assets in trash: accessible on a public URL

10.20.54

This hotfix fixes an issue with over agressive Antisamy cleansing. See release notes for details.

Bug fixes

PRESIDECMS-2468 Antisamy is converting " to "

10.20.53

This release addresses a duo of unrelated tickets. See release notes for details.

Fixes

PRESIDECMS-2761 Form builder select should not have first option selected
PRESIDECMS-2764 preInitializeDummyPresideSiteTreePage needed

10.20.52

The 10.20.52 hotfix fixes an issue when using complex segmentation filters to action an email send.

Bug fix

PRESIDECMS-2757 Complex segmentation filters fail when used to action an email send

10.20.51

This hotfix adds a fix for an issue with datatables struggling to behave well for tables with millions of rows. See release notes for details.

Bug fixes

PRESIDECMS-2750 Slow count() queries for datatables: allow a short timeout to get results back to user with unknown total

10.20.50

The 10.20.50 hotfix addresses an issue when queuing mass emails, where a bug in MariaDB could cause an endless loop.

Bug fix

PRESIDECMS-2748 Modify email queuing method to avoid potential endless loops

10.20.49

The 10.20.49 hotfix addresses an issue with duplicate inserts when queuing mass emails, and enhances the isTrue()/isFalse() helpers to allow null values to be passed in.

Bug fix

PRESIDECMS-2747 Duplicate entry 'xxxx' for key 'ux_email_mass_send_queue_queuedemail'

Enhancement

PRESIDECMS-2744 Allow null values to isTrue() and isFalse()

10.20.48

The 10.20.48 hotfix addresses three unrelated issues, including better column typing for Excel data export and an email hyperlink fix.

Bug fixes

PRESIDECMS-2727 Email hyperlink not working as expected
PRESIDECMS-2738 Excel data export uses wrong data type for formula fields
PRESIDECMS-2742 Missing ${prefix} on formula fields

10.20.47

This release contains four bug fixes. Two related to application reload performance, and two unrelated bugs. See release notes for details.

Bug fixes

PRESIDECMS-2716 Problem quick-editing Rules engine filters with long labels
PRESIDECMS-2729 SQL Schema sync: only query table columns when needing to make changes
PRESIDECMS-2730 Performance: repetetive file system reading by extension manager
PRESIDECMS-2732 Many-to-one filter expression can cause datatable record query to fail

10.20.46

This release addresses a pair of unrelated issues. Firstly, an issue where deserializing string values that could be interpreted as numbers leads to unpredictable results and second, making VIPs image processing more forgiving with images with odd colour profiles.

Bug fixes

PRESIDECMS-2722 Deserializing delayed viewlet args: some strings converted to numbers \(e.g. 4578e91\)
PRESIDECMS-2723 VIPS processing: error thrown when trying to convert some images to sRGB that have missing colour profiles

10.20.45

This release addresses a quartet of unrelated performance improvements. See release notes for details.

Bug fixes

PRESIDECMS-2715 Task logging: uses unduly large disk space in MySQL
PRESIDECMS-2717 Asset downloads: redirects to inline assets \(images\) should be permanent
PRESIDECMS-2718 Preside Object Views: Use of duplicate\(\)
PRESIDECMS-2720 Asset processing queue: out of memory error

10.20.44

This release addresses a pair of unrelated bugs including a performance improvement from Zac Spitzer related to use of dbinfo with later versions of Lucee. See release notes for details.

Bug fixes

PRESIDECMS-2712 Admin quickEdit content does not use richEditor when field defined with "mediumtext"
PRESIDECMS-2713 use faster Lucee 6 dbinfo when available

10.20.43

This release addresses a trio of unlrelated bugs, see release notes for details.

Bug fixes

PRESIDECMS-2704 Text is not visible in preside admin toolbar when viewing a frontend page
PRESIDECMS-2705 Exception type is not a simple value
PRESIDECMS-2708 Asset download: cache headers to not differentiate between public and private assets

10.20.42

This release fixes a number of critical bugs and adds some useful features to help with performance and stability. See release notes for ticket details.

Improvements

PRESIDECMS-2700 CSRF Tokens: allow option to only use when session exists
PRESIDECMS-2701 No ability to set query timeouts

Bug fixes

PRESIDECMS-2697 Missing result url for batch delete adhoc task
PRESIDECMS-2698 Recordcount fails if only fields supplied are formula fields
PRESIDECMS-2702 Autogen filters: enum property text matches fails in some way when used in conjunction with other filters
PRESIDECMS-2703 Missing advanced filter list on formbuilder question datamanager view

10.20.41

This release addresses fixes for a number of unrelated bugs. See release notes for details.

Bug fixes

PRESIDECMS-2372 Exporting content field in the email log throws error
PRESIDECMS-2373 Searching for a email template in the email log and exporting the results, the downloaded file will be empty
PRESIDECMS-2400 Sitetree: Error " Object \[login\] does not exist" after save reordered pages
PRESIDECMS-2570 Not able to clear orphaned system alert
PRESIDECMS-2683 Scheduled saved export not running as expected
PRESIDECMS-2687 Preside validation does not translate label for param field
PRESIDECMS-2693 Remove unsupported properties from JavaImageMetaReader

10.20.40

This hotfix resolves 5 unrelated issues.

Bug fixes

PRESIDECMS-2571 Text area resizes abnormally from default size when theres changes in text content
PRESIDECMS-2666 No paging on sync task logs
PRESIDECMS-2680 Error cloning page to a different site
PRESIDECMS-2681 500 on blank email layout cloned at preview page
PRESIDECMS-2684 Field without question resulted in empty label causes 500 error on form render

10.20.39

This hotfix resolves 2 unrelated issues.

Bug fixes

PRESIDECMS-2653 System email template edit saving with no layout selected results in 500 error
PRESIDECMS-2637 Nesting of widget configurator

10.20.38

This hotfix resolves 3 unrelated issues.

Bug fixes

PRESIDECMS-2655 Form builder POST action "Anonymous user email" option unable to proceed
PRESIDECMS-2667 Align attribute missing on image picker renderer causing image not align correctly on Outlook
PRESIDECMS-2670 Update changed data not picking up many-to-many field value

10.20.37

This hotfix addresses a recently introduced regression.

Bug fixes

PRESIDECMS-2673 Refactored find and replace: chokes when input string is a number

10.20.36

This hotfix addresses a regression introduced with the previous hotfix with regards to viewing email statistics in the email center.

Bug fixes

PRESIDECMS-2669 isRelationalAggregateField() helper referenced but does not exist in core Preside

10.20.35

The 10.20.35 hotfix addresses a slew of performance and bug fixes,

Bug fixes

PRESIDECMS-2657 Missing admin permission key for link menu item
PRESIDECMS-2659 Saved export access role not able to access saved export history
PRESIDECMS-2660 showNonLiveContent\(\) - don't do try/catch for checking the variable exists
PRESIDECMS-2661 Object with tenancy getting empty tenancy ID for filter
PRESIDECMS-2662 Use non-Google URL for ReCaptcha
PRESIDECMS-2663 Performance: find and replace techniques for delayed rendering, etc. could be optimized
PRESIDECMS-2664 Navigate permission key didn't include in the default operations
PRESIDECMS-2665 Slow performance on email logs when use filter

10.20.34

This hotfix release addresses a pair of unrelated issues. Firstly, an issue with how dynamic rules filters work for formula fields. Secondly, an issue with ad-hoc tasks with runnow=true failing to run in some circumstances.

Bug fixes

PRESIDECMS-2489 Formula field filters: cause multiple issues
PRESIDECMS-2566 Ad-hoc tasks that fail to run with runNow=true NEVER run

10.20.33

The 10.20.33 hotfix addresses an edge case regression introduced with recent improvements to datamanager listing counts.

Bug fixes

PRESIDECMS-2562 Do not optimise datmanager listing count if groupBy is specified

10.20.32

The 10.20.32 hotfix addresses a regression introduced to particular many-to-many auto generated filters in previous hotfixes.

Bug fixes

PRESIDECMS-2561 Many-to-many count auto filter: fails when on an auto join table

10.20.31

This hotfix addresses a number of unrelated bugs.

Bug fixes

PRESIDECMS-2543 Scheduled export run twice around same time when there are 2 replicas
PRESIDECMS-2548 Admin tree view: does not honour hiddenGridFields annotation
PRESIDECMS-2549 Multi link picker didn't take version number in account
PRESIDECMS-2550 Email center logs redirects to data manager email logs view after cancelling on save for later
PRESIDECMS-2551 Adding "results=xyz" in URL causes 500 error
PRESIDECMS-2552 Website welcome email getSite potentially will be empty struct
PRESIDECMS-2553 FormControl checkbox not translating i18n in checkboxLabel
PRESIDECMS-2554 Fix default types in linkPicker
PRESIDECMS-2555 Error on sending email with empty html or text body

10.20.30

The 10.20.30 hotfix provides further performance enhancements for sites with large and complex data.

Bug fixes

PRESIDECMS-2545 Performance: datatables should make use of faster recordcount queries

10.20.29

The 10.20.29 hotfix addresses a pair of performance issues for applications with large data and a fix from Zac Spitzer for a developer console error.

Bug fixes

PRESIDECMS-2539 avoid error in dev console when you just type console
PRESIDECMS-2542 Further performance improvements to be had with recordCountOnly queries
PRESIDECMS-2544 Performance: mass email sending: use exists\(\) subqueries to ensure no duplicate emails/no too frequent sending

10.20.28

The 10.20.28 hotfix addresses a trio of issues: two performance improvements and a minor issue with default email subjects for an admin notification email.

Bug fixes

PRESIDECMS-2527 Internationalised admin notification email
PRESIDECMS-2540 ManyToManyHas & ManyToManyCount rules filters can perform better
PRESIDECMS-2541 Performance: Selecting matching record count for filter can be optimised

10.20.27

THe 10.20.27 hotfix addresses a regression introduced in 10.20.25. The error causes background scheduled task system to raise errors when performing task cleanup.

Bug fixes

PRESIDECMS-2533 Variable localTaskThreads does not exist in cleanupNoLongerRunningTasks

10.20.26

The 10.20.26 hotfix resolves a long-standing bug exposed by the previous hotfix.

Bug fixes

PRESIDECMS-2531 object missing _version_is_latest_draft error when selecting from version table

10.20.25

The 10.20.25 hotfix resolves three unrelated bugs.

Bug fixes

PRESIDECMS-2522 variable threadId doesn't exist in cleanupNoLongerRunningTasks
PRESIDECMS-2523 Draft mail not saved correctly when clicking publish draft email on top right menu
PRESIDECMS-2528 DataTables can create querystring that is too long

10.20.24

The 10.20.24 hotfix resolves three unrelated bugs.

Bug fixes

PRESIDECMS-2515 DevTools: cache stats and resetstats ignore cachename argument
PRESIDECMS-2520 Custom flag field flag action doesn't update version record
PRESIDECMS-2521 Cloning Segments loses Parent relationship

10.20.23

The 10.20.23 hotfix addresses a number of performance micro optimisations and an error with certain multi-option formbuilder forms.

Bug fixes

PRESIDECMS-2512 Formbuilder multiple question with comma value issue
PRESIDECMS-2513 LinksService: not a singleton
PRESIDECMS-2517 Avoid using isObject\(\) and getApplicationSettings\(\) where possible: minor performance implications
PRESIDECMS-2518 Helpers functions: use cfsilent to optimize request memory usage

10.20.22

The 10.20.22 hotfix addresses a regression with 10.20.21 where recordcountonly queries could break when using group by statements with functions.

Bug fixes

PRESIDECMS-2514 Regression: recordcountonly queries break when using some sql functions in group by

10.20.21

The 10.20.21 hotfix releases a pair of issues. Firstly a bug fix for an issue introduced in 10.20.19. Secondly, a performance enhancement for admin data listing grids and other queries that get a record count only of a given set of select data arguments.

Bug fixes

PRESIDECMS-2510 Datamanager data table: slow count queries
PRESIDECMS-2511 Ensure alias escaping is applied correctly

10.20.20

The 10.20.20 hotfix addresses a performance issue with "autogroupby" and MySQL/MariaDB. Auto optimising queries when the DB engine is not configured to only allow full group by field lists.

Bug fixes

PRESIDECMS-2509 Performance: autogroup by could be optimized in some scenarios

10.20.19

The 10.20.19 hotfix fixes a number of unrelated bug fixes, including an issue with heap space usage for systems that make use of and frequently query dynamic rules engine filters.

Bug fixes

PRESIDECMS-2498 Pass validationResult as an argument to preQuickAddRecordAction
PRESIDECMS-2500 Data export etc: fails with FK label field when FK name is a reserved word
PRESIDECMS-2506 Heap space issues with foreign key calculation cache

10.20.18

The 10.20.18 hotfix addresses a load order issue that can prevent sites from starting when using db migrations (that have particular dependencies).

Bug fixes

PRESIDECMS-2503 DB Migrations: load order issue preventing some applications from starting up

10.20.17

The 10.20.17 hotfix addresses an issue with viewing email stats for system emails.

Bug fixes

PRESIDECMS-2502 System email stat filter returning 404

10.20.16

The 10.20.16 hotfix resolves an issue where the system alert data column might not be long enough to accept the required data.

Bug fix

PRESIDECMS-2499 System alert: Data too long for column 'data'

10.20.15

The 10.20.15 hotfix contains three unrelated fixes: allow UTF-8 in i18n properties; prevent errors when generating complex dynamic forms; and prevent the hijacking of formbuilder datatable row clicking if the response contains a URL.

Bug fixes

PRESIDECMS-2486 Preserve UTF-8 encoding when reading resource files

PRESIDECMS-2493 Prevent clickable link for formbuilder response

PRESIDECMS-2495 Increase length of system\_config value field

10.20.14

The 10.20.14 hotfix resolves an issue in the task manager where tasks are incorrectly marked as running when they are not.

Bug fix

PRESIDECMS-2491 Task is marked as running but not actually running (errors in task manager)

10.20.13

The 10.20.13 hotfix resolves three unrelated bugs, relating to System Alerts, email drafts and data export.

Bug fixes

PRESIDECMS-2408 Email draft gone when save settings

PRESIDECMS-2483 Passed field titles get overwritten during data export

PRESIDECMS-2485 SystemAlert adhoc tasks shoud be cleared on completion

10.20.12

The 10.20.12 hotfix addresses a regression introduced with a bug fix in relation to text matches against enum fields in rules engine filters.

Bug fixes

PRESIDECMS-2484 TextPropertyMatches with enum: filter now only works with enum values, not a mix

10.20.11

The 10.20.11 hotfix fixes a couple of client-side validation issues, and prevents cftoken and cfid cookies being set on 500 error pages.

Bug fixes

PRESIDECMS-2482 Session cookies set on 500 error pages

PRESIDECMS-2481 JS validator for SameAs validation rule throws error

PRESIDECMS-2480 Formbuilder jQuery validation

10.20.10

The 10.20.10 hotfix upgrades the Sticker library with a fix for a potential XSS vulnerability.

Bug fixes

PRESIDECMS-2478 XSS vulnerability on Preside admin login screen

10.20.9

The 10.20.9 hotfix releases a variety of bug fixes.

Bug fixes

PRESIDECMS-2466 Contact email Preview HTML Iframe is not full width.
PRESIDECMS-2467 Increase the maxInputSize for preside policy in antiSamy services.
PRESIDECMS-2471 Saved exports not showing the filter
PRESIDECMS-2473 Saved export file get overwritten by another savedExport
PRESIDECMS-2474 Admin custom homepage prevent redirect to custom application
PRESIDECMS-2475 fileupload formbuilder form type: 500 error
PRESIDECMS-2476 Update cache control no store
PRESIDECMS-2477 Saved export : Failed to generate report - function not found

10.20.8

The 10.20.8 hotfix addresses three issues, including two related to site tenancy. See notes for details.

Bug fixes

PRESIDECMS-2125 TextPropertyMatches filter not working with enum label

PRESIDECMS-2459 Related object validator interrupted by site tenant

Improvement

PRESIDECMS-2463 Redirect admin back to last edited form settings when saving with tenantId

10.20.7

The 10.20.7 hotfix addresses a performance issue with data export that had the potential to crash an application depending on its memory resources. See notes for details.

Bug fixes

PRESIDECMS-2465 Data export: memory usage issues

10.20.6

The 10.20.6 hotfix applies a fix for an issue with validation messages for max and min length validators introduced in 10.18.0.

Bug fixes

PRESIDECMS-2457 Incorrect error message for maxlength validator

10.20.5

The 10.20.5 hotfix fixes a pair of issues, one with saving formbuilder "v2" matrix responses with long questions and the other to do with cloning records in datamanager with many-to-many relationship fields.

Bug fixes

PRESIDECMS-2444 Formbuilder matrix throw error when row question has more than 100 chars
PRESIDECMS-2455 Datamanager Clone record: many-to-many fields not prepopulated

10.20.4

The 10.20.4 hotfix fixes a backward compatibility issue with the 10.20.3 release. Please upgrade as soon as possible if running 10.20.3 to avoid potential errors with custom rules engine expressions.

Bug fixes

PRESIDECMS-2453 Rules engine: backward compatibility issue with refactor

10.20.3

The 10.20.3 hotfix releases a quintet of unrelated bug fixes.

Bug fixes

PRESIDECMS-2445 System Alerts settings check runs multiple times
PRESIDECMS-2446 Batch edit field with custom control: does not use non-default control
PRESIDECMS-2448 Rules engine: bad exists() filters when using auto expressions on a one-to-many property
PRESIDECMS-2451 Batch Update All fails if extraSelectFields have been specified
PRESIDECMS-2452 Csrf Protection Interceptor Error - invalid call of the function getDefaultUrl

10.20.2

The 10.20.2 hotfix addresses a pair of unrelated bugs. Thanks to Thum Choon Tat and Karhong Cheah for the fixes.

Bug fixes

PRESIDECMS-2438 Relationship too complex error when quick edit rules conditions filter
PRESIDECMS-2440 Ensure that having fields are unique

10.20.1

The Preside 10.20.1 hotfix release addresses three minor unrelated admin issues.

Bug fixes

PRESIDECMS-2435 Quick edit the page content widget with link cause incorrect page has draft flagged
PRESIDECMS-2436 Accessing email via DM object url not redirected to customTemplate
PRESIDECMS-2437 typeToConfirmDelete not applicable on userManager & websiteUserManager

10.20.0

The Preside 10.20 release is here! Hot off the heals of 10.19 - we continue with a pocket sized release for Christmas. Thanks to everyone involved. Check the video for more details.

Overview

The 10.20 release is a "pocket" release with just four new features (see below). The headline feature is our new System Alerts feature - be sure to check that out along with the other improvements in the links and video below. As ever, big thanks to everyone involved in keeping Preside moving forward. And Merry Christmas!

Upgrade notes: https://docs.preside.org/upgradenotes/10-20.html

PRESIDECMS-2419 System Alerts
PRESIDECMS-2420 Exactly x days ago or from now filter
PRESIDECMS-2421 Top right buttons: allow button with primary action \+ dropdown
PRESIDECMS-2424 DBMigrations doMigration check isEnabled handler