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

phpMyAdmin error: #1054 - Unknown column #39;systeem_eisen#39; in #39;order clause#39;(phpMyAdmin 错误:#1054 - order 子句中的未知列systeem_eisen)

问题描述

昨天我从表中删除了一个名为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:

这篇关于phpMyAdmin 错误:#1054 - 'order 子句'中的未知列'systeem_eisen'的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持编程学习网！