Jump to the post that solved this thread.
Solved: 3 Years, 2 Weeks ago 2006 - MySQL server has gone away
#1
Solved: 3 Years, 2 Weeks ago
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
Reply
#2
Solved: 3 Years, 2 Weeks ago
can you check latest entries of server error log - they might have logged reasons for those errors
Reply
#3
Solved: 3 Years, 2 Weeks ago
(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>

Reply
#4
Solved: 3 Years, 2 Weeks ago
looks like there is a problem with the thanks related plugin you are using.
can you temporarily disable the plugin & check if it helps ..
Reply
#5
Solved: 3 Years, 2 Weeks ago
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
Reply
#6
Solved: 3 Years, 2 Weeks ago
^ 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 !)
Reply
#7
Solved: 3 Years, 2 Weeks ago
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
Reply
#8
Solved: 3 Years, 2 Weeks ago
install error viewer plugin & check if it provides useful log ..
Reply
Jump to the post that solved this thread.


Forum Jump:


Users browsing this thread: 1 Guest(s)