Critical Issues After Migrating Lucee 5.3 from Linux to Lucee 6 on Windows

After migrating our Lucee application from version 5.3 on Linux to version 6 on Windows, we are encountering several critical issues:

  1. Query of Queries (QoQ) Errors: We’re facing compatibility issues with QoQ, where some queries that worked previously now return errors.
  2. SQL Errors: Specific SQL queries are generating unexpected errors, such as “unexpected token: DEFAULT” with SQLState ‘42581’.
  3. JSON Parsing Issues: JSON data handling is not functioning as expected, leading to potential disruptions in data exchange.
  4. Blank Pages and URL Issues: URLs without extensions are showing blank pages, and there are inconsistencies in URL handling.
  5. Date Function Issues: Date functions, including CONVERT_TZ, are returning blank results.
  6. 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.

@Sandeep_Chaurasiya, there are many companies that can give you fast and professional support. You can find the list on the official Lucee website.

If you want to use the community you should start posting some code.

1 Like

This might be important and very valueable information that I know the Lucee Dev Team would like to see. But all the postings are very vague end general, they don’t give any information about anything. Would be nice to address all these issues, so please give details as @Roberto_Marzialetti already said.