MyBB Central

Full Version: max_allowed_packet
You're currently viewing a stripped down version of our content. View the full version with proper formatting.
what is " max_allowed_packet " ?

when occuring ?


Code:
Fatal error: [SQL] [1153] Got a packet bigger than 'max_allowed_packet' bytes
REPLACE INTO mybb_datacache SET `title`='forumpermissions',`cache`='a:200:{i:0;i:0;i:3;a:1:{i:54;a:18:{s:3:\"pid\";s:4:\"1648\";s:3:\"fid\";s:1:\"3\";s:3:\"gid\";s:2:\"54\";s:7:\"canview\";s:1:\"0\";s:14:\"canviewthreads
\";s:1:\"1\";s:21:\"canonlyviewownthreads\";s:1:\"0\";s:16:\"candlattachments\";s:1:\"1\";s:14:\"canpostthreads\
";s:1:\"1\";s:13:\"canpostreplys\";s:1:\"1\";s:18:\"canpostattachments\";s:1:\"0\";s:14:\"canratethreads\";s:1:\"1
\";s:12:\"caneditposts\
";s:1:\"1\";s:14:\
"candeleteposts\";s:1:\"1\";s:16:\"candeletethreads\";s:1:\"1\";s:18:\"caneditattachments\";s:1:\"1\";s:12:\"canpostpolls\
";s:1:\"1\";s:12:\"canvotepolls\";s:1:\"1\";s:9:\"cansearch\";s:1:\"1\";}}i:11;a:44:{i:2;a:18:{s:3:\"pid\";s:4:\"1707\";s:3:\
"fid\";s:2:\"11\";s:3:\"gid\";s:1:\"2\";s:7:\"canview\";s:1:\"1\";s:14:\"canviewthreads\";s:1:\"1\";s:21:\"canonlyviewownthreads\
";s:1:\"0\";s:16:\"candlattachments\";s:1:\"1\";s:14:\"canpostthreads\";s: in /home/nasleand/public_html/inc/db_mysql.php on line 550
Go into SSH and run these:

Code:
mysql -u admin -p

set global net_buffer_length=1000000;

set global max_allowed_packet=1000000000;