PhpMyAdmin error: # 1054 - Unknown column 'systeem_eisen' in 'order clause'

Question

Yesterday I deleted the "systeem_eisen" column from the table. Now, when I click in phpMyAdmin behind the products table, I get an error message:
#1054 - column 'systeem_eisen' in 'order clause'
I can not open the table "products". But my site is still working (it also used the “products” table).

But when I export the table “products” and I look at the code, I do not see the word “systeem_eisen” anywhere.

Can someone help me

Thanks for the help.

Answer 1

For me, the only way was to set the order of an existing column in the search options:

Answer 2

Open the phpmyadmin database, you will see pma_table_uiprefs . It stores preferences "cached", and you can delete or edit them.

Answer 3

It works.
I insert the column back, then I change the standard sql when you click to explore in phpMyAdmin.

When I deleted the column, there are no errors. Hooray!

Answer 4

I ran into this problem and none of these suggestions worked for me. The reason in my case was that phpmyadmin had sorting for the modified / dropped column, and I needed to fix it. Here is what resolved this for me.

In phpmyadmin, select your database in the left navigation pane. You will see all your tables, in which case we are interested in 'systeem_eisen' . After you find the table, click Structure .

Now you will see all the columns in the table. All you have to do is delete the sort or change it accordingly.

Now you can open the table.

Answer 5

I just refresh the page and it worked.

Answer 6

I got this error when I tried to view records using PHPMyAdmin, but I could see the table structure. In my case, this was because there was no primary key in the table.

Answer 7

the problem with was not able to insert crated_at and updated_at but when i am inert one by one it works and the problem is that there is an underscore '_' in my table https://sourceforge.net/p/phpmyadmin/bugs / 4208 /