Skip to main content
C
Claude5FCA
Participant
August 17, 2021
Question

File Types Creation works in great cf9.1 however not in cf 2021

  • August 17, 2021
  • 3 replies
  • 124 views

Hi,

 

The company has an application that stores the content of files uplaoded into an sql database table allowing for the content of those files to be rebuilt and downloaded as required using cf code.

The code works perfectly in the application running cf9.1 on a window 2008 server

 

When I run the identical code pointing to the same database running cf2021 on a windows 2016 server  the files are generated successfully however when they are opened they either generate an error within the default application used to open the file determined by the file extension  (eg ms word, xls, msg, etc ) and or advises there are permission errors preventing the file to be opened.

 

Can anyone shed some light on what may be causing this and a possible solution

 

Just recapping the cfm page generating the file, and the sql database, table, and the record being  used are idetical in both examples. The ony differnece is the working solution is running cf9.1 on windows server 2008 whilst the not working solution is running on cf 2021 on windows server 2016.

 

I thnak you in advance or any responses that can enlighten me as to the cause and the path to resovle the above 

Regards



Claude Raiola

This topic has been closed for replies.

3 replies

Charlie Arehart
Community Expert
Charlie ArehartCommunity Expert
Community Expert
August 18, 2021

Claude, any update on things? Did you consider what I or BKBK offered? Any follow-up?

/Charlie (troubleshooter, carehart. org)
BKBK
Community Expert
BKBKCommunity Expert
Community Expert
August 17, 2021

One suggestion comes to mind: make sure that locations, file paths and permissions are no longer for (CF9, Windows Server 2008), but for  (CF2021, Windows Server 2016).

Charlie Arehart
Community Expert
Charlie ArehartCommunity Expert
Community Expert
August 17, 2021

Claude, I'd assert that your description is too general for us to assess what may be amiss.

 

Can you take a few mins to create a working example that demonstrates the problem, even in just a few lines of code? In doing that, you'd clarify the problem for us and for you...and you may even see that the cause is other than just that "cf2021 doesn't work" for that process.

 

Perhaps you may find that some earlier partt of the process (that you're not currently considering) has changed in its behavior, affecting the results of the ultimate steps you actually see.

 

Note also that you're skipping over four releases (10, 11, 2016, and 2018) in addition.to 2021 itself (and about 100 updates). There have indeed been compatibility issues between each release (a few per release, on average, and in about 1 in 5 updates). You could be tripping over one or more in your entire process. We just can't know given what you've shared.

 

Also, did you install cf or someone else? When you were asked to implement the "secure profile" (new since 10), did you do it or skip it? That too can impact how your code runs.

 

I realize I'm offering more questions than answers, but you did ask for "any responses". 🙂 

/Charlie (troubleshooter, carehart. org)
Terms & ConditionsAccessibility statement
Using the community Terms of use Privacy Cookie preferences Do not sell or share my personal information ad choicesAdChoices