marcelf
Member
Hi all,
Im trying to use joomla search and already solved the fulltext problem. I converted my table to myisam.
But when I configure a databasejoin multilist element to be searched in List Filters I get a new error when I do a search (not happens with databasejoin drop). I already confirmed and repeat table is myisam.
<pre>You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '(SELECT GROUP_CONCAT(lookup.assunto SEPARATOR '//) AGAINST ('+realizacao*' IN B' at line 9</pre>
So anyone has any idea to solve this?
Thanks,
Marcel
Im trying to use joomla search and already solved the fulltext problem. I converted my table to myisam.
But when I configure a databasejoin multilist element to be searched in List Filters I get a new error when I do a search (not happens with databasejoin drop). I already confirmed and repeat table is myisam.
<pre>You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '(SELECT GROUP_CONCAT(lookup.assunto SEPARATOR '//) AGAINST ('+realizacao*' IN B' at line 9</pre>
So anyone has any idea to solve this?
Thanks,
Marcel