83 Posts
CAF St Brieuc
7 years ago
Topic

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

Get a Book for SEBLOD
4229 Posts
Kadministrator
7 years ago
5
Level 1

I can confirm the problem, MATCH replacements seems to be totally broken after 1.4. Please use older version until this is fixed.

https://github.com/Octopoos/SEBLOD/issues/322

83 Posts
CAF St Brieuc
7 years ago
4
Level 2

Hi Klas

I do that ! ;)

Thank's

40 Posts
yoyoxp
6 years ago
3
Level 3

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

4229 Posts
Kadministrator
6 years ago
2
Level 4

Hi,

sorry, we don't have this info.

4229 Posts
Kadministrator
6 years ago
1
Level 5

For older versions you need to go to the product download page, they are available at the bottom for active subscribers

https://www.seblod.com/store/extensions/19157

40 Posts
yoyoxp
6 years ago
0
Level 6

Cheers, 1.30 version works properly!

Nick

83 Posts
CAF St Brieuc
6 years ago
2
Level 1

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

4229 Posts
Kadministrator
6 years ago
1
Level 2

Please report this on the tracker linked above.

83 Posts
CAF St Brieuc
6 years ago
0
Level 3

Bonjour Klas

c'est fait : Issue 457

Get a Book for SEBLOD