Fabrik has generated an incorrect query for the list

[barraclm]

I was getting a "500 Fabrik has generated an incorrect query for the list" error. I have now solved this (id field name changes not carried through to database joins and PHP calc fields). However:

1) I had debugging turned on and "?fabrikdebug=1" appended to my URL but I got exactly the same message. Why?

2) How do I get to see the SQL query that Fabrik has generated?

3) What else can I do to figure out what is going wrong, please?

 

[troester]

You must set "Enable Fabrik debug"=Yes in Fabrik Options[Debugging]

 

[barraclm]

Thank you. I had already done this. I still got no additional information.

 

[troester]

Then I assume fabrikdebug is not your first URL parameter. Append &fabrikdebug=1 (instead of ?fabrikdebug=1)

BTW:
If you rename database columns/Fabrik element names you must really know what you are doing (same if you change the column type).
Fabrik is throwing a warning if you try to and you should not ignore it.

 

[barraclm]

Thank you. My bad. I was just about to confess to the fact that I had used ? instead of &! Everything (so far is now good). My next issue will be getting my head around Cascading Dropdowns.

 

[troester]

If you don't need the Cascading Dropdown function in list filtering you can also use a databasejoin with Data-where and Ajax update enabled.