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

Kenil Vasani

View Profile
  • 0
Asked: 2020-11-19T06:47:54+00:00 In:

Laravel / MySQL Error: SQLSTATE[HY000]: General error: 1835 Malformed communication packet

  • 0

Short situation description: Yesterday everything was working fine (for months our website were working fine), this morning I got woke up from my colleagues that both of our websites are down.

When trying to access them we receive error:

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

I have checked online and can’t find a solution. I tried to upgrade MySQL to newest version (Maria DB 10.3)

I tried to reset password for database user. (Also no changes)

I checked and tried sollution to set read_rnd_buffer_size=256K in my.cnf file for mysql settings

When I try to call this function directly in phpMyAdmin select * from users where id = 1 limit 1 it returns expected results.

I will appreciate every help, as all of our business depends on these platforms, I need to make them work as soon as possible.

With greetings, Artis.

Edit: When I try to disable function that causes error, it just shows next function, and all over like that. So I believe that Laravel can’t conect with mysql at all.

After deeper research I found out that only Laravel can’t connect to database. On same server I have 2x Laravel applications, Codeigniter and wordpress. Both Laravel applications stopped to work at same time, but codeigniter and wordpress works as expected.

laravelmysqlphp
Share

    1 Answer

    1. Kenil Vasani

      Kenil Vasani

      View Profile
      Best Answer

      for a quick fix just add this

      'options' => [PDO::ATTR_EMULATE_PREPARES => true]

      to config/database.php in

      '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],
    ],
      • 0

    You must login to add an answer.