Hello everybody
After update search query plugin 1.3.0 -> 1.4.0
I have this error : "1064 You have an error in your SQL syntax ..... where () AND () AND () ORDER BY a.id DESC"
I check in debug mode and with the 1.3.0 version :
SELECT a.*, c.name, b.title
FROM #__mytable_applications AS a
LEFT JOIN #__mytable_offers AS b ON (a.offer = b.id)
LEFT JOIN #__mytable_statuses AS c ON (a.status = c.id) where a.lastname LIKE '%%'
AND a.firstname LIKE '%%'
AND b.title LIKE '%%'
ORDER BY a.id DESC
with the 1.4.0 version :
SELECT a.*, c.name, b.title
FROM #__mytable_applications AS a
LEFT JOIN #__mytable_offers AS b ON (a.offer = b.id)
LEFT JOIN #__mytable_statuses AS c ON (a.status = c.id) where () AND () AND () ORDER BY a.id DESC
and my query in the fied is :
SELECT a.*, c.name, b.title FROM #__mytable_applications AS a
LEFT JOIN #__mytable_offers AS b ON (a.offer = b.id)
LEFT JOIN #__mytable_statuses AS c ON (a.status = c.id)
where [MATCH]a.lastname||$uri->getValue('mytable_lastname')[/MATCH] AND
[MATCH]a.firstname||$uri->getValue('mytable_prenom')[/MATCH] AND
[MATCH]b.title||$uri->getValue('mytable_offre')[/MATCH]
ORDER BY a.id DESC
if somebody has an investagation way ...
Best regards
G;Bob
I can confirm the problem, MATCH replacements seems to be totally broken after 1.4. Please use older version until this is fixed.
Hi Klas
I do that ! ;)
Thank's
Hi all,
This issue seems to be still prevalent in Search Query 1.50. If no values are passed to the query it does not compensate putting in empty data and generated query throws MySQL error. I'm not an SQL expert but I do believe my query is not the issue. It works fine once I exclude [MATCH] or hard-code value for clause
I also don't think I can download the 1.30 version as I only bought it the other day. Can I get access to the 1.30 version as a result?
Is there an ETA on when this will be fixed?
Cheers,
Nick
Hi,
sorry, we don't have this info.
For older versions you need to go to the product download page, they are available at the bottom for active subscribers
Cheers, 1.30 version works properly!
Nick
Hello Klas
I check in all my post and for that one the problem is always there.
I installed version 1.50 / 1.51 and I still have the same error.
As soon as I put the 1.30 version all works fine.
Best regards
Please report this on the tracker linked above.