Hi,

My website suddenly gives an SQL error when I try to search on it. The error:

1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'AND published=1' at line 1 SQL=SELECT id FROM #__k2_tags WHERE LOWER(name) LIKE AND published=1

The website:
NVRO

I have no idea why this error is suddenly popping up and currently I have no idea how to fix it. I have googled a bunch but no one seems to have had this particular error

Hopefully someone here can help, many thanks in advance.

Hello,

Try reinstalling K2 (do NOT unistall it first).
If that does not work let me know.

Hi,

I have reinstalled K2 succesfully but the error still remains.

Hello,
I'm not expert but maybe you can try to disable searching in tags in k2 search plugin

Hi,

Disabling the tags in the K2 search plugin did solve the problem for now, so thank you for your input. However we obviously would like to keep searching in K2 tags because we do not add tags for no reason :)

So if anyone has a solution that let's us keep searching using K2 tags I'd gladly hear it.

@LTM Walter

What's your Joomla! version? Which K2 version are you using?

My Joomla version is 3.3.6

My K2 version is 2.6.9

Try to replace the file plugins/search/k2/k2.php with this file: github.com/joomlaworks/k2/blob/master/plugins/search/k2.php . Let me know if that solves your issue.

Hi,

This seems to have solved the issue! Thank you so much!

You 're welcome.