Question [Resolved] Multiple Errors / Warnings - 126 - Incorrect key file for table, 145 - Table is marked as crashed and should be repaired... (cont.'d)

Hey there folks -

I'm coming to you all before I start poking and toying with things myself and potentially make the issue(s) worse. I did a few brief forum searches and didn't seem to find anything directly related unless I was looking wrong, and that may be the case.

Background : I am new to Joomla and Kurena and have had this build of the site up for ~1.5-2 months. This is the first sign of a problem from it. It started Thursday morning and I was presented with an error :

JDatabaseMySQL::query: 126 - Incorrect key file for table './ga_joomla/vg8fq_kunena_whoisonline.MYI'; try to repair it SQL=DELETE FROM vg8fq_kunena_whoisonline WHERE time < '1330639111'

It is a fairly light use forum and there weren't even any registries or posts made on that day. I figured it wasn't effecting the functionality, so I would leave it alone until I could get around to fixing it over the weekend. Well, today as I get home to do just that I am greeted with a new set of them... first this error (in addition to the first one) :

JDatabaseMySQL::query: 145 - Table './gadogo_joomla/vg8fq_kunena_whoisonline' is marked as crashed and should be repaired SQL=SELECT COUNT(*) FROM vg8fq_kunena_whoisonline WHERE userip='my IP address' AND userid='42'

Followed by :

Warning: Invalid argument supplied for foreach() in /home/ga/public_html/components/com_kunena/lib/kunena.pathway.class.php on line 73

I haven't changed anything since I saw the first warnings and there may have been 2 posts made maximum, no registrations if it makes any difference.

Any thoughts or suggestions? Any help would be much appreciated.

Including my configuration file.

Database collation check:

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

This message contains confidential information

htaccess: Exists | PHP environment: Max execution time: 60 seconds | Max execution memory: 168M | Max file upload: 128M

Joomla default template details : wow_guilds | author: Tolrem | version: 2.0.2 | creationdate: 13 dec 2011

Kunena default template details : WoW Guilds for Kunena | author: Tolrem | version: 2.0.2 | creationdate: 22 dec 2011

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	wow_guilds_kunena
showannouncement	1
avataroncat	0
catimagepath	category_images/
showchildcaticon	1
annmodid	62
rtewidth	450
rteheight	300
enableforumjump	1
reportmsg	1
username	1
askemail	0
showemail	0
showuserstats	1
showkarma	0
useredit	1
useredittime	0
useredittimegrace	600
editmarkup	1
allowsubscriptions	0
subscriptionschecked	0
allowfavorites	1
maxsubject	75
maxsig	300
regonly	0
changename	1
pubwrite	0
floodprotection	0
mailmod	0
mailadmin	0
captcha	1
mailfull	0
allowavatar	1
allowavatarupload	1
allowavatargallery	1
avatarquality	65
avatarsize	2048
allowimageupload	0
allowimageregupload	1
imageheight	800
imagewidth	800
imagesize	150
allowfileupload	0
allowfileregupload	1
filetypes	txt,rtf,pdf,zip,tar.gz,tgz,tar.bz2
filesize	120
showranking	0
rankimages	0
avatar_src	fb
fb_profile	fb
pm_component	no
userlist_rows	30
userlist_online	1
userlist_avatar	1
userlist_name	0
userlist_username	1
userlist_posts	1
userlist_karma	0
userlist_email	0
userlist_usertype	1
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	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
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	0
maxpersotext	50
ordering_system	replyid
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	auto
integration_activity	auto
boxghostmessage	0
userdeletetmessage	0
latestcategory_in	1
topicicons	1
onlineusers	1
debug	0
catsautosubscribed	0
showbannedreason	1
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	2
show_session_starttime	0
userlist_allowed	0
userlist_count_users	1
enable_threaded_layouts	0
category_subscriptions	disabled
topic_subscriptions	disabled
pubprofile	1
thankyou_max	10
email_recipient_count	0
email_recipient_privacy	bcc
email_visible_address
captcha_post_limit	0

Third-party components: UddeIm 2.5

Third-party SEF components: None

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

Modules: Kunena Latest 1.7.1 | Kunena Login 1.7.1

G'day, Xae, welcome to Kunena and thank you for your questions.

I suggest, before we deal with issues that may be caused by using outdated versions of Kunena and its add-ons, that you upgrade to K 1.7.2 and, likewise, Kunena Latest and Kunena Login modules. The next approach is to establish that the WoW Guilds for Kunena template that you've chosen also does not contribute to these issues and, in that respect, please try the Blue Eagle template.

Further, you might like to use phpMyAdmin to attempt to repair your "crashed" database tables.

If these things do not resolve your problem, can you please leave things in this "default" form (after applying the upgrade/changes I have recommended) and to post your revised configuration report here so that we can see what might be involved in resolving the problem. Thanks.

Thanks for the quick reply.

Did my back up and started the upgrade process. However, it appears my upgrade is hung up.

Got it uploaded (via the Joomla Extension upload), selected upgrade and now it's doing it's thing - I have a page that says "Installer is Running... Please Wait!" on the top, a step by step rundown on the left hand side and and a button that says "Next ->" on the far right. Pressing that does nothing, I would expect to need to push it to keep things moving, am I wrong? It's been there for about 45m - normal or no? I, again, didn't find any information on this directly on the forums. (Looked before I asked.)

Thanks again.

Sounds to me like you have an issue with your Joomla database. I suggest you attempt to repair the tables with phpMyAdmin or restore your site to the previous known good backup. Depending on the extent of the damage (and your ability to repair) you may have to uninistall Kunena, drop the existing Kunena tables, and re-install. This could mean that you will have lost your forum and any posts in it.

Well, I guess I should have gone with my first instinct.

I was able to go in, do a full database restore and everything snapped back into place... now, after the dust settles, I'll try and do another back up and upgrade next weekend... and now I know what to do if this happens again next time.

Thanks again for all your help, Snozzled; it is definitely appreciated.