Ajax search not working

[dylanhf]

Hi

I have installed prestashop 1.5.5.0 & default theme at

http://new.triotest.com.au/shop/

The ajax search is turned on but it's not doing anything.. am I missing something obvious?

Thanks
Dylan

[vekia]

you've got AJAX serach feature turned ON ? can you, for test purposes, use search block and disable search field in top menu ?

[dylanhf]

Thanks Vekia.. yes Ajax search feature was turned on - adding the search block instead of the search field in the top menu works ! :-) I should be able to take it from here.. thought it must have been something obvious I was missing !

[ajensen27]

I'm having the same issue. I enabled the search block as well but that search bar didn't work either. It just keeps bringing me back to my sites homepage.

 

Vekia, could you take a look? www (dot) llmedico (dot) com

[ajensen27]

Looks like I'm not the only one with this issue.

 

http://forge.prestashop.com/browse/PSCFV-10163

[dylanhf]

Ajensen27 - looks like you have the same problem I did ..

the fix for me was to turn on the "Quick search block" module .. then configure the 'top horizontal menu' module and turn off the 'search box' checkbox - that one doesn't have the ajax capability.

Hope that does the trick for you!

[vekia]

as far as i remember search in top horizontal menu has got little issue, can you turn on quick search module ?
then we will move it to the place, where you've got it now it will looks the same

[benjamin utterback]

as far as i remember search in top horizontal menu has got little issue, can you turn on quick search module ?

then we will move it to the place, where you've got it now it will looks the same

 

Hi vekia, is there a forge report about this that I can use to report to our team. I can't seem to find it. 

 

Overall, (sorry to go off topic) but we are looking to fix remaining bugs on the 1.5.5 version and it's modules. 

[ajensen27]

Thanks guys!... I tried this yesterday. I turned on the quick search module and it was doing the same thing. But I just enabled it again, turned off the search on the top block menu, and changed the position of the top search block so that it fits nicely in the top block menu.

 

But as you can see, the search still isn't working.

[vekia]

Hi vekia, is there a forge report about this that I can use to report to our team. I can't seem to find it. 

 

Overall, (sorry to go off topic) but we are looking to fix remaining bugs on the 1.5.5 version and it's modules. 

Hello Benjamin

Do you remember this error: http://www.prestashop.com/forums/topic/264409-solved-search-part-is-changed-the-place

i just thought that this may be related to this one, but as we can see - it isnt

[ajensen27]

Benjamin, no one is answering on the forge issue page and I don't see any updates on here. Is this being addressed?

 

http://forge.prestashop.com/browse/PSCFV-10163

 

Thanks,

Alex

[benjamin utterback]

Hi ajensen27, do you use godaddy as a hosting provider as well? 

[benjamin utterback]

Benjamin, no one is answering on the forge issue page and I don't see any updates on here. Is this being addressed?

 

http://forge.prestashop.com/browse/PSCFV-10163

 

Thanks,

Alex

 

 

Have you tried to turn "Disable apache multiviews" to "Yes" in the Backoffice/Preferences/SEO and URLs?

 

Try that and let me know if it works. Thank you!

[ajensen27]

Hi Benjamin,

 

Hi ajensen27, do you use godaddy as a hosting provider as well? 

 

No I do not use GoDaddy. I am on a VPS.

 

Have you tried to turn "Disable apache multiviews" to "Yes" in the Backoffice/Preferences/SEO and URLs?

 

Try that and let me know if it works. Thank you!

 

Disable apache multiviews is already turned on on my backend.

 

Thanks,

Alex

[benjamin utterback]

Hi Benjamin,

 

 

No I do not use GoDaddy. I am on a VPS.

 

 

Disable apache multiviews is already turned on on my backend.

 

Thanks,

Alex

 

 

No Error is thrown when you turn on error reporting? Could you tell me your upgrade history of versions? ie: 1.5.4.1 to 1.5.5 

[benjamin utterback]

Hi Benjamin,

 

 

No I do not use GoDaddy. I am on a VPS.

 

 

Disable apache multiviews is already turned on on my backend.

 

Thanks,

Alex

 

 

Are you on a windows server?

[ajensen27]

Nope, no errors are thrown when I turn on error reporting.

 

Not sure if this is an error or not but this shows up in my Chrome console after I try a search.

 

 

The only upgrade I ever did was from 1.5.1 to 1.5.2.

Are you on a windows server?

 

Nope. See below.

 

Server information

Server information: Linux #1 SMP Tue Apr 23 19:29:00 UTC 2013 x86_64

Server software version: Apache/2

PHP version: 5.3.24

Memory limit: 128M

Max execution time: 1000

[benjamin utterback]

Nope, no errors are thrown when I turn on error reporting.

 

Not sure if this is an error or not but this shows up in my Chrome console after I try a search.

 

 

The only upgrade I ever did was from 1.5.1 to 1.5.2.

 

Nope. See below.

 

Server information

Server information: Linux #1 SMP Tue Apr 23 19:29:00 UTC 2013 x86_64

Server software version: Apache/2

PHP version: 5.3.24

Memory limit: 128M

Max execution time: 1000

 

 

I received an error for clicktale. On the console, it was a javascript error. I am not sure that this is relevant but does clicktale ring a bell?

[ajensen27]

I received an error for clicktale. On the console, it was a javascript error. I am not sure that this is relevant but does clicktale ring a bell?

 

Interesting. I was testing out their service, in-page web analytics, and must have left the code in there. Removing it now and hopefully that solves my issue.

[ajensen27]

Ok, removed that ClickTale code and it's still not working.

[benjamin utterback]

Ok, removed that ClickTale code and it's still not working.

 

 

Can you send me your classes/search.php

[ajensen27]

<?php

/*

* 2007-2012 PrestaShop

*

* NOTICE OF LICENSE

*

* This source file is subject to the Open Software License (OSL 3.0)

* that is bundled with this package in the file LICENSE.txt.

* It is also available through the world-wide-web at this URL:

* http://opensource.org/licenses/osl-3.0.php

* If you did not receive a copy of the license and are unable to

* obtain it through the world-wide-web, please send an email

* to [email protected] so we can send you a copy immediately.

*

* DISCLAIMER

*

* Do not edit or add to this file if you wish to upgrade PrestaShop to newer

* versions in the future. If you wish to customize PrestaShop for your

* needs please refer to http://www.prestashop.com for more information.

*

* @author PrestaShop SA <[email protected]>

* @copyright 2007-2012 PrestaShop SA

* @version Release: $Revision: 7489 $

* @license http://opensource.org/licenses/osl-3.0.php Open Software License (OSL 3.0)

* International Registered Trademark & Property of PrestaShop SA

*/

 

