COM_FABRIK_JOIN_NO_PK message

[arcadeicons]

I keep getting this message on certain pages, no idea what it is, how do I get it to stop?

http://www.arcadeicons.com/index.php?option=com_jem&view=venue&id=9

 

[troester]

Are you really on J2.5/Fabrik3.0 (this forum)?

Did you include a Fabrik list in your jem site?
List is pointing to a MySQL view and you didn't define a column as PK?

 

[arcadeicons]

Are you really on J2.5/Fabrik3.0 (this forum)?

Did you include a Fabrik list in your jem site?
List is pointing to a MySQL view and you didn't define a column as PK?

Oops wrong forum. Weird I can't find any reference to a PK column anywhere, but yes my list is indeed pointing to a view.

 

[cheesegrits]

List settings, Data, Primary Key. It's what we then use as the 'rowid' to identify individual rows.

You need to include something in your view to use as the PK, typically the 'id' of the main table your view is built from, and manually point Fabrik's list settings at it. It must (like a "real" PK) be unique, so every row has it's own value. Normally when you create a Fabrik list from a table, we know what the PK is, because we ask MySQL and it tells us. But MySQL views don't have the concept of Primary Keys, so we can't do that when building a list on a view, and need you to tell us.

The other time this can be an issue is if you make a list join (even one built on a table) to a view, and you don't have a Fabrik list already built on that view. Same problem, we have no way of knowing the PK of the view, which we need to know when building the queries to read the data. So even if you don't use the view as it's own list and you only join to it, you still need to create a list from it and designate the PK, so we have that information when joining to the table.

-- hugh

 

[cheesegrits]

Moved thread to correct forum.

-- hugh

 

[arcadeicons]

Thanks, making a list of the view resolved the issue.