phpMyAdmin 错误:#1054 - 'order 子句'中的未知列'systeem_eisen'

2022-01-05 00:00:00 sql database php phpmyadmin

昨天我从表中删除了一个名为systeem_eisen"的列.现在,当我在产品"表中单击 phpMyAdmin 时,我收到错误消息:
#1054 - 'order 子句'中的'systeem_eisen'列
我无法打开产品"表.但我的网站仍然有效(他还使用了产品"表).

Yesterday I removed a column called 'systeem_eisen' from a table. Now when I click in phpMyAdmin at the table 'products' I get the error message:
#1054 - column 'systeem_eisen' in 'order clause'
I can't open the table 'products'. But my website still works(he used also the table 'products').

但是当我导出表产品"并查看代码时,我在任何地方都看不到systeem_eisen"这个词.

But when I export the table 'products' and I watch the code I see nowhere the word 'systeem_eisen'.

推荐答案

对我来说,唯一的方法是将顺序设置为搜索选项下的现有列:

For me the only way was to set the order to an existing column under the search options:

相关文章