cchiacchierini
Member
I was having the same problem as outlined in this thread: http://fabrikar.com/forums/index.php?threads/cannot-make-list-from-database-view.36830/ with the error:
Fabrik has generated an incorrect query for the list
Unknown column 'tablename.' in 'field list'
Via phpmyadmin, I checked the params field for the list in question in the xxx_fabrik_lists table and the last value was indeed "1". I then noticed that the primary key field was not defined for the list in question instead looking like this: "tablename.[blank]". Thus the error. I added a field name: "tablename.fieldname", and the list loaded without incident.
The question I have is this: I do not have any fields in this view that have unique values. As such, the field that I assigned in xxx_fabrik_lists via phpmyadmin is not a unique field. Is this going to cause me problems?
Sorry to bother you with a question about something that is solved and working.
J3.3.0
F3.1.1
Fabrik has generated an incorrect query for the list
Unknown column 'tablename.' in 'field list'
Via phpmyadmin, I checked the params field for the list in question in the xxx_fabrik_lists table and the last value was indeed "1". I then noticed that the primary key field was not defined for the list in question instead looking like this: "tablename.[blank]". Thus the error. I added a field name: "tablename.fieldname", and the list loaded without incident.
The question I have is this: I do not have any fields in this view that have unique values. As such, the field that I assigned in xxx_fabrik_lists via phpmyadmin is not a unique field. Is this going to cause me problems?
Sorry to bother you with a question about something that is solved and working.
J3.3.0
F3.1.1