Friday, July 23, 2021

Upgrading to ColdFusion 2021

 If you're thinking of upgrading to CF21 and you use cfspreadsheet in your code, don't.

Cfspreadsheet, when doing read, randomly locks files anywhere from minutes to hours. The only way to get rid of the lock if you want to move or delete the file is to restart the main instance even if the file was locked by another instance.

On July 22nd, Adobe said that the issue is fixed in Update 2, but gave no eta from when Update 2 will be released.

https://tracker.adobe.com/#/view/CF-4212149

Friday, January 29, 2021

Upgrading to MySQL 8: rank

 Rank is a reserved keyword in MySQL 8. Before upgrading, make sure it's not a table name, column, or alias used in a query.