PHPMyAdmin alert box - missing value in the form -

2019-01-27 18:31发布

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!".

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

PHPMyAdmin Create Table Modal Box

What I've tried so far:

  • Changing the data types all to VARCHAR with a length of 255 (except for the deindeal_id column, which remained INT with a length of 12).
  • 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!

11条回答
孤傲高冷的网名
2楼-- · 2019-01-27 18:50

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

查看更多
倾城 Initia
3楼-- · 2019-01-27 18:51

Stop & start MySQL service. You can create table.

查看更多
爱情/是我丢掉的垃圾
4楼-- · 2019-01-27 18:53

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.

查看更多
甜甜的少女心
5楼-- · 2019-01-27 18:56

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.

查看更多
萌系小妹纸
6楼-- · 2019-01-27 18:56

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.

Switch back to Original theme:

Home > Theme: "Original"

Disable the popup:

Home > More settings > SQL queries > Disable: "Edit in window"
查看更多
登录 后发表回答