Question K 1.7.1 (admin site): Error loading module MySQL server has gone away

(( I'm sorry, I thought I posted this under "Support" and just realized I posted under "Common Questions" - I don't want to create a duplicate thread, can I move this somehow? ))

Hi! Everything still appears to be working fine in both the front end, and the back-end. However while in the back-end today I received three errors, I clicked off the page to a different section of Kunena and the errors went away, but I wanted to check and make sure this won't eventually result in any issues.

First Error: "Upgrading Kunena to version 1.7.1 has failed!"
Which is a little weird because I wasn't attempting to upgrade anything and I have the latest version installed.

That was followed by:
Your forum may be missing some important fixes and some features may be broken.
Please try to upgrade again. If you cannot upgrade to Kunena 1.7.1, you can easily downgrade to the latest working version.
Our support forum can be found from: www.kunena.org

Then I underneath those I received:

Error loading module MySQL server has gone away SQL=SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid FROM mqhxa_modules AS m LEFT JOIN mqhxa_modules_menu AS mm ON mm.moduleid = m.id LEFT JOIN mqhxa_extensions AS e ON e.element = m.module AND e.client_id = m.client_id WHERE m.published = 1 AND e.enabled = 1 AND (m.publish_up = '0000-00-00 00:00:00' OR m.publish_up <= '2011-12-31 20:37:47') AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2011-12-31 20:37:47') AND m.access IN (1,1,2,3) AND m.client_id = 1 AND (mm.menuid = 0 OR mm.menuid <= 0) ORDER BY m.position, m.ordering

So, yea. Errors are are gone now. Kinda weird.

This is my "report configuration settings" in case that sheds some light on the situation

Database collation check: The collation of your table fields are correct

Legacy mode: Disabled | Joomla! SEF: Enabled | Joomla! SEF rewrite: Enabled | FTP layer: Disabled |

This message contains confidential information

htaccess: Exists | PHP environment: Max execution time: 30 seconds | Max execution memory: 128M | Max file upload: 2M

Joomla default template details : yoo_streamline | author: YOOtheme | version: 1.0.3 | creationdate: December 2011

Kunena default template details : Blue Eagle (default) | author: Kunena Team | version: 1.7.1 | creationdate: 2011-11-16

Kunena version detailled: Installed version: 1.7.1 | Build: 5162 | Version name: UnderUret | Kunena detailled configuration:

Warning: Spoiler!

[th]Kunena config settings:[/th]

board_offline	0
board_ofset	0.00
enablerss	1
enablepdf	1
threads_per_page	20
messages_per_page	6
messages_per_page_search	15
showhistory	1
historylimit	6
shownew	1
jmambot	0
disemoticons	0
template	default
showannouncement	1
avataroncat	0
catimagepath	category_images/
showchildcaticon	1
annmodid	62
rtewidth	450
rteheight	300
enableforumjump	1
reportmsg	1
username	1
askemail	1
showemail	0
showuserstats	1
showkarma	1
useredit	1
useredittime	0
useredittimegrace	600
editmarkup	1
allowsubscriptions	1
subscriptionschecked	1
allowfavorites	1
maxsubject	50
maxsig	300
regonly	0
changename	1
pubwrite	0
floodprotection	0
mailmod	0
mailadmin	1
captcha	0
mailfull	1
allowavatar	1
allowavatarupload	1
allowavatargallery	1
avatarquality	65
avatarsize	700
allowimageupload	0
allowimageregupload	1
imageheight	800
imagewidth	800
imagesize	2048
allowfileupload	0
allowfileregupload	0
filetypes	txt,rtf,pdf,zip,tar.gz,tgz,tar.bz2
filesize	120
showranking	1
rankimages	1
avatar_src	fb
fb_profile	fb
pm_component	no
userlist_rows	30
userlist_online	1
userlist_avatar	1
userlist_name	1
userlist_username	1
userlist_posts	1
userlist_karma	1
userlist_email	0
userlist_usertype	0
userlist_joindate	1
userlist_lastvisitdate	1
userlist_userhits	1
latestcategory
showstats	1
showwhoisonline	1
showgenstats	1
showpopuserstats	1
popusercount	5
showpopsubjectstats	1
popsubjectcount	5
usernamechange	0
rules_infb	1
rules_cid	1
help_infb	1
help_cid	1
showspoilertag	1
showvideotag	1
showebaytag	1
trimlongurls	1
trimlongurlsfront	40
trimlongurlsback	20
autoembedyoutube	1
autoembedebay	1
ebaylanguagecode	en-us
fbsessiontimeout	1800
highlightcode	0
rss_type	topic
rss_timelimit	month
rss_limit	100
rss_included_categories
rss_excluded_categories
rss_specification	rss2.0
rss_allow_html	1
rss_author_format	name
rss_author_in_title	1
rss_word_count	0
rss_old_titles	1
rss_cache	900
fbdefaultpage	recent
default_sort	asc
alphauserpointsnumchars	0
sef	1
sefcats	0
sefutf8	0
showimgforguest	1
showfileforguest	1
pollnboptions	4
pollallowvoteone	1
pollenabled	1
poppollscount	5
showpoppollstats	1
polltimebtvotes	00:15:00
pollnbvotesbyuser	100
pollresultsuserslist	1
maxpersotext	50
ordering_system	mesid
post_dateformat	ago
post_dateformat_hover	datetime
hide_ip	1
js_actstr_integration	0
imagetypes	jpg,jpeg,gif,png
checkmimetypes	1
imagemimetypes	image/jpeg,image/jpg,image/gif,image/png
imagequality	50
thumbheight	32
thumbwidth	32
hideuserprofileinfo	put_empty
integration_access	auto
integration_login	auto
integration_avatar	auto
integration_profile	auto
integration_private	jomsocial
integration_activity	auto
boxghostmessage	0
userdeletetmessage	0
latestcategory_in	1
topicicons	1
onlineusers	1
debug	0
catsautosubscribed	0
showbannedreason	0
version_check	1
showthankyou	1
showpopthankyoustats	1
popthankscount	5
mod_see_deleted	0
bbcode_img_secure	text
listcat_show_moderators	1
lightbox	1
activity_limit	0
show_list_time	720
show_session_type	0
show_session_starttime	0
userlist_allowed	0
userlist_count_users	1
enable_threaded_layouts	0
category_subscriptions	post
topic_subscriptions	every
pubprofile	1
thankyou_max	10000
email_recipient_count	0
email_recipient_privacy	bcc
email_visible_address
captcha_post_limit	0

Third-party components: Jomsocial 2.4.1 | UddeIm 2.5

Third-party SEF components: None

Plugins: System - Mootools Upgrade: Disabled | System - Mootools12: Disabled

Modules: None

I don't really have any suggestions to add to this topic. It may have been a transient thing; there may be another matter lurking in the background that could cause problems down the track. Make sure you have a good backup of your site.

Might be worth re-installing K 1.7.1 again (you won't lose any data) - see K 1.6 and K 1.7 Upgrade Guide

The interesting question is which "module" was your administration site attempting to load at the time? I don't know anything about mqhxa_modules. Does this help: >>> here <<<

"MySQL server has gone away" is the keyword in this issue.

That happens when Joomla installer uses a lot of time to copy the files -- and MySQL is set to timeout before files get copied.

There are two ways to prevent it:
1) Disabling FTP mode from Joomla usually makes copying files much faster
2) Increasing MySQL timeout from MySQL configuration file (usually in /etc/my.ini or /etc/mysql/my.ini)

Please use Google on the key words.

Thank you both!