MyBB Community Forums

Full Version: forumpermissions datacache error (MySQL server has gone away)
You're currently viewing a stripped down version of our content. View the full version with proper formatting.
Hello,

I've recently merged over a forum from SMF 2.5.x to myBB. Since the merge, we've been receiving this error:

SQL Error:2006 - MySQL server has gone awayQuery:REPLACE INTO mybb_datacache SET `title`='forumpermissions',`cache`='a:144:{i:0;i:0;i:3;a:1:{i:1;a:23:{s:3:\"pid\";s:4:\"3742\";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:21:\"canonlyviewownthreads\";s:1:\"0\";s:16:\"candlattachments\";s:1:\"0\";s:14:\"canpostthreads\";s:1:\"0\";s:13:\"canpostreplys\";s:1:\"0\";s:22:\"canonlyreplyownthreads\";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:8:\"modposts\";s:1:\"0\";s:10:\"modthreads\";s:1:\"0\";s:14:\"mod_edit_posts\";s:1:\"0\";s:14:\"modattachments\";s:1:\"0\";s:12:\"canpostpolls\";s:1:\"0\";s:12:\"canvotepolls\";s:1:\"0\";s:9:\"cansearch\";s:1:\"0\";}}i:17;a:8:{i:1;a:23:

Larger Img: http://prntscr.com/87tzxv

The query itself is approx. 2.3million characters long. I already know why I'm receiving this error, it's because the query is way to long and it won't execute. If I were to increase the the SQL packet size in mysql.ini to 3m, executing this long of a query would result in the server crashing.

I receive this error whenever the forumpermissions datacache needs to be written (editing usergroups, editing forums, etc.)

This error is giving me problems because its not entering any forumpermissions into the forum datacache. So, no forum permissions are working at all. E.g: guests can view boards even when they're set not to view, etc.


How can I reduce the size of this query for everything to work properly? What do I need to delete/rebuild? Is this because of the SMF merge?

If you need the forum URL to better analyze, please ask. Thank you anyone for help.

A quick update and some more information:

I (temporarily) fixed the error. I truncated the forumpermissions MySQL table to reset all permissions merged over from my SMF forum. I then manually configured all of the forum permissions again. My forumpermissions table is now at about 850 rows of data, opposed to the previous ~3,000 before truncation.  However, the forumpermissions row for the datacache is still at a staggering high size (1.6m characters). Previously, it was at 2.3m characters (700,000 less characters). The current MySQL packetsize limit is at 2m.  This is still very close to the limit and much higher than it really should be.

Some relevant stats on my forum: 
  • About 5,000 registered members
  • About 50 Usergroups
  • About 150 forums/boards (including child boards)
  • About 850 rows of forumpermissions spread about the forums/boards

From my view, this looks like both a problem in the merge system (SMF 2.x -> myBB 1.8) and a problem in the methods myBB software chooses to store data.
  • Problem in the merge system because it transferred about 3.5x more permissions than what was necessary
  • Problem in the forum software because its not efficiently storing data. My forum has about 850 forum permissions set, I don't really think that's a lot considering this software boasts unlimited expansion. Most web host providers set their MySQL packet size to 1M as default. So, definitely not unlimited. Maybe I shouldn't be expecting myBB to be so simple like my previous forums Rolleyes .

Of course, this is all speculation (for the most part). If anyone has any insight, support, or...anything. Please reply, thanks.
I would like to bump this topic as I have the same issue.
Image: http://puu.sh/qWqtZ/c31b59607b.png

It started happening today after I added some more user groups..

