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

mysql laravel mariadb mariadb-10.3
wbhuana picture wbhuana · Nov 4, 2020 · Viewed 13.5k times · Source

Suddenly got

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

on Laravel.

I already checked this: MySQL: ERROR 2027 (HY000): Malformed packet, but it seems a different case.

  1. I've successfully logged in to MySQL after previously login using SSH (using: mysql -u -p).
  2. I've successfully logged in to MySQL directly from a remote PC (using: mysql -h [IP] -u -p).

But my Laravel got the error I mentioned before. Any experience in this?

Answer

felixmensah6 picture felixmensah6 · Nov 5, 2020

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)

Related questions

Invalid datetime format: 1366 Incorrect string value

I'm getting this error: SQLSTATE[22007]: Invalid datetime format: 1366 Incorrect string value: '\xBD Inch...' for column 'column-name' at row 1 My database, table, and column have the format utf8mb4_unicode_ci also column-name is type text and NULL. This …

Read More
General error: 1615 Prepared statement needs to be re-prepared

I have been running into this issue every time I try and sync a medium size JSON object to my database so we can perform some reporting on it. From looking into what can cause it I have come across …

Read More
PDOException SQLSTATE[HY000] [2002] No such file or directory

I believe that I've successfully deployed my (very basic) site to fortrabbit, but as soon as I connect to SSH to run some commands (such as php artisan migrate or php artisan db:seed) I get an error message: [PDOException] …

Read More