I'm moving an old website on CF16 to a new CF21 se...
# cfml-generalb
Brian Lang
08/04/2022, 10:05 PMI'm moving an old website on CF16 to a new CF21 server.
Running a query and I get this in a date field:
In CF16, it returns a date/time value as normal.
Any suggestions on how to fix?
b
bdw429s
08/04/2022, 10:08 PM@Brian Lang You need to downgrade your MySQL JDBC driver
b
Brian Lang
08/04/2022, 10:09 PMSo the built-in drive is no good?
b
bdw429s
08/04/2022, 10:09 PMThere is no built in one
bdw429s
08/04/2022, 10:09 PMBut I suppose I should back up and ask what DB type
bdw429s
08/04/2022, 10:09 PMI just assumed it was mySQL since this is a common issue
b
Brian Lang
08/04/2022, 10:10 PMHm. Coworker set up the server, so maybe wrong driver.
MySQL.
C:\ColdFusion2021\pcbcrm\lib\mysql-connector-java-8.0.25.jar;
b
bdw429s
08/04/2022, 10:11 PMYeah, that didn't come bundled with CF. Someone added it
b
Brian Lang
08/04/2022, 10:11 PMok. Which version should I be using? Database is MySQL 5.26 I think
b
bdw429s
08/04/2022, 10:11 PMAdobe haven't bundled MySQL drivers for years due to Oracle licensing issues
bdw429s
08/04/2022, 10:12 PMbdw429s
08/04/2022, 10:12 PMCheck out the comments
bdw429s
08/04/2022, 10:13 PMYou need to go back to 8.0.22
bdw429s
08/04/2022, 10:13 PMThis was just discussed a couple weeks ago in #adobe too
b
Brian Lang
08/04/2022, 10:23 PMUsed the downgrade option in the CF Admin and that didn't work. Is there instructions on installing the 8.0.22 driver
Brian Lang
08/04/2022, 10:33 PMOK. Got the 8.0.22 version. Thanks for your help!
s
seancorfield
08/05/2022, 3:46 AM
8.0.23 -- a PATCH release -- introduced breaking changes in date handling. It's very frustrating. Luckily this is nothing to do with Adobe and you can deal with it on your own 🙂
9 Views