Jump to content
xt:Commerce Community Forum

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

Link to comment
Share on other sites

Archived

This topic is now archived and is closed to further replies.

×
  • Create New...