HiOn my stained glass page I have J! 1.5.18, Joomfish 2.0.4, K2 v2.3 (SVN 19 May 2010). The original language is Polish, the translated one is English.Search module works perfect only with original language (Polish). Search in English works only with Jommla core articles, but not with K2 items. Is there any solution of this?regards Tomasz

Is it only my problem?

Hi. In order to get this work you need a JoomFish search plugin (Like the plugins JoomFish comes with for com_content). This is not included in K2. I think that someone has implemented it but i m not sure where i have seen it.

Thanks Lefteris

I posted your advice to Joomfish forum. They adviced me earlier to ask here :-)

regards Tomasz

I have that problem too... Works fine on the default language, and not at all on the second language...

So, there are two of us. So asking once more hoping that there is somebody who know the "K2 search JF plugin". And additionaly better K2 content translation table - with possibility of filtering the items by category, time etc.

regards Tomasz

No, we are not two of us - there are many people with this search problem. I have problem with Extra Field Module + Joomfish, too. Actually the problem is in the Joomfish integration, cos my site is working well in one language. Hope someone will find soon a solution!

Same problem.... any feedback by developers?
is this concerning Joomfish or K2?

silvena ralinova said:No, we are not two of us - there are many people with this search problem. I have problem with Extra Field Module + Joomfish, too. Actually the problem is in the Joomfish integration, cos my site is working well in one language. Hope someone will find soon a solution!

Hi guys,

I've just made the K2 Joomfish search plugin.

It works with K2 content searching for now.

Implementing tags & extrafields search.

Will come back soon with plugin upload & configuration instructions

Olivier

Hi all!

I also have the same problem. Please olivier, tell us something when you can, of course... Thanks in advance for the effor ;)

Best Regards!

Alberto.

Hi everyone,

In attachment the Joomfish K2 search plugin that actually only works with K2 content.

I'm working on the full version (content, tag & extrafields).

Olivier


Alberto Barajas said:Hi all!
I also have the same problem. Please olivier, tell us something when you can, of course... Thanks in advance for the effor ;)

Best Regards!

Alberto.

This plugin not working, see error:
No valid database connection 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 '' FROM #__k2_items AS i LEFT JOIN #__jf_content as jfc ON reference_id =' at line 14 SQL=SELECT i.title AS title, i.metadesc, i.metakey, c.name as section, i.image_caption, i.image_credits, i.video_caption, i.video_credits, i.extra_fields_search, i.created, CONCAT(i.introtext, i.fulltext) AS text, CASE WHEN CHAR_LENGTH(i.alias) THEN CONCAT_WS(':', i.id, i.alias) ELSE i.id END as slug, CASE WHEN CHAR_LENGTH(c.alias) THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as catslug, jfl.code AS jflang, jfl.name AS jflname' FROM #__k2_items AS i LEFT JOIN #__jf_content as jfc ON reference_id = i.id LEFT JOIN #__languages as jfl ON jfc.language_id = jfl.id INNER JOIN #__k2_categories AS c ON c.id=i.catid AND c.access <= 0 WHERE ((LOWER(jfc.value) LIKE '%search..%')) AND i.trash = 0 AND i.published = 1 AND i.access <= 0 AND c.published = 1 AND c.access <= 0 AND c.trash = 0 AND jfc.reference_table = 'k2_items' AND jfl.code = '' GROUP BY i.id ORDER BY i.created DESC LIMIT 0, 50

Olivier Nolbert : Can u help me? I'm using joomla 1,5,22 / Last k2 version 2.4.1 / Last joomfish verison 2,0,4 / Mysql: 5.1.41 / Php: 5.3.1 / Local web server: Apache/2.2.14 (Win32) DAV/2 mod_ssl/2.2.14 OpenSSL/0.9.8l mod_autoindex_color PHP/5.3.1 mod_apreq2-20090110/2.7.1 mod_perl/2.0.4 Perl/v5.10.1 (Xampp)

Hi FPrefix,

I'm checking the code asap today.

Olivier


Fprefix said:Olivier Nolbert : Can u help me? I'm using joomla 1,5,22 / Last k2 version 2.4.1 / Last joomfish verison 2,0,4 / Mysql: 5.1.41 / Php: 5.3.1 / Local web server: Apache/2.2.14 (Win32) DAV/2 mod_ssl/2.2.14 OpenSSL/0.9.8l mod_autoindex_color PHP/5.3.1 mod_apreq2-20090110/2.7.1 mod_perl/2.0.4 Perl/v5.10.1 (Xampp)

Thank u Olivier, i'l be waiting. +1 !


Olivier Nolbert said:Hi FPrefix,
I'm checking the code asap today.

Olivier

Hi everyone,

I've updated the Joomfish search plugin for K2 to v1.1.0 with tags & extra fields search features.

Download & details here

Olivier

Olivier Nolbert said:Hi everyone,
I've updated the Joomfish search plugin for K2 to v1.1.0 with tags & extra fields search features.

Download & details here

Olivier


Thank u Olivier +1!

But still i have error with syntax. Maybe when i upload web page to the host, this error will be hided?

Hi,

Just a question : Have you installed Joomfish before or after K2 ?

If you've installed it after, you have to copy the K2 joomfish translation files in the Joomfish translation folder :

- Unzip your K2 installation file
- Copy all unzipped files that are in 'administrator/components/com_joomfish/contentelements' to the same folder on your website.

Does it change something ?

Sincerely,

Olivier

Hi Dimitris,

Any url i can check ?

Olivier


Dimitris Mitrolios said:Unfortunately same ol' error code.. =(

Hi Olivier

just tried this plugin on the following

 

J v 1.5.22

Joomfish v 2.1.0

K2 v 2.5 SVN

 

I get a massive sql error which is similar to one of the posts above.

 

Have you done any further updates to this plugin ?

regards

Matthew