ColdFusion

We are stumped ... we've been creating a CF web site for years.  It works fine on all our coders localhosts and it works fine on a commercial CF hosting server.   We just copied all the code into a rack WE own and it simply will not work.   The errors we're getting are db errors.  Table xxx does not exist yet we can see it on our RDP screen.   We've triple checked our settings in our CF Admin console ...  In 28 year of using CF we've never encountered this.  We have cleared our cache ... rebooted our CF server and db server and it still insists it cannot find a table or a field within a table.  We're using an old version CF 2018.  On locals and at our commercial CF hosts.   What (more) clues can I provide to help us fix this.  We're about to throw the rack in the bin.  Many thanks in advance.  

Let me preface this by saying I run ColdFusion 2021 & 2023 as standalone servers, and I do install patches once released.  I have an established process for acquiring and installing updates manually, which I have no intention of changing.  My question is how do I stop ColdFusion 2021/2023 from trying to connect to the Update Site automatically whenever I go to CF Admin> Package Manager?  When I try to open the Package Manager section within CF Admin, the server tries to reach out multiple times to the update site first.  Each attempt takes about a minute to timeout, so it takes 3-5 minutes to actually load the page.  This is not an exaggeration. Yes, I have "Automatically Check for Updates" unchecked.  And "Check for updates every" unchecked.  Doesn't make any difference.  I've tried blanking out and saving the Default URL for udpates in CF Admin.  When I save, it just restores the default value.  I've also tr

