This problem affects DHL Versenden up to version 1.5.1. It is resolved in newer versions.


If the filter "DHL Label Status" is used in the order list, the following error occurs:

Column not found: 1054 Unknown column 'status_code' in 'where clause', query was: SELECT COUNT(*) FROM `sales_flat_order_grid` AS `main_table` WHERE (`status_code` = '10')

The order list then cannot be accessed anymore, until the user logs out and logs in again.


This problem occurs in Magento or with the patch SUPEE-11219 in conjunction with DHL Versenden up to version 1.5.1.

The DHL Versenden module needs to be adapted to fix the status filter.


The problem is resolved in newer module versions (after 1.5.1).

Alternatively, the attached patch can be applied.