MySQL PHPMyAdmin 警报框 - 表单中缺少值 - 所有常用字段都已填写？

PHPMyAdmin alert box - missing value in the form - all usual fields are filled out?

提问by Avicinnian

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 并尝试保存表格时，即使我已经输入了我通常所做的所有信息，我也会收到一个弹出的警告框，内容为“表单中缺少值！”。

Here's a screenshot of my PHPMyAdmin console (2 screens merged due to resolution):

这是我的 PHPMyAdmin 控制台的屏幕截图（由于分辨率而合并了 2 个屏幕）：

PHPMyAdmin Create Table Modal Box

PHPMyAdmin 创建表格模式框

What I've tried so far:

到目前为止我尝试过的：

• Changing the data types all to VARCHARwith a length of 255(except for the deindeal_idcolumn, which remained INTwith a length of 12).
• Encasing descriptionin "`" (bacticks), thinking it may be a reserved word of some sort.
• Adding a coalition.
• Using different table engines (InnoDB, MyISAM (the one I wanted)).

• 将数据类型全部更改VARCHAR为长度为 的255（deindeal_id列除外，其INT长度为12）。
• 包含description在 "`" (bacticks) 中，认为它可能是某种保留字。
• 添加一个联盟。
• 使用不同的表引擎（InnoDB、MyISAM（我想要的））。

I'm really stumped as to what could be causing this issue, so any answers would be greatly appreciated!

我真的很难理解是什么导致了这个问题，所以任何答案都将不胜感激！

采纳答案by Daniel

Got the same error, probably a Bug.

遇到同样的错误，可能是一个错误。

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"

Lex 所说的话：“也许如果你定义一个 NOT NULL 列（即不选中 Null 列中的框，你必须定义一个默认值？ – Lex 20 小时前”

• Nope. Doesn't work either and wouldn't make much sense. If you don't define a default value, the server will either insert an empty string, or fail the query; depending on settings.

• 不。也不起作用，也没有多大意义。如果没有定义默认值，服务器要么插入空字符串，要么查询失败；取决于设置。

回答by julianm

Looks like a bug. Try going to Settings -> Features -> General tab and disable Ajax.

看起来像一个错误。尝试转到设置 -> 功能 -> 常规选项卡并禁用 Ajax。

Then, try to create a new table and it won't use the popup.

然后，尝试创建一个新表，它不会使用弹出窗口。

回答by DACrosby

I had this issue with the SQL form (where you can paste larger blocks of MySQL code). Not sure if it's a fluke, but I selected all of my input and thenhit Go..and it worked.

我在 SQL 表单中遇到了这个问题（您可以在其中粘贴更大的 MySQL 代码块）。不确定这是否是侥幸，但我选择了我所有的输入，然后点击 Go ..并且它起作用了。

回答by Alieze

Did you give it a table name. I had the same problem & I simply forgot to give it a table name...at the top.

你有没有给它一个表名。我有同样的问题，我只是忘了给它一个表名......在顶部。

回答by rew

I just encountered this.... It turns out I was forgetting to provide a name for the new table....

我刚刚遇到了这个......结果我忘记为新表提供一个名称......

回答by sadi

Stop & start MySQL service. You can create table.

停止和启动 MySQL 服务。您可以创建表。

回答by GPE

It's a bug I also "met" on phpMyAdmin v.3.5.1 - Disabling Ajax (and by default I love to disable it) will do the job.

这是我在 phpMyAdmin v.3.5.1 上也“遇到”的一个错误 - 禁用 Ajax（默认情况下我喜欢禁用它）将完成这项工作。

回答by eliorsh

Yes It's a bug. what I did is to stop xampp (or if you're using wampp), and then start them again. after that you will be able to create the table in phpMyAdmin

是的，这是一个错误。我所做的是停止 xampp（或者如果您正在使用 wampp），然后再次启动它们。之后，您将能够在 phpMyAdmin 中创建表

回答by Bigalow

You can also try USE databasename;at the top of your query. In some versions this error seem to happen even if you did select your database, USE databasename;will fix this bug in those situations.

您也可以尝试USE databasename;在查询的顶部。在某些版本中，即使您确实选择了数据库，此错误似乎也会发生，USE databasename;将在这些情况下修复此错误。

回答by Ambidex

I just encountered this in 4.1.11. Seems to be a bug (again?). Disabling the popup and switching to the original theme resolved it somewhat for me, although you'll be without the popup which is a pain in the behind.

我刚刚在4.1.11. 似乎是一个错误（再次？）。禁用弹出窗口并切换到原始主题对我来说在某种程度上解决了它，尽管您将没有弹出窗口，这在后面会很痛苦。

Switch back to Originaltheme:

切换回Original主题：

Home > Theme: "Original"

Disable the popup:

禁用弹出窗口：

Home > More settings > SQL queries > Disable: "Edit in window"