Forums

Turn on debugger

matcarls 15 Nov, 2019
Hi

How do I turn on the debugger in CC6 ??
I would like to see the sql statement generated for a db reader. It seems to be something wrong there.

An error has occurred.

1054 Unknown column 'modhead.1235' in 'where clause'



modhead is my module. The 1235 has replaced the column name I want to compare to 1235.. The sql where statement ought to be "modhead.contactno = 1235"

Regards Mattias
matcarls 18 Nov, 2019
Answer
I found myself. But for anyone else:

Create a html-view name it for example vwdebug and put {debug:} in content. Make sure you use the view in an event by putting {view:vwdebug} in the view content.

The other part above I hope eventually will be solved in this post:
building-advanced-filter-with-where-statement-in-php
healyhatman 19 Nov, 2019
You can just put {debug:} in the event, you don't need to make it into a view.
This topic is locked and no more replies can be posted.