Windows Authentication SELECT * FROM sys.sysusers WHERE isntuser = 1 SQL Authentication SELECT * FROM sys.sysusers WHERE issqluser = 1
read moreWhile doing routine WordPress updates I came across this error: cURL error 18: transfer closed with X bytes remaining to read After some investigation I found that my hosting server was unable to download files. Much of the advice I found suggests issues with cURL, PHP, or WordPress. If possible I advise checking the host […]
read moreI ran into an interesting change in ColdFusion 2018 with regard to <cfdump> The output produced by <cfdump> suddenly lacked formatting and any ability to collapse the tree nodes. This sample code: <cfcomponent> <cffunction name="test" access="public" returntype="any" output="false"> <cfset var test = structNew()> <cfset test.var1 = "Var1Value"> <cfset test.var2 = "Var2Value"> <cfset test.var3 = "Var3Value"> […]
read moreToday I began migrating some of our applications to ColdFusion 2018 (from ColdFusion 2016). Things went pretty smoothly until I ran into this error: Could not find the ColdFusion component or interface XXX.XXX.mycfc” Where “XXX.XXX.mycfc” is a ColdFusion component. In my case the component definitely exists and was in the path where it was being […]
read moreRecently I had a recurring issue where a user was being inexplicably dropped from the a SQL Server database. I used this query to quickly identify the user/application that was removing the user accounts: DECLARE @traceLog VARCHAR(256) SELECT @traceLog = CAST(value AS VARCHAR(256)) FROM ::fn_trace_getinfo(DEFAULT) WHERE traceid = 1 AND property = 2 SELECT TextData, […]
read moreWhile updating a WordPress site hosted on a Windows platform (Internet Information Server); I came across this error: The update cannot be installed because we will be unable to copy some files. This is usually due to inconsistent file permissions.: wp-admin/includes/update-core.php I confirmed the Application pool identity for the site had the appropriate permissions. After […]
read moreIn the course of uploading large files to a ColdFusion server you may encounter this error: coldfusion.util.MemorySemaphore$MemoryUnavailableException:Memory required (XXXXXXXXX bytes) exceeds the maximum allowed memory. The solutions I was able to find; suggest only increasing the “Maximum Size of Post Data” setting within the ColdFusion Administrator. However, you also need to increase the “Request Throttle […]
read moreWhile setting up a SQL AlwaysOn Availability Group I ran into a very interesting problem. I had created the AG while preparing for an upcoming speaking engagement so I’d setup two VMs (Node A and Node B) and checkpointed them immediately before creating the AG. This way I could just go back to the checkpoint […]
read moreOne of the ColdFusion 2016 servers that I’m responsible for managing suddenly stopped working after a simple reboot. The hosting environment is Windows based and I found that the ColdFusion Application Server service would not start. There were several Windows Event Log exceptions: The ColdFusion 2016 Application Server service terminated with the following service-specific error: […]
read moreWhile using ColdFusion’s Encrypt() function I received this error: The key specified is not a valid key for this encryption: Illegal key size or default parameters. If encryption key size is greater than 128 bits make sure to insall JCE Unlimited Strength Policy Files. Use the generateSecretKey method to generate a valid key for this […]
read more