define('PS_SEARCH_MAX_WORD_LENGTH', 15);

 

/* Copied from Drupal search module, except for \x{0}-\x{2f} that has been replaced by \x{0}-\x{2c}\x{2e}-\x{2f} in order to keep the char '-' */

define('PREG_CLASS_SEARCH_EXCLUDE',

'\x{0}-\x{2c}\x{2e}-\x{2f}\x{3a}-\x{40}\x{5b}-\x{60}\x{7b}-\x{bf}\x{d7}\x{f7}\x{2b0}-'.

'\x{385}\x{387}\x{3f6}\x{482}-\x{489}\x{559}-\x{55f}\x{589}-\x{5c7}\x{5f3}-'.

'\x{61f}\x{640}\x{64b}-\x{65e}\x{66a}-\x{66d}\x{670}\x{6d4}\x{6d6}-\x{6ed}'.

'\x{6fd}\x{6fe}\x{700}-\x{70f}\x{711}\x{730}-\x{74a}\x{7a6}-\x{7b0}\x{901}-'.

'\x{903}\x{93c}\x{93e}-\x{94d}\x{951}-\x{954}\x{962}-\x{965}\x{970}\x{981}-'.

'\x{983}\x{9bc}\x{9be}-\x{9cd}\x{9d7}\x{9e2}\x{9e3}\x{9f2}-\x{a03}\x{a3c}-'.

'\x{a4d}\x{a70}\x{a71}\x{a81}-\x{a83}\x{abc}\x{abe}-\x{acd}\x{ae2}\x{ae3}'.

'\x{af1}-\x{b03}\x{b3c}\x{b3e}-\x{b57}\x{b70}\x{b82}\x{bbe}-\x{bd7}\x{bf0}-'.

'\x{c03}\x{c3e}-\x{c56}\x{c82}\x{c83}\x{cbc}\x{cbe}-\x{cd6}\x{d02}\x{d03}'.

'\x{d3e}-\x{d57}\x{d82}\x{d83}\x{dca}-\x{df4}\x{e31}\x{e34}-\x{e3f}\x{e46}-'.

'\x{e4f}\x{e5a}\x{e5b}\x{eb1}\x{eb4}-\x{ebc}\x{ec6}-\x{ecd}\x{f01}-\x{f1f}'.

'\x{f2a}-\x{f3f}\x{f71}-\x{f87}\x{f90}-\x{fd1}\x{102c}-\x{1039}\x{104a}-'.

'\x{104f}\x{1056}-\x{1059}\x{10fb}\x{10fc}\x{135f}-\x{137c}\x{1390}-\x{1399}'.

'\x{166d}\x{166e}\x{1680}\x{169b}\x{169c}\x{16eb}-\x{16f0}\x{1712}-\x{1714}'.

'\x{1732}-\x{1736}\x{1752}\x{1753}\x{1772}\x{1773}\x{17b4}-\x{17db}\x{17dd}'.

'\x{17f0}-\x{180e}\x{1843}\x{18a9}\x{1920}-\x{1945}\x{19b0}-\x{19c0}\x{19c8}'.

'\x{19c9}\x{19de}-\x{19ff}\x{1a17}-\x{1a1f}\x{1d2c}-\x{1d61}\x{1d78}\x{1d9b}-'.

'\x{1dc3}\x{1fbd}\x{1fbf}-\x{1fc1}\x{1fcd}-\x{1fcf}\x{1fdd}-\x{1fdf}\x{1fed}-'.

'\x{1fef}\x{1ffd}-\x{2070}\x{2074}-\x{207e}\x{2080}-\x{2101}\x{2103}-\x{2106}'.

'\x{2108}\x{2109}\x{2114}\x{2116}-\x{2118}\x{211e}-\x{2123}\x{2125}\x{2127}'.

'\x{2129}\x{212e}\x{2132}\x{213a}\x{213b}\x{2140}-\x{2144}\x{214a}-\x{2b13}'.

'\x{2ce5}-\x{2cff}\x{2d6f}\x{2e00}-\x{3005}\x{3007}-\x{303b}\x{303d}-\x{303f}'.

'\x{3099}-\x{309e}\x{30a0}\x{30fb}\x{30fd}\x{30fe}\x{3190}-\x{319f}\x{31c0}-'.

'\x{31cf}\x{3200}-\x{33ff}\x{4dc0}-\x{4dff}\x{a015}\x{a490}-\x{a716}\x{a802}'.

'\x{E000}-\x{F8FF}\x{FB29}\x{FD3E}-\x{FD3F}\x{FDFC}-\x{FDFD}'.

'\x{fd3f}\x{fdfc}-\x{fe6b}\x{feff}-\x{ff0f}\x{ff1a}-\x{ff20}\x{ff3b}-\x{ff40}'.

'\x{ff5b}-\x{ff65}\x{ff70}\x{ff9e}\x{ff9f}\x{ffe0}-\x{fffd}');

 

define('PREG_CLASS_NUMBERS',

'\x{30}-\x{39}\x{b2}\x{b3}\x{b9}\x{bc}-\x{be}\x{660}-\x{669}\x{6f0}-\x{6f9}'.

'\x{966}-\x{96f}\x{9e6}-\x{9ef}\x{9f4}-\x{9f9}\x{a66}-\x{a6f}\x{ae6}-\x{aef}'.

'\x{b66}-\x{b6f}\x{be7}-\x{bf2}\x{c66}-\x{c6f}\x{ce6}-\x{cef}\x{d66}-\x{d6f}'.

'\x{e50}-\x{e59}\x{ed0}-\x{ed9}\x{f20}-\x{f33}\x{1040}-\x{1049}\x{1369}-'.

'\x{137c}\x{16ee}-\x{16f0}\x{17e0}-\x{17e9}\x{17f0}-\x{17f9}\x{1810}-\x{1819}'.

'\x{1946}-\x{194f}\x{2070}\x{2074}-\x{2079}\x{2080}-\x{2089}\x{2153}-\x{2183}'.

'\x{2460}-\x{249b}\x{24ea}-\x{24ff}\x{2776}-\x{2793}\x{3007}\x{3021}-\x{3029}'.

'\x{3038}-\x{303a}\x{3192}-\x{3195}\x{3220}-\x{3229}\x{3251}-\x{325f}\x{3280}-'.

'\x{3289}\x{32b1}-\x{32bf}\x{ff10}-\x{ff19}');

 

