[RESOLU] La barre de recherche ne fonctionne pas

[nicolasb73]

Bonjour,

J'ai une installation PS 8.1.7 et un problème avec la recherche. L'index est reconstruit, j'ai bien des éléments dans la base de données, la requête me donne bien des id_product, mais j'ai un message d'erreur (qui fait qu'aucun résultat n'est affiché) :

Key 'id_product' doesn't exist in table 'image_shop' puis le détails de la requête.

Mais j'ai bien id_product dans la table indiquée.

Est-ce que vous êtes déjà tombé sur ce problème ?

 

Suite de l'erreur :

<br /><br /><pre>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`, image_shop.`id_image` id_image, il.`legend`, m.`name` manufacturer_name ,( SELECT SUM(weight) FROM ps_search_word sw LEFT JOIN ps_search_index si ON sw.id_word = si.id_word WHERE sw.id_lang = 2 AND sw.id_shop = 1 AND si.id_product = p.id_product AND (sw.word LIKE '%elingue%') ) position, DATEDIFF( p.`date_add`, DATE_SUB( "2024-10-23 00:00:00", INTERVAL 210 DAY ) ) > 0 new, product_attribute_shop.minimal_quantity AS product_attribute_minimal_quantity, IFNULL(product_attribute_shop.`id_product_attribute`,0) id_product_attribute FROM ps_product p INNER JOIN ps_product_shop product_shop ON (product_shop.id_product = p.id_product AND product_shop.id_shop = 1) INNER JOIN `ps_product_lang` pl ON ( p.`id_product` = pl.`id_product` AND pl.`id_lang` = 2 AND pl.id_shop = 1 ) LEFT JOIN `ps_product_attribute_shop` product_attribute_shop FORCE INDEX (id_product) 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_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 ) LEFT JOIN `ps_manufacturer` m FORCE INDEX (PRIMARY) ON m.`id_manufacturer` = p.`id_manufacturer` LEFT JOIN `ps_image_shop` image_shop FORCE INDEX (id_product) 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` = 2) WHERE p.`id_product` IN (12,13,14,15,16,17,149,150,151,152,3232,3233,3234,550,551,220,1232,1006,70,1019,93,91,61,55,880,54,209,101,771,772,773,734,1220,363,1221,117,118,116,750,872,1287,1288,1756,1958,2889,145,308,29,30,307,1147,143,31,310,1159,2938,2939,3084,146,123,28,309,25,124,892,1007,497,319,318,121,32,1165,320,3034,147,314,148,317,18,19,20,21,22,23,1040,1041,236,97,98,99,362,3235,153,156,157,158,159,160,161,1018,2696,33,34,35,1011,1012,1010,37,38,36,183,1013,876,202,1076,498,115,1271,812,39,203,1272,1273,1274,1275,246,199,208,532,1222,1243,213,47,2750,177,245,2958,513,3143,26,258,528,529,58,59,281,288,548,879,549,3066,53,1536,1535,576,852,1250,1251,51,52,1166,1167,287,567,1260,566,1537,57,285,286,968,969,706,1329,1330,441,442,443,444,445,446,447,448,449,450,451,486,495,488,489,646,1030,647,3045,3046,3047,3048,3049,788,792,1543,3341,535,3351,3352,1581,961,960,958,959,962,859,1003,805,806,804,803,802,801,800,799,798,537,2964,516,1276,1277,1278,1279,1280,1168,1281,1282,1283,1284,1285,1286,538,1290,1291,1292,536,539,987,820,540,834,1122,197,196,821,1633,823,824,822,365,366,1356,1826,2946,875,562,748,563,1673,3070,858,890,891,1242,1048,1054,1055,1056,1057,1058,1059,1050,1051,1052,1053,272,79,80,1120,1162,1669,1671,1670,1668,2744,2745,2746,1205,1204,1206,534,1568,1569,1567,3033,60,590,2878,3383,1441,2921,1675,2966,2967,2968,1564,1605,1607,1608) GROUP BY product_shop.id_product ORDER BY position desc LIMIT 0,100</pre>
at line 773 in file classes/db/Db.php

 

Edited October 23 by nicolasb73 (see edit history)

[Eolia]

La requête ne parle pas de colonne mais d'index (FORCE INDEX (id_product))

Ajoutez un index sur votre table ps_image_shop (simple index sur la colonne id_product)

 

[nicolasb73]

Merci ! J'étais sûr de l'avoir fait ^^

Ca fonctionne en effet...

[Eolia]

Généralement je propose des réponses fonctionnelles  

[Divine]