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 Add Comment Developer Edit
 [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

Add a Patch

Pull Requests

Add a Pull Request

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-2024 The PHP Group
All rights reserved. 		Last updated: Sun Apr 28 06:01:30 2024 UTC