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


Problem

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.


Cause

This problem occurs in Magento 1.9.4.3+ 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.


Solutions

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


Alternatively, the attached patch can be applied.