herve06
Member
Hello,
I have a bug in the cascadingDropDown plugin form in autocomplete.
Sometimes it works in dropdown but not in autocomplete.
After analyses logs, the error is in the SQL query called by ajax.
The result of the ajax query is (Error 501 ...):
As you can see in the like it do not use the alias but the name of the table :/ (t_adorga whereas t_adorga_0)
PS: More information: http://pastebin.com/3iBKvTvu
PPS: I use joomla2.5 so Fabrik3 git updated on 1st August
I have a bug in the cascadingDropDown plugin form in autocomplete.
Sometimes it works in dropdown but not in autocomplete.
After analyses logs, the error is in the SQL query called by ajax.
The result of the ajax query is (Error 501 ...):
Code:
Unknown column 't_adorga.ADORNAME' in 'where clause'
SQL=SELECT DISTINCT(`t_adorga_0`.`adorcode`) AS value, `t_adorga_0`.`ADORNAME`AS text
FROM `t_adorga` AS `t_adorga_0`
WHERE ORADCNCODEX IN ('FR')
AND t_adorga.`ADORNAME` LIKE '%c%' ORDER BY text ASC
As you can see in the like it do not use the alias but the name of the table :/ (t_adorga whereas t_adorga_0)
PS: More information: http://pastebin.com/3iBKvTvu
PPS: I use joomla2.5 so Fabrik3 git updated on 1st August