define('PREG_CLASS_PUNCTUATION',

'\x{21}-\x{23}\x{25}-\x{2a}\x{2c}-\x{2f}\x{3a}\x{3b}\x{3f}\x{40}\x{5b}-\x{5d}'.

'\x{5f}\x{7b}\x{7d}\x{a1}\x{ab}\x{b7}\x{bb}\x{bf}\x{37e}\x{387}\x{55a}-\x{55f}'.

'\x{589}\x{58a}\x{5be}\x{5c0}\x{5c3}\x{5f3}\x{5f4}\x{60c}\x{60d}\x{61b}\x{61f}'.

'\x{66a}-\x{66d}\x{6d4}\x{700}-\x{70d}\x{964}\x{965}\x{970}\x{df4}\x{e4f}'.

'\x{e5a}\x{e5b}\x{f04}-\x{f12}\x{f3a}-\x{f3d}\x{f85}\x{104a}-\x{104f}\x{10fb}'.

'\x{1361}-\x{1368}\x{166d}\x{166e}\x{169b}\x{169c}\x{16eb}-\x{16ed}\x{1735}'.

'\x{1736}\x{17d4}-\x{17d6}\x{17d8}-\x{17da}\x{1800}-\x{180a}\x{1944}\x{1945}'.

'\x{2010}-\x{2027}\x{2030}-\x{2043}\x{2045}-\x{2051}\x{2053}\x{2054}\x{2057}'.

'\x{207d}\x{207e}\x{208d}\x{208e}\x{2329}\x{232a}\x{23b4}-\x{23b6}\x{2768}-'.

'\x{2775}\x{27e6}-\x{27eb}\x{2983}-\x{2998}\x{29d8}-\x{29db}\x{29fc}\x{29fd}'.

'\x{3001}-\x{3003}\x{3008}-\x{3011}\x{3014}-\x{301f}\x{3030}\x{303d}\x{30a0}'.

'\x{30fb}\x{fd3e}\x{fd3f}\x{fe30}-\x{fe52}\x{fe54}-\x{fe61}\x{fe63}\x{fe68}'.

'\x{fe6a}\x{fe6b}\x{ff01}-\x{ff03}\x{ff05}-\x{ff0a}\x{ff0c}-\x{ff0f}\x{ff1a}'.

'\x{ff1b}\x{ff1f}\x{ff20}\x{ff3b}-\x{ff3d}\x{ff3f}\x{ff5b}\x{ff5d}\x{ff5f}-'.

'\x{ff65}');

 

/**

* Matches all CJK characters that are candidates for auto-splitting

* (Chinese, Japanese, Korean).

* Contains kana and BMP ideographs.

*/

define('PREG_CLASS_CJK', '\x{3041}-\x{30ff}\x{31f0}-\x{31ff}\x{3400}-\x{4db5}\x{4e00}-\x{9fbb}\x{f900}-\x{fad9}');

 

class SearchCore

{

public static function sanitize($string, $id_lang, $indexation = false)

{

$string = Tools::strtolower(strip_tags($string));

$string = html_entity_decode($string, ENT_NOQUOTES, 'utf-8');

 

$string = preg_replace('/(['.PREG_CLASS_NUMBERS.']+)['.PREG_CLASS_PUNCTUATION.']+(?=['.PREG_CLASS_NUMBERS.'])/u', '\1', $string);

$string = preg_replace('/['.PREG_CLASS_SEARCH_EXCLUDE.']+/u', ' ', $string);

 

if ($indexation)

$string = preg_replace('/[._-]+/', '', $string);

else

{

$string = preg_replace('/[._]+/', '', $string);

$string = ltrim(preg_replace('/([^ ])-/', '$1', ' '.$string));

$string = preg_replace('/[._]+/', '', $string);

$string = preg_replace('/[^\s]-+/', '', $string);

}

 

$blacklist = Configuration::get('PS_SEARCH_BLACKLIST', $id_lang);

if (!empty($blacklist))

{

$string = preg_replace('/(?<=\s)('.$blacklist.')(?=\s)/Su', '', $string);

$string = preg_replace('/^('.$blacklist.')(?=\s)/Su', '', $string);

$string = preg_replace('/(?<=\s)('.$blacklist.')$/Su', '', $string);

$string = preg_replace('/^('.$blacklist.')$/Su', '', $string);

}

 

if (!$indexation)

{

$words = explode(' ', $string);

$processed_words = array();

// search for aliases for each word of the query

foreach ($words as $word)

{

$alias = new Alias(null, $word);

if (Validate::isLoadedObject($alias))

$processed_words[] = $alias->search;

else

$processed_words[] = $word;

}

$string = implode(' ', $processed_words);

}

 

if ($indexation)

{

$minWordLen = (int)Configuration::get('PS_SEARCH_MINWORDLEN');

if ($minWordLen > 1)

{

$minWordLen -= 1;

$string = preg_replace('/(?<=\s)[^\s]{1,'.$minWordLen.'}(?=\s)/Su', ' ', $string);

$string = preg_replace('/^[^\s]{1,'.$minWordLen.'}(?=\s)/Su', '', $string);

$string = preg_replace('/(?<=\s)[^\s]{1,'.$minWordLen.'}$/Su', '', $string);

$string = preg_replace('/^[^\s]{1,'.$minWordLen.'}$/Su', '', $string);

}

}

 

$string = trim(preg_replace('/\s+/', ' ', $string));

return $string;

}

 

public static function find($id_lang, $expr, $page_number = 1, $page_size = 1, $order_by = 'position',

$order_way = 'desc', $ajax = false, $use_cookie = true, Context $context = null)

{

if (!$context)

$context = Context::getContext();

$db = Db::getInstance(_PS_USE_SQL_SLAVE_);

 

// Only use cookie if id_customer is not present

if ($use_cookie)

$id_customer = $context->customer->id;

else

$id_customer = 0;

 

// TODO : smart page management

if ($page_number < 1) $page_number = 1;

if ($page_size < 1) $page_size = 1;

 

if (!Validate::isOrderBy($order_by) || !Validate::isOrderWay($order_way))

return false;

 

$intersect_array = array();

$score_array = array();

$words = explode(' ', Search::sanitize($expr, $id_lang));

 

foreach ($words as $key => $word)

if (!empty($word) && strlen($word) >= (int)Configuration::get('PS_SEARCH_MINWORDLEN'))

{

$word = str_replace('%', '\\%', $word);

$word = str_replace('_', '\\_', $word);

$intersect_array[] = 'SELECT si.id_product

FROM '._DB_PREFIX_.'search_word sw

LEFT JOIN '._DB_PREFIX_.'search_index si ON sw.id_word = si.id_word

WHERE sw.id_lang = '.(int)$id_lang.'

AND sw.id_shop = '.$context->shop->id.'

AND sw.word LIKE

'.($word[0] == '-'

? ' \''.pSQL(Tools::substr($word, 1, PS_SEARCH_MAX_WORD_LENGTH)).'%\''

: '\''.pSQL(Tools::substr($word, 0, PS_SEARCH_MAX_WORD_LENGTH)).'%\''

);

 

if ($word[0] != '-')

$score_array[] = 'sw.word LIKE \''.pSQL(Tools::substr($word, 0, PS_SEARCH_MAX_WORD_LENGTH)).'%\'';

}

else

unset($words[$key]);

 

if (!count($words))

return ($ajax ? array() : array('total' => 0, 'result' => array()));

 

$score = '';

if (count($score_array))

$score = ',(

SELECT SUM(weight)

FROM '._DB_PREFIX_.'search_word sw

LEFT JOIN '._DB_PREFIX_.'search_index si ON sw.id_word = si.id_word

WHERE sw.id_lang = '.(int)$id_lang.'

AND sw.id_shop = '.$context->shop->id.'

AND si.id_product = p.id_product

AND ('.implode(' OR ', $score_array).')

) position';

 

