aijosh
Member
I keep getting a 500 error except I unpublish one of the userid.
LIST A
id, userid, post
LISTB
id, userid, postid, comment
I want the post and comments on a single list view so I created
LISTC (a copy of LIST A) then joined LISTB to it. id->postid
LISTC
id, userid, post, id, postid, comment
ISSUE:
When trying to load LISTC I get a 500 error. Says fabrik has generated an invalid query. <br/>
If I unpublish either one of the userid the list loads.
If I also remove the join, the LISTC loads without issues.
I guess fabrik doesn't understand why there can be two different userid in a list. Cos the "commenter" and the "poster" are not the same.
It's there a way to solve this?
LIST A
id, userid, post
LISTB
id, userid, postid, comment
I want the post and comments on a single list view so I created
LISTC (a copy of LIST A) then joined LISTB to it. id->postid
LISTC
id, userid, post, id, postid, comment
ISSUE:
When trying to load LISTC I get a 500 error. Says fabrik has generated an invalid query. <br/>
If I unpublish either one of the userid the list loads.
If I also remove the join, the LISTC loads without issues.
I guess fabrik doesn't understand why there can be two different userid in a list. Cos the "commenter" and the "poster" are not the same.
It's there a way to solve this?