Skip to main content
A
Anonymous
April 8, 2014
Question

Error Executing Database Query

  • April 8, 2014
  • 1 reply
  • 1100 views

Error Executing Database Query.

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' at line 1

I keep getting this error everytime I try to log into my inventory database I set up.  I cn not find it anywhere in order to view or change the syntax.  Please help!

    This topic has been closed for replies.

    1 reply

    Carl Von Stetten
    Carl Von Stetten
    Legend
    April 8, 2014

    What version of ColdFusion are you running?  Also, what version of MySQL?  This particular error may be a known issue related to version incompatibilities between CF and MySQL.  This was the first hit on Google when searching "OPTION SQL_SELECT_LIMIT=DEFAULT": http://stackoverflow.com/questions/15038312/cf10-mysql-sql-select-limit-default

    If this is indeed your issue, more detailed information can be found on Charlie Aerhart's blog.

    -Carl V.

    A
    Anonymous
    April 8, 2014

    My ColdFusion version is 9 and MySQL version is 5.6

    On Tue, Apr 8, 2014 at 12:45 PM, Carl Von Stetten

    Carl Von Stetten
    Carl Von Stetten
    Legend
    April 8, 2014

    CF9 and CF10 (prior to update 11) don't officially support MySQL above version 5.1.  You will need to update your MySQL JDBC connector to support MySQL 5.6 (although it won't be supported by Adobe).   See the links in my first reply for details on how to do this.

    -Carl V.

    Terms & ConditionsAccessibility statement
    Using the community Terms of use Privacy Cookie preferences Do not sell or share my personal information ad choicesAdChoices