[SOLVED] creating a list from a query

[nicolapiva]

Hi
I have a custom mysql view on several tables. The view works well inside phpMyAdmin. I created a list in Fabrik with reference to the view. When I click the menu linked to the list I obtain the error:
"500 Fabrik has generated an incorrect query for the list prova2"
An advice?
Thanks

 

[troester]

In Fabrik Options/Debugging set Debug=yes.
Then call your list and append &fabrikdebug=1 (?fabrikdebug=1 if there's no other URL parameter)
This should display the complete error message.

 

[nicolapiva]

First of all Thanks a lot. I followed your advice.
The complete error message is:
500 Fabrik has generated an incorrect query for the list prova4: <br /><br /><pre>Unknown column 'prova4.' in 'field list'</pre>
but I don't understand the problem.
Thanks

 

[troester]

Your view needs a column which can and must be assiged as Primary key in the Fabrik list settings.

 

[nicolapiva]

I love you......

 

[cheesegrits]

And just to be clear, that column MUST contain unique, numeric values. Typically you'd include the primary key from one of the tables you are creating your view from (just be careful if your query does joins, such that you might end up with repeated primary rows).

Also note that Fabrik lists built on views are "read only", you can't save form data to them.

-- hugh