PHPMyAdmin警报框-表单中缺少值-填写所有常用字段吗? [英] PHPMyAdmin alert box - missing value in the form - all usual fields are filled out?
问题描述
由于某些原因,在使用PHPMyAdmin并尝试保存表时,即使我通常已经输入了所有信息,但通常会弹出一个警告框,其中显示内容为表单中缺少值!".
For some reason while using PHPMyAdmin and attempting to save a table, even though I've entered all of the information I usually do I'm getting an alert box popping up with the content "Missing value in the form!".
以下是我的PHPMyAdmin控制台的屏幕截图(由于分辨率原因,合并了两个屏幕):
到目前为止,我已经尝试过:
- 将所有数据类型都更改为长度为
255
的VARCHAR
(deindeal_id
列除外,该列仍为长度为12
的INT
). - 将
description
括在`"(字母)中,以为它可能是某种保留字. - 添加联盟.
- 使用不同的表引擎(InnoDB,MyISAM(我想要的那个)).
- Changing the data types all to
VARCHAR
with a length of255
(except for thedeindeal_id
column, which remainedINT
with a length of12
). - Encasing
description
in "`" (bacticks), thinking it may be a reserved word of some sort. - Adding a coalition.
- Using different table engines (InnoDB, MyISAM (the one I wanted)).
对于可能导致此问题的原因,我真的感到很困惑,因此,任何答复将不胜感激!
I'm really stumped as to what could be causing this issue, so any answers would be greatly appreciated!
推荐答案
遇到相同的错误,可能是错误.
Got the same error, probably a Bug.
Lex所说的话:也许如果您定义的列NOT NULL(即,不选中Null列中的框,则必须定义一个默认值?– Lex在20小时前")
What Lex said: "Maybe if you define a column NOT NULL (ie. don't check the box in the Null column, you have to define a default value? – Lex 20 hours ago"
- 不.也不起作用,也没有任何意义.如果您未定义默认值,则服务器将插入一个空字符串,或者使查询失败;取决于设置.
这篇关于PHPMyAdmin警报框-表单中缺少值-填写所有常用字段吗?的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!