Hallo an @lle die das eventuell auch schon hatten....ich habe JTL Wawi usw. installiert und klappt auch alles wunderbar....nur habe ich jetzt das Problem welches hier schon mal Beschrieben wurde, wo ich aber leider keine Antwort gefunden habe.
Nach dem ich halt Artikel bearbeitet habe und dann einen Shopabgleich gemacht habe kommt jetzt dieser Fehler wenn ich auf Suche gehe.
1104 - The SELECT would examine more than MAX_JOIN_SIZE rows; check your WHERE and use SET SQL_BIG_SELECTS=1 or SET SQL_MAX_JOIN_SIZE=# if the SELECT is okay
SELECT distinct p.products_id, p.products_price, p.products_model, p.products_quantity, p.products_shippingtime, p.products_fsk18, p.products_image, p.products_weight, p.products_tax_class_id, pd.products_name, pd.products_short_description, pd.products_description FROM products AS p LEFT JOIN products_description AS pd ON (p.products_id = pd.products_id) LEFT OUTER JOIN products_attributes AS pa ON (p.products_id = pa.products_id) LEFT OUTER JOIN products_options_values AS pov ON (pa.options_values_id = pov.products_options_values_id) LEFT OUTER JOIN specials AS s ON (p.products_id = s.products_id) AND s.status = '1' WHERE p.products_status = '1' AND pd.language_id = '2' AND ( ( pd.products_keywords LIKE ('%lack%') OR pd.products_description LIKE ('%lack%') OR pd.products_short_description LIKE ('%lack%') OR pd.products_name LIKE ('%lack%') OR p.products_model LIKE ('%lack%') OR (pov.products_options_values_name LIKE ('%lack%') AND pov.language_id = '2') ) ) GROUP BY p.products_id ORDER BY p.products_id
[XT SQL Error]
Ich bin kein Fachmann(Frau) aber bitte um Hilfe.
Danke im voraus.
Lg
Christine
Nach dem ich halt Artikel bearbeitet habe und dann einen Shopabgleich gemacht habe kommt jetzt dieser Fehler wenn ich auf Suche gehe.
1104 - The SELECT would examine more than MAX_JOIN_SIZE rows; check your WHERE and use SET SQL_BIG_SELECTS=1 or SET SQL_MAX_JOIN_SIZE=# if the SELECT is okay
SELECT distinct p.products_id, p.products_price, p.products_model, p.products_quantity, p.products_shippingtime, p.products_fsk18, p.products_image, p.products_weight, p.products_tax_class_id, pd.products_name, pd.products_short_description, pd.products_description FROM products AS p LEFT JOIN products_description AS pd ON (p.products_id = pd.products_id) LEFT OUTER JOIN products_attributes AS pa ON (p.products_id = pa.products_id) LEFT OUTER JOIN products_options_values AS pov ON (pa.options_values_id = pov.products_options_values_id) LEFT OUTER JOIN specials AS s ON (p.products_id = s.products_id) AND s.status = '1' WHERE p.products_status = '1' AND pd.language_id = '2' AND ( ( pd.products_keywords LIKE ('%lack%') OR pd.products_description LIKE ('%lack%') OR pd.products_short_description LIKE ('%lack%') OR pd.products_name LIKE ('%lack%') OR p.products_model LIKE ('%lack%') OR (pov.products_options_values_name LIKE ('%lack%') AND pov.language_id = '2') ) ) GROUP BY p.products_id ORDER BY p.products_id
[XT SQL Error]
Ich bin kein Fachmann(Frau) aber bitte um Hilfe.
Danke im voraus.
Lg
Christine