dimoss
Well-Known Member
Hi
I have a dbjoin element which joins to the joomla users table. I use username both as value and label. This is ok as the username is unique. I have also used this element as search dropdown filter.
Using the latest github, when I perform a search using this filter I get error 500
"Fabrik has generated an incorrect query"
Unknown column 'AFG' in 'where clause'
In this example AFG is the username.
On the contrary when I perform a search using another dbjoin element where value and label is different then there is no problem.
In the previous github ver. (Nov. 20th) there is no problem at all.
Thanks!
I have a dbjoin element which joins to the joomla users table. I use username both as value and label. This is ok as the username is unique. I have also used this element as search dropdown filter.
Using the latest github, when I perform a search using this filter I get error 500
"Fabrik has generated an incorrect query"
Unknown column 'AFG' in 'where clause'
Code:
WHERE ( fab_plist.tournament IN (SELECT tournament_code FROM fab_organizers WHERE user_id = 33 AND code = YEAR(CURDATE())) OR fab_plist.tournament IN (SELECT id FROM fab_tournaments WHERE activation = 'Yes') ) AND ( `fab_plist`.`assoc` IN (AFG) )
In this example AFG is the username.
On the contrary when I perform a search using another dbjoin element where value and label is different then there is no problem.
In the previous github ver. (Nov. 20th) there is no problem at all.
Thanks!