Questions

Hi,I always preface with I am not a programmer.  🙂I just moved my server.  The new server is Windows 2019 with CF 2021.On the new and old server CF was installed on the E drive.On the old site, I accessed the CF Administrator on the web through https://My.Site.org/CFIDE/administrator/index.cfm.  That doesn't work with the new server.I can access it while directly on the server at http://127.0.0.1:8500/CFIDE/administrator/index.cfmThe old server was in place for a long time, I tried searching and cannot find out how I was able to access the old server through my PCs browser while not directly on the server.Suggestions? Thank you!

I'm getting errors using some of the sample code (after adjusting for typos): https://helpx.adobe.com/coldfusion/using/integrate-coldfusion-amazon-sns.html <cfscript>//'archinet_aws_user_1' and 'snsConf' are aliases configured in the CFAdmin panel// define the credential and the configuration aliases in the ColdFusion Adminsns=getCloudService("archinet_aws_user_1","snsConf");// code below.</cfscript> Throws this error:"The httpClient and the httpClientBuilder can't both be configured." Any one else encounter this?

Hello, Just a query on 2 differing ways of calling a function from a component in Coldfusion. I've always called functions in one of 2 ways.  Method 1:  <cfset myComponent = createObject("component", "pathToMyComponent.componentGet")> <cfset myVariable= myComponent.getKey ( data = someDSN, key = myKey, ........)>​ Method 2:  <cfinvoke component="pathToMyComponent.componentGet" method="getKey " returnvariable="myVariable"> <cfinvokeargument name="data" value="#someDSN#"> <cfinvokeargument name="key" value="#myKey#"> ....... </cfinvoke>  My question would be is there any overhead using Method 1 over Method 2. I assume there must be

There appears to be a significant bug in Adobe's ColdFusion Documentation on getting variables with period references.Under the "getting a variable" heading it shows the following sample code: <cfoutput>myVar.a.b is: #Variables["myVar.a.b"]#</cfoutput> However, you can't reference a struct key like that in any version of ACF.  Here's a snippet that will throw an error every time you try to execute it (change the server to try different versions).Here's the code: <cfscript> variables.myVar.a.b = "apple"; writeDump( variables[ "myVar.a.b" ] ); </cfscript> Oddly enough, I feel like CFML should work as the documentation describes.  It is too bad that it does not. 

Hello CFers,I installed the ColdFusion 2016 Update 17 (from Update 16) which came out this week and unfortunately all of my Coldbox sites are getting 500 errors when trying to load them.  The line that is causing the error is as follows:`variables.thisRoute.handler = arguments.handler ?: "";`The error that is being generated in the logs is:"Error","ajp-nio-127.0.0.1-8016-exec-12","03/23/21","22:31:22","6A70E1E9B0E6E14EC4590A014F4D5C13","coldfusion.runtime.CFPage._isDefinedElvis(Ljava/lang/String;)Ljava/lang/Object; The specific sequence of files included or processed is: C:\websites\mysite.com\wwwroot\index.cfm, line: 1217 "java.lang.NoSuchMethodError: coldfusion.runtime.CFPage._isDefinedElvis(Ljava/lang/String;)Ljava/lang/Object;at cfRouter2ecfc1597072887$func_CF_ANONYMOUSCLOSURE_ELVIS1155.runFunction(C:\websites\mysite.com\wwwroot\coldbox\system\web\routing\Router.cfc:1217)at coldfusion.runtime.Closure.invoke(Closure.java:109)at coldfusion.runtime.UDFMethod$ArgumentCollectionFil

Does anyone know the correct syntax/ settings to create an Oracle datasource in ColdFusion 2021? I just did an upgrade and when it imported Oracle datasources, it claims the "Use of Adobe JDBC Drivers is restricted." and we were using macromedia.jdbc.MacromediaDriver. We also have the Oracle thin client installed but I'm not sure of syntax for the JDBC URL and placement of jar files. Can anyone point me in the right direction? Thanks!

I installed ColdFusion 2021 Developer Edition on a newly created Azure VM runing Wndows 10 Pro, and IIS 10.  I then started the process to add a website to the VM by creating a Server instance in the CF Admin, and a webstie in IIS.  After that I ran the WSConfig.exe for the website in Administrator mode.  I clicked the "Add" button, made sure the "AppServer Host" and the "IIS Website" were for the website I added.  When I clicked the "OK" button I received a popup with the error "An unknown error has occurred."  The only option on the popup error was an "OK" button, which I clicked.  The connection was not made.  The attached image is a screen shot of a window that was running in the background.  I don't know if it helps.  Any suggestions on how I can get the WSConfig to work? 

