Incorrect string value: 'xC4x81ne' for column
ALTER TABLE table_name CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;Incorrect string value: 'xC4x81ne' for column
ALTER TABLE table_name CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;phpMyAdmin - Error Incorrect format parameter
1. Exceed PHP limits
First of all, we start by checking the PHP parameters.
However, the exact location of the PHP configuration depends on the server we
are looking into. Let’s discuss a few such types.
1. If it’s WHM, then the config is located at
WHM->Server configuration -> Tweak Settings.
2. For the Ubuntu server with Apache, it is in
/etc/php/{PHPversion}/apache2/php.ini.
3. If it’s a local machine with Xammp: xampp/php/php.ini.
4. For Nginx webserver : /etc/php/{PHPversion}.
We change the following parameters based on requirements.
max_execution_time = 3000
max_input_time = 60
memory_limit = 128M
post_max_size = 200M
upload_max_filesize = 200M
We restart the apache service for the changes to reflect. If the issue still
persists, we further change the execution time limit in the phpmyadmin
configuration file. For WHM/cPanel it is generally located at
/usr/local/cpanel/base/3rdparty/phpMyAdmin/config.inc.php. Here again,
configuration file location may vary depending on the type of server.
reference:
https://bobcares.com/blog/phpmyadmin-error-incorrect-format-parameter/Copyright © 2021 Codeinu
Forgot your account's password or having trouble logging into your Account? Don't worry, we'll help you to get back your account. Enter your email address and we'll send you a recovery link to reset your password. If you are experiencing problems resetting your password contact us
