Saturday, September 6, 2014

Coldfusion 10 needs updates for MySql 5.6 support

On my local development machine I have Coldfusion 10.  Recently I needed to install MySql so I downloaded the latest version and installed it.  I was able to successfully setup a datasource but when I tried to use it I got the following error.



You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'OPTION SQL_SELECT_LIMIT=DEFAULT'

Some quick googling showed me that it was a problem with the database driver in cf.  There were some articles about updating the driver manually but they were kind of old.  I decided to update cf first and see if that helped.  I had not installed any updates yet on my local machine.  I updated to update 13 and everything started working so it was an easy fix this time.


No comments:

Post a Comment

Using Brave

For a few weeks now I have been using the Brave browser.  It is based on Chromium , so switching from Chrome was a quick adjustment since ...