The Kunena team has announce the arrival of Kunena 6.2.1 [K 6.2.1] which is now available for download as a native Joomla extension for J! 4.3.x/4.4.x/5.0.x. This version addresses most of the issues that were discovered in K 6.1.0 and issues discovered during the last development stages of K 6.1
Solved MySQL server has gone away
Database collation check: The collation of your table fields are correct
Joomla! SEF: Enabled | Joomla! SEF rewrite: Enabled | FTP layer: Disabled |
This message contains confidential informationhtaccess: Exists | PHP environment: Max execution time: 45 seconds | Max execution memory: 128M | Max file upload: 24M
Kunena menu details:Warning: Spoiler!
ID Name Menutype Link Path 337 Forum mainmenu Itemid=571 kunena-2013-08-19 571 Forum kunenamenu view=home&defaultmenu=44 forums 572 Index kunenamenu view=category&layout=list&catid=0 forums/index 573 Recent Topics kunenamenu view=topics&mode=replies forums/recent 576 My Topics kunenamenu view=topics&layout=user&mode=default forums/mylatest 575 No Replies kunenamenu view=topics&mode=noreplies forums/noreplies 579 Search kunenamenu view=search forums/search 577 Profile kunenamenu view=user forums/profile 578 Help kunenamenu view=misc forums/help 574 New Topic kunenamenu view=topic&layout=create&catid= newtopic 61 Forum mainmenu view=home&defaultmenu=44 forum 553 Index mainmenu view=category&layout=list&catid=0 forum/index 554 Recent Topics mainmenu view=topics&mode=replies forum/recent 558 Recent Posts mainmenu view=topics&layout=posts&mode=recent&userid= forum/recent-posts 557 My Topics mainmenu view=topics&layout=user&mode=default&modetype= forum/my-topics 555 Profile mainmenu view=user forum/profile 556 Forum Search mainmenu view=search forum/search 653 My Forum Topics mainmenu view=topics&layout=user&mode=default&modetype= forum/my-forum-topics
Joomla default template details : rt_cerulean | author: RocketTheme, LLC | version: 1.2 | creationdate: Unknown
Kunena default template details : Blue Eagle 2.0 | author: Kunena Team | version: 3.0.2 | creationdate: 2013-08-18
Kunena version detailed: Kunena 3.0.2 | 2013-08-18 [ Nocturne ]
| Kunena detailed configuration:| Kunena integration settings:Warning: Spoiler!
Kunena config settings: board_offline 0 enablerss 1 threads_per_page 15 messages_per_page 10 messages_per_page_search 15 showhistory 1 historylimit 6 shownew 1 disemoticons 0 template blue_eagle showannouncement 0 avataroncat 0 catimagepath category_images/ showchildcaticon 1 rtewidth 450 rteheight 600 enableforumjump 1 reportmsg 1 username 1 askemail 0 showemail 0 showuserstats 1 showkarma 0 useredit 1 useredittime 0 useredittimegrace 600 editmarkup 0 allowsubscriptions 1 subscriptionschecked 1 allowfavorites 1 maxsubject 110 maxsig 300 regonly 0 pubwrite 0 floodprotection 15 mailmod 0 mailadmin 0 captcha 0 mailfull 1 allowavatarupload 1 allowavatargallery 1 avatarquality 65 avatarsize 2048 imageheight 800 imagewidth 800 imagesize 150 filetypes txt,rtf,pdf,zip,tar.gz,tgz,tar.bz2 filesize 120 showranking 1 rankimages 1 userlist_rows 30 userlist_online 1 userlist_avatar 1 userlist_name 0 userlist_posts 1 userlist_karma 0 userlist_email 0 userlist_joindate 1 userlist_lastvisitdate 1 userlist_userhits 0 latestcategory 0 showstats 1 showwhoisonline 1 showgenstats 1 showpopuserstats 1 popusercount 10 showpopsubjectstats 1 popsubjectcount 10 usernamechange 0 showspoilertag 1 showvideotag 0 showebaytag 0 trimlongurls 1 trimlongurlsfront 40 trimlongurlsback 20 autoembedyoutube 1 autoembedebay 1 ebaylanguagecode en-us sessiontimeout 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 defaultpage recent default_sort asc sef 1 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 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 boxghostmessage 0 userdeletetmessage 0 latestcategory_in 1 topicicons 1 debug 0 catsautosubscribed 0 showbannedreason 1 version_check 0 showthankyou 1 showpopthankyoustats 1 popthankscount 5 mod_see_deleted 1 bbcode_img_secure text listcat_show_moderators 0 lightbox 1 show_list_time 720 show_session_type 0 show_session_starttime 0 userlist_allowed 1 userlist_count_users 1 enable_threaded_layouts 0 category_subscriptions post topic_subscriptions every pubprofile 1 thankyou_max 10 email_recipient_count 0 email_recipient_privacy bcc captcha_post_limit 0 keywords 0 userkeywords 0 image_upload registered file_upload everybody topic_layout flat time_to_create_page 0 show_imgfiles_manage_profile 1 hold_newusers_posts 0 hold_guest_posts 0 attachment_limit 8 pickup_category 0 article_display intro send_emails 1 fallback_english 1 cache 1 cache_time 60 iptracking 0 rss_feedburner_url autolink 1 access_component 0 userlist_usertype 1 sefutf8 0 changename 0 enablepdf 0 jmambot 0 annmodid 62 userlist_username 1 rules_infb 1 help_infb 1 onlineusers 1| Joomla! detailed language files installed:Warning: Spoiler!Kunena - AlphaUserPoints Disabled
Kunena - Community Builder Disabled
Kunena - Gravatar Disabled
Kunena - JomSocial Enabled: access=1 login=1 activity=0 avatar=1 profile=1 private=1 activity_points_limit=0 activity_stream_limit=0
Kunena - Joomla Enabled: access=1 login=1
Kunena - Kunena Disabled
Kunena - UddeIM Disabled
Joomla! languages installed: en-GB English (United Kingdom)
Third-party components: Jomsocial 3.0.3
Third-party SEF components: None
Plugins: Search - Kunena Search 3.0.1 | Content - Kunena Discuss 3.0.1 | JomSocial - My Kunena Forum Menu 2.0.3 | JomSocial - My Kunena Forum Posts 3.0.1 | JomSocial - Kunena Groups 2.0.3
Modules: Kunena Latest 3.0.1 | Kunena Login 3.0.1
Typically, "MySQL server has gone away" messages indicate that there is a problem with your hosting platform. Looking back at other topics that relate to this situation, we also see that Kunena is not responsible for these kinds of problems:
You may find that moving to a different webhosting platform will resolve these kinds of problems.
I wanted to update this post with the response back from Siteground. I was just curious as to whether Kunena has too run into this problem regarding its database size or rather optimization? My website has around 5000 pages published, Google is showing over 16,000 pages. But nevertheless this response was given to me, and I was just wondering if I did nothing - will this only become worse? Lastly, I take it that if I need this to be optimized I am best suited to seek expert help or rather paid for service, do you have any recommendation? Are your services available for hire or that of the Kunena team?
The issue seems to be caused by the fact that your database is too heavy. That means that it is too large and not well optimized, hence the queries executed to it need too much time and exceed the MySQL timeout. This way the scripts processing it need more time than the allowed and cannot complete successfully their execution. The result is the "mysql gone away" message.
The reported error message might be caused by a few reasons. Please refer to the following knowledge base article which explains how to deal with this issue:
However, since you are hosted on a VPS, I raised the MySQL timeout settings significantly and the problem should be resolved.
What we can advise you is to try to reduce your database in size and optimize it. You can reduce it be deleting some old records/articles from your website. For the optimization we can suggest you to use the following hints:
Please be informed that the website/database optimization is a complex on-going activity which is best when performed by a professional developer.
If there is anything else that we can help you with, please create a new ticket anytime!
Technical Support Team
On a side note, I am totally happy with Siteground, and hate for someone to take this post as a negative reflection of their services, especially their customer service, I only asked the question regarding inflated unoptimized databases to see if others had run into this problem and therefore could verify resolving the issue.
So far so good, regarding increasing the MySql timings - haven't noticed the error.
The key point that everyone who may encounter the situation where they get "MySQL server has gone away" is that this has absolutely nothing to do with Kunena.
The problem is a webhosting issue. Talking over the issue with your wehost provider will usually resolve this problem.
I have marked this as solved.