Jump to content
xt:Commerce Community Forum
Sign in to follow this  
Sebastian05

1054 - Unknown column???

Recommended Posts

Hi@all

ich hab ein problem mit meinem shop bzw SQL

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

Er zeigt mir an wenn ich die unterkategorien öffnen mag folgendes an:

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 p.group_permission_0=1 and pd.language_id = '2' and p2c.categories_id = '66' ORDER BY p.products_price ASC

[XT SQL Error]

was ich garnicht verstehen kann, denn ich habe nichts an der SQL verändert?

wer kann mir helfen? Ist das ein provider fehler? Oder wo is der haken

Share this post


Link to post
Share on other sites
Sign in to follow this  

×
×
  • Create New...