dimoss
Well-Known Member
Hi
I have created a View using phpMyadmin which returns the results ok.
I created a list using this View as usual. The View hasn't a PK value.
When I tried to run this fabrik list I got an error that there is an Unknown column 'PLAYER_CANCELLATION.' in 'field list'.
So I re-created the View adding an id and the error gone.
However in the past I used exactly the same View with a table in F2.1.x with J!1.5.26 without a PK value and worked like a charm.
It seems that in F3.1.x the PK value is mandatory or there is a problem??
And what about the views which are based in other views where I can't have an id?
In MySQL we can't create an automatic increment id in Views.
Any help on this is appreciated.
Thanks.
I have created a View using phpMyadmin which returns the results ok.
I created a list using this View as usual. The View hasn't a PK value.
When I tried to run this fabrik list I got an error that there is an Unknown column 'PLAYER_CANCELLATION.' in 'field list'.
So I re-created the View adding an id and the error gone.
However in the past I used exactly the same View with a table in F2.1.x with J!1.5.26 without a PK value and worked like a charm.
It seems that in F3.1.x the PK value is mandatory or there is a problem??
And what about the views which are based in other views where I can't have an id?
In MySQL we can't create an automatic increment id in Views.
Any help on this is appreciated.
Thanks.