Questions

After upgrading MySQL to 8 we noticed some odd date behaviors.Example:2024-06-28T02:11:51.000 stored in a varchar type field named tstampWhen we execute this statement in mysql workbench directly:STR_TO_DATE(tstamp,'%Y-%m-%dT%H:%i') as listedonThe result is correct: 2024-06-28 02:11:00The same exact query when done using a coldfusion query on the same field and database returns:2024-06-27 22:11:00.0The coldfusion SELECT is subtracting 4 hours from the date stored in a varchar field when we use str_to_date to format it? Needless to say this is causing issues. Does anyone know of a possible cause or fix for this maybe changing db drivers so that I don't have to recoded all queries on our sites using str_to_date? ThanksForrest  

I am trying to install ColdFusion 2023 on a new Windows virtual machine.I set it up as Development Type - Development with CF Server Profile - Development Profile.  After installation I ran the Web Server Config tool and added the IIS website/all Here is what IIS has after installation & web config  After this I tried to access the localhost and receive this error message The ColdFusion administration doesn't load either Windows Virtual MachineMicrosoft Windows Server 2022 Standard64-bitVMware 7,1CPU: Dual 3.10 GHz Intel Xeon(r) Gold 6254@, Memory: 32768 MBC: 79.62 GB (43.86 GB free) Any help is greatly appreciated.  Thank you!

Hoping for some input/help. I have an IIS failover cluster freshly installed across two servers. We purchased CF2023 Enterprise and installed it on both servers. I ran the lockdown software per this document on both servers. When trying to add a remote instance per the instructions here (Registering a Remote Instance), the information seems to take but then the remote instance disappears from the list of servers after the form is submitted (and accepted). When attempting to edit/view the remote instance I just added, I get an error (An error occurred while executing the application. Please try again or contact the administrator.) and it is then removed from the list.In looking at the coldfusion-error.log file, I see a line "SEVERE: Error storing instances.xml" and an access denied error to the instances.xml file (\cfusion\..\config\instances.xml (Access is denied)). I believe the issue is related to the lockdown tool. I was able to add remote instances before running the lockdown tool.

Requesting some help with this one.I know the basic steps for creating the new connector. I am able to do that successfully, but upon using the new isapi_redirect.dll the isapi_redirect.log is being written with this error upon trying to access the ColdFusion Administrator: [warn] jk_check_path::jk_util.c (2476): Blocking this uri: [/CFIDE/Administrator/index.cfm] since its starting with cfideI know I've seen numerous posts about not accessing the CFIDE and that Adobe is helping us by blocking it, but this is my only way to administer this in my environment.If I go back to using the previous isapi_redirect.dll there is no issue and I am able to access the ColdFusion Administrator console without any issues.Is there a new exclusion that we need to include somewhere to allow access to CFIDE/Administrator with this new update?

I am not able to get line debugging to work.I have an up-to-date VS Code and believe the CF Extension to be up-to-date.I am devopling against a localhost instance of CF, and have administered its RDS to be enable. From VS Codes CF Server configuation, and can test connetion. That works.But when I choose a file with a breakpoint, nothing happens.The debug console output is this:Error on RDS request :: {"code":"ERR_SOCKET_BAD_PORT"} 323 :: {"statusCode":500,"data":[],"error":{"code":"ERR_SOCKET_BAD_PORT"}} Error on launchRequest :: 13 Error on RDS request :: {"code":"ERR_SOCKET_BAD_PORT"} Debugger stopped Error on RDS request :: {"code":"ERR_SOCKET_BAD_PORT"} Debugger stopped All, I know is that CF+Tomcat is configured for port 8500 and the RDS line debugger port is 5005. No changes from defaults. Everything about runing CF code and using RDS on my development platform but this appears to run as expected.There is a bug tracker report about something similar, but I see nothing that t

I have a virtual website running off of IIS (looks like version 8.5,) and ColdFusion 11.When I access a page as http://something.example.org/ which uses a ColdFusion template (index.cfm), the page correctly displays. However, when I request http://something.example.org/index.cfm it results in a 404.All .cfm pages result in a 404Other virtual websites on the same server behave correctly, returning successfully for both http://other.example.org and http://other.example.org/index.cfmSince I just set up this new website, I'm wondering if there is an additional setting I'm just missing that prevents this error from occurring?Pages with non .cfm extensions, like .htm & .pdf display properly.

Hi,We are having issues with the PDF engine after migrating to CF2023 Build 7. Though the HTML is correct converting to pdf using cfhtmltopdf is broken. Few issues are like1. text overflowing on the pdf2. lot of spaces between 2 div blocks.

I just try using coldfusion 2023, and get error rewriting.I use following- OS Ubuntu 24.01- Apache 2.4- FW/1 frameworkSo when I open example at browserhttp://xxxx.com/index.cfm/test/rewrite ====> working wellbuthttp://xxxx.com/test/rewrite ====>  error as belowPlease advice.Error log is :[warn] ajp_process_callback::jk_ajp_common.c (2263): (cfusion) AJP13 protocol: Reuse is set to false

