Discussion Forum

Dear all,

I have one problem with the apostrophe: when I put  a title like

L'occupazione costiera

then the result in the frontend is

L\'occupazione costiera

is there any solution?

Thanks!!

There is a bug in the code regarding apostrophes, unfortunately I do not have time to fix it at the moment.

I hacked the component and it now works when entering references manually from admin backend. I can't check wether it works or not when importing a file.
If you allow users to enter references in frontend, same hack should apply in components/com_jombib/jombib.php for update and save functions (line 266, 702 and 763 I suppose)

3 lines to correct in administrator/components/com_jombib/admin.jombib.php

215 $updates[]=$key."='".mysql_real_escape_string($data)."'";
becomes
215 $updates[]=$key."='".$data."'";

642 $paper[$fieldsgiven]=ereg_replace('[{}]','',mysql_real_escape_string($valuesgiven));
becomes
642 $paper[$fieldsgiven]=ereg_replace('[{}]','',$valuesgiven);

704 $author[$afield]=ereg_replace('[{}]','',mysql_real_escape_string($avalues));
becomes
704 $author[$afield]=ereg_replace('[{}]','',$avalues);

Hope this helps ;)

Will this fix be included in the next version?
Are there any risks with using this change?

That is a sensible short term fix for the problem,  however it now means that if you try to enter a string which is not mysql safe, i.e. unusual characters ( I cannot remember which) then the data might not get added.

Cannot search including an apostrophe

Warning: Invalid argument supplied for foreach() in
../components/com_jombib/jombib.php on line 597