I am transferring a rather large forum from vBulletin 3.8 to MyBB. Everything worked great (although it took about two hours), until I reached the cleanup part "Removing columns import_aid from table mybb_attachments"
1153 - Got a packet bigger than 'max_allowed_packet' bytes
The query error is rather long, so will not post it.
Now here's my question: How can I perform the cleanup without this error, and without completely corrupting the forum and forcing me to do the long, tedious transfer again?
If you got your host to raise the max_allowed_packet setting in php.ini to something higher it should work. I think you can then run the cleanup task again without any problems. Or, if you can post the query in code tags just so I can see what it's actually doing, we can probably remove it in phpMyAdmin manually.
I can't post the whole thing as it will crash the browser, but here's a sample (It basically repeats from here, except for the numbers)
Quote:REPLACE INTO mybb_datacache SET `title`='forumpermissions',`cache`='a:111:{i:0;i:0;i:13;a:11:{i:10;a:17:{s:3:\"pid\";s:3:\"877\";s:3:\"fid\";s:2:\"13\";s:3:\"gid\";s:2:\"10\";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:\"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:\"0\";}
How high should I increase the setting?
Try doubling it. It doesn't need to be too massive I shouldn't think.
You can always increase it by steps until the query works.
I increased the setting and it worked perfectly fine, thanks
How was your conversion experience overall? Did you lose anything important? One big vB addon I'm using is Paul's Thanks add-on. I'm really going to need to get those stats converted as well somehow into the ThankYou add-on here.
How were your users after the move? How are you finding the whole experience?
Thanks in advance.
Well you'll need to modify the converter module to convert the thanks to mybb. That won't be part of the converter. I don't have experience using the merge tool from vb, but from general experience with the merge tool it's a pretty simple process that all you basically have to do is click next
.