Mysql Felermeldung

[spezibos-world]

i, kann mir jemand helfen sad.gif . Wenn ich zu Kategorien gehe bekomme ich diese Fehlermeldung.

Ich habe schon gelesen, dass man irgendwas ?ndern muss im index.php, aber wo und wie genau ?

ich bin Sehr dankbar f?r Eure Tipps.

1054 - Unknown column 'p.products_id' in 'on clause'

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 p left join manufacturers m on p.manufacturers_id = m.manufacturers_id, products_to_categories p2c 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 = '2' ORDER BY p.products_price ASC

[XT SQL Error]

[woschwarz]

Hi, habe etwas rumgespielt und bin auf diese L?sung gekommen. Du musst in der datei /includes/modules/default.php in der Zeile 301 bis 328 den Code:

  $listing_sql = "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 ".TABLE_PRODUCTS_DESCRIPTION." pd, ".TABLE_PRODUCTS." p left join ".TABLE_MANUFACTURERS." m on p.manufacturers_id = m.manufacturers_id, ".TABLE_PRODUCTS_TO_CATEGORIES." p2c

                  left join ".TABLE_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

                  ".$group_check."

                  ".$fsk_lock."                

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

                  and p2c.categories_id = '".$current_category_id."'".$sorting;

durch diesen Code ersetzen:

  $listing_sql = "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 ".TABLE_PRODUCTS_DESCRIPTION." pd, ".TABLE_PRODUCTS." p left join ".TABLE_SPECIALS." s on p.products_id = s.products_id 

       left join ".TABLE_MANUFACTURERS." m on p.manufacturers_id = m.manufacturers_id, ".TABLE_PRODUCTS_TO_CATEGORIES." p2c

                  where p.products_status = '1'

                  and p.products_id = p2c.products_id

                  and pd.products_id = p2c.products_id

                  ".$group_check."

                  ".$fsk_lock."                

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

                  and p2c.categories_id = '".$current_category_id."'".$sorting;

gru?, Wolfgang

[smokwawelski]

Kategorien = CODE O.K. :-)

Schnellkauf = 1054 - Unknown column 'p.products_id' in ... :-(

Suche = Unknown column 'p.products_id' in ...... :-(

Help

[J?rg]

Edit2:

Vermutlich sql-Version. Welche l?uft auf deinem Server. Und welche Shopversion hast du? Bei der Vers.5 kann oder gibt es Probleme.

Lies mal da:

http://www.xt-commerce.com/forums/index.php?showtopic=27302

[Johnny23]

Die Link is nicht mehr aktuell

Wenn ich diese Losung versuche bekomm ich dieser Fehler:

1054 - Unknown column 'p.products_ean' in 'field list'

Kann jemand bitte helfen ??

Danke,

Johnny