Hi, hab schon wieder einen SQL-Fehler. Wenn man in der Hersteller Box auf einen Hersteller klickt, so kommt folgender Fehler:
1052 - COLUMN 'manufacturers_id' IN WHERE clause IS ambiguous
SELECT DISTINCT c.categories_id AS id,
cd.categories_name AS name
FROM products p
JOIN products_description pd
ON p.products_id = pd.products_id
AND pd.language_id = '2'
AND TRIM(pd.products_name) != ''
JOIN manufacturers m
ON m.manufacturers_id = p.manufacturers_id
JOIN products_to_categories p2c
ON p2c.products_id = p.products_id
JOIN categories c
ON c.categories_id = p2c.categories_id
JOIN categories_description cd
ON cd.categories_id = p2c.categories_id
AND cd.language_id = '2'
WHERE p.products_status = '1'
AND manufacturers_id = '1'
ORDER BY name
Request URL: www.meinshop.de/tollerhersteller:.:1.html
[XT SQL Error]
Ich weiß leider nicht einmal, wo ich diesen Query finden kann, geschweige denn, was daran "ambiguous" ist... weiß jemand Bescheid?
Linkback: https://www.modified-shop.org/forum/index.php?topic=35184.0