Bug #1123: Cannot update to a MEDIUM/LONGBLOB with data > 65450 characters
| From: | q98 at besiex dot org | Date: | Sat, 06 Feb 1999 23:25:25 +0000 |
| Subject: | Bug #1123: Cannot update to a MEDIUM/LONGBLOB with data > 65450 characters | ||
| Groups: | php.dev | ||
| Request: | Send a blank email to php-dev+get-3946@lists.php.net to get a copy of this message | ||
From: q98@besiex.org
Operating system: Linux 2.0.35 / Windows 98
PHP version: 3.0.6
PHP Bug Type: MySQL related
Bug description: Cannot update to a MEDIUM/LONGBLOB with data > 65450 characters
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.)
--
PHP Development Mailing List http://www.php.net/
To unsubscribe send an empty message to php-dev-unsubscribe@lists.php.net
For help: php-dev-help@lists.php.net