php.net |  support |  documentation |  report a bug |  advanced search |  search howto |  statistics |  random bug |  login

go to bug id or search bugs for

Bug #1123 Cannot update to a MEDIUM/LONGBLOB with data > 65450 characters
Submitted: 1999-02-06 18:25 UTC Modified: 1999-02-06 18:35 UTC
From: q98 at besiex dot org Assigned:
Status: Closed Package: MySQL related
PHP Version: 3.0.6 OS: Linux 2.0.35 / Windows 98
Private report: No CVE-ID: None
View Developer Edit
Welcome back! If you're the original bug submitter, here's where you can edit the bug or add additional notes.
If you forgot your password, you can retrieve your password here.
Password:
Status:
Package:
Bug Type:
Summary:
From: q98 at besiex dot org
New email:
PHP Version: OS:

 

 [1999-02-06 18:25 UTC] q98 at besiex dot org 
The error I get from PHP is:

2006, MySQL server has gone away

And I wrote some test code to figure out where the limit was, and sure enough it can UPDATE something 65450 characters long, but not 65460.  Works every time at or below 65450, but never above 65460.  Very reproducable, fails every time.  (Fails for 3.0.5 on Win32 and 3.0.6 on Linux.)  

I checked my tables to make sure they are LONGBLOB (tried MEDIUMBLOB, too).  (Not that it should matter, but the field was converted from a BLOB.)

Patches

Pull Requests

History

AllCommentsChangesGit/SVN commitsRelated reports
 [1999-02-06 18:35 UTC] rasmus 
This is a MySQL thing.  Read the MySQL documentation.  If you want to deal with blobs larger than 65K
you have to up the 'max_allowed_packet' size.  Type 'mysqladmin variables' to see the current setting.  This
has nothing to do with PHP.
 
PHP Copyright © 2001-2025 The PHP Group
All rights reserved. 		Last updated: Sun Oct 26 18:00:01 2025 UTC