[FIXED] PhpMyAdmin change default insert rows value

Issue

When you try to insert a single row in a table using PhpMyAdmin it has a default number of rows to insert set to 2, so everytime I have to change that value to 1, otherwise it throws a truncated error, and adds 2 rows (The second one being empty). How can I change this default value to 1 ?

Solution

From the phpMyAdmin main page:

Settings > Main panel (or: Main frame) > Edit mode > Number of inserted rows

Change the value and hit Apply.

Tested with phpMyAdmin 3.4.11 and 4.2.10. See also phpMyAdmin 4.2 documentation: $cfg['InsertRows'].

Answered By - Peter Nowee