Keyword

K2 Search - Issue - 0-Error:0

More
10 years 5 months ago #126421 by Alan
K2 Search - Issue - 0-Error:0 was created by Alan
Hello, I'm building a website, I installed K2, but now I have a problem; When I try to search something on the Search Field, it displays an error (0-Error:0).

"SQL=SELECT DISTINCT I.*, CASE WHEN I.MODIFIED = 0 THEN I.CREATED ELSE I.MODIFIED END AS LASTCHANGED, C.NAME AS CATEGORYNAME,C.ID AS CATEGORYID, C.ALIAS AS CATEGORYALIAS, C.PARAMS AS CATEGORYPARAMS FROM QX9JV_K2_ITEMS AS I RIGHT JOIN QX9JV_K2_CATEGORIES AS C ON C.ID = I.CATID WHERE I.PUBLISHED = 1 AND I.ACCESS IN(1,1) AND I.TRASH = 0 AND C.PUBLISHED = 1 AND C.ACCESS IN(1,1) AND C.TRASH = 0 AND ( I.PUBLISH_UP = '0000-00-00 00:00:00' OR I.PUBLISH_UP <= '2014-03-21 16:38:53' ) AND ( I.PUBLISH_DOWN = '0000-00-00 00:00:00' OR I.PUBLISH_DOWN >= '2014-03-21 16:38:53' ) AND MATCH(I.TITLE, I.INTROTEXT, I.`FULLTEXT`, I.IMAGE_CAPTION, I.IMAGE_CREDITS, I.VIDEO_CAPTION, I.VIDEO_CREDITS, I.METADESC, I.METAKEY) AGAINST ('""' IN BOOLEAN MODE) ORDER BY I.TITLE LIMIT 0, 10"

I really need some help.

Thanks so much in advance.

Please Log in or Create an account to join the conversation.

More
10 years 5 months ago #126422 by Lefteris
Replied by Lefteris on topic Re: K2 Search - Issue - 0-Error:0
Hi. Probably you are using an outdated version of K2. You can get the latest development build from getk2.org/assets/get/. Note that if you are using a very old version of K2, probably you will need to update your template overrides. In any case make a backup of your site first just in case something goes wrong.

JoomlaWorks Support Team
---
Please search the forum before posting a new topic :)

Please Log in or Create an account to join the conversation.


Powered by Kunena Forum