MY probleme is: i use Artio and Joomfish. They do not go along well... HELP ME PLEASE...

DB function failed with error number 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 jf_content.published=1 AND jf_content.reference_id IN(108) AND jf_cont' at line 4 SQL=SELECT jf_content.reference_field, jf_content.value, jf_content.reference_id, jf_content.original_value FROM jos_jf_content AS jf_content WHERE jf_content.language_id= AND jf_content.published=1 AND jf_content.reference_id IN(108) AND jf_content.reference_table='menu'

do you have any clue?

matesz-design.com

Hello,

could you please specify which versions of Joomla, JoomSEF and JoomFish you are using and when this error happens?

Best regards,
ARTIO Support Team

I do have exactly the same problem.
i am using joomla 1.0.15 and joomfish 1.8.2 and joomsef 2.2.6

I have these errors when i try to create a new account or when i am looking at a profile.... i think it is around community builder.

and, If I disable the module "joomfish language selection" the site works perfect.

I had already test so many things and still have the problem. Please, some help would be really great.
Regards

I had tried this solution found on another forum


Hi!: here is one solution found on the Artio.net forum:
-open the file : components/com_joomfish/includes/joomfish.class.php
and edit this line (line 364) :
WHERE jf_content.language_id=".$languages[$language]->id

-change the line as follows :
WHERE jf_content.language_id=".( $languages[$language]->id!=0 ? $languages[$language]->id : 2)
It should work. (At least it worked on my website with JF 1.8.2 and Joomsef 2.2.1




but i have this error message:

Error: headers already sent in joomfish.class.php on line 1155.
Stopped at line 887 in joomsef.php: HEADERS ALREADY SENT (200)
URL=www.kyomi.froption=com_frontpage&Itemid=1:
OPTION=com_frontpage:


PPLEASEEEE, it is really urgent, i don't know what to do.

Thanks you so much for help.

Hello,

I think the "headers already sent" error is caused simply by leaving an extra blank line at the end of joomfish.class.php file. Removing the extra line should fix it. Or see line 1155 if there's anything printed to output buffer.

Best regards,
ARTIO Support Team