deni9 Posted April 19, 2008 Report Share Posted April 19, 2008 Hallo hab mir soeben eine neue Kategorie hochgeladen und wollte mal nachschauen ob die Artikel drin sind. jetzt bekomme ich diese fehlermedlung wen ich artikel aufrufe- 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 p.products_fsk18, p.products_shippingtime, p.products_model, p.products_ean, pd.products_name, m.manufacturers_name, p.products_quantity, p.products_image, p.products_weight, pd.products_short_description, pd.products_description, p.products_id, p.manufacturers_id, p.products_price, p.products_vpe, p.products_vpe_status, p.products_vpe_value, p.products_discount_allowed, p.products_tax_class_id from products_description pd, products_to_categories p2c, products p left join manufacturers m on p.manufacturers_id = m.manufacturers_id left join specials s on p.products_id = s.products_id where p.products_status = '1' and p.products_id = p2c.products_id and pd.products_id = p2c.products_id and pd.language_id = '2' and p2c.categories_id = '500' ORDER BY p.products_price ASC [XT SQL Error] Kann mir jemand Helfen ist sehr dringend. Link to comment Share on other sites More sharing options...
deni9 Posted April 20, 2008 Author Report Share Posted April 20, 2008 keiner der mir Helfen kann:( Link to comment Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.