Well here is my error message:
SQL ERROR [ mysqli ]
MySQL server has gone away 
SET NAMES 'binary'
http://area51.phpbb.com/phpBB/viewtopic ... 03#p171103
Been getting this MySQL has gone away error message. Haven't reported it as a bug yet. But anyone know how do I find the offending post?
Apparantly this error is caused by a post full of loads of spam and causes MySQL to lose connection. So I need to find a really big post. Any ideas? I have access to Query Browser so there must be some SQL code for it?
EDIT: I am dealing with it by going into mysql Query browser (Probably work in phpmyadmin as well) and running this code
The number 10000 can obviously be changed and the top post will most likely be the problem causing post. However anyone know where the converter will die?
Code: Select all
SELECT * FROM phpbb_posts_text WHERE LENGTH(post_text)>10000 ORDER BY LENGTH(post_text) desc;
EDIT: I believe the offending post had 65,535 characters
My next biggest post which I haven't touched is 43,080