MyBB Community Forums › 1.8 Support › General Support v
2006 - MySQL server has gone away

Jump to the post that solved this thread.
Thread Modes
Solved: 3 Years, 2 Weeks ago 2006 - MySQL server has gone away
Michael_vx Offline
Posts: 211
Threads: 49
Joined: Nov 2014
Reputation: 2
#1
Solved: 3 Years, 2 Weeks ago 2018-04-06, 12:20 PM (This post was last modified: 2018-04-06, 12:31 PM by Michael_vx.)
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
Website Find
Reply
.m. Offline

Former Staff
Posts: 21,687
Threads: 5
Joined: Aug 2011
Reputation: 2,310
#2
Solved: 3 Years, 2 Weeks ago 2018-04-06, 12:37 PM
can you check latest entries of server error log - they might have logged reasons for those errors
Find
Reply
Michael_vx Offline
Posts: 211
Threads: 49
Joined: Nov 2014
Reputation: 2
#3
Solved: 3 Years, 2 Weeks ago 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>
Website Find
Reply
.m. Offline

Former Staff
Posts: 21,687
Threads: 5
Joined: Aug 2011
Reputation: 2,310
#4
Solved: 3 Years, 2 Weeks ago 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 ..
Find
Reply
Michael_vx Offline
Posts: 211
Threads: 49
Joined: Nov 2014
Reputation: 2
#5
Solved: 3 Years, 2 Weeks ago 2018-04-07, 01:13 AM (This post was last modified: 2018-04-07, 08:04 AM by Michael_vx.)
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
Website Find
Reply
.m. Offline

Former Staff
Posts: 21,687
Threads: 5
Joined: Aug 2011
Reputation: 2,310
#6
Solved: 3 Years, 2 Weeks ago 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 !)
Find
Reply
Michael_vx Offline
Posts: 211
Threads: 49
Joined: Nov 2014
Reputation: 2
#7
Solved: 3 Years, 2 Weeks ago 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
Website Find
Reply
.m. Offline

Former Staff
Posts: 21,687
Threads: 5
Joined: Aug 2011
Reputation: 2,310
#8
Solved: 3 Years, 2 Weeks ago 2018-04-07, 02:06 PM
install error viewer plugin & check if it provides useful log ..
Find
Reply
Jump to the post that solved this thread.


Forum Jump:


Users browsing this thread: 1 Guest(s)