I already saw that variable and assumed it was related to packet length - as in TCP/IP packet length - not query length.
It's all working now. Thanks!
-Galen
On Dec 11, 2003, at 2:36 AM, Rich Gray wrote:
I have a script that accepts large files (images) and inserts them into[chop]
a MySQL table. The images are manipulated and whatnot, no problems at
all getting the image into a string and running addslashes() on it.
Then I go and use it with a mysql query. This is something I've coded
dozens of times, but now there's a twist. The files are bigger than
I've ever worked with. In theory, I didn't think there would be a
problem, but there is. When I try in insert a file of about 800K or
larger (9-10 MB is as large as I ever try to insert) the insert fails.
The query is written correctly AKAIK, but no data reaches the table I'm
writing to.
Hi Galen
I'd hazard a guess that it is probably your MySQL server settings that are
cause of the problem - in particular check the max_allowed_packet_size (?? -
you'll probably need to check this name as I haven't any docs to hand at the
moment) setting in your my.ini file...
HTH Cheers Rich
-- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
