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! If you don't have a Git account, you can't do anything here.
If you reported this bug, you can edit this bug over here.
(description)
Block user comment
Status: Assign to:
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 Jun 01 20:01:26 2025 UTC