Problem with "packet bigger than 'max_allowed_packet' error" - Webmaster Forums - Webmaster forum for HTML, PHP, ASP, CSS and more

jeddiki · 12-25-2011, 11:55 AM

Hi
I am running an update to a database and I keep getting this error:

Quote:

Could not Insert to CB_MAIN (update)Got a packet bigger than 'max_allowed_packet' bytes

And it is from this code:

PHP Code:


			
$result_upd = mysql_query($sql_upd) or write_error("Could not Insert to CB_MAIN (update)".mysql_error()." \r\n");

The write_error() function writes to a log and on line no. 79,870 I get that error.

Searched and read this:

Quote:

You probably have to change it for both the client (you are running to do the import) AND the daemon mysqld that is running and accepting the import.
But didn't understand it.

My system is as follows:

Operating system CentOS Linux 6.0
Perl version 5.010001
Path to Perl /usr/bin/perl
BIND version 9.7.0
Postfix version 2.6.6
Apache version 2.2.15
PHP version 5.3.2
Webalizer version 2.21-02
Logrotate version 3.7.8
MySQL version 5.1.52

Would much appreciate it if some would help me by telling me what config files need to be changed and where they might be.

Thanks.

sandman · 12-30-2011, 02:26 PM

Login to your mysql server to increase the size limits.

# mysql -u admin -p

mysql> set global net_buffer_length=1000000;
Query OK, 0 rows affected (0.00 sec)

mysql> set global max_allowed_packet=1000000000;
Query OK, 0 rows affected (0.00 sec)