1. "Fabrik 4" helpers needed!

    You are invited to join other community members active in coding, maintaining and improving Fabrik. Please visit https://fabrik.help for more information!
    Dismiss Notice

Error List linked to mysql view

Discussion in 'Community' started by enrb, Dec 7, 2021.

  1. enrb

    enrb Member

    Level: Community
    Good morning,

    i am trying to create a list linked to a view created with mysql, however i always get this error in fabrik when i try to open the list:
    500 - Fabrik has generated an incorrect query for the list viewtable001: <br />
  2. lousyfool

    lousyfool Well-Known Member Staff Member

    Level: Community
    Fabrik lists need a Primary Key column. Does your view have that and is it specified in the list settings (data tab)?
    troester likes this.

Share This Page