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
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
$query->where('LOWER( a.title ) LIKE "%'.$this->getState('filter.search').'%"');
to
$query->where('LOWER( a.title ) LIKE "%'.$db->escape($this->getState('filter.search')).'%"');
Ok, thank You, But i am using the joomla 2.5 version, sorry !
PLease ! Help me !
My website www.cheyne-editeur.com
Pascal
your_site/components/com_abook/models/search.php
line 90
from:
$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:
$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')) ."%'))";
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
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.
Joomla 2.5.9 and abook 2.0.4 ...
What search string does not work? Can you give me an example?
Hi !
Here, When you search the book "L'ignare" >> No result
And when you search "Ignare" >> The book with title "L'ignare" is found !
Pascal
How then I to make?
Just add this line:
$db = JFactory::getDbo();
after line 86.
Like this:
function getKey()
{
$db = JFactory::getDbo();
$searchparam = null;
...
It's not ok, Same Problem...
Hi !
Here,
www. cheyne-editeur.com/index.php/recherche-livre
When you search the book "L'ignare" >> No result
And when you search "Ignare" >> The book with title "L'ignare" is found !
Pascal
No solutions ?
It's very very importante for me !
It's not ok, Same Problem...
Here,
www. cheyne-editeur.com/index.php/recherche-livre
When you search the book "L'ignare" >> No result
And when you search "Ignare" >> The book with title "L'ignare" is found !
Pascal
Hi pascal7,
I already fixed the problem in the version 3.0.0
Hi,
It's not possible ton find the probleme in the 2.5 version ?
I can't upgrade Joomla 2.5 on 3.0 Now..
Can you help me ?
Pascal
Hi Pascal,
Abook for Joomla 2.5 is no longer developed.
I can not follow two versions at the same time, so I follow only the latest version.