How to fix phpMyAdmin error - Incorrect format parameter

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.

phpMyAdmin error - Incorrect format parameter - Clue Mediator

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.

max_execution_time = 3000
max_input_time = 600
memory_limit = 512M
post_max_size = 256M
upload_max_filesize = 256M

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.

$cfg['ExecTimeLimit'] = 300;

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

$cfg['ExecTimeLimit'] = 0;

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