ColdFusion

The "no ColdFusion update without issues"-streak continues ... It's year 10 now, I guess. Ok, so I logged into CFIDE/adminstrator and hit the "Download" button below the Core Server Update 2 Logs say:Sep 22, 2021 12:05:49 PM Information [http-nio-8500-exec-5] - Starting HTTP request {URL='https://www.adobe.com/go/coldfusion-updates', method='get'} Sep 22, 2021 12:05:49 PM Information [http-nio-8500-exec-7] - Starting HTTP request {URL='https://www.adobe.com/go/coldfusion-updates', method='get'} Sep 22, 2021 12:05:49 PM Information [http-nio-8500-exec-7] - HTTP request completed {Status Code=200 ,Time taken=363 ms} Sep 22, 2021 12:05:49 PM Information [http-nio-8500-exec-5] - HTTP request completed {Status Code=200 ,Time taken=414 ms} ... but the progress bar just shows "Starting Download..." and is stuck. Manually installing the update worked, but lost some packages on the way (adminapi, administrator, ...) AND although the system information page (top right, "i")

My first post! 🙂 I am currently doing a search of a list of data elements (like 15) from a specific table.  The goal is to see if they are being UPDATEd or INSERTed in any of the existing ColdFusion sources we have.  The site is HUGE and I am using DREAMWEAVER's FIND & REPLACE search too to look into from the root folder down, then I check the "matched text" results and in doubt, I open the source to double check if the field is in an UPDATE or INSERT statement. So, I was wondering if there is a way to build a TABLE-WHERE-USED or FIELD-WHERE-USED approach that can be used as a reference, in order to speed up database analysis like this.  Any suggestions are welcomed.Thank you!

I have updated an installation of CF2018 from U4 to U8, and then to U12.  I did upgrade the web connectors after upgrading to U8, and then upgraded to U12.  All of these steps completed with no errors, and my site is now up, and I am able to use CFAdmin.  I also confirmed that the secret introduced in U8 matchs in server.xml and workers.properties. In CFAdmin, when I check the Information page, to verify the current version, I see that CF is at U8 (2018.0.08.328566), and not U12.  If I go Server Updates, no updates are available.  If I check the CF Updates folder, I see that there is information for the U12 update.  As part of this update, I also updated to Java 11.0.12 (I will update to 11.0.13 at a later date). At this point, I need some guidance.  Do I manually uninstall U12, even though CFAdmin thinks that I am at U8?  Or, do I manually re-install U12 without uninstalling it first?  Or, is there a different way to on how to add

HelloEach person in this DB has their unique ID (ged_ID), and a spouse ID (ged_spouse_ID).Also ged_lastname, ged_firstnameI'm having trouble with the SQL query structure to output:Person First, Last, - Spouse First, Last names on a single row.Would this be set up as a single query, qoqs, or SQL Joins "WHERE IN" etc.?Sorry if this is staring me in face- probably is...Norman B.

We have an application that uses CFLDAP, port 636 to authenticate user to Active Directory. We are getting the following error: An error has occurred while trying to execute query :xxx.yyy.zzzz:636.The server is running CF2021 Enterprise, on a Windows 2016 serverI can get it to work randomly rebooting the server or starting/stopping the CF Application service. It might start working on the second, third, fourth reboot, etc. Once it is working it is fine until monthly patch reboots and the failure process starts all over again. We do have a CF2018 server also on Windows 2016 server and do not have the issue.Here is what I have tried, all with no long-term luck in fixing the issue:Reinstalled Windows and a fresh copy of CF2021Tried different OpenJDK versions (all ver 11.x)Tried importing our domain and server certs into the cacert in the JRE folderTried a completely different CF2021 server – same issueThe error output is not very helpful.No entries in Windows, Apache or CF logs when the

This popped up with CF8.  I am using Ben's ImageDrawTextArea, which I have been using on CF8, CF9 and Railo.  Now that I ponied up for my nice new CF10 server, this code no longer works.  I have tried everything from copying the fonts into the JRE/Fonts directory to trying to use plain ole Arial.When I run the code I throw the following error:Unable to find font: Serif.Any thoughts or solutions to try?Thanks!- Robert

Coludfusion version: 2018Goal is to manipulate images when given x and y coordinates from clients for adding text(s) and e-sign or thumbnail images onto parent image without comprimising the resolution (pixels) and dimenssions of the image. I tried all different image functions available with no much luck.Looking to find solution either by using third party tool, upgrading coldfusion version or purchasing add ons to coldfusion engine. Does any one has any suggustions?

 Hello, while running below command - getting error - “java.lang.NullPointerException” Please see attachment of screenshot queryExecute ("SELECT * FROM test WHERE id = :id", { id=1, cfsqltype="cf_sql_integer" },{ datasource="creditapp" });

