Home/ Questions/Q 43
Next
Answered
Kenil Vasani
Kenil Vasani

Kenil Vasani

View Profile
  • 0
Asked: 2020-11-19T05:52:13+00:00 In:

SQLSTATE[HY000]: General error: 1835 Malformed communication packet on LARAVEL

  • 0

Suddenly got

SQLSTATE[HY000]: General error: 1835 Malformed communication packet (SQL: select * from tb_users where (username = 121211) limit 1)

on Laravel.

laravelmariadbmariadb-10.3mysql
Share

    2 Answers

    1. Kenil Vasani

      Kenil Vasani

      View Profile

      All my Laravel apps running PHP 7.2 had this error but those running on PHP 7.3 did not. So I changed the PHP version to 7.3 and the problem was fixed. (Running Laravel 7)

      • 0
    2. Kenil Vasani

      Kenil Vasani

      View Profile
      Best Answer

      Found the solution. Don’t know if it’s permanent or temporary:

      'mysql' => [
            'driver' => 'mysql',
            'host' => env('DB_HOST', '127.0.0.1'),
            'port' => env('DB_PORT', '3306'),
            'database' => env('DB_DATABASE', 'forge'),
            'username' => env('DB_USERNAME', 'forge'),
            'password' => env('DB_PASSWORD', ''),
            'unix_socket' => env('DB_SOCKET', ''),
            'charset' => 'utf8mb4',
            'collation' => 'utf8mb4_unicode_ci',
            'prefix' => '',
            'strict' => false,
            'engine' => null,
            **'options'   => [PDO::ATTR_EMULATE_PREPARES => true]**
        ],

      make sure that

      ‘options’ => [PDO::ATTR_EMULATE_PREPARES => true]

      exist on mysql connection.

      • 0

    You must login to add an answer.