I have downloaded the latest version of the auto-lockdown tool from the adobe website and have the latest CF update/hotfix (13) installed. I have tried running the auto-lockdown tool (for Windows/IIS) several times , following the lockdown guide to the letter. I was able to install this on another server with no issue. I have tried the following multiple times: 1. running tool, uninstalling tool , running tool again2. running tool, uninstalling tool, uninstalling CF, uninstalling IIS, deleting the user created by the tool, clearing partitions, restarting server, reinstalling CF, running tool  Everytime I run the tool, it finishes, but says there are errors. In the installation log, the only thing that looks odd is after it tries to remove the new CF user from all groups - it says "Failed to create the user!", but doesn't specify what user it's trying to create (The new CF User account was already created earlier in the process, so maybe it's an IIS User?): 2025-04-1

Hello, We are using ColdFusion 2023 Standard edition. We have an application which contains a CFCHART that worked when CF 2023 was on Update 6. However, now that we have updated to Update 7, the CFCHART no-longer works and is instead showing a red X. The CFCHART is within a CFSAVECONTENT which is then CFOUTPUTed into a CFDOCUMENT so that a PDF can be created. If I remove the CFSAVECONTENT, the CFCHART does display correctly. The CFCHART is in JPG format, but changing the format does not cause the CFCHART to display, only removing the CFSAVECONTENT. However, I do not want to remove the CFSAVECONTENT because I want the overall PDF format. Please let me know what additional information I can provide to help you help me. Thank you very much for your time, expertise, and help.

Is there any chance this will be updated in the future? I am getting a lot of heat from the security people because the scans keep coming back with log4j vulns.The analytics service is using an old version of elasticsearch that requires log4j-1.2.17.jarDoes anyone know of anyway to not usre the analytics service and still run the API manager or know of any work arounds to use a new elastic search? I know we can remove the jndi classes and put some flags on the JVM but the security folks see the file and thats all they care about.This is the case for both coldfusion 2021 api manager and coldfusion 2023 api managerExample directoryC:\ColdFusion2023APIManager\database\analytics\lib

What are the benefits of migrating from Adobe ColdFusion to Lucee? I hear the migration itself is fairly smooth. Are there other benefits like more hosting availability, cheaper hosting, etc? What are people's experiences and what prompted you to do it? 

Hi All,  After updating my Coldufsion 2021 server to the latest release (18 went from 2021,0,0,323925 to 2021,0,18,330341) to mitigate vulnerabilities CFR reports stopped working and I'm getting the following errors: coldfusion.runtime.report.Report$ReportCompilationException: Report compilation error.at coldfusion.runtime.report.Report.compileXml(Report.java:840)at coldfusion.runtime.report.Report._compileReport(Report.java:281)at coldfusion.runtime.report.Report.compileReport(Report.java:176)at coldfusion.runtime.report.Report.runReport(Report.java:425)at coldfusion.tagext.report.ReportTag.doEndTag(ReportTag.java:626)at cfrpt_insumos_pdf2ecfm955247095.runPage(/app/residente/rpt_insumos_pdf.cfm:14)at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:257)at coldfusion.tagext.lang.IncludeTag.handlePageInvoke(IncludeTag.java:749)at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:578)at coldfusion.filter.CfincludeFilter.invoke(CfincludeFilter.java:65

Hello,I am currently working on an S3 integration using ColdFusion, and I'm facing an issue when trying to retrieve all the files from an S3 bucket. I am using the listAll() method, but it seems that it only returns a maximum of 1000 files, and I need to handle cases where there are more than 1000 files in the bucket.I understand that Amazon S3 uses pagination for listing objects, and I need to handle the NextContinuationToken to paginate through the results, but I'm unsure how to implement this correctly in ColdFusion.Has anyone experienced this issue or can offer advice on how to paginate through the list of objects in S3 using ColdFusion to retrieve more than 1000 files?Here is the code I'm currently using:<cfset allObjects = bucket.listAll()>Can someone please guide me on how to modify this to handle pagination when there are more than 1000 objects in the bucket?Thanks in advance!

I have tried 5 different locations and they all redirect to the 2018 download page. I have been going from here https://www.adobe.com/support/coldfusion/downloads.html#cf2021productdownloads and it still takes you to the 2018 download.  I was told by Adobe support to post on the forums as they couldn't provide me with a proper link even though marketing emails and your own site are saying it is available for download.

I use CF 2021 release for a long time. After installing the Update 11, when the coldfusion-out.log reaches a certain size, it's archieved as coldfusion-out.1.log but writing logs to default file stops.  All services running properly, all other logs works just fine but out log stops writing untill restarting coldfusion.  As far as I know, I've tested removing cflogging.jar, changing logging directory etc. It's working on Ubuntu 23.04 (GNU/Linux 6.2.0-36-generic x86_64) Anyone facing the same issue or having a solution for that problem?Any help would be appreciated..

I started evaluating CF2025 a couple weeks ago. I set it up to function through IISThe CF app we developed works as expected under HTTP, so we decided to get a SSL cert to make the server "legit" - after installing the SSL cert, CFCHART stopped appearing on the CFM page. Other basic CF content still appears (ie cfoutput), but not CFCHARTWeb searches seem to indicate that this has been an issue since 2006 -- yet still exists today. Suggestions from back then don't work today however, since {a} the setup for IIS is not the same as it used to be back then, and {b} some of the files they reference back then no longer exist either.  Who has the magic fix for this latest version of the long standing bug?

Is Adobe going to continue supporting ColdFusion? I have a potential investor/collaborator who is concerned that we may end up having to rebuild the site in DotNet or something because without Adobe's continued support of the product, security of ColdFusion websites would ultimately suffer. He's read somewhere that Adobe won't continue to support ColdFusion. He might have been reading about ColdFusion Builder. I don't know. What is the latest?

I have a CF page "MemberExpress" like below<cfFORM ACTION="MemberExpressRegActionPage.cfm" method="post">..................<dd><B>My Email:</b><cfINPUT TYPE="text" size="30" name="Email" message="Please enter your email address." required="yes" >...............</cfform> In the page MemberExpressRegActionPage.cfm, I have this like below <CFQUERY NAME="AddAppMemTable" DATASOURCE="MEM">INSERT INTO Members(HandleName, Age, BirthYear, State, CCountry, Email)VALUES('#Form.HandleName#', '#Form.Age#', '#Form.BirthYear#', '#Form.State#', '#Form.CCountry#', '#Form.Email#')</CFQUERY> The page cannot be posted sucessfully with error "An error occurred while executing the application. Please try again or contact the administrator." The issue is I cannot insert '#Form.Email#' value into the database If I remove '#Form.Email#' in page MemberExpressRegActionPage.cfm , I can insert sucesffully without issue. Bu

Since my latest VS Code update I am getting this error in the output console: [Error - 10:08:39 PM] Request textDocument/documentHighlight failed.  Message: Internal error.  Code: -32603 java.util.concurrent.CompletionException: java.lang.NullPointerException  at java.base/java.util.concurrent.CompletableFuture.encodeThrowable(CompletableFuture.java:314)  at java.base/java.util.concurrent.CompletableFuture.completeThrowable(CompletableFuture.java:319)  at java.base/java.util.concurrent.CompletableFuture$AsyncSupply.run(CompletableFuture.java:1702)  at java.base/java.util.concurrent.CompletableFuture$AsyncSupply.exec(CompletableFuture.java:1692)  at java.base/java.util.concurrent.ForkJoinTask.doExec(ForkJoinTask.java:290)  at java.base/java.util.concurrent.ForkJoinPool$WorkQueue.topLevelExec(ForkJoinPool.java:1020)  at java.base/java.util.concurrent.ForkJoinPool.scan(ForkJoinPool.java:1656)  at java.base/java.util.concurrent.ForkJoi

I'm trying to generate a map of tradespeople nearby to the site visitor. I've figured out most of it and am stuck on the final part mainly due to my weakness when it comes to arrays, structures etc. Apparently, the api needs  an array that looks like:  var locations = [ ['Bondi Beach', -33.890542, 151.274856, 4], ['Coogee Beach', -33.923036, 151.259052, 5], ['Cronulla Beach', -34.028249, 151.157507, 3], ['Manly Beach', -33.80010128657071, 151.28747820854187, 2], ['Maroubra Beach', -33.950198, 151.259302, 1] ]; I'm adapting this for my application, i.e. not Australian beaches but company names. function getNearbyTradies(oArg){ var lat = oArg.lat || ""; var lng = oArg.lng || ""; var tradies = []; $.getJSON("cfcs/user.cfc?method=getNearbyUsers&returnformat=json&queryformat=column",{"lat":lat,"lng":lng},function(res,code){ if(res.ROWCOUNT > 0){ for (var i = 0; i<res.ROWCOUNT; i++) {

Would greatly appreciate if someone could comment on this snippet from the external session storage doc:Once a session object is received from Redis, there can be changes to the object within the timespan of a given request. The session is persisted (if modified) back to external storage on request end. The changes made by the current request on one node are available to all other nodes.https://helpx.adobe.com/coldfusion/using/external-session-storage.htmlAs part of my organization's move to a cluster of cf server instances, we're also moving to storing sessions in a redis cache. Some places in the app make remote invocations via fetch request to first modify the session in some way, then before that request has finished, re-fetch some data which may or may not use the newly modified state. This was fine while we were storing session in memory, but we're finding that the modified state is getting overwritten by the second request (perhaps because that second request pulls from the cach

I've run into a bit of a strange issue. I installed CF 2023 and had everything up and running without issue including the Solr server. I left for the day, and upon logging back in this morning, the ColdFusion Collections page was giving a generic 404 error page and is now just not loading anything (i.e. blank page). Again, everything worked when I signed out yesterday. The Solr server is still functioning correctly, I can navigate to ...:8995/solr/ and the Solr admin page is fully functional, and I can see all the collections I created yesterday. I'm assuming this is just an issue with the CF admin GUI, but nothing was changed, so I'm not sure why it would suddenly start failing to load a specific page. Checking the logs, the corresponding errors appear to be:Error [http-nio-8500-exec-8] - org/apache/zookeeper/KeeperException$NoNodeException The specific sequence of files included or processed is: {cfrootpath}\wwwroot\CFIDE\administrator\solr\index.cfm, line: 346and:Apr 02, 2

I ran ./cf-init-run.sh install which created /etc/systemd/system/cf2023.service and created the symlink to run it but it doesn't work cf2023.service has the following which doesn't seem right (sysinit doesn't exist) [Unit]Description=Adobe ColdFusion 2023After=multi-user.target[Service]ExecStart=/appl/ColdFusion2023/cfusion/bin/../bin/sysinit startExecStop=/appl/ColdFusion2023/cfusion/bin/../bin/sysinit stopRemainAfterExit=yes[Install]WantedBy=multi-user.target I tried changing "sysinit" to "coldfusion" but that didn't work either Has anyone gotten this to work? Or is there a diffferent way I should get ColdFusion to start on reboot?Thanks!

In the MemberUpdateForm.cfm, I have the following......<cfFORM ACTION="MemberUpdateActionPage.cfm" METHOD="Post">...........<table border="1" height="350">.........<P><INPUT TYPE="text" Name="MembersID" size="15" maxlength="50" required="yes"       VALUE="<CFOUTPUT QUERY="MemberRecord">#MembersID#</CFOUTPUT>"></P><P><b>My handle name is</b><INPUT TYPE="Text" Name="HandleName" size="15" maxlength="50" required="yes" disabled="disabled"       VALUE="<CFOUTPUT QUERY="MemberRecord">#HandleName#</CFOUTPUT>">   </P><P><INPUT TYPE="submit" NAME="SUBMIT" VALUE="Submit Data">     <INPUT TYPE="reset" NAME="Clear" VALUE="Clear Form"></P><br></center></cfform> In the MemberUpdateActionPage.cfm page, I have the following...........<CFQUERY NAME="MemberRecordUpdate" DATASOURCE="Contact">UPDATE Me

I'm attempting to run the ColdFusion_2023_GUI_WWEJ_win64.exe Windows installer on a 2019 server that currently has ColdFusion 2018 installed.  The plan is to upgrade to CF 2023. Everytime that I run the installer, it ultimately fails with an error.  It unpacks 100% of the contents of the installer to the user profile temp folder and begins to launch the install wizard.The green status bar gets about 70 - 80% and then it throws a fatal error:These are the error details:java.lang.ClassCastException: class java.lang.String cannot be cast to class java.lang.Integer (java.lang.String and java.lang.Integer are in module java.base of loader 'bootstrap')at com.zerog.ia.installer.LifeCycleManager.getEnable8dot3(Unknown Source)at com.zerog.ia.installer.LifeCycleManager.a6(Unknown Source)at com.zerog.ia.installer.LifeCycleManager.executeApplication(Unknown Source)at com.zerog.ia.installer.Main.main(Unknown Source)at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invok

var keySpec = createObject("java", "javax.crypto.spec.PBEKeySpec").init(arguments.password.toCharArray(), salt, 128, 80); results in error:java.lang.reflect.InaccessibleObjectException: Unable to make public boolean com.sun.crypto.provider.PBKDF2KeyImpl.equals(java.lang.Object) accessible: module java.base does not "opens com.sun.crypto.provider" to unnamed module @db99785 this code works on previous versions of CF/Java. Is there something I should add to the JVM arguments?

Ever since we upgraded from ColdFusion 2021 to ColdFusion 2023 we have been dealing with out of memory issues. ColdFusion will run fine for roughly 24-30 hours, then we will start seeing CPU spikes to 100% every 30 seconds. Garbage collection can't free up enough memory so ColdFusion eventually crashes and we have to restart the server. Things we have tried that don't seem to help: - Downgrading to 17.0.11- Tweaking the min and max heap sizes- Tweaking the caching settings- Changing the garbage collector algorithm to G1GC- Tweaking our websites to cache queries for a shorter period of time (1 hour down to 15 minutes down to 5 minutes) Here are our current settings: Min Heap: 8192Max Heap: 8192Garbage Collector: UseParallelGCCached Templates: 1000Cached Queries: 5000 We do have Fusion Reactor installed on all of our servers but this is like trying to find a needle in a haystack. I really don't know what I should be looking at. Here is a most recent screensh

We have a working CFHTTP call in our production code on a CF2021 server which works just dandy. It calls an outside party to get a token and follow up with more specific requests using get & put. As part of our enterprise migration process we have cloned the same code to our newly installed CF2023 instance on our twin sister dev server, where many of the same calls have now failed. We're pretty sure it's not any SSL or CERT issue, because the one initial call to get the token still works. The subsequent calls fail with:<html><head> <meta http-equiv="content-type" content="text/html;charset=utf-8"> <title>400 Bad Request</title> </head> <body text=#000000 bgcolor=#ffffff> <h1>Error: Bad Request</h1> <h2>Your client has issued a malformed or illegal request.</h2> <h2></h2> </body></html> This sure looks like the API's response, not a network issue. I had started down the typical d

Hi,using cfoauth at amazon to access selling portal api.If I hard code my clientid, secretKey etc everything works great I get the access_token.  I have a query in the cfc component that gets these but if I use them in the <cfoauth tag the process fails - "invalid_client".  I tried this <cfset x = "typed my client id here" />then in cfoauth    clientid = "#x#"  and this worked also. I tried adding toString() to the query result of clientid, that did not help. Wondering if anyone else has had problems with using query results inside cfoauth? 

I'm thinking about hosting a CF site at Hostek, starting with shared hosting and maybe moving up to a dedicated setup later. I just want to test the site initially. Just wondering if anyone can share their experience with Hostek. As I understand it, shared hosting doesn't give you access to the CFAdministrator. Initially I just want to upload and start testing.