1054 - Unknown column 'o.dpd_tacking_id' in 'field list'

[A-C]

Das bekomme ich immer Angezeigt im Adminbreich unter Bestellungen.

1054 - Unknown column 'o.dpd_tacking_id' in 'field list'

select o.orders_id, o.orders_status, o.afterbuy_success, o.afterbuy_id, o.dpd_tacking_id, o.customers_name, o.payment_method, o.date_purchased, o.last_modified, o.currency, o.currency_value, s.orders_status_name, ot.text as order_total, o.dpd_tacking_id, o.delivery_postcode from orders o left join orders_total ot on (o.orders_id = ot.orders_id), orders_status s where (o.orders_status = s.orders_status_id and s.language_id = '2' and ot.class = 'ot_total') or (o.orders_status = '0' and ot.class = 'ot_total' and s.orders_status_id = '1' and s.language_id = '2') order by o.date_purchased DESC limit 0, 100

[XT SQL Error]

Jemand eine Idee was zu bedeuten hat?

[P.Schwarz]

Hallo A-C,

ich glaub da fehlt einfach nur ein "r", ich kenne nämlich nur die "tracking_id" des Deutschen Post Dienstes.

select o.orders_id, o.orders_status, o.afterbuy_success, o.afterbuy_id, o.dpd_tracking_id, o.customers_name, o.payment_method, o.date_purchased, o.last_modified, o.currency, o.currency_value, s.orders_status_name, ot.text as order_total, o.dpd_tacking_id, o.delivery_postcode from orders o left join orders_total ot on (o.orders_id = ot.orders_id), orders_status s where (o.orders_status = s.orders_status_id and s.language_id = '2' and ot.class = 'ot_total') or (o.orders_status = '0' and ot.class = 'ot_total' and s.orders_status_id = '1' and s.language_id = '2') order by o.date_purchased DESC limit 0, 100

MfG

Schwarz

[A-C]

Das wäre ja Super einfach.

In welcher Datei kann man das korrigieren?

Lg A-C

[A-C]

Keiner eine Idee?

[A-C]

Ich werde natürlich demjenigen der mir das Problem erklären kann bzw. es lösen kann bezahlen.