Today, we’ll explain to you how to fix phpMyAdmin error – “Incorrect format parameter” that occurred when importing the database in phpMyAdmin.

Error:

phpMyAdmin – Error

Incorrect format parameter

Look at the following image for your reference.

Reasons for phpMyAdmin error – Incorrect format parameter

There are multiple reasons for phpMyAdmin error – Incorrect format parameter such as:

• Script runs longer than defined maximum execution time.
• Requested input data exceeds the defined limit.
• Script memory higher than the defined memory limit.
• Size of post data higher than the defined maximum post data size.
• Size of the file more than defined maximum file size.

Fixed the phpMyAdmin error – Incorrect format parameter

Now, we need to update or increase the value of the all above settings in the php.ini file. In the local machine php.ini file is located on xampp/php/php.ini and

In the ubuntu server it will be found on /etc/php/{PHPversion}/apache2/php.ini.

Now we will update the settings in the php.ini file as per the requirements as given below.

After that restart the apache server to reflect the changes. If the error still occurs then open \phpmyadmin\libraries\config.default.php file and change the value of the ExecTimeLimit parameter to disable the script execution time limit.

You will find it in config.default.php file as below.

We need to set the value to 0 to disable the execution time limit as follows.

That’s it for today.
Thank you for reading. Happy Coding..!!