Increase max_input_vars for PhpMyAdmin | vetechno

Increase max_input_vars for PhpMyAdmin | vetechno
Increase max_input_vars for PhpMyAdmin | vetechno


In this blog post we are going to fix a warning message i.e Warning: a form on this page has more than 1000 fields. On submission, some of the fields might be ignored, due to PHP's max_input_vars configuration. 

This message generally comes when we export a large database table from phpMyAdmin. This warning message is about the default max_input_vars value seen in the phpMyAdmin’s  or php.ini configuration file:

Also read 

 
 
 

How to Fix Warning: a form on this page has more than 1000 fields

Step1. Open php.ini file from your favorite text editor,

In my case location of php.ini file is /etc/php.ini 

Note:- The location may differ according to the PHP version.

Step2. Search line max_input_vars

By default the line max_input_vars will be commented, To enable uncomment by removing ; 

; How many GET/POST/COOKIE input variables may be accepted
max_input_vars = 1000

If still not work then change the value

max_input_vars = 1000 to max_input_vars = 100000;

Step3. Now restart the Nginx or Apache and Mysql service.

Conclusion

We have now increase max_input_vars for PhpMyAdmin . Let us know if you are still facing issue in the comment box.

You may also link

Comments

Post a Comment

Popular posts from this blog

Fixed - loading shared libraries: libpangox-1.0.so.0: Anydesk on Ubuntu 22.04 | vetechno

Image
Fixed - loading shared libraries: libpangox-1.0.so.0: Anydesk on Ubuntu 22.04 | vetechno When I successfully Installed latest Anydesk on my local Ubuntu 22.04 Jammy Jellyfish system. And tried to run the Anydesk application, it doesn't launch/start. when I checked the status service, the anydesk service was failed. And got the below error message Fixed - loading shared libraries: libpangox-1.0.so.0: Anydesk on Ubuntu 22.04 | vetechno Error is looks like /usr/bin/anydesk: error while loading shared libraries: libpangox-1.0.so.0: cannot open shared object file: No such file or directory anydesk.service: Failed with result 'exit-code'. libpangox-1.0.so.0 is a library used for text layout and rendering the text. Most of the work on Pango-1.0 was done using the GTK+ widget toolkit as a test platform. Basically what I have done is just installed libpangox library which is used by Anydesk service to launch. Also Read: * Install Anydesk on Ubuntu 22.04 LTS Jammy Jellyfish How to...
Read more

Failed to establish the VPN connection. This may be caused by a mismatch in the TLS version.

Image
Failed to establish the VPN connection. This may be caused by a mismatch in the TLS version.  Hey readers, In this post  we will share you how to fix " Failed to establish the VPN connection. This may be caused by a mismatch in the TLS version. Please check the TLS version settings in the Advanced of the Internet options:- (5029) " error that comes in windows 10 or windows 7 while connecting to VPN. This error generally happens because of the TLS mismatch in the windows machine or client machine. Read Also:-  How to Download and install Windows 11 on Virtual Box | VMware | Laptop Download, install and activate Microsoft Office 2019 for FREE legally How to Download Windows 11 ISO file [Direct Google Drive link] 2021   How to Fix Forticlient TLS 'error 5029': failed to establish the VPN connection ? Step1. Go to Internet Explorer. Step2. Now search for setting and  then select internet option/properties. OR Open run box and type "inetcpl.cpl" Step3. Select...
Read more

To make SSL VPN connection work, please turn off IE security configuration | vetechno

Image
turn off internet explorer enhanced security configuration server 2019   Hello reader, if you are installing and configuring SSL Forticlient VPN on Windows Server 2019, you might got a warning message saying that " To make SSL VPN connection work, please turn off IE security configuration " on Windows server 2019. In this blog, we will fix the warning message and configure the SSL Forticlient VPN on Windows Server 2019. Failed to establish the VPN connection. This may be caused by a mismatch in the TLS version. How do you turn off Internet Explorer Enhanced Security Configuration is enabled? If Internet Explorer Enhanced Security Configuration (IE ESC) is turned on, you will receive an error message to disable this setting before you can log on Application. To avoid this problem, follow the below simple steps. To turn off Internet Explorer Enhanced Security Configuration: Step 1. Enter Server Manager in Windows search to start Server manager application. Step 2. Select Lo...
Read more