When using the Web Server Configuration tool I'm receiving the following error. I don't want to attempt installing this on a server if I can't get it running locally. java.lang.NullPointerExceptionat com.adobe.coldfusion.connector.connectorinstaller.ParserUtils.parseXMLDocument(ParserUtils.java:103)at com.adobe.coldfusion.connector.connectorinstaller.ConfigParser.getRootNode(ConfigParser.java:52)at com.adobe.coldfusion.connector.connectorinstaller.ConfigParser.getTreeNode(ConfigParser.java:37)at com.adobe.coldfusion.connector.connectorinstaller.ConfigParser.getConnectorHeartbeatPath(ConfigParser.java:200)at com.adobe.coldfusion.connector.connectorinstaller.WebServerInstaller.writeConnectorPropertiesFile(WebServerInstaller.java:988)at com.adobe.coldfusion.connector.connectorinstaller.IISInstaller.installConnector(IISInstaller.java:337)at com.adobe.coldfusion.connector.connectorinstaller.gui.AddConfigDialog$AddConfigThread.run(AddConfigDialog.java:1189) It looks like the wsconf

Hi folks,we are testing application in ColdFusion 2021I am getting below error message as i am using offset in ormExecuteQuery()we used offset for pagination.error is : "query result offset is not supported"I tried below steps to resolve but none work for me.1. Adding hibernate configuration filethis.ormSettings.ormconfig = "hibernate.cfg.xml";<?xml version="1.0" encoding="UTF-8"?><!DOCTYPE hibernate-configuration PUBLIC "-//Hibernate/Hibernate Configuration DTD 3.0//EN" "http://hibernate.sourceforge.net/hibernate-configuration-3.0.dtd"><hibernate-configuration><session-factory><property name = "hibernate.legacy_limit_handler">true</property></session-factory></hibernate-configuration> 2. Adding below setting along with other orm settings.<cfset structInsert( this.ormSettings,'hibernate',structNew(),true )><cfset structInsert( this.ormSettings.hibernate,'legacy_limit_handler',true,true )>i am not sure this works or n

Adobe tells me:"Boolean values Use True, Yes, or 1 for  true  and False, No, or 0 for false. Boolean values are not case sensitive." String values are enclosed in double quotes. When used in code, are boolean values enclosed in quotes like strings are? Or are they used, plain?For example, should the following be written as:<cfif session.isloggedin is "1"> —or— <cfif session.isloggedin is true> Thanks!

I have been at this for quite a few years and tried since ColdFusion 2016 to get PDFg working on Redhat Linux.  I finally got it working and would like to share my steps in hopes of helping someone else:Installed Coldfusion 2021 at /opt/ColdFusionDownload Linux Version of Add on Services Install defaults(admin, solr, and pdfg) but change java path to /usr/java/latest(where I have java installed for ColdFusion).  Choose install directory of /opt/ColdFusion/addonservicesIn /opt/ColdFusion/addonservices/cfjetty change java path because it apparently didn't care what you said during install(I've created a bug report):     #SOLR_JVM="/opt/ColdFusion/addonservices/jre"     SOLR_JVM="/usr/java/latest"     Remove /opt/Coldfusion/addonservices/jre3.  Download fonts required for linux install     wget http://cgit.freedesktop.org/xorg/font/ibm-type1/snapshot/font-ibm-type1-1.0.3.tar.gz     tar -zxvf fon

Migrating a few websites from CF 4.5 to 2018 (I know!) and could use some assistance.  Seems CF 2018 doesn't like my syntax:<cfquery name="CalCount" datasource="#dsn#">SELECT ID FROM Calendar WHERE Approved = 1 AND Caldate > #now()# -1 AND WebsiteID=#application.WebsiteID#</cfquery>Seems #now()# converts to{ts '2021-06-10 07:26:22'}SELECT ID FROM Calendar WHERE Approved = 1 AND Caldate > {ts '2021-06-10 07:26:22'} -1 AND WebsiteID=1CF doesn't seem to like my syntax. Will be digging into dates and formatting, but any insights appreciated. 

I've created a CAR file in CF2018 Administrator on our development server but I can't get it to deploy on our production server. Creating the archive was a little buggy. When I select "Assoc. Files/Dirs" in the archive wizard, I'm unable to select any of the other options. When I skip "Assoc. Files/Dirs" altogether, it seems to work. The resulting file is 385k. (Does that file size suggest a successful build?) Once I've built the archive, I move the CAR file to the production server, use the CF Administrator to deploy, and... nothing happens. The file path is cleared from the input and no datasources have been added, collections, mappings, etc. I'm not skilled at reading the CF logs, but there doesn't seem to be anything related to my failed efforts. Both servers are current through Update 11. Any insight or suggestions? Thanks!