Today we've been seeing a lot of long load times that eventually error out any place we're using the storeSetACL() function for S3 files.  The error is "Error in STORE Operation". This code has worked for years so I'm assuming this may be an AWS thing?  Anyone else having issues? For instance, after saving a file to S3 we do something like:<cfset storeSetACL("s3://#awsCreds#ourBucket/#dirpath#",S3permObj)> 

I am trying to create reports in Stripe but their examples are PHP. I've had success with all their other functions I'm just stuck on reports. The PHP example is:  POST /v1/reporting/report_runs // Note that a live-mode API key is required. \Stripe\Reporting\ReportRun::create([ 'report_type' => 'balance_change_from_activity.itemized.3', 'parameters' => [ 'interval_start' => '1577865600', 'interval_end' => '1580544000', 'timezone' => 'America/Los_Angeles', ], ]); My code looks like: <!--- Data related to call ---> <cfset stripe_api_key = 'sk_live_XXXXXX' /> <cfset stripe_api_url = 'https://api.stripe.com/v1/' /> <cfset report_type = 'payout_reconciliation.summary.1' /> <cfset Interval_Start = #DateDiff("s", DateConvert("utc2Local", "January 1 1970 00:00"), Start)# /> <cfset Interval_End = #DateDiff("s", DateConvert("utc2Local", "January 1 1970 00:00"), End)# /> <cfset timezone = 'Ameri

Probably a stupid question, but I can't open cfm files properly. For example, the text of the file: "<cfinclude template="header.cfm"><p>Welcome to my website on ColdFusion cfinclude usage!</p><cfinclude template="footer.cfm">" outputs:"<cfinclude template="header.cfm"><p>Welcome to my website on ColdFusion cfinclude usage!</p><cfinclude template="footer.cfm">"instead of"This is the headerWelcome to my website on ColdFusion cfinclude usage!This is the footer"Tried to open in different browsers, ColdFusion installed. What could be the problem?

Hi All, Currently my CF application running on windows server , Cf version 2021 and database Oracle11g. Now my application moving from Azure servers with same coldfusion 2021 and Oracle 19c. Do I need to change the coldfusion configuration setting or any changes in Cf administrator ?Please help me what are the necessary changes are required to do in coldfusion side while moving from WINDOWS server to AZURE servers Thanks..  

I am updating ColdFusion 9 to 9.0.1, I followed all the steps mentioned in https://helpx.adobe.com/coldfusion/kb/cumulative-hotfix-4-coldfusion-901.html. Then followed instructions on https://helpx.adobe.com/coldfusion/kb/change-coldfusion-jvm.html. Copied MSVCR100.dll from C:\program files\java\jdk1.7.0_21\jre\bin\ folder to CF9\runtime\bin. Changed the config.jvm to Java.home=C:/Program Files/Java/jdk1.7.0_80/. It worked correctly but still my ColdFusion server is displaying the JVM Version 1.6.0_14. Secondly,  Still the administrator version is 9,0,0,251028. On running jRun I found out this Ignoring invalid file in updates directory: chf9010004.jar 

I'm attempting to use the native driver for my datasource on AZURE.  When verifing, I get[Macromedia][SQLServer JDBC Driver][Macromedia][SQLServer JDBC Driver]Attempted connection to the secondary server <HOST>:11000 failed.When I use the JDBC driver from microsoft, I do not have this issue.Any suggestions on how to configure the native driver to resolve this error?  I've tried matching the JDBC connection string in the additional settings, but still get this error with the native driver. Thanks! 

I was sent a patch to solve a particular problem, which I installed.  Then I was sent another patch and told to uninstall the first one and install this one instead.  How do I uninstall the first patch?  I see no uninstaller.jar in the hf-updates directory for the first patch I installed. Thanks.  -bg

hello,I am trrying to setup SSO with a ColdFusion 2021 application and Azure SSO - does anyone know of a guide?I am running into the problem where is seems I get stuck in a loop on the Idp side (azure)I think the problem is where I am  using the certificates. 1) do I have to figure out how to extract the public key from the cf keystore and where exactly do I need to past the cert obtained from the Idpin the sign or encrypt section of the idp configuration on the cfd side this is the errorError Message: The Message of the Response is not signed and the SP requires it

Auto Lockdown adds a few RedirectMatch rules to prevent accessing certain parts of your install when securing an Apache install. A few of the regex's used in these rules are too generic. For instance:RedirectMatch 404 (?i).*.svn.* RedirectMatch 404 (?i).*.git.*The unescaped period and lack of a leading directory separator makes these rules too generic. In particular, the .git expression matches a common words like digit or digital. These were added with the 2021 lockdown tool I downloaded on October 11th and I'm not sure how long they've been added. 

 I am using ColdFusion 9 Enterprise edition and using CFHTTP to send data to consume an API for SMS services, but I am getting the following Error I/O Exception: peer not authenticated. My Code <cfhttp url='https://sms.itpark.pk/api/sendsms' method='POST' multipart='yes' result='res'> <cfhttpparam type="header" name="username" value="03xxxxxxxx" > <cfhttpparam type="header" name="mask" value="ITPARK" > <cfhttpparam type="header" name="password" value="00xxxxxxx" > <cfhttpparam type="header" name="to" value="92300xxxxxxx" > <cfhttpparam type="header" name="from" value="92300xxxxxxx" > <cfhttpparam type="header" name="message" value="Some Message" > </cfhttp>What I Tried:I've Googled and searched and tested all possible solutions. Even Installed the Certificate of the service provider, tried changing the JVM but ColdFusion 9 won't start. Tried to follow the instructions on adobe

