bascherz
Member
I have a list that has 3 inner joins:
I need the name and email element contents from #__users, which is the only reason that table is joined. However, if I publish either of those elements, I get this fun and familiar error:
If I unpublish all #__users elements, the list works, but then I don't have name or email in the list or in the form, and I need them. What causes this and is there some alternative method I could use if this is a problematic pair of tables?
Oh by the way...in the complete error message (which is very long), all the other element names have the full table name, not the #__ prefix and use the Fabrik placeholder syntax (in the error message). Also, if I publish both name and email, the error is for name. Then if I unpublish name, the error message is for email. I have to unpublish them both (defeating the purpose of joining the #__users table) in order for the list to work.
- #__comprofiler to #__users on user_id=id
- #__comprofiler to #__zipcodes on cb_zip=zip
- #__zipcodes to #__district_names on district=id
I need the name and email element contents from #__users, which is the only reason that table is joined. However, if I publish either of those elements, I get this fun and familiar error:
Code:
500 Fabrik has generated an incorrect query for the list Paused Volunteers: <br /><br /><pre>Unknown column '#__users.name' in 'field list'
If I unpublish all #__users elements, the list works, but then I don't have name or email in the list or in the form, and I need them. What causes this and is there some alternative method I could use if this is a problematic pair of tables?
Oh by the way...in the complete error message (which is very long), all the other element names have the full table name, not the #__ prefix and use the Fabrik placeholder syntax (in the error message). Also, if I publish both name and email, the error is for name. Then if I unpublish name, the error message is for email. I have to unpublish them both (defeating the purpose of joining the #__users table) in order for the list to work.
Last edited: