Jump to content
xt:Commerce Community Forum

mysql-Fehlermeldung


cosmerba

Recommended Posts

Ich habe folgende Fehlermeldung per Email erhalten. Aus der Fehlermeldung kann ich zwar sehen, welche DB-Tabellen ein Problem sein könnte, doch schlau werde ich nicht daraus.

Könnte mir jemand bei der 'Übersetzung' etwas helfen? Thx

mysql error: [1054: Unknown column 's.group_permission_14' in 'where clause'] in EXECUTE("SELECT COUNT(*) FROM (SELECT p.products_id FROM xt_products p RIGHT JOIN xt_products_price_special s ON (s.products_id = p.products_id) left JOIN xt_products_permission group_permission ON (group_permission.pid = p.products_id and group_permission.pgroup = 'group_permission_14' ) left JOIN xt_products_permission shop ON (shop.pid = p.products_id and shop.pgroup = 'shop_1' ) LEFT JOIN xt_seo_url su ON (p.products_id = su.link_id and su.link_type='1') WHERE p.products_id != '' and s.status = '1' and (s.group_permission_14=1 or s.group_permission_all=1) and group_permission.permission IS NULL and shop.permission IS NULL and p.products_fsk18!=1 and p.products_status = '1' and su.language_code = 'de' and (p.products_master_model='' or p.products_master_model IS NULL) GROUP BY p.products_id ) _ADODB_ALIAS_ LIMIT 1")

Link to comment
Share on other sites

Archived

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

×
  • Create New...