Coldfusion 2018, Linux serverThis is on our development site but was working until last week. We've googled and see this is not uncommon and tried the suggested solutions such as creating a mapping, which seems the most popular, and a few others but nothing seems to fix the issue.The development machine is shared so each developer is mapping their CFCs to their own unique location and each application has a unique name even on the same server, a hash is involved.  When we create the Create the object<cfobject component="/#APPLICATION.cfcroot#.Security" name="sec"> It seems to find the Security CFC because the error is on the "extends" attribute which is set to a CFC called Authenticate.<cfcomponent extends="Authenticate" accessors="true" output="false" persistent="false"> It can't find the Authenticate CFC which is in the same directory and throws the error, "Could not find the ColdFusion component or interface var.www.html.mark.financeonline.account_ser

I'm trying to report this so the online docs get corrected:On the page:https://helpx.adobe.com/coldfusion/cfml-reference/coldfusion-tags/tags-r-s/cfschedule.html#There is an error: The misfire attribute used to accept "fire_now", but after CF2018 it's "firenow"This page is still telling users to use fire_now, which will result in an error.

Hi Coldfusion communioty. i am trying to write mobile app that uses camera. I have taken CFML code from Adobe website :https://helpx.adobe.com/coldfusion/cfml-reference/coldfusion-mobile-functions/camera-functions/cfclient-camera-getpicture.htmland trying to run it using emulator as well as web browser but facing javascript errors:"Your client-side CFML code has encountered an initialization error. The required plugins cannot be loaded successfully within the timeout period"I have coldfusion 2021 Standard edition installed on my local machine.Someone please help me running the code given on above mentioned URL. Whats going wrong, not sure. Your client-side CFML code has encountered an initialization error. The required plugins cannot be loaded successfully within the timeout period.  

Hi,Would like to know is it possible to have multiple sort in array of structuresIn other words,is there any equivalent function for multi_sort like in php?For example,in the below product color information,want primary sort using product style column and secondary sort using its color. ie,if same product has different color,sort again using color as below.AA6040~~redKP155~~LimeKP155~~OrangeTried using arraySort as below,but seems it can be used to sort using single key.<cfscript>local.ary_styleInfo = arrayNew(1);authors = structnew();authors= {style = 'KP155',color = 'orange'};//writeDump(authors);arrayAppend(local.ary_styleInfo ,authors);authors = structnew();authors= {style = 'KP155',color = 'Lime'};//writeDump(authors);arrayAppend(local.ary_styleInfo ,authors);//2authors = structnew();authors= {style = 'AA6040',color = 'red'};//writeDump(authors);arrayAppend(local.ary_styleInfo ,authors);writeDump( local.ary_styleInfo );//sortarraySort(local.ary_styleInfo, function (e1, e2){r

I just upgraded a server from ACF 2016 to ACF 2018 and I started receiving a strange java.lang.ArrayIndexOutOfBoundsException error message on some Query of Query (QofQ) statements.  What's strange is that the exception only occurs when I have SELECT * in the statement.  When I actually specify the columns by name, the exception goes away. Unfortunately I can't replace the issue on www.trycf.com because I need an actual database query to start from. Here's a simplified example of a query that throws the exception:   <cfquery dbtype="query" name="tempInvoices"> SELECT * FROM invoices </cfquery>   Replacing it with the column names (or this), fixes the issue:   <cfquery dbtype="query" name="tempInvoices"> SELECT #invoices.columnList# <!--- I can also list out the columns and it works ---> FROM invoices </cfquery>  The exception looks like this:Has anyone else encounter

Existe-t-il une option pour que la fonction supprime les accentués  (exemple : Ê pour E) ?Merci par avanceIs there an option for the function to remove accentuates (example: Ê for E)?Thanks in advance

Recently our team decided to implement a secure session management. It is very similar to the guidelines mentioned in the article.Session Management Guide CFML Documentation (cfdocs.org) However, the hash stored in the cookie is not immediately updated. ie when CF reads from the cookie to verify it, it still holds the old value and logs the user out. It doesn't happen often but randomly. Especially when we there's multiple user actions in quick succession. Has any one implemented a solution similar to this? The code has been made thread safe by encapsulating in cflock block. Please advice.