Debug error when inserting filecontent - classic template

aspirenet · March 15, 2025, 6:57pm

I was wondering if anybody else has come across this? Could be a bug?

If I upload a TXT file and then insert the contents of that file using filecontent it works fine the CFM completes all the way to the end. However the debugger is not too happy and it tries to display an extra array item, one too many, if I have other fields in there, it always adds an extra one in and throws the error. Screenshot attached

Tech stack

Lucee 6.2.0.321
Java 21.0.5 (Eclipse Adoptium) 64bit
Windows Server 2022 (10.0) 64bit
IIS 10

Zackster · March 15, 2025, 7:14pm

Can you file a bug with a repo?

As the debug template is written in cfml, you might be able to solve it and become a Lucee contributor by filing a pull request with the fix?

github.com

lucee/Lucee/blob/6.2/core/src/main/java/resource/context/admin/debug/Classic.cfc#L388


      
          <code><b>#queries.name#</b> (Datasource=#queries.datasource#, Time=#formatUnit(arguments.custom.unit, queries.time)#, Records=#queries.count#) in <cfif len(queries.src)>#queries.src#:#queries.line#</cfif></code><br />
          <cfif ListFindNoCase(queries.columnlist,'usage') and IsStruct(queries.usage)><cfset var usage=queries.usage><cfset var lstNeverRead="">
          <cfloop collection="#usage#" index="local.item" item="local._val"><cfif not _val><cfset lstNeverRead=ListAppend(lstNeverRead,item,', ')></cfif></cfloop>
          <cfif len(lstNeverRead)><font color="red">the following colum(s) are never read within the request:#lstNeverRead#</font><br /></cfif>
          </cfif>
          <pre>#queries.sql#</pre>
          <cfif !isEmpty(queries.paramValue) && !isEmpty(queries.paramType)>
          <cfset paramValue1 = listtoarray(queries.paramValue,",")>
          <cfset paramType1 = listtoarray(queries.paramType, ",")>
          <cfoutput>
          	<pre><b> Query Parameter Value(s) - </b><br><br><cfloop from="1" to="#arraylen(paramValue1)#" index="i">###i# Parameter(#paramType1[i]#) = #paramValue1[i]#<br></cfloop></pre>
          </cfoutput>
          </cfif>
          </cfloop>
          </cfif>
          
          
          <!--- Scopes --->
          <cfset var scopes="Application,CGI,Client,Cookie,Form,Request,Server,Session,URL">
          <cfif not structKeyExists(arguments.custom,"scopes")><cfset arguments.custom.scopes=""></cfif>
          <cfif len(arguments.custom.scopes)>

Betsy · April 26, 2025, 2:16pm

Yes, I’ve been having this same issue for months.

Query Parameter Value(s) -

After a INSERT or UPDATe statement is shows you the successful query on debug info but then tries to show a list of the parameters after the query – it happens 99% of the time when i have debugging setup on a page:
#1 Parameter(CF_SQL_VARCHAR) = Cl. 153 #19-39
#2 Parameter(CF_SQL_VARCHAR) = Bogotá
#3 Parameter(CF_SQL_VARCHAR) = Colombia
#4 Parameter(CF_SQL_INTEGER) = OPERATIONAL
#5 Parameter(

Lucee 6.1.0.243 Error (expression)
Message Array index [5] out of range, array size is [4]
Function info
Component lucee-server.admin.info.Info
Stacktrace The Error Occurred in
/opt/lucee/tomcat/lucee-server/context/context/admin/debug/Classic.cfc: line 386

384: <cfset paramType1 = listtoarray(queries.paramType, “,”)>
385:
386:
 Query Parameter Value(s) - 

###i# Parameter(#paramType1[i]#) = #paramValue1[i]#
387:
388:

Zackster · April 26, 2025, 3:52pm

I’ll fix it in 6.2.2

https://luceeserver.atlassian.net/browse/LDEV-5544