Barrett Chamberlain
Barrett Chamberlain

Reputation: 129

getting error information on cfgrid - cfdebug

I'm using CF9

When editing a field which updates information on a db in a cfgrid, I get this error:

"Error invoking CFC /assetMgmt/assetdata.cfc : Error Executing Database Query. [Enable debugging by adding 'cfdebug' to your URL parameters to see more information]".

adding ?cfdebug to the end of the url and hitting enter opens the menu to search for items to populate the grid, so the cfdebug parameter gets removed once the grid has been populated (because of hitting the search button).

I guess I need some way to enable this cfdebug mode without having to navigate to the page, since it removes the cfgrid. Sorry if that sounds confusing

Upvotes: 2

Views: 8090

Answers (2)

Rob
Rob

Reputation: 1

I found that giving a sql column an alias with a space in it caused an issue in ext-all.js with cfgrid. To fix this, I replaced the spaces with non breaking spaces (&nbsp) and it solved the issue.

Upvotes: 0

Doug Hughes
Doug Hughes

Reputation: 981

Here's my advice: Use chrome or Safari. Open the developer tools and look at the console. Make sure that xmlhttprequests are being logged.

Now access the page with the issue. You will see the error logged (likely a 500 error) in the console along with the URL that was requested. Right click on the url and open in a new tab. This will rerun the request and output the result directly in the browser so you can see the error being thrown. Fix the error and you should be good to go.

If you need any more assistance please let me know.

Upvotes: 1

Related Questions