Hello:I am in the United States, for example, but I suspect this might be an issue from any locale. I have noticed this problem several times, but have not mentioned it until now. I though this would have been fixed by now, but apparently no one else has noticed or complained. Or perhaps something is amiss with my system, but not likely as I have no reason to have India setup as my region/locale. To replicate the problem:Start on this page from the United States region/locale: https://helpx.adobe.com/coldfusion/developing-applications/using-external-resources/sending-and-receiving-e-mail/using-coldfusion-with-mail-servers.htmlClick on the menu above where it says Coldfusion (see attached screenshot: circled in purple)The link I receive is: https://www.adobe.com/in/products/coldfusion-family.html which includes the region/local *in* for India and I get the message in the second attached screenshot. Text + links follow. Are you visiting adobe.com from outside you

Good morning,       I have ran into a rather peculiar issue.  I have a CentOS 7 server with ColdFusion 2018 installed and configured.  Apache virtual directories are configures with correct directory structure to each web application document root via Plesk.  I'm going to use two web applications in this example, although I am experiencing the same issue with others.        I have one web application that when navigated to loads the correct Application.cfc file in it's directory root: r1gup.egtyctest.com.  The other web application, utgup2.egtyctest.com, is navigating to the r1gup.egtyctest.com Application.cfc file.  I placed a javascript alert on each Application.cfc files to display which Application.cfc file is being called and what the current hostname is being requested.  You can see the message when you navigate to either URL mentioned above.  FYI, these applications are in testing, and you will get a

Linux CentOS 7 - Apache 2.4Sometimes our ColdFusion2018 service crashes without producing specific error logs.How can we investigate further the causes? Thank you. Here is the last error we found on coldfusion-error.log after last crash episode:dic 19, 2020 2:48:33 PM org.apache.coyote.ajp.AjpProcessor logErrorSEVERE: nulljava.io.IOException: Broken pipeat java.base/sun.nio.ch.FileDispatcherImpl.write0(Native Method)at java.base/sun.nio.ch.SocketDispatcher.write(SocketDispatcher.java:47)at java.base/sun.nio.ch.IOUtil.writeFromNativeBuffer(IOUtil.java:113)at java.base/sun.nio.ch.IOUtil.write(IOUtil.java:79)at java.base/sun.nio.ch.IOUtil.write(IOUtil.java:50)at java.base/sun.nio.ch.SocketChannelImpl.write(SocketChannelImpl.java:466)at org.apache.tomcat.util.net.NioChannel.write(NioChannel.java:140)at org.apache.tomcat.util.net.NioBlockingSelector.write(NioBlockingSelector.java:101)at org.apache.tomcat.util.net.NioSelectorPool.write(NioSelectorPool.java:152)at org.apache.tomcat.util.

Hoy folks, Long time lurker first time caller.  I've hit an issue with ColdFusion ORM that I just can't figure out. Here's the situation. 1) I have a database procedure that I use to create tables with a number of columns that are common to all the tables. These columns are mapped to the persistent component. 2) The code to generate the keys looks like this (wod= word of the day):CREATE TABLE [dbo].[tblName]([idx] [int] IDENTITY(1,1) NOT NULL,[id] [varchar](36) PRIMARY KEY NOT NULL, ALTER TABLE [dbo].[tblName] ADD CONSTRAINT [DF_tblName_id] DEFAULT (newid()) FOR [id] 3) The rest of the columns mapped to given entity are generated by ORM. 4) The code for mapping these fields is...property name="idx" fieldtype="column" ormtype="int" generated="insert" setter="false";property name="id" fieldType="id" length=36 generated="insert" setter="false"; 5) My goal is to get the id property to be populated on save() from the database. 6) I get this

entityLoad('Account') throws this error,Error while loading entityjava.sql.SQLException: [Macromedia][Oracle JDBC Driver]Numeric overflow.However  entityLoad('Account',1) returns the proper record.I am using oracle 10g as a datebase.Is this a bug with oracle? entityLoad('Account') should return all my accounts.

Hi,Recently, i ran the update process from Update10 to Update11 for our CF 2018 Enterprise.However, we found that some (almost all) calls to REST services failed and throw the "java.lang.IllegalArgumentException: argument type mismatch" exception. To isolate the error from our entire implementation I made a simple implementation to reproduce the error: REST Service component (api.cfc)component rest = true { /** * * @httpmethod POST * @consumes application/json * @produces application/json * */ remote Input function echo(required Input payload) { return payload; } }Component (Input.cfc)component { property type = string name = content required = true; } I ran an HTTP POST through Postman and got the following exception (exception.logs):"Error","http-nio-8500-exec-8","05/26/21","09:12:36","","HTTP 500 Internal Server Error" coldfusion.rest.method.dispatch.CFRestException: HTTP 500 Internal Server Error at

