Thread Rating:
  • 1 Vote(s) - 1 Average
  • 1
  • 2
  • 3
  • 4
  • 5
Solved: 2 Years, 7 Months, 3 Weeks ago SQL error
#1
Solved: 2 Years, 7 Months, 3 Weeks ago
I moved my site to another server. After that when i will make a childforum i get the next error.


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

Query:REPLACE INTO mybb_datacache SET title='forumpermissions',cache='a:914:{i:0;i:0;i:1;a:4:{i:1;a:23:{s:3:\"pid\";s:4:\"5317\";s:3:\"fid\";s:1:\"1\";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:2;a:23:{s:3:\"pid\";s:4:\"5318\";s:3:\"fid\";s:1:\"1\";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:\"1\";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:\"1\";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:5;a:23:{s:3:\"pid\";s:4:\"5319\";s:3:\"fid\";s:1:\"1\";s:3:\"gid\";s:1:\"5\";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:

And much more lines
What do i have to do to resolve this.

Grtz
Erigo19
Reply


Messages In This Thread
SQL error - by erigo19 - 12-13-2016, 08:59 AM
RE: SQL error - by roy - 12-13-2016, 09:17 AM
RE: SQL error - by Ben Cousins - 12-13-2016, 09:28 AM
RE: SQL error - by Matt - 12-13-2016, 10:08 AM
RE: SQL error - by erigo19 - 12-17-2016, 08:44 AM
RE: SQL error - by Infinite - 12-17-2016, 10:22 AM
RE: SQL error - by erigo19 - 01-18-2017, 08:31 PM

Forum Jump:


Users browsing this thread: 1 Guest(s)