MyBB Community Forums

MyBB Community Forums > 1.8 Support > General Support > 2006 - MySQL server has gone away
Full Version: 2006 - MySQL server has gone away
You're currently viewing a stripped down version of our content. View the full version with proper formatting.

Michael_vx

2018-04-06, 12:20 PM
MyBB has experienced an internal SQL error and cannot continue.

SQL Error:2006 - MySQL server has gone awayQueryConfusedELECT pthx FROM mybb_posts WHERE pid IN('4732') ORDER BY pthx DESC LIMIT 1

the link with this error https://micsoft.gq/showthread.php?tid=3379

i just posted this thread and i cannot access it

im looking over my forum nothing bad or not working only the link above
another thread but with 502 error
https://micsoft.gq/showthread.php?tid=3345

.m.

2018-04-06, 12:37 PM
can you check latest entries of server error log - they might have logged reasons for those errors

Michael_vx

2018-04-06, 01:44 PM
(2018-04-06, 12:37 PM).m. Wrote: [ -> ]can you check latest entries of server error log - they might have logged reasons for those errors

i was able to find only this log file in the main root folder

<error>
	<dateline>1522469369</dateline>
	<script>inc/plugins/MentionMe/forum.php</script>
	<line>509</line>
	<type>2</type>
	<friendly_type>Warning</friendly_type>
	<message>Invalid argument supplied for foreach()</message>
</error>

<error>
	<dateline>1522534560</dateline>
	<script>inc/plugins/MentionMe/forum.php</script>
	<line>91</line>
	<type>2</type>
	<friendly_type>Warning</friendly_type>
	<message>html_entity_decode(): charset `�' not supported, assuming utf-8</message>
</error>

<error>
	<dateline>1522534560</dateline>
	<script>inc/plugins/MentionMe/forum.php</script>
	<line>91</line>
	<type>2</type>
	<friendly_type>Warning</friendly_type>
	<message>html_entity_decode(): charset `�' not supported, assuming utf-8</message>
</error>

<error>
	<dateline>1522541013</dateline>
	<script>inc/plugins/MentionMe/forum.php</script>
	<line>91</line>
	<type>2</type>
	<friendly_type>Warning</friendly_type>
	<message>html_entity_decode(): charset ` ' not supported, assuming utf-8</message>
</error>

<error>
	<dateline>1522541013</dateline>
	<script>inc/plugins/MentionMe/forum.php</script>
	<line>91</line>
	<type>2</type>
	<friendly_type>Warning</friendly_type>
	<message>html_entity_decode(): charset ` ' not supported, assuming utf-8</message>
</error>

<error>
	<dateline>1522542528</dateline>
	<script></script>
	<line>0</line>
	<type>20</type>
	<friendly_type>MyBB SQL Error</friendly_type>
	<message>SQL Error: 2006 - MySQL server has gone away
Query: SELECT uid, username, usergroup, displaygroup, additionalgroups, ignorelist, avatar FROM mybb_users WHERE LOWER(username)='lindabjorkp' LIMIT 1</message>
</error>

<error>
	<dateline>1522743369</dateline>
	<script></script>
	<line>0</line>
	<type>20</type>
	<friendly_type>MyBB SQL Error</friendly_type>
	<message>SQL Error: 2006 - MySQL server has gone away
Query: SELECT * FROM mybb_users WHERE uid = '1'</message>
</error>

<error>
	<dateline>1522770653</dateline>
	<script></script>
	<line>0</line>
	<type>20</type>
	<friendly_type>MyBB SQL Error</friendly_type>
	<message>SQL Error: 2006 - MySQL server has gone away
Query: SELECT * FROM mybb_users WHERE uid = '1'</message>
</error>

<error>
	<dateline>1522797927</dateline>
	<script></script>
	<line>0</line>
	<type>20</type>
	<friendly_type>MyBB SQL Error</friendly_type>
	<message>SQL Error: 2006 - MySQL server has gone away
Query: SELECT * FROM mybb_users WHERE uid = '1'</message>
</error>

<error>
	<dateline>1522884327</dateline>
	<script></script>
	<line>0</line>
	<type>20</type>
	<friendly_type>MyBB SQL Error</friendly_type>
	<message>SQL Error: 2006 - MySQL server has gone away
Query: SELECT * FROM mybb_users WHERE uid = '1'</message>
</error>

<error>
	<dateline>1523016698</dateline>
	<script></script>
	<line>0</line>
	<type>20</type>
	<friendly_type>MyBB SQL Error</friendly_type>
	<message>SQL Error: 2006 - MySQL server has gone away
Query: SELECT pthx FROM mybb_posts WHERE pid IN('4732') ORDER BY pthx DESC LIMIT 1</message>
</error>

<error>
	<dateline>1523016836</dateline>
	<script></script>
	<line>0</line>
	<type>20</type>
	<friendly_type>MyBB SQL Error</friendly_type>
	<message>SQL Error: 2006 - MySQL server has gone away
Query: SELECT pthx FROM mybb_posts WHERE pid IN('4732') ORDER BY pthx DESC LIMIT 1</message>
</error>

