MyBB Community Forums

Hey guys.

I have this error very frequently. I get it in my email and the error shows up sometimes, but what it does is it loads for about 30 seconds on a white page then the thread finally loads - this is the error that comes in the email and sometimes people experience this error on that red mybb screen:

Your copy of MyBB running on Gaming Forums | GamingBay (http://gamingbay.org) has experienced an error. Details of the error include:
---
Type: 20
File:  (Line no. 0)
Message
SQL Error: 2006 - MySQL server has gone away
Query: SELECT url,id
                             FROM mybb_google_seo
                             WHERE active=1
                             AND idtype=1
                             AND id IN (457)

Type: 20
File:  (Line no. 0)
Message
SQL Error: 2006 - MySQL server has gone away
Query: SELECT url,id
                             FROM mybb_google_seo
                             WHERE active=1
                             AND idtype=1
                             AND id IN (827)

Your copy of MyBB running on Gaming Forums | GamingBay (http://gamingbay.org) has experienced an error. Details of the error include:
---
Type: 20
File:  (Line no. 0)
Message
SQL Error: 2006 - MySQL server has gone away
Query: SELECT * FROM mybb_myadvertisements_zones WHERE zid=3

The errors are frequent and the content changes. As I said before, when visiting threads, the page hangs for a long time sometimes. I have set tables to repair and optimize every hour, so I don't think that's it.

Test login:

User: test
pass: test123

There's no point in trying to bump so often, at least try and have some patience, we do have lives.

This is a host issue. Pages taking 30 seconds to load is not going to be a MyBB issue, and that error you got emailed means it's lost connection to the MySQL server, which isn't a MyBB problem either. It sounds like your host is overselling your server and it can't cope.

You've already made this thread http://community.mybb.com/thread-86587.html about the MYSQL server going away, this is the exact same thing, it's a host issue.

I use Hostgator and I've contacted them, they said it's all fine. :/

Sorry, forgot about that thread.

It clearly isn't fine if you keep getting errors saying the connection to the MySQL server has been lost...

These are the queries that are getting 'killed' according to the host

 1295388721 ] [ gamingb2_c ] [ 3965869 ] [ 47 ] [ gamingb2_forums ] [ Query ] [ KILLED ] [ 'gator1304.hostgator.com' ] [ UPDATE mybb_users SET lastactive='1295388640', timeonline=timeonline+1 WHERE uid='815' ]
[ 1295609221 ] [ gamingb2_c ] [ 191002 ] [ 21 ] [ gamingb2_forums ] [ Query ] [ KILLED ] [ 'gator1304.hostgator.com' ] [ REPLACE INTO mybb_sessions SET `uid`='0',`sid`='2152e37c648c2df797ed4b4c39f6af45',`time`='1295609199 ]
[ 1295879941 ] [ gamingb2_c ] [ 4200928 ] [ 69 ] [ gamingb2_forums ] [ Query ] [ KILLED ] [ 'gator1304.hostgator.com' ] [ SELECT s.ip, s.uid, s.time, u.username, u.invisible, u.usergroup, u.usergroup, u.displaygroup
[ 1295879942 ] [ gamingb2_c ] [ 4201341 ] [ 76 ] [ gamingb2_forums ] [ Query ] [ KILLED ] [ 'gator1304.hostgator.com' ] [ REPLACE INTO mybb_sessions SET `uid`='0',`sid`='af019bf53c2d122a8961f7095591bf10',`time`='1295879864 ]
[ 1295894161 ] [ gamingb2_blog ] [ 4377024 ] [ 26 ] [ gamingb2_blog ] [ Query ] [ KILLED ] [ 'gator1304.hostgator.com' ] [ UPDATE `wp1_options` SET `option_value` = 'a:11:{i:1295893959;a:1:{s:16:\"w3_pgcache_prime\";a:1:{s: ]
[ 1296030782 ] [ gamingb2_c ] [ 2971294 ] [ 16 ] [ gamingb2_forums ] [ Sleep ] [ KILLED ] [ 'gator1304.hostgator.com' ] [ ]
[ 1296033842 ] [ gamingb2_c ] [ 3259154 ] [ 21 ] [ gamingb2_forums ] [ Sleep ] [ KILLED ] [ 'gator1304.hostgator.com' ] [ ]
[ 1296044281 ] [ gamingb2_c ] [ 4423742 ] [ 16 ] [ gamingb2_forums ] [ Sleep ] [ KILLED ] [ 'gator1304.hostgator.com' ] [ ]
[ 1296050581 ] [ gamingb2_c ] [ 5088508 ] [ 16 ] [ gamingb2_forums ] [ Sleep ] [ KILLED ] [ 'gator1304.hostgator.com' ] [ ]
[ 1296057242 ] [ gamingb2_c ] [ 5893751 ] [ 21 ] [ gamingb2_forums ] [ Sleep ] [ KILLED ] [ 'gator1304.hostgator.com' ] 

There's really basic queries, and one of them is from WordPress by the look of it. If these queries are causing problems, your server is being oversold.

Yeah, I use a plugin that makes a WordPress + MyBB bridge. The server is really fast, but when I load some threads it takes a long time for it to load. Apparently they set a low limit for MySQL timeout, could that be the problem? They said those above queries are 'sleeping queries and should not cause any problems'