First, I apologize if this is answered elsewhere. I tried searching here and Google, but didn't really find much.   I'm a former programmer who still has a legacy app used by my company very often.  For better or worse, I'm still the maintainer whenever IT can't handle it, and we are running into an issue where I made tabbed forms using Flash format with CFFORM many years ago. Does anyone have a suggestion on how to replace with something else?  I was hoping for something as simple as format="HTML5" but that's not an option...  Not a complex form, it's got about 4 tabs to better organize data that can be edited to maintain records in a DB.   Help & thanks!

My overall objective here is simply to be able to use a Java logging library, specifically log4j2 here, so that I can log user accesses to the application to a folder of my choice. And also make use of log rolling facility to copy log files to an archive directory at the end ofe very day. I have been using log4j2 with ColdFusion 2016.  I just placed the two jar files, log4j-api-2.6.2,jar and log4j-core-2.6.2.jar into the folder WEB-INF\lib and my config file, log4j2.xml into WEB-INF\classes.  That worked fine because ColdFusion 2016 was using log4j version 1 and there was no conflict of package names.  In ColdFusion 2021 it is using log4j version 2 and has the files log4j-api-2.13.3,jar and log4j-core-2.13.3.jar  installed in cfusion/lib and now I get an error on the first call to log4j2 when it should be reading the configuration file.It reports:ERROR StatusLogger Unrecognized format specifierERROR StatusLogger Unrecognized conversion This is simular to w

Recently we started upgrading ColdFusion from 2016 to 2021.So tried to install ColdFusion 2021 and using 30 days free trial for testing purposeApplication can’t make Database Calls so can’t able to login into application and can’t perform CURD operations.Below are orm settings in application.ormenabled = true;ormsettings = {};ormsettings.cfclocation = [… ];ormSettings.dbcreate = "update";ormSettings.flushAtRequestEnd = false;ormsettings.eventhandling = true;ormSettings.automanageSession = false;ormSettings.savemapping = false;ormSettings.skipCFCwitherror = false;ormSettings.useDBforMapping = true;ormSettings.autogenmap = true;ormSettings.logsql = true; And below are some errors on Hibernate level.Error executing DDL via JDBC StatementGetting this error when adding new properties on entities like case, group. Because those are reserved words in database Tried below options to resolve this issue but none helpful.Adding hibernate properites as  jvm arguments, orm properties

We cannot get a valid Serial number for CF10 to work when upgrading from CF10 to CF2021.The CF10 says the number is invalid however the serial number has been checked and is valid.How do we get around this to make the install work?

After a lot of blood sweat and tears I got the pdfg servlet running on my Redhat 8 Linux server.  A could of bugs that I found are:1. The <installdirectory>cfjetty file is not reflective of the java path that the user chooses during install.  I had to update the SOLR_JVM to my java path and delete the jre folder that was put there during install.2. If you stop the pdf service it "unregisters" it from your CF instance.  When you start the service it doesn't "register" the service so you have to bounce the entire CF instance to pick it up again. Also, since you cannot rely on the fonts like a Windows install it looks only at <installdirectory>/webapps/PDFgServlet/Resources/fonts where you are given very limited font options.  I do not feel I should have to pay for Adobe .otf fonts.  Please provide some.

We are using ColdFusion 2018 on a Windows Server 2016 machine.  We upgraded to CF2018 in March and all code has been working fine.  Last night, some Windows patches were applied, and today, any <cffile> or <cfdirectory> access causes it to fail with the following error.  Other tags seem to work fine.  As you can see, we can't even open the administrator tool right now to check other settings. at java.base/java.lang.Thread.run(Thread.java:834) "Error","http-nio-8500-exec-3","05/21/21","09:35:27","cfadmin","Could not initialize class coldfusion.tagext.io.FileUtils The specific sequence of files included or processed is: E:\ColdFusion2018\cfusion\wwwroot\CFIDE\administrator\index.cfm, line: 442 " java.lang.NoClassDefFoundError: Could not initialize class coldfusion.tagext.io.FileUtils at coldfusion.tagext.io.FileTag.read(FileTag.java:576) at coldfusion.tagext.io.FileTag.doStartTag(FileTag.java:393) Memory was initially at 95% so we added more and