wunschtacho Posted February 3, 2006 Report Share Posted February 3, 2006 Wenn man eine Suche nach einem Wort startet, dauert es ewig und dann kommt eine gro?e Fehlermeldung: 1053 - Server shutdown in progress SELECT DISTINCT p.products_model, pov.products_options_values_name, pd.products_name, m.manufacturers_name, p.products_quantity, p.products_shippingtime, p.products_fsk18, p.products_image, p.products_weight, pd.products_short_description, pd.products_description, m.manufacturers_id, p.products_id, pd.products_name, p.products_price, p.products_tax_class_id FROM products p LEFT JOIN manufacturers m using(manufacturers_id), products_description pd LEFT JOIN specials s ON p.products_id = s.products_id, categories c, products_to_categories p2c, products LEFT JOIN products_attributes pa ON p.products_id = pa.products_id LEFT JOIN products_options_values pov ON pa.options_values_id = pov.products_options_values_id WHERE p.products_status = '1' AND p.products_id = pd.products_id AND pd.language_id = '2' AND p.products_id = p2c.products_id AND p2c.categories_id = c.categories_id AND ( p.products_id = pa.products_id AND (pd.products_name LIKE '%test%' OR p.products_model LIKE '%test%' OR p.products_ean like '%test%' OR m.manufacturers_name LIKE '%test%' OR pov.products_options_values_name LIKE '%test%' OR pd.products_description LIKE '%test%' OR pd.products_short_description LIKE '%test%' OR pa.attributes_model LIKE '%test%') OR (pd.products_name LIKE '%test%' OR p.products_model like '%test%' OR p.products_ean LIKE '%test%' OR m.manufacturers_name LIKE '%test%' OR pd.products_description LIKE '%test%' OR pd.products_short_description LIKE '%test%') ) GROUP BY pd.products_id ORDER BY pd.products_name [XT SQL Error] Hat jemand eine Idee hierzu? W?re f?r jeden Tipp dankbar Link to comment Share on other sites More sharing options...
wunschtacho Posted February 3, 2006 Author Report Share Posted February 3, 2006 Suche dauert wohl einfach zu lange, so wie ich das sehe, wenn ich "Advanced Search" anw?hle und innerhalb einer Kategorie findet er etwas (aber braucht auch saulange). Cache ist aktiv bei mir Hat keiner eine Idee warum die Suche so extrem lahm ist? Gr??e Link to comment Share on other sites More sharing options...
syncrosoni Posted February 3, 2006 Report Share Posted February 3, 2006 Version 3.0.3 ?? Link to comment Share on other sites More sharing options...
wunschtacho Posted February 3, 2006 Author Report Share Posted February 3, 2006 japp leider Link to comment Share on other sites More sharing options...
leo0001 Posted March 8, 2006 Report Share Posted March 8, 2006 Ja hast Du`s hin bekommen? Link to comment Share on other sites More sharing options...
wunschtacho Posted March 9, 2006 Author Report Share Posted March 9, 2006 Ja schon vor l?ngerem - einfach die search.php und search_advanced.php (oder so ?hnlich) der 3.02 benutzen Link to comment Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.