$sql = 'SELECT cp.`id_product`

FROM `'._DB_PREFIX_.'category_group` cg

INNER JOIN `'._DB_PREFIX_.'category_product` cp ON cp.`id_category` = cg.`id_category`

INNER JOIN `'._DB_PREFIX_.'category` c ON cp.`id_category` = c.`id_category`

INNER JOIN `'._DB_PREFIX_.'product` p ON cp.`id_product` = p.`id_product`

'.Shop::addSqlAssociation('product', 'p', false).'

WHERE c.`active` = 1

AND product_shop.`active` = 1

AND product_shop.`visibility` IN ("both", "search")

AND product_shop.indexed = 1

AND cg.`id_group` '.(!$id_customer ? '= 1' : 'IN (

SELECT id_group FROM '._DB_PREFIX_.'customer_group

WHERE id_customer = '.(int)$id_customer.'

)');

$results = $db->executeS($sql);

 

$eligible_products = array();

foreach ($results as $row)

$eligible_products[] = $row['id_product'];

foreach ($intersect_array as $query)

{

$eligible_products2 = array();

foreach ($db->executeS($query) as $row)

$eligible_products2[] = $row['id_product'];

 

$eligible_products = array_intersect($eligible_products, $eligible_products2);

if (!count($eligible_products))

return ($ajax ? array() : array('total' => 0, 'result' => array()));

}

 

$eligible_products = array_unique($eligible_products);

 

$product_pool = '';

foreach ($eligible_products as $id_product)

if ($id_product)

$product_pool .= (int)$id_product.',';

if (empty($product_pool))

return ($ajax ? array() : array('total' => 0, 'result' => array()));

$product_pool = ((strpos($product_pool, ',') === false) ? (' = '.(int)$product_pool.' ') : (' IN ('.rtrim($product_pool, ',').') '));

 

if ($ajax)

{

$sql = 'SELECT DISTINCT p.id_product, pl.name pname, cl.name cname,

cl.link_rewrite crewrite, pl.link_rewrite prewrite '.$score.'

FROM '._DB_PREFIX_.'product p

INNER JOIN `'._DB_PREFIX_.'product_lang` pl ON (

p.`id_product` = pl.`id_product`

AND pl.`id_lang` = '.(int)$id_lang.Shop::addSqlRestrictionOnLang('pl').'

)

'.Shop::addSqlAssociation('product', 'p').'

INNER JOIN `'._DB_PREFIX_.'category_lang` cl ON (

product_shop.`id_category_default` = cl.`id_category`

AND cl.`id_lang` = '.(int)$id_lang.Shop::addSqlRestrictionOnLang('cl').'

)

WHERE p.`id_product` '.$product_pool.'

ORDER BY position DESC LIMIT 10';

return $db->executeS($sql);

}

 

if (strpos($order_by, '.') > 0)

{

$order_by = explode('.', $order_by);

$order_by = pSQL($order_by[0]).'.`'.pSQL($order_by[1]).'`';

}

$alias = '';

if ($order_by == 'price')

$alias = 'product_shop.';

$sql = 'SELECT p.*, product_shop.*, stock.out_of_stock, IFNULL(stock.quantity, 0) as quantity,

pl.`description_short`, pl.`available_now`, pl.`available_later`, pl.`link_rewrite`, pl.`name`,

tax.`rate`, image_shop.`id_image`, il.`legend`, m.`name` manufacturer_name '.$score.',

DATEDIFF(

p.`date_add`,

DATE_SUB(

NOW(),

INTERVAL '.(Validate::isUnsignedInt(Configuration::get('PS_NB_DAYS_NEW_PRODUCT')) ? Configuration::get('PS_NB_DAYS_NEW_PRODUCT') : 20).' DAY

)

) > 0 new

FROM '._DB_PREFIX_.'product p

'.Shop::addSqlAssociation('product', 'p').'

INNER JOIN `'._DB_PREFIX_.'product_lang` pl ON (

p.`id_product` = pl.`id_product`

AND pl.`id_lang` = '.(int)$id_lang.Shop::addSqlRestrictionOnLang('pl').'

)

LEFT JOIN `'._DB_PREFIX_.'tax_rule` tr ON (product_shop.`id_tax_rules_group` = tr.`id_tax_rules_group`

AND tr.`id_country` = '.(int)$context->country->id.'

AND tr.`id_state` = 0)

LEFT JOIN `'._DB_PREFIX_.'tax` tax ON (tax.`id_tax` = tr.`id_tax`)

LEFT JOIN `'._DB_PREFIX_.'manufacturer` m ON m.`id_manufacturer` = p.`id_manufacturer`

