At 11:13 AM +1000 8/27/99, Cameron Just wrote:
>Hi,
>
>I am running
>Ver 7.11 Distrib 3.22.25, for pc-linux-gnu on i686
>
>
>I get an error when I try to do the following.
>update messages set status = 'read' where id = 1568;
>ERROR 2013: Lost connection to MySQL server during query
>
>It only happens when I try to update an record with a 'body' field greater
>than ~40K
>all other queries to records which have smaller 'body' fields work perfectly.
>
>
>Table Messages
>+--------------+--------------+------+-----+---------+----------------+
>| Field | Type | Null | Key | Default | Extra |
>+--------------+--------------+------+-----+---------+----------------+
>| id | int(11) | | PRI | 0 | auto_increment |
>| userid | int(11) | | MUL | 0 | |
>| headers | blob | YES | | | |
>| body | longblob | YES | | | |
>| popid | varchar(64) | YES | | | |
>| folderid | int(11) | YES | | | |
>| attachmentid | int(11) | YES | | | |
>| recieveddate | int(11) | YES | | | |
>| status | varchar(255) | YES | | | |
>+--------------+--------------+------+-----+---------+----------------+
Is your server running with a small value of the max_allowed_packet
parameter?
--
Paul DuBois, paul@stripped
Northern League Chronicles: http://www.snake.net/nl/
