MyBB Community Forums

Hi,

I have updated my board from 1.4.9 to 1.4.10.
The last update (1.4.8 to 1.4.9) i didn't run upgrade script.

For the 1.4.10, the upgrade script done me an error:

Fatal error: [SQL] [1153] Got a packet bigger than 'max_allowed_packet' bytes
REPLACE INTO mybb_datacache SET `title`='forumpermissions',`cache`='a:127:{i:0;i:0;i:157;a:23:{i:1;a:17:{s:3:\"pid\";s:4:\"8176\";s:3:\"fid\";s:3:\"157\";s:3:\"gid\";s:1:\"1\";s:7:\"canview\";s:1:\"0\";s:14:\"canviewthreads\";s:1:\"0\";s:16:\"candlattachments\";s:1:\"0\";s:14:\"canpostthreads\";s:1:\"0\";s:13:\"canpostreplys\";s:1:\"0\";s:18:\"canpostattachments\";s:1:\"0\";s:14:\"canratethreads\";s:1:\"0\";s:12:\"caneditposts\";s:1:\"1\";s:14:\"candeleteposts\";s:1:\"1\";s:16:\"candeletethreads\";s:1:\"0\";s:18:\"caneditattachments\";s:1:\"0\";s:12:\"canpostpolls\";s:1:\"0\";s:12:\"canvotepolls\";s:1:\"0\";s:9:\"cansearch\";s:1:\"0\";}i:2;a:17:{s:3:\"pid\";s:4:\"8177\";s:3:\"fid\";s:3:\"157\";s:3:\"gid\";s:1:\"2\";s:7:\"canview\";s:1:\"0\";s:14:\"canviewthreads\";s:1:\"0\";s:16:\"candlattachments\";s:1:\"0\";s:14:\"canpostthreads\";s:1:\"0\";s:13:\"canpostreplys\";s:1:\"0\";s:18:\"canpostattachments\";s:1:\"0\";s:14:\"canr in /home/user/public_html/mybbsite/inc/db_mysql.php on line 548

I contacted my host support and they modified "max_allowed_packet" to 128MB.
I get again this error.

My question: what value do they bring to "max_allowed_packet" ?

Thank you

You didn't need the upgrade script for 1.4.8 > 1.4.9.

We can't do anything about this, you'll need to contact your host again.

(2009-12-09, 11:03 PM)MattRogowski Wrote: [ -> ]You didn't need the upgrade script for 1.4.8 > 1.4.9.

We can't do anything about this, you'll need to contact your host again.

And what "max_allowed_packet" value do you recommend ?
128MB is it a normal value ?

I don't really know what the best value is, it's only 1MB on my localhost and I've never seen this error, and I've done fairly large upgrades and merges on it. How big is your forum??

It looks to me like they accidentally set it to 128 BYTES instead of 128 MEGABYTES. And 128MB should be PLENTY! I've run production servers with only an 8MB limit and no problems.