LEFT JOIN `'._DB_PREFIX_.'image` i ON (i.`id_product` = p.`id_product`)'.

Shop::addSqlAssociation('image', 'i', false, 'image_shop.cover=1').'

LEFT JOIN `'._DB_PREFIX_.'image_lang` il ON (i.`id_image` = il.`id_image` AND il.`id_lang` = '.(int)$id_lang.')

'.Product::sqlStock('p', 0).'

WHERE p.`id_product` '.$product_pool.'

AND ((image_shop.id_image IS NOT NULL OR i.id_image IS NULL) OR (image_shop.id_image IS NULL AND i.cover=1))

'.($order_by ? 'ORDER BY '.$alias.$order_by : '').($order_way ? ' '.$order_way : '').'

LIMIT '.(int)(($page_number - 1) * $page_size).','.(int)$page_size;

$result = $db->executeS($sql);

 

$sql = 'SELECT COUNT(*)

FROM '._DB_PREFIX_.'product p

'.Shop::addSqlAssociation('product', 'p').'

INNER JOIN `'._DB_PREFIX_.'product_lang` pl ON (

p.`id_product` = pl.`id_product`

AND pl.`id_lang` = '.(int)$id_lang.Shop::addSqlRestrictionOnLang('pl').'

)

LEFT JOIN `'._DB_PREFIX_.'tax_rule` tr ON (product_shop.`id_tax_rules_group` = tr.`id_tax_rules_group`

AND tr.`id_country` = '.(int)Context::getContext()->country->id.'

AND tr.`id_state` = 0)

LEFT JOIN `'._DB_PREFIX_.'tax` tax ON (tax.`id_tax` = tr.`id_tax`)

LEFT JOIN `'._DB_PREFIX_.'manufacturer` m ON m.`id_manufacturer` = p.`id_manufacturer`

LEFT JOIN `'._DB_PREFIX_.'image` i ON (i.`id_product` = p.`id_product`)'.

Shop::addSqlAssociation('image', 'i', false, 'image_shop.cover=1').'

LEFT JOIN `'._DB_PREFIX_.'image_lang` il ON (i.`id_image` = il.`id_image` AND il.`id_lang` = '.(int)$id_lang.')

WHERE p.`id_product` '.$product_pool.'

AND ((image_shop.id_image IS NOT NULL OR i.id_image IS NULL) OR (image_shop.id_image IS NULL AND i.cover=1))';

$total = $db->getValue($sql);

 

if (!$result)

$result_properties = false;

else

$result_properties = Product::getProductsProperties((int)$id_lang, $result);

 

return array('total' => $total,'result' => $result_properties);

}

 

public static function getTags($db, $id_product, $id_lang)

