- Posts: 5
- Thank you received: 1
Kunena 6.2.5 & module Kunena Latest 6.0.7 released
The Kunena team has announce the arrival of Kunena 6.2.5 [K 6.2.5] 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 / K 6.2 and issues discovered during the last development stages of K 6.2
Please Read This First:
This category is only for reporting defects with K 3.0.
Do not use this category:
- to ask general questions about how to use K 3.0 or to ask when new versions of Kunena will be released;
- to ask about other (older) versions of Kunena; or
- if you have tried to install K 3.0 on J! 1.5; or
- if you installed K 3.0 on a live, production site and you want your site restored to its previous state; or
- if this website ( www.kunena.org ) works but works differently to how you expected.
You must include your K 3.0 configuration report; if you do not include your configuration report, your topic may be closed (locked) or deleted without any further warnings from the moderators.
Topics that have been closed (resolved) will be archived and no further discussion on those topics will be allowed.
Question Recurrent error - Could not connect to mysql database!
I'm using kunena for more than 3 years. I was and I'm so happy using it in my educational website as the forum solution. But recently few weeks ago I'm getting recurrent mysql error which says "Could not connect to mysql database". Initially I thought that it could be due to restrictions of the shared hosting. So I moved my site to a VPS (1GB ram & 1 core) in digitalocean!
But still I'm getting the error. As soon as I restart the mysql, everything comes back to normal. Also when I repair and optimize the mysql database of the site everyday, the incidents of the error is less. But still I couldn't figure out the problem why I'm still getting it.
I have only installed Kunena, akeeba backup & akeeba admin tools as extensions.
My forum:
Configuration:
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: 30 seconds | Max execution memory: 128M | Max file upload: 20M
Kunena menu details:
Warning: Spoiler!
ID Name Menutype Link Path In trash 679 Forum kunenamenu view=home&defaultmenu=681 forum No 680 Index kunenamenu view=category&layout=list forum/index No 681 Recent Topics kunenamenu view=topics&mode=replies forum/recent No 682 New Topic kunenamenu view=topic&layout=create forum/newtopic No 683 No Replies kunenamenu view=topics&mode=noreplies forum/noreplies No 684 My Topics kunenamenu view=topics&layout=user&mode=default forum/mylatest No 685 Profile kunenamenu view=user forum/profile No 686 Rules kunenamenu view=misc forum/help No 687 Search kunenamenu view=search forum/search No
Joomla default template details : isrsapphire | author: Kyle Ledbetter | version: 1.0 | creationdate: Unknown
Kunena default template details : Blue Eagle | author: Kunena Team | version: 3.0.7 | creationdate: 2015-02-01
Kunena version detailed: Kunena 3.0.7 | 2015-02-01 [ Galah ]
| Kunena detailed configuration:| Kunena integration settings:Warning: Spoiler!
Kunena config settings: board_offline 0 enablerss 1 threads_per_page 30 messages_per_page 20 messages_per_page_search 15 showhistory 1 historylimit 10 shownew 1 disemoticons 0 template blue_eagle showannouncement 1 avataroncat 0 catimagepath category_images showchildcaticon 1 rtewidth 450 rteheight 300 enableforumjump 1 reportmsg 1 username 0 askemail 0 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 pubwrite 0 floodprotection 0 mailmod 0 mailadmin 0 captcha 0 mailfull 1 allowavatarupload 1 allowavatargallery 1 avatarquality 75 avatarsize 512 imageheight 1200 imagewidth 800 imagesize 1048 filetypes txt,docx,pptx,rtf,pdf,zip,tar.gz,tgz,tar.bz2 filesize 70000 showranking 1 rankimages 1 userlist_rows 30 userlist_online 1 userlist_avatar 1 userlist_name 1 userlist_posts 1 userlist_karma 1 userlist_email 0 userlist_joindate 1 userlist_lastvisitdate 1 userlist_userhits 1 latestcategory 0 showstats 1 showwhoisonline 1 showgenstats 1 showpopuserstats 1 popusercount 10 showpopsubjectstats 1 popsubjectcount 10 usernamechange 0 showspoilertag 1 showvideotag 1 showebaytag 1 trimlongurls 1 trimlongurlsfront 40 trimlongurlsback 20 autoembedyoutube 1 autoembedebay 1 sessiontimeout 3600 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 5 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 80 thumbheight 32 thumbwidth 32 hideuserprofileinfo put_empty boxghostmessage 0 userdeletetmessage 0 latestcategory_in 1 topicicons 1 debug 0 catsautosubscribed 0 showbannedreason 1 version_check 1 showthankyou 1 showpopthankyoustats 1 popthankscount 10 mod_see_deleted 0 bbcode_img_secure text listcat_show_moderators 1 lightbox 1 show_list_time 8760 show_session_type 0 show_session_starttime 400 userlist_allowed 0 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 registered topic_layout flat time_to_create_page 1 show_imgfiles_manage_profile 1 hold_newusers_posts 0 hold_guest_posts 0 attachment_limit 20 pickup_category 1 article_display intro send_emails 1 fallback_english 1 cache 1 cache_time 180 iptracking 1 rss_feedburner_url autolink 1 access_component 0 statslink_allowed 1 superadmin_userlist 0 ebay_language 0 ebaylanguagecode en-us userlist_usertype 0 sefutf8 0 changename 0 | Joomla! detailed language files installed:Warning: Spoiler!Kunena - AlphaUserPoints Disabled
Kunena - Community Builder Disabled
Kunena - Gravatar Disabled
Kunena - JomSocial Disabled
Kunena - Joomla Enabled: access=1 login=1
Kunena - Kunena Enabled: avatar=1 profile=1
Kunena - UddeIM Disabled
Warning: Spoiler!
Joomla! languages installed: en-GB English (en-GB)
Third-party components: None
Third-party SEF components: sh404sef 4.4.6.2271
Plugins: Search - Kunena Search 3.0.1
Modules: Kunena Latest 3.0.1
Mysql error log:
150331 22:00:09 [Note] Plugin 'FEDERATED' is disabled.
150331 22:00:09 InnoDB: The InnoDB memory heap is disabled
150331 22:00:09 InnoDB: Mutexes and rw_locks use GCC atomic builtins
150331 22:00:09 InnoDB: Compressed tables use zlib 1.2.8
150331 22:00:09 InnoDB: Using Linux native AIO
150331 22:00:09 InnoDB: Initializing buffer pool, size = 64.0M
150331 22:00:09 InnoDB: Completed initialization of buffer pool
150331 22:00:09 InnoDB: highest supported file format is Barracuda.
InnoDB: Log scan progressed past the checkpoint lsn 1657582635
150331 22:00:09 InnoDB: Database was not shut down normally!
InnoDB: Starting crash recovery.
InnoDB: Reading tablespace information from the .ibd files...
InnoDB: Restoring possible half-written data pages from the doublewrite
InnoDB: buffer...
InnoDB: Doing recovery: scanned up to log sequence number 1657592733
150331 22:00:10 InnoDB: Starting an apply batch of log records to the database...
InnoDB: Progress in percents: 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99
InnoDB: Apply batch completed
150331 22:00:10 InnoDB: Waiting for the background threads to start
150331 22:00:11 InnoDB: 5.5.41 started; log sequence number 1657592733
150331 22:00:11 [Note] Server hostname (bind-address): '127.0.0.1'; port: 3306
150331 22:00:11 [Note] - '127.0.0.1' resolves to '127.0.0.1';
150331 22:00:11 [Note] Server socket created on IP: '127.0.0.1'.
150331 22:00:11 [Note] Event Scheduler: Loaded 0 events
150331 22:00:11 [Note] /usr/sbin/mysqld: ready for connections.
Version: '5.5.41-0ubuntu0.14.04.1' socket: '/var/run/mysqld/mysqld.sock' port: 3306 (Ubuntu)
150331 22:00:12 [ERROR] /usr/sbin/mysqld: Table './istudyroom/jml_kunena_attachments' is marked as crashed and should be repaired
150331 22:00:12 [Warning] Checking table: './istudyroom/jml_kunena_attachments'
150331 22:00:12 [ERROR] /usr/sbin/mysqld: Table './istudyroom/jml_kunena_categories' is marked as crashed and should be repaired
150331 22:00:12 [Warning] Checking table: './istudyroom/jml_kunena_categories'
150331 22:00:12 [ERROR] /usr/sbin/mysqld: Table './istudyroom/jml_kunena_messages' is marked as crashed and should be repaired
150331 22:00:12 [Warning] Checking table: './istudyroom/jml_kunena_messages'
150331 22:00:12 [ERROR] /usr/sbin/mysqld: Table './istudyroom/jml_kunena_messages_text' is marked as crashed and should be repaired
150331 22:00:12 [Warning] Checking table: './istudyroom/jml_kunena_messages_text'
150331 22:00:12 [ERROR] /usr/sbin/mysqld: Table './istudyroom/jml_kunena_sessions' is marked as crashed and should be repaired
150331 22:00:12 [Warning] Checking table: './istudyroom/jml_kunena_sessions'
150331 22:00:12 [ERROR] /usr/sbin/mysqld: Table './istudyroom/jml_kunena_thankyou' is marked as crashed and should be repaired
150331 22:00:12 [Warning] Checking table: './istudyroom/jml_kunena_thankyou'
150331 22:00:12 [ERROR] /usr/sbin/mysqld: Table './istudyroom/jml_kunena_topics' is marked as crashed and should be repaired
150331 22:00:12 [Warning] Checking table: './istudyroom/jml_kunena_topics'
150331 22:00:12 [ERROR] /usr/sbin/mysqld: Table './istudyroom/jml_kunena_user_read' is marked as crashed and should be repaired
150331 22:00:12 [Warning] Checking table: './istudyroom/jml_kunena_user_read'
150331 22:00:12 [ERROR] /usr/sbin/mysqld: Table './istudyroom/jml_kunena_user_topics' is marked as crashed and should be repaired
150331 22:00:12 [Warning] Checking table: './istudyroom/jml_kunena_user_topics'
150331 22:00:12 [ERROR] /usr/sbin/mysqld: Table './istudyroom/jml_kunena_users' is marked as crashed and should be repaired
150331 22:00:12 [Warning] Checking table: './istudyroom/jml_kunena_users'
150331 22:00:12 [ERROR] /usr/sbin/mysqld: Table './istudyroom/jml_sh404sef_urls' is marked as crashed and should be repaired
150331 22:00:12 [Warning] Checking table: './istudyroom/jml_sh404sef_urls'
150331 22:12:14 [Note] Plugin 'FEDERATED' is disabled.
150331 22:12:14 InnoDB: The InnoDB memory heap is disabled
150331 22:12:14 InnoDB: Mutexes and rw_locks use GCC atomic builtins
150331 22:12:14 InnoDB: Compressed tables use zlib 1.2.8
150331 22:12:14 InnoDB: Using Linux native AIO
150331 22:12:14 InnoDB: Initializing buffer pool, size = 64.0M
150331 22:12:14 InnoDB: Completed initialization of buffer pool
150331 22:12:14 InnoDB: highest supported file format is Barracuda.
InnoDB: Log scan progressed past the checkpoint lsn 1658424049
150331 22:12:14 InnoDB: Database was not shut down normally!
InnoDB: Starting crash recovery.
InnoDB: Reading tablespace information from the .ibd files...
InnoDB: Restoring possible half-written data pages from the doublewrite
InnoDB: buffer...
InnoDB: Doing recovery: scanned up to log sequence number 1658472540
150331 22:12:15 InnoDB: Starting an apply batch of log records to the database...
InnoDB: Progress in percents: 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99
InnoDB: Apply batch completed
150331 22:12:15 InnoDB: Waiting for the background threads to start
150331 22:12:16 InnoDB: 5.5.41 started; log sequence number 1658472540
150331 22:12:16 [Note] Server hostname (bind-address): '127.0.0.1'; port: 3306
150331 22:12:16 [Note] - '127.0.0.1' resolves to '127.0.0.1';
150331 22:12:16 [Note] Server socket created on IP: '127.0.0.1'.
150331 22:12:16 [Note] Event Scheduler: Loaded 0 events
150331 22:12:16 [Note] /usr/sbin/mysqld: ready for connections.
Version: '5.5.41-0ubuntu0.14.04.1' socket: '/var/run/mysqld/mysqld.sock' port: 3306 (Ubuntu)
150331 22:12:16 [ERROR] /usr/sbin/mysqld: Table './istudyroom/jml_sh404sef_urls' is marked as crashed and should be repaired
150331 22:12:16 [Warning] Checking table: './istudyroom/jml_sh404sef_urls'
150331 22:12:37 [Note] Plugin 'FEDERATED' is disabled.
150331 22:12:37 InnoDB: The InnoDB memory heap is disabled
150331 22:12:37 InnoDB: Mutexes and rw_locks use GCC atomic builtins
150331 22:12:37 InnoDB: Compressed tables use zlib 1.2.8
150331 22:12:37 InnoDB: Using Linux native AIO
150331 22:12:37 InnoDB: Initializing buffer pool, size = 64.0M
InnoDB: mmap(68681728 bytes) failed; errno 12
150331 22:12:37 InnoDB: Completed initialization of buffer pool
150331 22:12:37 InnoDB: Fatal error: cannot allocate memory for the buffer pool
150331 22:12:37 [ERROR] Plugin 'InnoDB' init function returned error.
150331 22:12:37 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
150331 22:12:37 [ERROR] Unknown/unsupported storage engine: InnoDB
150331 22:12:37 [ERROR] Aborting
150331 22:12:37 [Note] /usr/sbin/mysqld: Shutdown complete
150331 22:12:38 [Note] Plugin 'FEDERATED' is disabled.
150331 22:12:38 InnoDB: The InnoDB memory heap is disabled
150331 22:12:38 InnoDB: Mutexes and rw_locks use GCC atomic builtins
150331 22:12:38 InnoDB: Compressed tables use zlib 1.2.8
150331 22:12:38 InnoDB: Using Linux native AIO
150331 22:12:38 InnoDB: Initializing buffer pool, size = 64.0M
InnoDB: mmap(68681728 bytes) failed; errno 12
150331 22:12:38 InnoDB: Completed initialization of buffer pool
150331 22:12:38 InnoDB: Fatal error: cannot allocate memory for the buffer pool
150331 22:12:38 [ERROR] Plugin 'InnoDB' init function returned error.
150331 22:12:38 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
150331 22:12:38 [ERROR] Unknown/unsupported storage engine: InnoDB
150331 22:12:38 [ERROR] Aborting
150331 22:12:38 [Note] /usr/sbin/mysqld: Shutdown complete
150331 23:43:22 [Note] Plugin 'FEDERATED' is disabled.
150331 23:43:22 InnoDB: The InnoDB memory heap is disabled
150331 23:43:22 InnoDB: Mutexes and rw_locks use GCC atomic builtins
150331 23:43:22 InnoDB: Compressed tables use zlib 1.2.8
150331 23:43:22 InnoDB: Using Linux native AIO
150331 23:43:22 InnoDB: Initializing buffer pool, size = 64.0M
150331 23:43:22 InnoDB: Completed initialization of buffer pool
150331 23:43:23 InnoDB: highest supported file format is Barracuda.
InnoDB: Log scan progressed past the checkpoint lsn 1658472708
150331 23:43:23 InnoDB: Database was not shut down normally!
InnoDB: Starting crash recovery.
InnoDB: Reading tablespace information from the .ibd files...
InnoDB: Restoring possible half-written data pages from the doublewrite
InnoDB: buffer...
InnoDB: Doing recovery: scanned up to log sequence number 1658481424
150331 23:43:23 InnoDB: Starting an apply batch of log records to the database...
InnoDB: Progress in percents: 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99
InnoDB: Apply batch completed
150331 23:43:23 InnoDB: Waiting for the background threads to start
150331 23:43:24 InnoDB: 5.5.41 started; log sequence number 1658481424
150331 23:43:24 [Note] Server hostname (bind-address): '127.0.0.1'; port: 3306
150331 23:43:24 [Note] - '127.0.0.1' resolves to '127.0.0.1';
150331 23:43:24 [Note] Server socket created on IP: '127.0.0.1'.
150331 23:43:24 [Note] Event Scheduler: Loaded 0 events
150331 23:43:24 [Note] /usr/sbin/mysqld: ready for connections.
Version: '5.5.41-0ubuntu0.14.04.1' socket: '/var/run/mysqld/mysqld.sock' port: 3306 (Ubuntu)
150331 23:43:25 [ERROR] /usr/sbin/mysqld: Table './istudyroom/jml_kunena_attachments' is marked as crashed and should be repaired
150331 23:43:25 [Warning] Checking table: './istudyroom/jml_kunena_attachments'
150331 23:43:25 [ERROR] /usr/sbin/mysqld: Table './istudyroom/jml_kunena_categories' is marked as crashed and should be repaired
150331 23:43:25 [Warning] Checking table: './istudyroom/jml_kunena_categories'
150331 23:43:25 [ERROR] /usr/sbin/mysqld: Table './istudyroom/jml_kunena_messages' is marked as crashed and should be repaired
150331 23:43:25 [Warning] Checking table: './istudyroom/jml_kunena_messages'
150331 23:43:25 [ERROR] /usr/sbin/mysqld: Table './istudyroom/jml_kunena_messages_text' is marked as crashed and should be repaired
150331 23:43:25 [Warning] Checking table: './istudyroom/jml_kunena_messages_text'
150331 23:43:25 [ERROR] /usr/sbin/mysqld: Table './istudyroom/jml_kunena_sessions' is marked as crashed and should be repaired
150331 23:43:25 [Warning] Checking table: './istudyroom/jml_kunena_sessions'
150331 23:43:25 [ERROR] /usr/sbin/mysqld: Table './istudyroom/jml_kunena_topics' is marked as crashed and should be repaired
150331 23:43:25 [Warning] Checking table: './istudyroom/jml_kunena_topics'
150331 23:43:25 [ERROR] /usr/sbin/mysqld: Table './istudyroom/jml_kunena_user_read' is marked as crashed and should be repaired
150331 23:43:25 [Warning] Checking table: './istudyroom/jml_kunena_user_read'
150331 23:43:25 [ERROR] /usr/sbin/mysqld: Table './istudyroom/jml_kunena_user_topics' is marked as crashed and should be repaired
150331 23:43:25 [Warning] Checking table: './istudyroom/jml_kunena_user_topics'
150331 23:43:25 [ERROR] /usr/sbin/mysqld: Table './istudyroom/jml_kunena_users' is marked as crashed and should be repaired
150331 23:43:25 [Warning] Checking table: './istudyroom/jml_kunena_users'
Eagerly waiting for your response!
Please Log in or Create an account to join the conversation.
Do-you have empty space on hard disk ?
In your log, i can see that MySQL has been not shutdown correctly, i think it's you that you have tried to restart mysql :
150331 22:12:14 InnoDB: Database was not shut down normally!
InnoDB: Starting crash recovery.
I don't provide support by PM, because this can be useful for someone else.
Please Log in or Create an account to join the conversation.
I have allocated 10Gb for the joomla website with the forum and I have more than 8Gb free space.
The error used to occur every other day. When I get the error, I restart the mysql. As soon as I restart it, everything comes back to normal.
I'm pretty confused because I had the same problem when I was using shared hosting at ipage. Now the same problem is with my VPS. (To host the sites, I'm using webmin control panel.)
Please Log in or Create an account to join the conversation.
I don't provide support by PM, because this can be useful for someone else.
Please Log in or Create an account to join the conversation.
I'll ask it at ubuntu forum!
Have a great day!
Please Log in or Create an account to join the conversation.
- raunharman
- Offline
- New Member
- Posts: 1
- Thank you received: 0
Please Log in or Create an account to join the conversation.
The messages are stored into #__kunena_messages
I don't provide support by PM, because this can be useful for someone else.
Please Log in or Create an account to join the conversation.