MyBB Community Forums

My board has got a sql error whenever I add a new forum or edit one of the forums...

Please download the file so as to see the error... It's very long...

How can the problem be solved?


Edit:

Sorry, I couldn't upload the file here because it's more than 1 mb as a txt...

Quote:MyBBMyBB SQL Error

MyBB has experienced an internal SQL error and cannot continue.

SQL Error:
1153 - Got a packet bigger than 'max_allowed_packet' bytes

Query:
REPLACE INTO mybb_datacache SET title='forumpermissions',cache='a:207:{i:0;i:0;i:3;a:5:{i:1;a:17:{s:3:\"pid\";s:3:\"412\";s:3:\"fid\";s:1:\"3\";s:3:\"gid\";s:1:\"1\";s:7:\"canview\";s:1:\"1\";s:14:\"canviewthreads\";s:1:\"1\";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:\"0\";s:14:\"candeleteposts\";s:1:\"0\";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:\"1\";}i:3;a:17:{s:3:\"pid\";s:3:\"413\";s:3:\"fid\";s:1:\"3\";s:3:\"gid\";s:1:\"3\";s:7:\"canview\";s:1:\"1\";s:14:\"canviewthreads\";s:1:\"1\";s:16:\"candlattachments\";s:1:\"1\";s:14:\"canpostthreads\";s:1:\"1\";s:13:\"canpostreplys\";s:1:\"1\";s:18:\"canpostattachments\";s:1:\"1\";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:5;a:17:{s:3:\"pid\";s:3:\"562\";s:3:\"fid\";s:1:\"3\";s:3:\"gid\";s:1:\"5\";s:7:\"canview\";s:1:\"1\";s:14:\"canviewthreads\";s:1:\"1\";s:16:\"candlattachments\";s:1:\"1\";s:14:\"canpostthreads\";s:1:\"0\";s:13:\"canpostreplys\";s:1:\"0\";s:18:\"canpostattachments\";s:1:\"0\";s:14:\"canratethreads\";s:1:\"1\";s:12:\"caneditposts\";s:1:\"0\";s:14:\"candeleteposts\";s:1:\"0\";s:16:\"candeletethreads\";s:1:\"0\";s:18:\"caneditattachments\";s:1:\"0\";s:12:\"canpostpolls\";s:1:\"0\";s:12:\"canvotepolls\";s:1:\"1\";s:9:\"cansearch\";s:1:\"1\";}i:7;a:17:{s:3:\"pid\";s:3:\"414\";s:3:\"fid\";s:1:\"3\";s:3:\"gid\";s:1:\"7\";s:7:\"canview\";s:1:\"1\";s:14:\"canviewthreads\";s:1:\"1\";s:16:\"candlattachments\";s:1:\"1\";s:14:\"canpostthreads\";s:1:\"0\";s:13:\"canpostreplys\";s:1:\"0\";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:\"0\";s:18:\"caneditattachments\";s:1:\"0\";s:12:\"canpostpolls\";s:1:\"0\";s:12:\"canvotepolls\";s:1:\"1\";s:9:\"cansearch\";s:1:\"1\";}i:13;a:17:{s:3:\"pid\";s:3:\"596\";s:3:\"fid\";s:1:\"3\";s:3:\"gid\";s:2:\"13\";s:7:\"canview\";s:1:\"1\";s:14:\"canviewthreads\";s:1:\"1\";s:16:\"candlattachments\";s:1:\"1\";s:14:\"canpostthreads\";s:1:\"1\";s:13:\"canpostreplys\";s:1:\"1\";s:18:\"canpostattachments\";s:1:\"1\";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:4;a:9:{i:1;a:17:{s:3:\"pid\";s:3:\"412\";s:3:\"fid\";s:1:\"4\";s:3:\"gid\";s:1:\"1\";s:7:\"canview\";s:1:\"1\";s:14:\"canviewthreads\";s:1:\"1\";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:\"0\";s:14:\"candeleteposts\";s:1:\"0\";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:\"1\";}i:2;a:17:{s:3:\"pid\";s:3:\"991\";s:3:\"fid\";s:1:\"4\";s:3:\"gid\";s:1:\"2\";s:7:\"canview\";s:1:\"1\";s:14:\"canviewthreads\";s:1:\"1\";s:16:\"candlattachments\";s:1:\"1\";s:14:\"canpostthreads\";s:1:\"1\";s:13:\"canpostreplys\";s:1:\"1\";s:18:\"canpostattachments\";s:1:\"1\";s:14:\"canratethreads\";s:1:\"1\";s:12:\"caneditposts\";s:1:\"1\";s:14:\"candeleteposts\";s:1:\"1\";s:16:\"candeletethreads\";s:1:\"0\";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:3;a:17:{s:3:\"pid\";s:3:\"992\";s:3:\"fid\";s:1:\"4\";s:3:\"gid\";s:1:\"3\";s:7:\"canview\";s:1:\"1\";s:14:\"canviewthreads\";s:1:\"1\";s:16:\"candlattachments\";s:1:\"1\";s:14:\"canpostthreads...........................
............................... .................... .....

You'll probably need to ask your host about that - Got a packet bigger than 'max_allowed_packet' bytes, sounds like you've exceeded a host-set limit.

It's my own server. How can I extend 'max_allowed_packet?

Possible to do it with ssh?