After migrating our Lucee application from version 5.3 on Linux to version 6 on Windows, we are encountering several critical issues:
- Query of Queries (QoQ) Errors: We’re facing compatibility issues with QoQ, where some queries that worked previously now return errors.
- SQL Errors: Specific SQL queries are generating unexpected errors, such as “unexpected token: DEFAULT” with SQLState ‘42581’.
- JSON Parsing Issues: JSON data handling is not functioning as expected, leading to potential disruptions in data exchange.
- Blank Pages and URL Issues: URLs without extensions are showing blank pages, and there are inconsistencies in URL handling.
- Date Function Issues: Date functions, including
CONVERT_TZ
, are returning blank results. - requestLanguages Function: The
requestLanguages
function is not behaving as expected in ColdFusion code.
We need immediate assistance to troubleshoot and resolve these issues to ensure smooth operation on the new platform.
Thank you for your prompt attention.