Product info SQL Fehler

[philipp1988]

hey ho community ...

ich kriege nen hals :/

ich habe eben mein anderes problem fertig bekommen und nun wunder ich mich sobald ich ein produkt aufrufe kommt ein SQL Fehler

Folgende Fehlermeldung:

1064 - Fehler in der Syntax bei '6' in Zeile 22.

select p.products_fsk18, p.products_id, p.products_price, p.products_tax_class_id, p.products_image, pd.products_name, p.products_vpe, p.products_vpe_status, p.products_vpe_value, pd.products_short_description FROM orders_products opa, orders_products opb, orders o, products p, products_description pd where opa.products_id = '1811' and opa.orders_id = opb.orders_id and opb.products_id != '1811' and opb.products_id = p.products_id and opb.orders_id = o.orders_id and p.products_status = '1' and pd.language_id = '2' and opb.products_id = pd.products_id group by p.products_id order by o.date_purchased desc 6

[XT SQL Error]

Die Datei ist glaube ich die product.php

Auszug aus der SQL Abfrage

	$orders_query = "select

														                                  p.products_fsk18,

														                                  p.products_id,

														                                  p.products_price,

														                                  p.products_tax_class_id,

														                                  p.products_image,

														                                  pd.products_name,

														                                  p.products_vpe,

						                           										  p.products_vpe_status,

						                           										  p.products_vpe_value,

														                                  pd.products_short_description FROM ".TABLE_ORDERS_PRODUCTS." opa, ".TABLE_ORDERS_PRODUCTS." opb, ".TABLE_ORDERS." o, ".TABLE_PRODUCTS." p, ".TABLE_PRODUCTS_DESCRIPTION." pd

														                                  where opa.products_id = '".$this->pID."'

														                                  and opa.orders_id = opb.orders_id

														                                  and opb.products_id != '".$this->pID."'

														                                  and opb.products_id = p.products_id

														                                  and opb.orders_id = o.orders_id

														                                  and p.products_status = '1'

														                                  and pd.language_id = '".(int) $_SESSION['languages_id']."'

														                                  and opb.products_id = pd.products_id

														                                  ".$group_check."

														                                  ".$fsk_lock."

														                                  group by p.products_id order by o.date_purchased desc ".MAX_DISPLAY_ALSO_PURCHASED;[/PHP]

hat jmd eine idee?

mfg

[philipp1988]

// EDIT:

Problem gelöst.

Habe die product.php einfach nochmal neu hochgeladen.

mfg