{

$tags = '';

$tagsArray = $db->executeS('

SELECT t.name FROM '._DB_PREFIX_.'product_tag pt

LEFT JOIN '._DB_PREFIX_.'tag t ON (pt.id_tag = t.id_tag AND t.id_lang = '.(int)$id_lang.')

WHERE pt.id_product = '.(int)$id_product);

foreach ($tagsArray as $tag)

$tags .= $tag['name'].' ';

return $tags;

}

 

public static function getAttributes($db, $id_product, $id_lang)

{

if (!Combination::isFeatureActive())

return '';

 

$attributes = '';

$attributesArray = $db->executeS('

SELECT al.name FROM '._DB_PREFIX_.'product_attribute pa

INNER JOIN '._DB_PREFIX_.'product_attribute_combination pac ON pa.id_product_attribute = pac.id_product_attribute

INNER JOIN '._DB_PREFIX_.'attribute_lang al ON (pac.id_attribute = al.id_attribute AND al.id_lang = '.(int)$id_lang.')

'.Shop::addSqlAssociation('product_attribute', 'pa').'

WHERE pa.id_product = '.(int)$id_product);

foreach ($attributesArray as $attribute)

$attributes .= $attribute['name'].' ';

return $attributes;

}

 

public static function getFeatures($db, $id_product, $id_lang)

{

if (!Feature::isFeatureActive())

return '';

 

$features = '';

$featuresArray = $db->executeS('

SELECT fvl.value FROM '._DB_PREFIX_.'feature_product fp

LEFT JOIN '._DB_PREFIX_.'feature_value_lang fvl ON (fp.id_feature_value = fvl.id_feature_value AND fvl.id_lang = '.(int)$id_lang.')

WHERE fp.id_product = '.(int)$id_product);

foreach ($featuresArray as $feature)

$features .= $feature['value'].' ';

return $features;

}

 

protected static function getProductsToIndex($total_languages, $id_product = false, $limit = 50)

{

// Adjust the limit to get only "whole" products, in every languages (and at least one)

$max_possibilities = $total_languages * count(Shop::getShops(true));

$limit = max(1, floor($limit / $max_possibilities) * $max_possibilities);

 

return Db::getInstance()->executeS('

SELECT p.id_product, pl.id_lang, pl.id_shop, pl.name pname, p.reference, p.ean13, p.upc,

pl.description_short, pl.description, cl.name cname, m.name mname

FROM '._DB_PREFIX_.'product p

LEFT JOIN '._DB_PREFIX_.'product_lang pl

ON p.id_product = pl.id_product

'.Shop::addSqlAssociation('product', 'p').'

LEFT JOIN '._DB_PREFIX_.'category_lang cl

ON (cl.id_category = product_shop.id_category_default AND pl.id_lang = cl.id_lang AND cl.id_shop = product_shop.id_shop)

LEFT JOIN '._DB_PREFIX_.'manufacturer m

ON m.id_manufacturer = p.id_manufacturer

WHERE product_shop.indexed = 0

AND product_shop.visibility IN ("both", "search")

'.($id_product ? 'AND p.id_product = '.(int)$id_product : '').'

LIMIT '.(int)$limit

);

}

 

public static function indexation($full = false, $id_product = false)

{

$db = Db::getInstance();

 

if ($id_product)

$full = false;

 

if ($full)

{

$db->execute('TRUNCATE '._DB_PREFIX_.'search_index');

$db->execute('TRUNCATE '._DB_PREFIX_.'search_word');

ObjectModel::updateMultishopTable('Product', array('indexed' => 0), '1');

}

else

{

// Do it even if you already know the product id in order to be sure that it exists and it needs to be indexed

$products = $db->executeS('

SELECT p.id_product

FROM '._DB_PREFIX_.'product p

'.Shop::addSqlAssociation('product', 'p').'

WHERE product_shop.visibility IN ("both", "search")

AND '.($id_product ? 'p.id_product = '.(int)$id_product : 'product_shop.indexed = 0')

);

 

$ids = array();

if ($products)

foreach ($products as $product)

$ids[] = (int)$product['id_product'];

if (count($ids))

$db->execute('DELETE FROM '._DB_PREFIX_.'search_index WHERE id_product IN ('.implode(',', $ids).')');

}

 

// Every fields are weighted according to the configuration in the backend

$weight_array = array(

'pname' => Configuration::get('PS_SEARCH_WEIGHT_PNAME'),

'reference' => Configuration::get('PS_SEARCH_WEIGHT_REF'),

'ean13' => Configuration::get('PS_SEARCH_WEIGHT_REF'),

'upc' => Configuration::get('PS_SEARCH_WEIGHT_REF'),

'description_short' => Configuration::get('PS_SEARCH_WEIGHT_SHORTDESC'),

'description' => Configuration::get('PS_SEARCH_WEIGHT_DESC'),

'cname' => Configuration::get('PS_SEARCH_WEIGHT_CNAME'),

'mname' => Configuration::get('PS_SEARCH_WEIGHT_MNAME'),

'tags' => Configuration::get('PS_SEARCH_WEIGHT_TAG'),

'attributes' => Configuration::get('PS_SEARCH_WEIGHT_ATTRIBUTE'),

'features' => Configuration::get('PS_SEARCH_WEIGHT_FEATURE')

);

 

// Those are kind of global variables required to save the processed data in the database every X occurrences, in order to avoid overloading MySQL

$count_words = 0;

$query_array3 = array();

$products_array = array();

 

// Every indexed words are cached into a PHP array

$word_ids = $db->executeS('

SELECT id_word, word, id_lang, id_shop

FROM '._DB_PREFIX_.'search_word', false);

$word_ids_by_word = array();

while ($word_id = $db->nextRow($word_ids))

{

if (!isset($word_ids_by_word[$word_id['id_shop']][$word_id['id_lang']]))

$word_ids_by_word[$word_id['id_shop']][$word_id['id_lang']] = array();

$word_ids_by_word[$word_id['id_shop']][$word_id['id_lang']]['_'.$word_id['word']] = (int)$word_id['id_word'];

}

 

// Retrieve the number of languages

$total_languages = count(Language::getLanguages(false));

 

// Products are processed 50 by 50 in order to avoid overloading MySQL

while (($products = Search::getProductsToIndex($total_languages, $id_product, 50)) && (count($products) > 0))

{

// Now each non-indexed product is processed one by one, langage by langage

foreach ($products as $product)

{

$product['tags'] = Search::getTags($db, (int)$product['id_product'], (int)$product['id_lang']);

$product['attributes'] = Search::getAttributes($db, (int)$product['id_product'], (int)$product['id_lang']);

$product['features'] = Search::getFeatures($db, (int)$product['id_product'], (int)$product['id_lang']);

 

// Data must be cleaned of html, bad characters, spaces and anything, then if the resulting words are long enough, they're added to the array

$product_array = array();

foreach ($product as $key => $value)

if (strncmp($key, 'id_', 3))

{

$words = explode(' ', Search::sanitize($value, (int)$product['id_lang'], true));

foreach ($words as $word)

if (!empty($word))

{

$word = Tools::substr($word, 0, PS_SEARCH_MAX_WORD_LENGTH);

// Remove accents

$word = Tools::replaceAccentedChars($word);

 

if (!isset($product_array[$word]))

$product_array[$word] = 0;

$product_array[$word] += $weight_array[$key];

}

}

 

// If we find words that need to be indexed, they're added to the word table in the database

if (count($product_array))

{

$query_array = $query_array2 = array();

foreach ($product_array as $word => $weight)

if ($weight && !isset($word_ids_by_word['_'.$word]))

{

$query_array[$word] = '('.(int)$product['id_lang'].', '.(int)$product['id_shop'].', \''.pSQL($word).'\')';

$query_array2[] = '\''.pSQL($word).'\'';

$word_ids_by_word[$product['id_shop']][$product['id_lang']]['_'.$word] = 0;

}

 

if ($query_array2)

{

$existing_words = $db->executeS('

SELECT DISTINCT word FROM '._DB_PREFIX_.'search_word

WHERE word IN ('.implode(',', $query_array2).')

AND id_lang = '.(int)$product['id_lang'].'

AND id_shop = '.(int)$product['id_shop']);

 

foreach ($existing_words as $data)

unset($query_array[Tools::replaceAccentedChars($data['word'])]);

}

 

if (count($query_array))

{

// The words are inserted...

$db->execute('

INSERT IGNORE INTO '._DB_PREFIX_.'search_word (id_lang, id_shop, word)

VALUES '.implode(',', $query_array));

}

if (count($query_array2))

{

// ...then their IDs are retrieved and added to the cache

$added_words = $db->executeS('

SELECT sw.id_word, sw.word

FROM '._DB_PREFIX_.'search_word sw

WHERE sw.word IN ('.implode(',', $query_array2).')

AND sw.id_lang = '.(int)$product['id_lang'].'

AND sw.id_shop = '.(int)$product['id_shop'].'

LIMIT '.count($query_array2));

// replace accents from the retrieved words so that words without accents or with differents accents can still be linked

foreach ($added_words as $word_id)

$word_ids_by_word[$product['id_shop']][$product['id_lang']]['_'.Tools::replaceAccentedChars($word_id['word'])] = (int)$word_id['id_word'];

}

}

 

foreach ($product_array as $word => $weight)

{

if (!$weight)

continue;

if (!isset($word_ids_by_word[$product['id_shop']][$product['id_lang']]['_'.$word]))

continue;

if (!$word_ids_by_word[$product['id_shop']][$product['id_lang']]['_'.$word])

continue;

$query_array3[] = '('.(int)$product['id_product'].','.

(int)$word_ids_by_word[$product['id_shop']][$product['id_lang']]['_'.$word].','.(int)$weight.')';

// Force save every 200 words in order to avoid overloading MySQL

if (++$count_words % 200 == 0)

Search::saveIndex($query_array3);

}

 

if (!in_array($product['id_product'], $products_array))

$products_array[] = (int)$product['id_product'];

}

Search::setProductsAsIndexed($products_array);

 

// One last save is done at the end in order to save what's left

Search::saveIndex($query_array3);

}

return true;

}

 

protected static function setProductsAsIndexed(&$products)

{

if (count($products))

ObjectModel::updateMultishopTable('Product', array('indexed' => 1), 'a.id_product IN ('.implode(',', $products).')');

}

 

/** $queryArray3 is automatically emptied in order to be reused immediatly */

protected static function saveIndex(&$queryArray3)

{

if (count($queryArray3))

Db::getInstance()->execute(

'INSERT INTO '._DB_PREFIX_.'search_index (id_product, id_word, weight)

VALUES '.implode(',', $queryArray3).'

ON DUPLICATE KEY UPDATE weight = weight + VALUES(weight)'

);

$queryArray3 = array();

}

 

public static function searchTag($id_lang, $tag, $count = false, $pageNumber = 0, $pageSize = 10, $orderBy = false, $orderWay = false,

$useCookie = true, Context $context = null)

{

if (!$context)

$context = Context::getContext();

 

// Only use cookie if id_customer is not present

if ($useCookie)

$id_customer = (int)$context->customer->id;

else

$id_customer = 0;

 

if (!is_numeric($pageNumber) || !is_numeric($pageSize) || !Validate::isBool($count) || !Validate::isValidSearch($tag)

|| $orderBy && !$orderWay || ($orderBy && !Validate::isOrderBy($orderBy)) || ($orderWay && !Validate::isOrderBy($orderWay)))

return false;

 

if ($pageNumber < 1) $pageNumber = 1;

if ($pageSize < 1) $pageSize = 10;

 

$id = Context::getContext()->shop->id;

$id_shop = $id ? $id : Configuration::get('PS_SHOP_DEFAULT');

if ($count)

{

$sql = 'SELECT COUNT(DISTINCT pt.`id_product`) nb

FROM `'._DB_PREFIX_.'product` p

'.Shop::addSqlAssociation('product', 'p').'

LEFT JOIN `'._DB_PREFIX_.'product_tag` pt ON (p.`id_product` = pt.`id_product`)

LEFT JOIN `'._DB_PREFIX_.'tag` t ON (pt.`id_tag` = t.`id_tag` AND t.`id_lang` = '.(int)$id_lang.')

LEFT JOIN `'._DB_PREFIX_.'category_product` cp ON (cp.`id_product` = p.`id_product`)

LEFT JOIN `'._DB_PREFIX_.'category_shop` cs ON (cp.`id_category` = cs.`id_category` AND cs.`id_shop` = '.(int)$id_shop.')

LEFT JOIN `'._DB_PREFIX_.'category_group` cg ON (cg.`id_category` = cp.`id_category`)

WHERE product_shop.`active` = 1

AND cs.`id_shop` = '.(int)Context::getContext()->shop->id.'

AND cg.`id_group` '.(!$id_customer ? '= 1' : 'IN (

SELECT id_group FROM '._DB_PREFIX_.'customer_group

WHERE id_customer = '.(int)$id_customer.')').'

AND t.`name` LIKE \'%'.pSQL($tag).'%\'';

return (int)Db::getInstance(_PS_USE_SQL_SLAVE_)->getValue($sql);

}

 

$sql = 'SELECT DISTINCT p.*, product_shop.*, stock.out_of_stock, IFNULL(stock.quantity, 0) as quantity, pl.`description_short`, pl.`link_rewrite`, pl.`name`,

tax.`rate`, image_shop.`id_image`, il.`legend`, m.`name` manufacturer_name, 1 position,

DATEDIFF(

p.`date_add`,

DATE_SUB(

NOW(),

INTERVAL '.(Validate::isUnsignedInt(Configuration::get('PS_NB_DAYS_NEW_PRODUCT')) ? Configuration::get('PS_NB_DAYS_NEW_PRODUCT') : 20).' DAY

)

) > 0 new

FROM `'._DB_PREFIX_.'product` p

INNER JOIN `'._DB_PREFIX_.'product_lang` pl ON (

p.`id_product` = pl.`id_product`

AND pl.`id_lang` = '.(int)$id_lang.Shop::addSqlRestrictionOnLang('pl').'

)

'.Shop::addSqlAssociation('product', 'p', false).'

LEFT JOIN `'._DB_PREFIX_.'image` i ON (i.`id_product` = p.`id_product`)'.

Shop::addSqlAssociation('image', 'i', false, 'image_shop.cover=1').'

LEFT JOIN `'._DB_PREFIX_.'image_lang` il ON (i.`id_image` = il.`id_image` AND il.`id_lang` = '.(int)$id_lang.')

LEFT JOIN `'._DB_PREFIX_.'tax_rule` tr ON (product_shop.`id_tax_rules_group` = tr.`id_tax_rules_group`

AND tr.`id_country` = '.(int)$context->country->id.'

AND tr.`id_state` = 0)

LEFT JOIN `'._DB_PREFIX_.'tax` tax ON (tax.`id_tax` = tr.`id_tax`)

LEFT JOIN `'._DB_PREFIX_.'manufacturer` m ON (m.`id_manufacturer` = p.`id_manufacturer`)

LEFT JOIN `'._DB_PREFIX_.'product_tag` pt ON (p.`id_product` = pt.`id_product`)

LEFT JOIN `'._DB_PREFIX_.'tag` t ON (pt.`id_tag` = t.`id_tag` AND t.`id_lang` = '.(int)$id_lang.')

LEFT JOIN `'._DB_PREFIX_.'category_product` cp ON (cp.`id_product` = p.`id_product`)

LEFT JOIN `'._DB_PREFIX_.'category_group` cg ON (cg.`id_category` = cp.`id_category`)

LEFT JOIN `'._DB_PREFIX_.'category_shop` cs ON (cg.`id_category` = cs.`id_category` AND cs.`id_shop` = '.(int)$id_shop.')

'.Product::sqlStock('p', 0).'

WHERE product_shop.`active` = 1

AND cs.`id_shop` = '.(int)Context::getContext()->shop->id.'

AND cg.`id_group` '.(!$id_customer ? '= 1' : 'IN (

SELECT id_group FROM '._DB_PREFIX_.'customer_group

WHERE id_customer = '.(int)$id_customer.')').'

AND t.`name` LIKE \'%'.pSQL($tag).'%\'

AND ((image_shop.id_image IS NOT NULL OR i.id_image IS NULL) OR (image_shop.id_image IS NULL AND i.cover=1))

ORDER BY position DESC'.($orderBy ? ', '.$orderBy : '').($orderWay ? ' '.$orderWay : '').'

LIMIT '.(int)(($pageNumber - 1) * $pageSize).','.(int)$pageSize;

if (!$result = Db::getInstance(_PS_USE_SQL_SLAVE_)->executeS($sql))

return false;

 

return Product::getProductsProperties((int)$id_lang, $result);

}

}

 

[ajensen27]

Remember, the search works when URL_Rewriting is turned off so I'm assuming it has something to do with that.

[benjamin utterback]

Yes, this is strange indeed. Just to confirm, you have been re-built the index. I think we are looking at a Server configuration problem that we are not aware of. 

[ajensen27]

Yup, I've rebuilt the index. Turned off "ajax search". Turned off "instant search".

 

Nothing seems to work except if I turn off url rewriting.

[ajensen27]

Hi Benjamin,

 

Any new update on this? Would love to get my search working.

 

Thanks!

[ajensen27]

Checking in again.

[ajensen27]

Can someone please help with this? I have customers searching all the time (I can tell by Google Analytics) and I know this still isn't working. Makes our site look bad.

 

Thanks!

[ajensen27]

Since I seem to be getting no help on here I opened an issue on the forge. It was a clone of another person's issue that hasn't seemed to be worked on in a while either. Hopefully I can get some help with this forge issue.

 

http://forge.prestashop.com/browse/PSCFV-10818

[benjamin utterback]

The forge is primarily concerned with bugs and issues that are inherent within the software. Are you also using GoDaddy?

[ajensen27]

Wouldn't you consider this a bug if multiple people are experiencing it?

 

No, we have our own VPS with https://www.gridvirt.com/

[benjamin utterback]

It would be considered a bug if two people with the same conditions produced this bug. The problem is that it is difficult to determine what is a bug and what's not. Ajax in general can have problems due to a variety of different things. At this point I really think you should look into having a professional or freelancer look into the problem a little deeper. The forge reports are not detailed enough for our team to test and reproduce. 

[Gregory Roussac]

Hi, Alex, Ben,

 

Regarding http://forge.prestashop.com/browse/PSCFV-10823, I believe your are looking for this commit https://github.com/PrestaShop/PrestaShop/commit/eeb469dda5f070d3c92d1795afe4da1c8b65c808

 

Best regards

[bellini13]

you expect an end user to understand github and code changes?  You also expect everyone upgrade their entire store due to a single issue with a core module?  I would have expected better from Prestashop... deeply concerning and disappointing.

 

If an issue is reported for a particular version of Prestashop, you should be answering how to address that issue in that version of Prestashop, the answer cannot be upgrade your entire store and see if it works...

[ajensen27]

you expect an end user to understand github and code changes?  You also expect everyone upgrade their entire store due to a single issue with a core module?  I would have expected better from Prestashop... deeply concerning and disappointing.

 

If an issue is reported for a particular version of Prestashop, you should be answering how to address that issue in that version of Prestashop, the answer cannot be upgrade your entire store and see if it works...

 

Thank you! This was my point exactly! While I am tech savvy person and have a bachelors degree in IT, I'm not a programmer. Upgrading my store is not an option as of right now since my store has been heavily modified to fit our needs. If we are going to upgrade, it was going to be when vs 1.6 was released. All I want right now is for my search to function properly. It must have something to do with URL rewriting since the search works fine when it is turned off. However, URL rewriting supersedes the ability to search on our site.

 

Also, I tried fix you showed above Gregory and it did not do anything.

 

Thanks.

[benjamin utterback]

Hey Alex,

 

   If you are on v1.5x, lets try something else. Make sure you back up and thennn lets upload the newest version of the module block search.

 

A problem with Ajax search and Friendly URL on two stores does not mean that it is directly connected or related, I also personally think that this is related to other modifications on the website, and not entirely the core module. That said, we are still trying to find a resolution.

 

Alex, thank you for your patience and understanding. I have zipped the module in this post. 

 

But before that, can you just disable and re-enabled the search module. Toggle on and off ajax search and instant search. At this point, it's worth a shot.

 

 

blocksearch.zip

[ajensen27]

Thanks for the response Bejamin. It's actually happening on another store as well as seen in this forge post http://forge.prestashop.com/browse/PSCFV-10163

 

As for installing the blocksearch from the latest version of PS, I copied over all those files earlier trying to fix the issue and it caused a fatal error in my store because my website went blank. Not sure if copying over the files is the same as upgrading the module but if not can you tell me how to backup my current blocksearch module? Just copy the current files to my local computer? Then install the module you attached?

 

As for disabling and re-enabling the module, turning on and off ajax, etc. I've tried all of that to no avail.

 

Thanks for your help Benjamin, I do appreciate it.

 

-Alex

[ajensen27]

Benjamin,

 

Bellini13 combed through my store yesterday and finally found the issue. We had a redirect in our .htaccess for a page on our old site for /search that redirected back to the homepage. We didn't realize this was the SEO URL for the search function within Prestashop because we never see the URL (now we notice it under SEO on the backend).

 

So sorry for the confusion Benjamin and I really do appreciate your help. I would definitely recommend anyone else that has the issue with search not working when URL re-writing is turned on to take a look at this as a possible issue.

 

Thanks,

Alex

[the_raven]

hello

 

I have the same problem after migration from local to server . i didn't have this problem before on my previous shop .

 

 

____________S O L V E D_________________

 

The problem was javascript conflict's in template files .

Edited June 16, 2014 by the_raven (see edit history)

[nutxlago]

I have the same issue with PS 1.6.0.9 version. Ajax  search box on top is not working. Ihavemade the changes  you propose: enabling/disabling search in top menu, activating/deactivating ajax search block. But nothing changes. Result is always the same: 0 records found. Could anyone help with this issue or provide a link on this forum to a solution?

[PrestaHeroes USA]

I have the same issue with PS 1.6.0.9 version. Ajax  search box on top is not working. Ihavemade the changes  you propose: enabling/disabling search in top menu, activating/deactivating ajax search block. But nothing changes. Result is always the same: 0 records found. Could anyone help with this issue or provide a link on this forum to a solution?

 

Please open new topic in 'new 1.6'.

 

closing this topic due to age, please post new topic.