when you enter a word with quote in the search box, query return mysql error, ie : liubov's
//search_search : search on Nom du Chien
$search_search = $this->getState('search.search');
$this->_addSearch('search', ' a.dname', 'like');
if (($search_search != '') && ($search_search_val = $this->_buildSearch('search', $search_search)))
$where[] = $search_search_val;
return:
WHERE (a.dname LIKE '%liubov's%') ORDER BY a.dname
( ! ) Warning: mysqli_num_rows() expects parameter 1 to be mysqli_result, boolean given in D:\wamp\www\Jbreeding2.5.0\libraries\joomla\database\database\mysqli.php on line 263
I saw the function _buildSearch in jmodel.list, but the $db->Quote("%%s%") does not seem to work with me.
I will check in the SandBox ...
Thx,
Marc
