coldbox [3.81] Error

Communities ColdBox HMVC
1

I was working on a page today and using a function in queryhelper to join two queries together.

<cfset prc.qry5 = getPlugin(“QueryHelper”).doLeftOuterJoin(prc.PositionList, tbl_fpt, ‘strValue’, ‘pos_id’)>

The join completed fine but I got this error on the page:

The web site you are accessing has experienced an unexpected error.
Please contact the website administrator.

The following information is meant for the website developer for debugging purposes.

Error Occurred While Processing Request

The value ‘’ cannot be converted to a number.

The error occurred in C:/wamp/www/coldbox/system/includes/panels/CollectionPanel.cfm: line 38
Called from C:/wamp/www/coldbox/system/includes/Debug.cfm: line 276
Called from C:/wamp/www/coldbox/system/web/services/DebuggerService.cfc: line 230
Called from C:/wamp/www/coldbox/system/Coldbox.cfc: line 367
Called from C:/wamp/www/WMT_PROD/Application.cfc: line 44

36 : 				<!--- Max Display For Queries  --->
37 : 				<cfif isQuery(varVal) and (varVal.recordCount gt getDebuggerConfig().getmaxRCPanelQueryRows())>
38 : 					<cfquery name="varVal" dbType="query" maxrows="#getDebuggerConfig().getmaxRCPanelQueryRows()#">
39 : 						select * from varVal
40 : 					</cfquery>

There are 816 records total in that join and I guess if you double that you get 1632 total records on the page.

When I comment out the join, the page works as normal.

I have never seen this error before. I was trying to join the results of a stored-procedure the results from another table. I was hoping to join these tables without having to fool with the stored procedure.

Am I hitting a limit on something?

2

Can you show us your debugger config?

getDebuggerConfig().getmaxRCPanelQueryRows() is apparently returning an empty string.

Thanks!

~Brad

ColdBox Platform Evangelist
Ortus Solutions, Corp

E-mail: brad@coldbox.org
ColdBox Platform: http://www.coldbox.org
Blog: http://www.codersrevolution.com

3

This was commented. I un-commented it to see if increasing the query rows would help.

Again, same error with this commented or not.

Thanks

debugger = {
enableDumpVar = false,
persistentRequestProfilers = true,
maxPersistentRequestProfilers = 10,
maxRCPanelQueryRows = 250,
showRCSnapshots = false,
//Panels
showTracerPanel = true,
expandedTracerPanel = true,
showInfoPanel = true,
expandedInfoPanel = true,
showCachePanel = true,
expandedCachePanel = true,
showRCPanel = true,
expandedRCPanel = true,
showModulesPanel = true,
expandedModulesPanel = false
};

4

So I used a different query to get what I needed instead of using query helper to join them together. I am still curious as to what caused this error. I do have the original code commented so I can reproduce the error if needed.

5

If you can zip up a stand alone app that shows the issue, post it here or put in a ticket. If it does turn out to be a bug in 3.8.1, I’m not sure if there will be any more 3.x releases since everything is changed in 4.0 concerning the debugger module.

Thanks!

~Brad

ColdBox Platform Evangelist
Ortus Solutions, Corp

E-mail: brad@coldbox.org
ColdBox Platform: http://www.coldbox.org
Blog: http://www.codersrevolution.com

6

Thanks Brad,

I’ll see if I can create a simple app and duplicate just that.