Wenn ich bei der Suche nach Kategorien Dropdownbox eine Kategorie anwähle kommt folgende Meldung:
SQL Fehler [256] (1064) You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'INNER JOIN manufacturers m WHERE p.products_status = '1'' at line 31
Query: SELECT DISTINCT p.products_fsk18, p.products_shippingtime, p.products_model, p.manufacturers_id, p.products_ean, p.products_price, p.products_tax_class_id, m.manufacturers_name, p.products_quantity, p.products_image, p.products_weight, pd.products_name, pd.products_short_description, pd.products_description, pd.products_img_alt, 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_slave_in_list, p.products_master, p.products_tax_class_id FROM products p, products_description pd, products_to_categories p2c, INNER JOIN manufacturers m WHERE p.products_status = '1' AND p.manufacturers_id = m.manufacturers_id AND m.manufacturers_id = '5' AND p.products_id = p2c.products_id AND (p.products_slave_in_list = '1' OR p.products_master = '1' OR ((p.products_slave_in_list = '0' OR p.products_slave_in_list = '') AND (p.products_master_article = '' OR p.products_master_article = '0'))) AND pd.products_id = p2c.products_id AND pd.language_id = '2' AND p2c.categories_id = '27390' ORDER BY pd.products_name
Beim Aufruf der Datei /index.php , PHP 5.3.3-7+squeeze13 (Linux)
Die Abfrage wurde abgebrochen, kontaktieren Sie den Administrator...
Wie kann man diesen Fehler beheben?