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

PHP-Code:

    $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; 


hat jmd eine idee?

mfg

[philipp1988]

// EDIT:

Problem gelöst.

Habe die product.php einfach nochmal neu hochgeladen.

mfg