PHPMyAdmin alert box - missing value in the form -

Question

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!

Answer 1

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

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

Answer 2

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 then hit Go..and it worked.

Answer 3

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

Answer 4

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

Answer 5

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"

• 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.

Answer 6

I got this problem too and I had opened same database in phpmyadmin in two separate tabs of browser . When I closed one tab and access phpmyadmin, the problem disappeared.