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/in...howtopic=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