<error>
	<dateline>1523016956</dateline>
	<script></script>
	<line>0</line>
	<type>20</type>
	<friendly_type>MyBB SQL Error</friendly_type>
	<message>SQL Error: 2006 - MySQL server has gone away
Query: SELECT pthx FROM mybb_posts WHERE pid IN('4732') ORDER BY pthx DESC LIMIT 1</message>
</error>

<error>
	<dateline>1523016978</dateline>
	<script></script>
	<line>0</line>
	<type>20</type>
	<friendly_type>MyBB SQL Error</friendly_type>
	<message>SQL Error: 2006 - MySQL server has gone away
Query: SELECT pthx FROM mybb_posts WHERE pid IN('4732') ORDER BY pthx DESC LIMIT 1</message>
</error>

<error>
	<dateline>1523017138</dateline>
	<script></script>
	<line>0</line>
	<type>20</type>
	<friendly_type>MyBB SQL Error</friendly_type>
	<message>SQL Error: 2006 - MySQL server has gone away
Query: SELECT pthx FROM mybb_posts WHERE pid IN('4732') ORDER BY pthx DESC LIMIT 1</message>
</error>

<error>
	<dateline>1523017145</dateline>
	<script></script>
	<line>0</line>
	<type>20</type>
	<friendly_type>MyBB SQL Error</friendly_type>
	<message>SQL Error: 2006 - MySQL server has gone away
Query: SELECT pthx FROM mybb_posts WHERE pid IN('4732') ORDER BY pthx DESC LIMIT 1</message>
</error>

<error>
	<dateline>1523017301</dateline>
	<script></script>
	<line>0</line>
	<type>20</type>
	<friendly_type>MyBB SQL Error</friendly_type>
	<message>SQL Error: 2006 - MySQL server has gone away
Query: SELECT pthx FROM mybb_posts WHERE pid IN('4732') ORDER BY pthx DESC LIMIT 1</message>
</error>

<error>
	<dateline>1523017843</dateline>
	<script></script>
	<line>0</line>
	<type>20</type>
	<friendly_type>MyBB SQL Error</friendly_type>
	<message>SQL Error: 2006 - MySQL server has gone away
Query: SELECT template FROM mybb_templates WHERE title='thanks_guests_tag' AND sid IN ('-2','-1','7') ORDER BY sid DESC LIMIT 1</message>
</error>

<error>
	<dateline>1523018038</dateline>
	<script></script>
	<line>0</line>
	<type>20</type>
	<friendly_type>MyBB SQL Error</friendly_type>
	<message>SQL Error: 2006 - MySQL server has gone away
Query: SELECT * FROM mybb_users WHERE uid = '1'</message>
</error>

<error>
	<dateline>1523018129</dateline>
	<script></script>
	<line>0</line>
	<type>20</type>
	<friendly_type>MyBB SQL Error</friendly_type>
	<message>SQL Error: 2006 - MySQL server has gone away
Query: SELECT * FROM mybb_users WHERE uid = '1'</message>
</error>

<error>
	<dateline>1523019777</dateline>
	<script></script>
	<line>0</line>
	<type>20</type>
	<friendly_type>MyBB SQL Error</friendly_type>
	<message>SQL Error: 2006 - MySQL server has gone away
Query: SELECT template FROM mybb_templates WHERE title='thanks_guests_tag' AND sid IN ('-2','-1','7') ORDER BY sid DESC LIMIT 1</message>
</error>

<error>
	<dateline>1523021826</dateline>
	<script></script>
	<line>0</line>
	<type>20</type>
	<friendly_type>MyBB SQL Error</friendly_type>
	<message>SQL Error: 2006 - MySQL server has gone away
Query: SELECT template FROM mybb_templates WHERE title='thanks_guests_tag' AND sid IN ('-2','-1','7') ORDER BY sid DESC LIMIT 1</message>
</error>

<error>
	<dateline>1523022050</dateline>
	<script></script>
	<line>0</line>
	<type>20</type>
	<friendly_type>MyBB SQL Error</friendly_type>
	<message>SQL Error: 2006 - MySQL server has gone away
Query: SELECT pthx FROM mybb_posts WHERE pid IN('4732') ORDER BY pthx DESC LIMIT 1</message>
</error>

.m.

2018-04-06, 02:21 PM
looks like there is a problem with the thanks related plugin you are using.
can you temporarily disable the plugin & check if it helps ..

Michael_vx

2018-04-07, 01:13 AM
no still same
can that be because i used merge script so many times on this database of the forum ?
or because the plugin files still there so it will make problems
i think i will have to search for every topic that do not work and delete it and i hope that solve all problem

.m.

2018-04-07, 01:37 PM
^ sorry, deleting problematic topics cannot be said as right approach.
the issue should be analyzed & cause needs to be traced (may be with more patience !)

Michael_vx

2018-04-07, 01:52 PM
i requested a log on my website but there is no errors at all in any logs of the website and SQL do not have error log
so no possible for problem to be analyzed
i do not know where to search else Sad

.m.

2018-04-07, 02:06 PM
install error viewer plugin & check if it provides useful log ..
MyBB Community Forums > 1.8 Support > General Support > 2006 - MySQL server has gone away