Bonsoir Eolia,
Excusez moi de vous déranger une nouvelle fois encore mais je viens de vérifier sur phenix v14 sur mon sitetest.com j'ai 2 soucis niveaux
"barre de recherche rapide" et des erreurs SQL
Tout d'abord pour ma part votre module paypal v12 fonctionne parifaitement testé paiemennt t en réel etc
1/ concernant mon soucis avec la barre de recherche rapide, la recherche fonctionne sur certains catégories comme scooters, lits,injections et tandis que d'autres catégories ou mots comme fauteuil, embout cannes, crème ça ne trouve rien (pourtant ces articles existent bien)
2/ Suite au soucis de la barre de recherche rapide, j'ai activé le mode débug
j'ai ça en error en front office, je ne sais pas si c'est lié
[ SQL ERROR ]
You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near ')) ) LEFT JOIN `ps_product_attribute_shop` product_attrib...' at line 16
SELECT p.id_product, IFNULL(product_attribute_shop.id_product_attribute,0) id_product_attribute, pl.`link_rewrite`, pl.`name`, pl.`description_short`, product_shop.`id_category_default`, image_shop.`id_image` id_image, il.`legend`, ps.`quantity` AS sales, p.`ean13`, p.`upc`, p.`reference`, cl.`link_rewrite` AS category, p.show_price, p.available_for_order, IFNULL(stock.quantity, 0) as quantity, p.customizable, IFNULL(pa.minimal_quantity, p.minimal_quantity) as minimal_quantity, stock.out_of_stock, product_shop.`date_add` > "2023-04-01" as new, product_shop.`on_sale`, product_attribute_shop.minimal_quantity AS product_attribute_minimal_quantity FROM `ps_product_sale` ps INNER JOIN `ps_product` p ON(ps.`id_product` = p.`id_product`) INNER JOIN ps_product_shop product_shop ON (product_shop.id_product = p.id_product AND product_shop.id_shop = 1) AND EXISTS ( SELECT 1 FROM ps_product_group pg WHERE (pg.id_product = p.id_product AND pg.id_group IN ()) ) LEFT JOIN `ps_product_attribute_shop` product_attribute_shop ON(p.`id_product` = product_attribute_shop.`id_product` AND product_attribute_shop.`default_on` = 1 AND product_attribute_shop.id_shop=1) LEFT JOIN `ps_product_attribute` pa ON(product_attribute_shop.id_product_attribute=pa.id_product_attribute) LEFT JOIN `ps_product_lang` pl ON(p.`id_product` = pl.`id_product` AND pl.`id_lang` = 1 AND pl.id_shop = 1 ) LEFT JOIN `ps_image_shop` image_shop ON(image_shop.`id_product` = p.`id_product` AND image_shop.cover=1 AND image_shop.id_shop=1) LEFT JOIN `ps_image_lang` il ON(image_shop.`id_image` = il.`id_image` AND il.`id_lang` = 1) LEFT JOIN `ps_category_lang` cl ON(cl.`id_category` = product_shop.`id_category_default` AND cl.`id_lang` = 1 AND cl.id_shop = 1 ) LEFT JOIN ps_stock_available stock ON (stock.id_product = p.id_product AND stock.id_product_attribute = 0 AND stock.id_shop = 1 AND stock.id_shop_group = 0 ) WHERE product_shop.`active` = 1 AND product_shop.`visibility` = 'both' AND EXISTS( SELECT 1 FROM `ps_category_product` cp INNER JOIN `ps_category_group` cg ON(cp.id_category = cg.id_category AND cg.`id_group` IN (1,2,3,4,5,7)) WHERE cp.`id_product` = p.`id_product`) ORDER BY ps.quantity DESC LIMIT 0, 12
DbCore->displayError in /classes/db/Db.php:450
DbCore->query in /classes/db/Db.php:694
DbCore->executeS in /classes/ProductSale.php:245
ProductSaleCore::getBestSalesLight in /modules/blockbestsellers/blockbestsellers.php:266
BlockBestSellers->getBestSellers in /modules/blockbestsellers/blockbestsellers.php:206
BlockBestSellers->hookDisplayHomeTab in /classes/Hook.php:626
HookCore::coreCallHook in /classes/Hook.php:571
HookCore::exec in /controllers/front/IndexController.php:41
IndexControllerCore->initContent in /classes/controller/Controller.php:204
ControllerCore->run in /classes/Dispatcher.php:408
DispatcherCore->dispatch in /index.php:28
Si vous pouvez m'aider svp c'est sur mon sitetest.com
En vous remerciant par avance