Some stats:
2665 users
107 forums
1200 forum permissions
REPLACE INTO datacache SET `title`='forumpermissions',`cache`='a:78:{i:0;i:0;i:5;a:18:{i:1;a:23:{s:3:\"pid\";s:4:\"3223\";s:3:\"fid\";s:1:\"5\";s:3:\"gid\";s:1:\"1\";s:7:\"canview\";s:1:\"1\";s:14:\"canviewthreads\";s:1:\"1\";s:21:\"canonlyviewownthreads\";s:1:\"0\";s:16:\"candlattachments\";s:1:\"0\";s:14:\"canpostthreads\";s:1:\"0\";s:13:\"canpostreplys\";s:1:\"0\";s:22:\"canonlyreplyownthreads\";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:\"1\";s:18:\"caneditattachments\";s:1:\"0\";s:8:\"modposts\";s:1:\"0\";s:10:\"modthreads\";s:1:\"0\";s:14:\"mod_edit_posts\";s:1:\"0\";s:14:\"modattachments\";s:1:\"0\";s:12:\"canpostpolls\";s:1:\"0\";s:12:\"canvotepolls\";s:1:\"0\";s:9:\"cansearch\";s:1:\"0\";}i:2;a:23:{s:3:\"pid\";s:4:\"3224\";s:3:\"fid\";s:1:\"5\";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:1:\"0\";s:13:\"canpostreplys\";s:1:\"1\";s:22:\"canonlyreplyownthreads\";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:\"0\";s:16:\"candeletethreads\";s:1:\"0\";s:18:\"caneditattachments\";s:1:\"0\";s:8:\"modposts\";s:1:\"0\";s:10:\"modthreads\";s:1:\"0\";s:14:\"mod_edit_posts\";s:1:\"0\";s:14:\"modattachments\";s:1:\"0\";s:12:\"canpostpolls\";s:1:\"0\";s:12:\"canvotepolls\";s:1:\"1\";s:9:\"cansearch\";s:1:\"1\";}i:3;a:23:{s:3:\"pid\";s:4:\"3225\";s:3:\"fid\";s:1:\"5\";s:3:\"gid\";s:1:\"3\";s:7:\"canview\";s:1:\"0\";s:14:\"canviewthreads\";s:1:\"0\";s:21:\"canonlyviewownthreads\";s:1:\"0\";s:16:\"candlattachments\";s:1:\"0\";s:14:\"canpostthreads\";s:1:\"0\";s:13:\"canpostreplys\";s:1:\"0\";s:22:\"canonlyreplyownthreads\";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:\"1\";s:18:\"caneditattachments\";s:1:\"0\";s:8:\"modposts\";s:1:\"0\";s:10:\"modthreads\";s:1:\"0\";s:14:\"mod_edit_posts\";s:1:\"0\";s:14:\"modattachments\";s:1:\"0\";s:12:\"canpostpolls\";s:1:\"0\";s:12:\"canvotepolls\";s:1:\"0\";s:9:\"cansearch\";s:1:\"0\";}i:4;a:23:{s:3:\"pid\";s:4:\"3226\";s:3:\"fid\";s:1:\"5\";s:3:\"gid\";s:1:\"4\";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:1:\"1\";s:13:\"canpostreplys\";s:1:\"1\";s:22:\"canonlyreplyownthreads\";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:\"1\";s:18:\"caneditattachments\";s:1:\"0\";s:8:\"modposts\";s:1:\"0\";s:10:\"modthreads\";s:1:\"0\";s:14:\"mod_edit_posts\";s:1:\"0\";s:14:\"modattachments\";s:1:\"0\";s:12:\"canpostpolls\";s:1:\"1\";s:12:\"canvotepolls\";s:1:\"1\";s:9:\"cansearch\";s:1:\"1\";}i:8;a:23:{s:3:\"pid\";s:4:\"3227\";s:3:\"fid\";s:1:\"5\";s:3:\"gid\";s:1:\"8\";s:7:\"canview\";s:1:\"1\";s:14:\"canviewthreads\";s:1:\"1\";s:21:\"canonlyviewownthreads\";s:1:\"0\";s:16:\"candlattachments\";s:1:\"0\";s:14:\"canpostthreads\";s:1:\"0\";s:13:\"canpostreplys\";s:1:\"1\";s:22:\"canonlyreplyownthreads\";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:\"0\";s:16:\"candeletethreads\";s:1:\"0\";s:18:\"caneditattachments\";s:1:\"0\";s:8:\"modposts\";s:1:\"0\";s:10:\"modthreads\";s:1:\"0\";s:14:\"mod_edit_posts\";s:1:\"0\";s:14:\"modattachments\";s:1:\"0\";s:12:\"canpostpolls\";s:1:\"0\";s:12:\"canvotepolls\";s:1:\"1\";s:9:\"cansearch\";s:1:\"1\";}i:9;a:23:{s:3:\"pid\";s:4:\"3228\";s:3:\"fid\";s:1:\"5\";s:3:\"gid\";s:1:\"9\";s:7:\"canview\";s:1:\"1\";s:14:\"canviewthreads\";s:1:\"1\";s:21:\"canonlyviewownthreads\";s:1:\"0\";s:16:\"candlattachments\";s:1:\"0\";s:14:\"canpostthreads\";s:1:\"0\";s:13:\"canpostreplys\";s:1:\"1\";s:22:\"canonlyreplyownthreads\";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:\"0\";s:16:\"candeletethreads\";s:1:\"0\";s:18:\"caneditattachments\";s:1:\"0\";s:8:\"modposts\";s:1:\"0\";s:10:\"modthreads\";s:1:\"0\";s:14:\"mod_edit_posts\";s:1:\"0\";s:14:\"modattachments\";s:1:\"0\";s:12:\"canpostpolls\";s:1:\"0\";s:12:\"canvotepolls\";s:1:\"1\";s:9:\"cansearch\";s:1:\"1\";}i:10;a:23:{s:3:\"pid\";s:4:\"3229\";s:3:\"fid\";s:1:\"5\";s:3:\"gid\";s:2:\"10\";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:1:\"1\";s:13:\"canpostreplys\";s:1:\"1\";s:22:\"canonlyreplyownthreads\";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:\"1\";s:18:\"caneditattachments\";s:1:\"0\";s:8:\"modposts\";s:1:\"0\";s:10:\"modthreads\";s:1:\"0\";s:14:\"mod_edit_posts\";s:1:\"0\";s:14:\"modattachments\";s:1:\"0\";s:12:\"canpostpolls\";s:1:\"1\";s:12:\"canvotepolls\";s:1:\"1\";s:9:\"cansearch\";s:1:\"1\";}i:11;a:23:{s:3:\"pid\";s:4:\"3230\";s:3:\"fid\";s:1:\"5\";s:3:\"gid\";s:2:\"11\";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:1:\"1\";s:13:\"canpostreplys\";s:1:\"1\";s:22:\"canonlyreplyownthreads\";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:\"1\";s:18:\"caneditattachments\";s:1:\"0\";s:8:\"modposts\";s:1:\"0\";s:10:\"modthreads\";s:1:\"0\";s:14:\"mod_edit_posts\";s:1:\"0\";s:14:\"modattachments\";s:1:\"0\";s:12:\"canpostpolls\";s:1:\"1\";s:12:\"canvotepolls\";s:1:\"1\";s:9:\"cansearch\";s:1:\"1\";}i:12;a:23:{s:3:\"pid\";s:4:\"3231\";s:3:\"fid\";s:1:\"5\";s:3:\"gid\";s:2:\"12\";s:7:\"canview\";s:1:\"1\";s:14:\"canviewthreads\";s:1:\"1\";s:21:\"canonlyviewownthreads\";s:1:\"0\";s:16:\"candlattachments\";s:1:\"0\";s:14:\"canpostthreads\";s:1:\"0\";s:13:\"canpostreplys\";s:1:\"1\";s:22:\"canonlyreplyownthreads\";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:\"0\";s:16:\"candeletethreads\";s:1:\"0\";s:18:\"caneditattachments\";s:1:\"0\";s:8:\"modposts\";s:1:\"0\";s:10:\"modthreads\";s:1:\"0\";s:14:\"mod_edit_posts\";s:1:\"0\";s:14:\"modattachments\";s:1:\"0\";s:12:\"canpostpolls\";s:1:\"0\";s:12:\"canvotepolls\";s:1:\"1\";s:9:\"cansearch\";s:1:\"1\";}i:13;a:23:{s:3:\"pid\";s:4:\"3232\";s:3:\"fid\";s:1:\"5\";s:3:\"gid\";s:2:\"13\";s:7:\"canview\";s:1:\"1\";s:14:\"canviewthreads\";s:1:\"1\";s:21:\"canonlyviewownthreads\";s:1:\"0\";s:16:\"candlattachments\";s:1:\"0\";s:14:\"canpostthreads\";s:1:\"0\";s:13:\"canpostreplys\";s:1:\"1\";s:22:\"canonlyreplyownthreads\";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:\"0\";s:16:\"candeletethreads\";s:1:\"0\";s:18:\"caneditattachments\";s:1:\"0\";s:8:\"modposts\";s:1:\"0\";s:10:\"modthreads\";s:1:\"0\";s:14:\"mod_edit_posts\";s:1:\"0\";s:14:\"modattachments\";s:1:\"0\";s:12:\"canpostpolls\";s:1:\"0\";s:12:\"canvotepolls\";s:1:\"1\";s:9:\"cansearch\";s:1:\"1\";}i:20;a:23:{s:3:\"pid\";s:4:\"3237\";s:3:\"fid\";s:1:\"5\";s:3:\"gid\";s:2:\"20\";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:1:\"0\";s:13:\"canpostreplys\";s:1:\"1\";s:22:\"canonlyreplyownthreads\";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:\"0\";s:16:\"candeletethreads\";s:1:\"0\";s:18:\"caneditattachments\";s:1:\"0\";s:8:\"modposts\";s:1:\"0\";s:10:\"modthreads\";s:1:\"0\";s:14:\"mod_edit_posts\";s:1:\"0\";s:14:\"modattachments\";s:1:\"0\";s:12:\"canpostpolls\";s:1:\"0\";s:12:\"canvotepolls\";s:1:\"1\";s:9:\"cansearch\";s:1:\"1\";}i:16;a:23:{s:3:\"pid\";s:4:\"3233\";s:3:\"fid\";s:1:\"5\";s:3:\"gid\";s:2:\"16\";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:1:\"0\";s:13:\"canpostreplys\";s:1:\"1\";s:22:\"canonlyreplyownthreads\";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:\"0\";s:16:\"candeletethreads\";s:1:\"0\";s:18:\"caneditattachments\";s:1:\"0\";s:8:\"modposts\";s:1:\"0\";s:10:\"modthreads\";s:1:\"0\";s:14:\"mod_edit_posts\";s:1:\"0\";s:14:\"modattachments\";s:1:\"0\";s:12:\"canpostpolls\";s:1:\"0\";s:12:\"canvotepolls\";s:1:\"1\";s:9:\"cansearch\";s:1:\"1\";}i:17;a:23:{s:3:\"pid\";s:4:\"3234\";s:3:\"fid\";s:1:\"5\";s:3:\"gid\";s:2:\"17\";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:1:\"0\";s:13:\"canpostreplys\";s:1:\"1\";s:22:\"canonlyreplyownthreads\";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:\"0\";s:16:\"candeletethreads\";s:1:\"0\";s:18:\"caneditattachments\";s:1:\"0\";s:8:\"modposts\";s:1:\"0\";s:10:\"modthreads\";s:1:\"0\";s:14:\"mod_edit_posts\";s:1:\"0\";s:14:\"modattachments\";s:1:\"0\";s:12:\"canpostpolls\";s:1:\"0\";s:12:\"canvotepolls\";s:1:\"1\";s:9:\"cansearch\";s:1:\"1\";}i:18;a:23:{s:3:\"pid\";s:4:\"3235\";s:3:\"fid\";s:1:\"5\";s:3:\"gid\";s:2:\"18\";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:1:\"1\";s:13:\"canpostreplys\";s:1:\"1\";s:22:\"canonlyreplyownthreads\";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:\"1\";s:18:\"caneditattachments\";s:1:\"0\";s:8:\"modposts\";s:1:\"0\";s:10:\"modthreads\";s:1:\"0\";s:14:\"mod_edit_posts\";s:1:\"0\";s:14:\"modattachments\";s:1:\"0\";s:12:\"canpostpolls\";s:1:\"1\";s:12:\"canvotepolls\";s:1:\"1\";s:9:\"cansearch\";s:1:\"1\";}i:19;a:23:{s:3:\"pid\";s:4:\"3236\";s:3:\"fid\";s:1:\"5\";s:3:\"gid\";s:2:\"19\";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:1:\"1\";s:13:\"canpostreplys\";s:1:\"1\";s:22:\"canonlyreplyownthreads\";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:\"1\";s:18:\"caneditattachments\";s:1:\"0\";s:8:\"modposts\";s:1:\"0\";s:10:\"modthreads\";s:1:\"0\";s:14:\"mod_edit_posts\";s:1:\"0\";s:14:\"modattachments\";s:1:\"0\";s:12:\"canpostpolls\";s:1:\"1\";s:12:\"canvotepolls\";s:1:\"1\";s:9:\"cansearch\";s:1:\"1\";}i:21;a:23:{s:3:\"pid\";s:4:\"3239\";s:3:\"fid\";s:1:\"5\";s:3:\"gid\";s:2:\"21\";s:7:\"canview\";s:1:\"1\";s:14:\"canviewthreads\";s:1:\"1\";s:21:\"canonlyviewownthreads\";s:1:\"0\";s:16:\"candlattachments\";s:1:\"0\";s:14:\"canpostthreads\";s:1:\"0\";s:13:\"canpostreplys\";s:1:\"1\";s:22:\"canonlyreplyownthreads\";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:\"0\";s:16:\"candeletethreads\";s:1:\"0\";s:18:\"caneditattachments\";s:1:\"0\";s:8:\"modposts\";s:1:\"0\";s:10:\"modthreads\";s:1:\"0\";s:14:\"mod_edit_posts\";s:1:\"0\";s:14:\"modattachments\";s:1:\"0\";s:12:\"canpostpolls\";s:1:\"0\";s:12:\"canvotepolls\";s:1:\"1\";s:9:\"cansearch\";s:1:\"1\";}i:22;a:23:{s:3:\"pid\";s:4:\"3305\";s:3:\"fid\";s:1:\"5\";s:3:\"gid\";s:2:\"22\";s:7:\"canview\";s:1:\"1\";s:14:\"canviewthreads\";s:1:\"1\";s:21:\"canonlyviewownthreads\";s:1:\"0\";s:16:\"candlattachments\";s:1:\"0\";s:14:\"canpostthreads\";s:1:\"0\";s:13:\"canpostreplys\";s:1:\"1\";s:22:\"canonlyreplyownthreads\";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:\"0\";s:16:\"candeletethreads\";s:1:\"0\";s:18:\"caneditattachments\";s:1:\"0\";s:8:\"modposts\";s:1:\"0\";s:10:\"modthreads\";s:1:\"0\";s:14:\"mod_edit_posts\";s:1:\"0\";s:14:\"modattachments\";s:1:\"0\";s:12:\"canpostpolls\";s:1:\"0\";s:12:\"canvotepolls\";s:1:\"1\";s:9:\"cansearch\";s:1:\"1\";}i:23;a:23:{s:3:\"pid\";s:4:\"3371\";s:3:\"fid\";s:1:\"5\";s:3:\"gid\";s:2:\"23\";s:7:\"canview\";s:1:\"1\";s:14:\"canviewthreads\";s:1:\"1\";s:21:\"canonlyviewownthreads\";s:1:\"0\";s:16:\"candlattachments\";s:1:\"0\";s:14:\"canpostthreads\";s:1:\"0\";s:13:\"canpostreplys\";s:1:\"1\";s:22:\"canonlyreplyownthreads\";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:\"0\";s:16:\"candeletethreads\";s:1:\"0\";s:18:\"caneditattachments\";s:1:\"0\";s:8:\"modposts\";s:1:\"0\";s:10:\"modthreads\";s:1:\"0\";s:14:\"mod_edit_posts\";s:1:\"0\";s:14:\"modattachments\";s:1:\"0\";s:12:\"canpostpolls\";s:1:\"0\";s:12:\"canvotepolls\";s:1:\"1\";s:9:\"cansearch\";s:1:\"1\";}}i:58;a:19:{i:1;a:23:


Any idea how to fix?