I am trying to create a Coldfusion Docker image to run as a container that is created using Google Cloud Build and Google Cloud Run.Currently I have everything working correctly. My problem is that the .car and the mysql.jar files are not being copied, so when the Docker image is built (Google Cloud Build) there are no Coldfusion Datasources or settings. Security of these settings is very important and thus I am not inclined to use a setting.json file for importing settings.I have also tried building the file locally and pushing it to the Google Artifact Registry and using that image. That image had the same issue when I run it.Here is the Log from Google Cloud Run:```Starting ColdFusionStarting ColdFusion 2021 server ...session): Could not set limit for 'locks' to soft=-1, hard=-1: Operation not permitted; uid=0,euid=0session): Could not set limit for 'sigpending' to soft=0, hard=0: Operation not permitted; uid=0,euid=0session): Could not set limit for 'msgqueue' to soft=819200, hard=

I moved code from ColdFusion2016 (Linux) to ColdFusion2023 (Windows). The database and network share behind the website are identical.  I am using cffile read to read a file in a network share.  The website on the CF16 server can read the file and displays as expected.  The website (same code) on the CF23 server is unable to read the file and throws and error.  This is the value in our database that sits behind both CF16 & CF23 code 'PLN_29886_ Istanbul SIOT DAY 1 - 1to1 Turkish Thank You — Triggered Email.htm'On the network drive the filename is displayed as 'PLN_29886_ Istanbul SIOT DAY 1 - 1to1 Turkish Thank You — Triggered Email.htm' I do not have any control over the filenames that are placed into the network share. I can see that the em-dash is translated into — in the file. I'm at a loss as to why cffile on CF16 reads the file but cffile on CF23 an error is thrown. I would expect the same result either they both read the

Hi! Is there a way to clear template cache manually on a Windows ColdFusion 2023 server, please?We have multiple ColdFusion servers that point to a single location where our ColdFusion applications are stored. One specific application running from one specific server errors out, even after "clearing the template cache" using its ColdFusion Administrator.  This specific application runs just fine from all other ColdFusion servers.  Additionally, all  other applications that run from the server in question..  work just fine!In the past, when we where on ColdFusion 2018, we had seen a similar problem and deleting the "cfclasses" directory and then clearing the "Template Cache" fixed the problem.  However, in Coldfusion 2023, the "cfclasses" directory no longer seems to be use.  Any assistance would be greatly appreciated! Thank you very much!

Hi,I've never used cachedwithin parameter before in queries as the queries are generally dynamic but i'm potentially thinking it might be of benefit to us. The question I have is with a lot of users and active sessions, would adding this cachedwithin parameter to a few queries overload the cache or have negative affects to performance. I don't know enough about how the cache works or what kind of space it has to operate. Is there a benefit of using that parameter if the queries are dynamic. All I can see in the documentation is that for dynamic queries it will create a new one for each but it doesn't warn against using it if that is the case.Thanks

Ive been using POIUtility.cfc on cf8 and its worked flawlessly. Now we have switched to cf23  and I am getting this error Element CELL.CELL_TYPE_NUMERIC is undefined in LOCAL. We are using the exact same spreadsheet. worked fine in cf08 but now doesnt work cf23. Any ideas?

ColdFusionを用いてPDF統合の検証中ですが、うまくいきません。複数ファイル（拡張子：xls,xlsx,docx,txt,pdf）を１つのPDFファイルに統合し表示したい（PDFポートフォリオを作成、表示したい）のですが、一部ファイルがプレビュー表示されません。 表示する端末によっても挙動が変わってしまうのですが、TXT,PDF形式のファイルはプレビュー閲覧できています。Excel、Wordのプレビュー閲覧ができず、「文書を開く」を押下することで作成元のアプリケーションが立ち上がり、別ウィンドウでの展開はできる状況です。 検証中のソースではcfpdfタグを使用し、以下設定しています。action="merge"package="yes"overwrite="yes" PDFポートフォリオの作成方法の変更で端末に依存せず、全ファイルのプレビュー表示ができるでしょうか。それとも、特定のAdobe Readerでしか表示できない等、制約があるでしょうか。

Except for uninstalling and reinstalling the software as a whole, is there a way to update the Deployment Type from Development to Production?ColdFusion 2021 Enterprise was installed initially with the Development Type because the environment where it was being installed was yet to be full Production. We now have licensing acquired and are ready to go full Production with the software, but I am looking for if there is an easier way to update it.

Getting below error while running the application in localhost :  You do not hold the required permissions to access this page.If you believe you should be able to access this page, please contact the system administrators:The following information has been logged for audit purposes but I have access to the development database, same application is running as development server, no issues with dev serverI cleared cache in my 127.0.0.1 cf aministrator. but still same issue. I'm not sure how to resolve the issue, please help

I am using Coldfusion 2023 (developer version, for now while I test it). In the debugging IP address section (see image below) I have entered 127.0.0.1 But, it doesn't matter what IP address I connect from, I still see the debugging info when I test with a .cfm page that has an error in it.I thought that debugging info would only show if I connected from the ip address in the debugging list. Is there something else that I need to configure?  

I have code that reads a network share to get a list of directories which then I compare to another newtwork share to determine if there are duplicate folders (same name folder in both network shares).  I had the code running  correctly on ColdFusion 2016 (Linux) but we are now on ColdFusion 2023 (Windows Server 2022) so i'm working on updating the code to access the network share on the CF2023 server. I've tried just using the network share location but that doesn't return anything and then I tried mapping a drive in Windows to access this share but I get a directory not found error.  I also tired using the linux network share '/nas/root' but that just throws errors saying it doesn't exist (which is to be expected). The code below is what i'm using to test cfdirectory.   It looks like ColdFusion can read and write to the network shares but when I run the cfdirectory to get a listing of directories nothing is returning.  I've been in the wee

Using cold fusion 11 we unable to viee the data from front end through stored procedure. Pls help how to modify cf script accordingly 

Updating to CF2021 Enterprise Update 11 on my Linux server connecting to Oracle 19c database that uses encryption & checksum breaks.  Downgrading the Oracle package from 2021.0.11 to 2021.0.05 lets me connect again. While an update to the Oracle driver isn't listed in the Update 11 notes, it is indeed updated. They do mention "enhancements in ...Database, and other areas".  Searching for "database" I see some changes to MySQL and Postgres but nothing for Oracle.  I do indeed see the new files on my filesystem.  Going to the Package Manager in the CF Administrator GUI shows that it has updated to "2021.0.11.330247".  If I select "2021.0.05.330109" in the "Available Versions" and then click "Downgrade" and restart my CF instance, the datasource now connects.  Incidentally, there is no "downgrade" command in cfpm.sh so I had to actually go through using the web-gui to do the downgrade.  I'll submit a Feature Request to allow downgrade command vi

Hi, After applying CF update 14 on cf2021 box search no longer works.  When I go to the CF admin to the coldfusion collections tab I get: Unable to retrieve collections from the Search Services.Ensure that you have installed ColdFusion Search Service and it is running. I tried uninstalling the search component and re-installing and also down grading the search component but no luck. After more research, I see that the issue only happens when there are multiple Coldfusion Instances and does not happen on my local which only has one CF instance Any ideas? Thanks,Gabe

I want to pass a query into a function one row at a time in the same way you could pass an array to a function one row at a time. I've read that queries are just CF structures under the hood so I believe it should be possible. I just don't know the syntax to reference a single query row (and all it's variables). I don't want to pass the whole query to the variable because I would like to do the looping outside the function. The idea is to simplify and standardize the formatting and arrangement of several variables (columns) in a UDF and keep the syntax to use the function simple. Therefore, I'd like to avoid having to do stuff like convert the query to an array. That would defeat the goal of keeping it simple. Thanks Magnus

Hi all,Recently I have installed coldfusion2023, while configuring IIS and coldfusion appliaction server, trying to run wsconfig.exe file, I am getting java.lang.NullPointerException errors and unable to move forward.can anyone help me how to troubleshoot or suggest me alternative solution for this?Charlie ArehartThanks,

The following cfdocument is not displaying the fonts.<cfoutput>        <cfdocument format="pdf" fontembed="true">            <style>body{font-family: 'SimSun' 'Microsoft Yahei'; font-size: 35px; }td,th, h1,h2,h3, p{font-family:'Microsoft Yahei', sans-serif,Helvetica, Arial;}    </style>        <cfoutput>            <h1>PDF #chinese characters here#</h1> <!-- "PDF Example Title" in Chinese -->          </cfoutput></cfdocument></cfoutput>===========================AWS Linux 2023 EC2 instanceCF2023 TrialTried:Adding fonts via CF AdministratorAdding fonts to /usr/share/fontsAdding fonts to /usr/share/fonts/default/TrueTypeUsed in-built web server as well as apache All suggestions welcome!  Thank you.

I installed PMT 2023 on a REHL 9.3-0.5.el9.x86_64. I accepted all of the defaults from the installer. When the installer finished it said it had some errors and I should look at the log files. I went to where it told me the log files were but there were no log files. Trying to connect through a browser returned a 404 page not found error. I stopped and then started the PMT and when I started the PMT I got the error below which probably explains why there were no log files. It seems there is a permissions issue. [cimwebadm@tx11cofu01lvtst bin]$ sudo ./perfmontoolset startException in thread "main" java.lang.RuntimeException: starting java failed with [1]output:[0.000s][error][logging] Error opening log file 'logs/gc.log': Permission denied[0.000s][error][logging] Initialization of output 'file=logs/gc.log' using options 'filecount=32,filesize=64m' failed.error:Invalid -Xlog option '-Xlog:gc*,gc+age=trace,safepoint:file=logs/gc.log:utctime,pid,tags:filecount=32,filesize=64m', s