search : mysql

select a category, or use search below
(searches all categories and all time range)

displaying top 100 results

Bug 77420:Tried to set up a datasource using mysql 4/5 type and have the right info and connected with cf8 but not 9
Comment on Bug 80192:The DataDirect MySQL driver will not connect to a Community Edition MySQL database by External U.
Comment on Bug 80192:The DataDirect MySQL driver will not connect to a Community Edition MySQL database by External U.
Bug 80192:The DataDirect MySQL driver will not connect to a Community Edition MySQL database
2608336 CF-4119801 External U. MySQL Connector/J 5.1.37 gets no table information of MySQL 5.7 Your suggestion: MySQL 5 embedded driver shows Table definition (works) MySQL Data direct is not supported by MSQL Enterprise 5.7 ---------- We had to use the JDBC driver to see the SQL query
Comment on Connection String in MySQL Datasource sent to Database with trailing space by External U.
CF18 MYSQL8 Windows Server 2019
MySQL DD corrupts UTF-8 data / MySQL 5 does not
Comment on Can't Uninstall MySQL from AWS AMI by Vamseekrishna N.
2608336 CF-4119801 Akhila K. We are unable to repro this issue, tried with drivers MySQL 5, MySQL (DataDirect) . Please provide us more details on JDBC driver name, version for repro. Thanks, Akhila.
Comment on Unknown table variables in information_schema ColdFusion10 + MySQL 5.5 Enterprise by Nimit S.
Comment on Bug 78969:When ColdFusion is running, and successfully makes one or more exchanges with a database ( MySQL in my setup ), and then that database server is restarted ( the MySQL service is restarted ), the first by External U.
Comment on Loads of SQL errors in ClientScopeCleanUpThread with MySQL by Bradley W.
2608613 CF-4049903 Nimit S. Hi Kheirbakhsh, MySQL(DataDirect) driver is supported only for MySQL Enterprise or Commercial versions. If you are using MySQL Community Edition, then please try creating data source with "MySQL5" and not with "MySQL(DataDirect)". Please let us know if you are still
Comment on Unknown table variables in information_schema ColdFusion10 + MySQL 5.5 Enterprise by Adobe D.
Bug 77588:Tried to make a database connection using MySQL 4/5 and it failed
Can't Uninstall MySQL from AWS AMI
3297734 CF-4199071 Database : CFQuery Joshua Saia CFQUERY turns Emojis into Question marks Problem Description: CFQUERY turns Emojis into Question marks on insert in MySQL database Steps to Reproduce: Using Coldfusion connected to MySQL database with everything set to use UTF8MB4 collation, try
Comment on Unknown table variables in information_schema ColdFusion10 + MySQL 5.5 Enterprise by External U.
Comment on Please integrate MariaDB driver in CF Administrator since MySQL 5 drivers were dropped in CF 11 by Philipp C.
Comment on Coldfusion CFScript Query with MySQL Assignment Operator by Vamseekrishna N.
Comment on Coldfusion CFScript Query with MySQL Assignment Operator by Himavanth R.
Comment on Connection String in MySQL Datasource sent to Database with trailing space by External U.
Comment on Connection String in MySQL Datasource sent to Database with trailing space by External U.
Bug 76111:Mysql driver 5
MySQL 5.6 Unable to Execute Queries
Comment on Why are the MySQL drivers not shipped? by External U.
Comment on MySQL DD corrupts UTF-8 data / MySQL 5 does not by Nimit S.
Comment on MySQL DD corrupts UTF-8 data / MySQL 5 does not by External U.
Why are the MySQL drivers not shipped?
2609062 CF-3940288 Database : JDBC Troy Garrett Cannot find already verified datasource Problem Description: After connecting to a MySQL 5.6 Community Server database and creating a datasource in CF Admin, any page that tries to reference the datasource receives an error: Datasource "test" could
Unknown table variables in information_schema ColdFusion10 + MySQL 5.5 Enterprise
2608613 CF-4049903 Database Mohammad kheirbakhsh Database connection issue via CFIDE/admin & MAMP Pro Problem Description: Steps to Reproduce: start CF server via yosemite terminal on macbook Pro go to http://127.0.0.1/CFIDE/administrator/index.cfm under datasource click add datasource with MYSQL
Please integrate MariaDB driver in CF Administrator since MySQL 5 drivers were dropped in CF 11
2609408 CF-3849591 Database : General ext-user Issue while creating application-specific data source using lowercase alphabet only in format. Problem: Issue while creating application-specific data source using lowercase alphabet only in format. Method: see notes this.datasources = { "mysql5_DD
2609062 CF-3940288 Piyush K. Troy, I am using MySQL community 5.7.3-m13 (the supported version of MySQL) hosted on Win 7 x64 CF11 update 4 build 293328 hosted on OSX 10.10.2 JDBC driver : mysql-connector-java-5.1.32-bin.jar. I am able to query the DSN in a cfm page even after restarting CF. What
Bug 78969:When ColdFusion is running, and successfully makes one or more exchanges with a database ( MySQL in my setup ), and then that database server is restarted ( the MySQL service is restarted ), the first
Loads of SQL errors in ClientScopeCleanUpThread with MySQL
How to use Unicode for Chinese characters in ColdFusion and MySQL
MySQL 5.6 datetime rounding error
Comment on Why are the MySQL drivers not shipped? by Vamseekrishna N.
2673653 CF-4119834 External U. The attached report is full accessable but you can't see the query. RDS -> Coldfusion MySQL embedded ODBC driver. Server: Windows Server 2008 Client: Windows 7
2609062 CF-3940288 External U. Hi Piyush, The build number is 000094 JDBC Driver version 5.1.34 (from http://dev.mysql.com/downloads/connector/j/ ) It is very strange behaviour.
Comment on Connection String in MySQL Datasource sent to Database with trailing space by External U.
Comment on Connection String in MySQL Datasource sent to Database with trailing space by External U.
Comment on Connection String in MySQL Datasource sent to Database with trailing space by Nimit S.
Comment on Connection String in MySQL Datasource sent to Database with trailing space by External U.
Comment on Bug 80629:A date value returned from a MySQL query using the GREATEST() function, is seen by CF9 as a binary value by External U.
Comment on Loads of SQL errors in ClientScopeCleanUpThread with MySQL by Nimit S.
2611550 CF-3612846 Scheduler Kevyn Weiner CF10u11 requests improper SQL for Cluster Scheduling Problem Description: When attempting to configure a Cluster Setup for Scheduled Tasks, and utilizing a mySQL datasource, ColdFusion creates all upper case tables, but when requesting the tables uses mixed
Comment on CF18 MYSQL8 Windows Server 2019 by Charlie Arehart
Bug 79536:This error is caused when setting up a MySQL 4/5 Datasource, the same datasource works in the public beta but gives an error in the new version
Bug 85531:(Watson Migration Closure)cfdbinfo tag returns column_size of 10 for MySQL columns of datatype INT(8)
martyi3150533 Problem picking-up my datasource Any assistance would be appreciated ?? I connected my CF2018 to my mariaDB server: Actions Data Source Name Driver Status rhce MySQL OK But, I’m getting below output: SELECT sno, firstname, lastname, city, country, age FROM scientists Sno First
2673364 CF-4126692 Administrator A. Bakia After installation the Coldfusion Administrator worked at first, then gave error "The DataSource service is not available" Problem Description: I successfully installed Coldfusion Raijin on Windows 7, 32 Bit. I then opened the administrator and added MySQL
Coldfusion CFScript Query with MySQL Assignment Operator
2613538 CF-3285881 Language Eric Sontag cfexecute has a problem using redirect operator -p -D Actual Result: cmdoutput retyurns: mysql.exe Ver 14.3 Distrib 4.1.1-alpha, for Win95/Win98 (i32) Copyright (C) 2002 MySQL AB This software comes with ABSOLUTELY NO WARRANTY. This is free ... dummy
Connection String in MySQL Datasource sent to Database with trailing space
Bug 80629:A date value returned from a MySQL query using the GREATEST() function, is seen by CF9 as a binary value
Tracker Issue Bug 78418:Hi,
2600373 CF-3039097 ORM Support Sam Farmer Bug 78418:Hi, Problem: Hi, I am getting a DDL generation error with the code below. Connecting to a MySQL 5.1 community database on Mac OS 10.5.7. Thanks, Sam Method: App.cfc: Component Application { this.name = "trackrApp"; this
4056001 CF-4201446 Chad A. I found the problem. I was testing ColdFusion 2016 Standard on the same MySQL 5.7 database as the production server running ColdFusion 9 Enterprise. After making a copy of the production database and using the copied database for testing, the SQL statements are now
3185843 CF-4198855 Chris D. Is this issue actually fixed in HF5? I'm encountering a similar issue with CF2016 HF5 while using MySQL and Oracle datasources, see post at: https://forums.adobe.com/message/10044289#10044289
2673022 CF-4156096 External U. its vague, because they don't think its their baby. Maybe they should at least put out or endorse an end to end solution with the 2 major CF DBs MySQL and SQL Server. CF needs to document itself more as a solution to common problems.
2673653 CF-4119834 Poonam J. Crasen, Could you please provide more information to let us understand the scenario: 1) Which mysql version you are using? 2) The screenshot attached says RDS type as JDBC while in note you are mentioning the type as ODBC. 3)How you configured the data source
2609215 CF-3910529 External U. Have you tried with MySQL instead of Apache Derby? Have you tried using a real Application.cfc instead of some lines inside a file named Application.cfc? Have you tried using a service object instead of a function inline in the view file?
Comment on Connection String in MySQL Datasource sent to Database with trailing space by External U.
Comment on Connection String in MySQL Datasource sent to Database with trailing space by External U.
Comment on Connection String in MySQL Datasource sent to Database with trailing space by External U.
Comment on Connection String in MySQL Datasource sent to Database with trailing space by Asha K.
Comment on Connection String in MySQL Datasource sent to Database with trailing space by External U.
Comment on Connection String in MySQL Datasource sent to Database with trailing space by Nimit S.
Comment on Connection String in MySQL Datasource sent to Database with trailing space by External U.
Comment on Connection String in MySQL Datasource sent to Database with trailing space by External U.
Comment on Connection String in MySQL Datasource sent to Database with trailing space by External U.
Comment on Bug 80629:A date value returned from a MySQL query using the GREATEST() function, is seen by CF9 as a binary value by External U.
Comment on Bug 80629:A date value returned from a MySQL query using the GREATEST() function, is seen by CF9 as a binary value by External U.
5394853 CF-4204046 Nimit S. Hi Travis, I have tried it with Oracle12c, MySQL 5.6 and MS SQL Server 2016. It is working as expected. Create Table Snippet: {code:java} create table table_test1 (name_test varchar(20)) {code} CFML Code Snippet: {code:java} {code}   Can you try reproducing
Connection to local MySQL database with port 3307 doesn't work
2611830 CF-3587061 Caching Michael Henson Cannot clear query cache Problem Description: I cannot clear the query cache. Using does not work and neither does clearing the query cache from the CF administrator. Steps to Reproduce: I run a query on my MySQL database and use the attribute
.datasources.mydatasource={ class:'org.gjt.mm.mysql.Driver' ,connectionString:'jdbc:mysql://localhost:3306/demo_db?characterEncoding=UTF-8&useUnicode=true' ,username:'demouser' ,password:"encrypted:5943217a74b3d570f7ed78738da72bb4972228f46c8f9b7e96f5e995d66d1e9a" }; } ----------------------------- Additional Watson Details
Setup section, "Datasource" should be "Data source" as that's how it's spelled throughout the rest of the CF Administrator. 2. "Currently supported databases for cluster setup are MYSQL, SQLSERVER and ORACLE" should be "Currently supported databases for cluster setup are MySQL, Microsoft SQL Server
CMS. It needs a database for it. I'd be nice if I could have something in the preinstall like $simpleCMS MySQL Derby This would allow the person installing to setup a datasource during the install process and either set it up as a MySQL or derby DB
2673542 CF-4126428 General Server Philipp Cielen [cielen] OS X Preference pane for starting/stopping CF server There is an OS X preference pane for MySQL and Tomcat and it would be nice to have one for ColdFusion too so one can conveniently start/stop the server from there
to a certain number of records. MySQL doesn't exhibit the same behavior. My workaround has been to create the indexes manually and set index=false on all persistent properties. Closing the is probably the right call on your end, as the bug should be submitted to the driver development team.
2611830 CF-3587061 Adobe D. Used CF10 update 11 with mysql datasource and run the below code in Chrome(Windows 7): select firstname from t1 select firstname from t1 It has dumped the cached value in the first select query and the changed value in second select query. Can you please let
Portal Topic Linked Folder
called Learn Cold Fusion in a Week and struggled through it having to adapt Cold Fusion 10 to Cold Fusiln 2018 and MySql to Sql Server. I […] The post Linked Folder appeared first on ColdFusion. CF2018 Updates,ColdFusion 2018,Question,2018,cf2018 updates,coldfusion 2018,question
Legorol San Charlie, when we had this issue, our problem was that the connection timeout set for the datasource in the CF admin was simply ignored by the CF server. The timeout set on the db server was not relevant. (For full clarity, we were using MySQL and not Oracle). One experiment we did
: "_" (95), after : "" The error occurred in D:/websites/www.scribble.local/junk/junk.cfm: line 6 4 : 5 : 6 : 7 : SELECT id AS _id 8 : FROM rainbow Confirmed on CF9 & 10. Fine on Railo. Fine in T/SQL and MySQL dialects of SQL. -- Adam ----------------------------- Additional Watson Details
: "Currently supported databases for cluster setup are MYSQL, SQLSERVER and ORACLE " However, the actual dropdown lists all datasources regardless of db type. For consistency, the dropdown should filter out any datasources that are associated with non supported databases. Steps to Reproduce: Actual Result
2682599 CFB-3848642 Extensions Wrong code generated when code is generated using "Adobe CFC Generator" for DB tables Problem: Wrong code generated when code is generated using "Adobe CFC Generator" for MySQL DB tables Method: 1> Create a project and database 2> Go to RDS Dataview 3> Right
Release User User Name:Steve Walker Note Added: Entered Bug. I ran across this when attempting to add the MySQL connector. Windows 10, Build 11082 Date Added :2015-12-28 14:06:41.0