Problems with apostrophizes

[pascal7]

Hello, I have a problem with the system of search. When I make a search with apostrophizes > ' <, the system of search does not function !


Pascal

[federica]

Ho pascal,
I fix this bug in the next relase. I you want fix the bug yourself, change this file.
your_site/components/com_abook/models/search.php
line 157
From

Code Select Expand

$query->where('LOWER( a.title ) LIKE "%'.$this->getState('filter.search').'%"');

to

Code Select Expand

$query->where('LOWER( a.title ) LIKE "%'.$db->escape($this->getState('filter.search')).'%"');

[pascal7]

Ok, thank You, But i am using the joomla 2.5 version, sorry !

PLease ! Help me !

My website www.cheyne-editeur.com

Pascal

[federica]

your_site/components/com_abook/models/search.php
line 90
from:

Code Select Expand

$searchparamid['keyword']= "((a.title LIKE '%" .$this->getState('keyword') ."%') OR (a.subtitle LIKE '%" .$this->getState('keyword') ."%') OR (a.description LIKE '%" .$this->getState('keyword') ."%') OR (cat.title LIKE '%" .$this->getState('keyword') ."%') OR (a.catalogo LIKE '%" .$this->getState('keyword') ."%'))";

to:

Code Select Expand

$searchparamid['keyword']= "((a.title LIKE '%" .$db->escape($this->getState('keyword')) ."%') OR (a.subtitle LIKE '%" .$db->escape($this->getState('keyword')) ."%') OR (a.description LIKE '%" .$db->escape($this->getState('keyword')) ."%') OR (cat.title LIKE '%" .$db->escape($this->getState('keyword')) ."%') OR (a.catalogo LIKE '%" .$db->escape($this->getState('keyword')) ."%'))";

[pascal7]

Thank You but it's not ok...

Fatal error: Call to a member function escape() on a non-object in /homepages/5/d342551515/htdocs/cheyne/components/com_abook/models/search.php on line 90

Pascal

[federica]

Can you tell me both joomla version and abook version?
I installed joomla 2.5.18 and abook 2.0.4 and the search with apostrophizes works fine without modify anything.

[pascal7]

Joomla 2.5.9 and abook 2.0.4 ...