phpMyAdmin错误:#1054 - 'order clause'中的未知列'systeem_eisen' [英] phpMyAdmin error: #1054 - Unknown column 'systeem_eisen' in 'order clause'
问题描述
昨天我从表中删除了一个名为systeem_eisen的列。
现在当我在表'products'上点击phpMyAdmin时,我得到错误信息:
#1054 - 'order clause'列'systeem_eisen' code>
我无法打开表'products'。但我的网站仍然可以工作(他也使用表'产品')。
但是当我导出表'products',我看到代码我看不到'systeem_eisen'。
有人可以帮助我,
感谢您的意见。
$ b $对我来说,唯一的方法是在搜索选项下将现有列的顺序设置为:i.stack.imgur.com/7J34p.pngalt =enter image description here>
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').
But when I export the table 'products' and I watch the code I see nowhere the word 'systeem_eisen'.
Can someone help me,
Thanks in advange.
For me the only way was to set the order to an existing column under the search options:
这篇关于phpMyAdmin错误:#1054 - 'order clause'中的未知列'systeem_eisen'的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!