http://stackoverflow.com/questions/23295343/phpmyadmin-error-1054-unknown-column-systeem-eisen-in-order-clause

Goto phpmyadmin database you will see the pma_table_uiprefs. It stores thoses “cached” preferences and you could delete or edit them.
For me the only way was to set the order to an existing column under the search options: enter image description here
Advertisements