Not displaying debugging info on Railo

[mschierberl]

I'm having an issue with Railo 3.3.1, FF 9.01, and coldfire 1.9

I'm seeing correct debugging info coming from an ACF 9 server, so I know my setup is OK.

My debug template is running properly, coldfire headers are set and returned, but when I look at the ColdFusion tab in firebug I can only see information in the "General" tab. All the others are blank.

I've been comparing headers returned from CF vs. those from Railo, and they are almost identical, the only major difference is the order that query columns appear in the data struct.

Got any ideas on where I should look next? I'm a bit stumped at this point.

[nmische]

I'm not sure what the issue is either. I need to install Railo and do some testing.

[mschierberl]

Would it help if I setup a test environment for you to check out? It would be easy to do.

On Tue, Jan 24, 2012 at 6:22 AM, Nathan Mische < [email protected]

wrote:

I'm not sure what the issue is either. I need to install Railo and do some testing.

---

Reply to this email directly or view it on GitHub: https://github.com/nmische/ColdFire/issues/2#issuecomment-3632993

[nmische]

No. I'm going to set up Railo on a Vagrant box for testing, but thanks for the offer.

[nmische]

This took me much longer to investigate than i hoped, but I'm unable to reproduce on Railo 3.3.4.003. Is this still an issue?

[peterpham]

I am running on Railo 3.3.4.003 Using ColdFire on Firefox 19.0 and seeing issue exists. Going through the code, I saw the encoded debugging queries are causing this issue. If there is a backslash () in the encoded SQL, it will fail.

For example: SELECT * FROM request.messages WHERE type = 'notice' ==> fail (nothing will show in ColdFire)

but this one: SELECT * FROM request.messages WHERE type = 'notice' ==> work

Test case 1: with backslash

<cfsavecontent variable="a">
{
    "RECORDCOUNT": 0,
    "COLUMNLIST": "DATASOURCE,QUERYNAME,ET,SQL,PARAMETERS,RESULTSETS,RECORDSRETURNED,TYPE,CACHEDQUERY,TEMPLATE,TIMESTAMP",
    "DATA": {
        "DATASOURCE": [""],
        "QUERYNAME": ["qNotice"],
        "ET": [0],
        "SQL": [" SELECT * FROM request.messages WHERE type = \'notice\' "],
        "PARAMETERS": [ [] ],
        "RESULTSETS": [ "" ],
        "RECORDSRETURNED": [0],
        "TYPE": ["SqlQuery"],
        "CACHEDQUERY": [""],
        "TEMPLATE": ["test.cfc"],
        "TIMESTAMP": [""]
    }
}
</cfsavecontent>
<cfheader name="x-coldfire-queries-1" value="#a#">

Test case 2: without backslash

<cfsavecontent variable="a">
{
    "RECORDCOUNT": 0,
    "COLUMNLIST": "DATASOURCE,QUERYNAME,ET,SQL,PARAMETERS,RESULTSETS,RECORDSRETURNED,TYPE,CACHEDQUERY,TEMPLATE,TIMESTAMP",
    "DATA": {
        "DATASOURCE": [""],
        "QUERYNAME": ["qNotice"],
        "ET": [0],
        "SQL": [" SELECT * FROM request.messages WHERE type = 'notice' "],
        "PARAMETERS": [ [] ],
        "RESULTSETS": [ "" ],
        "RECORDSRETURNED": [0],
        "TYPE": ["SqlQuery"],
        "CACHEDQUERY": [""],
        "TEMPLATE": ["test.cfc"],
        "TIMESTAMP": [""]
    }
}
</cfsavecontent>
<cfheader name="x-coldfire-queries-1" value="#a#">

[nmische]

Thanks @peterpham . It looks like i need to incorporate this change into the Railo debugging template: https://github.com/nmische/ColdFire/commit/7937554f3058831c0b59affaf72e5d8eac92b631#L0L1075.