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