Simple Machines Community Forum

SMF Support => SMF 2.0.x Support => Topic started by: outdoors-stuff on November 14, 2017, 10:07:03 AM

Title: Errors logging in - smf_admin_info_files corrupt
Post by: outdoors-stuff on November 14, 2017, 10:07:03 AM
Hi

Running SMF 2.0.14
php 5.4.45
only 1 mod - SMF Gallery Lite (this is unimportant and could be ditched if need be)

I seem to have an SMF database table which is corrupt (smf_admin_info_files)

Which is I assume (although I should point out that I'm far from an IT expert here) the reason for some intermittent failures to login (often taking 3-4 attempts at logging in, with an error of session timed out?) and the SMF news failing to load/current version info not loading in the admin screen.

I've done a search for others having the same issue, and I see there have been some other folks having trouble with logins and tables crashing but nothing seemed the same as ours -others seemed to be after hosting moves or updates.

We're on the current 2.0.14 version of the forum and this has not been updated in a while. Likewise, the forum is seperate to our website, so any changes there *shouldn't* be the cause of issues, although we did update to https/SSL a few months ago.

I've tried fixing the table in our website control panel (plesk) with a "Check and Repair" option in the databases section. But this comes up with
   
QuoteTable is marked as crashed and last repair failed. Key 2 doesn't point at same records that key 1. Corrupt

I'm assuming that the fix is probably to reinstall SMF? (Can I just run the 2.0.14 update again, I'm guessing probably not if it's a database problem rather than a files problem?)

Is there any chance of a working version of this corrupt table - and I'll try and figure out how to drop the table and recreate it in our database?

Otherwise it sounds like I need do a complete scrap and restart of the forum, which I really don't want to do if can be avoided, apart from anything else I don't have a recent enough backup of our forum to be happy reverting to (yes, I know...)

If that is essential though - I can't download the entire database (due to the corrupt table) to do a hasty backup now, but I can download individual tables other than the admin-info one. Can I get away with just downloading the smf-messages table (which seems to contain all the forum posts). I guess I might need more tables than that though - to install the users and boards... Can someone tell me which other tables are needed to keep user data intact (I'm guessing:
smf_attachments, smf_boards, smf_board_permissions, smf_categories, (smf_collapsed_categories?), smf_membergroups, smf_members, smf_messages.

I'm assuming I don't need smf_group_moderators as was empty (we don't really have them) and the rest either look to be log tables or not ones that hold user data?

And then I'll need to figure out how to import these tables into a fresh new forum...

Any help much appreciated!
Title: Re: Errors logging in - smf_admin_info_files corrupt
Post by: Illori on November 14, 2017, 10:08:25 AM
can you try to do a repair in phpmyadmin? that might work better for you.
Title: Re: Errors logging in - smf_admin_info_files corrupt
Post by: outdoors-stuff on November 14, 2017, 10:10:41 AM
Sorry I'm far from the most expert of folks at database stuff :( Not sure how to do this?
Title: Re: Errors logging in - smf_admin_info_files corrupt
Post by: Illori on November 14, 2017, 10:12:25 AM
if you are not sure you might be better to ask your host to look into repairing the table for you.
Title: Re: Errors logging in - smf_admin_info_files corrupt
Post by: outdoors-stuff on November 14, 2017, 10:15:19 AM
Our host doesn't really want anything to do with the forum - as we added it not them :(

But it doesn't appear possible from the screenshot attached?
Title: Re: Errors logging in - smf_admin_info_files corrupt
Post by: outdoors-stuff on November 14, 2017, 10:15:50 AM
And apols, my first line of reply should also have been many thanks for such a quick response!
Title: Re: Errors logging in - smf_admin_info_files corrupt
Post by: Illori on November 14, 2017, 10:23:11 AM
take a look at https://www.a2hosting.com/kb/cpanel/cpanel-database-features/optimizing-and-repairing-mysql-databases-with-phpmyadmin#Repairing-MySQL-databases and see if it helps you.

if your host will not fix a crashed database table then i would look for a new host.
Title: Re: Errors logging in - smf_admin_info_files corrupt
Post by: outdoors-stuff on November 14, 2017, 10:29:24 AM
Yes that helps - but it says it can't create a new temp file and fails? :(

I guess that probably is a hosting issue to make temp files creatable isn't it...
Title: Re: Errors logging in - smf_admin_info_files corrupt
Post by: Illori on November 14, 2017, 10:30:00 AM
then you need to go back to your host and ask them to fix this.
Title: Re: Errors logging in - smf_admin_info_files corrupt
Post by: outdoors-stuff on November 14, 2017, 10:32:12 AM
That crossed - but yes, does seem so.
Title: Re: Errors logging in - smf_admin_info_files corrupt
Post by: aegersz on November 14, 2017, 06:32:39 PM
ever since i got some solid gold advice here about converting painlessly to InnoDB i wonder why it isn't mandatory for hosts to do so ?

no more table crashes !
Title: Re: Errors logging in - smf_admin_info_files corrupt
Post by: Kindred on November 14, 2017, 08:27:46 PM
Because there are trade offs
Title: Re: Errors logging in - smf_admin_info_files corrupt
Post by: outdoors-stuff on November 17, 2017, 07:04:11 AM
Just to update. My host fixed the broken table for me and clearing Firefox's cache plus it updating to the latest version at the same time apepared to solve the issue for me. But a day later, on first login, both the lack of stylesheet and login failure issue reappeared. And the lack of stylesheet was now affecting every page including those after login (which works on the failure to login page, just not the main login page. Bizzarre!). So was worse than before.

Solution - my host had noted that an image file was stubbornly set to http, not https. Looking in the admin panel for its path drew a blank as did looking in settings.php and index.php. The forum's admin panel error log was also saying that the database table had crashed, but this time phpmyadmin didn't agree - it was fine. Clearing Firefox cache and cookies didn't change this.

Running repair_settings I was surprised that it showed up several paths that weren't obvious from my earlier searchings and that were still http, not https (although not the image file my hosts had noted - that may be a dependancy of one of the repair-settings files though). Changing these to https appears to have resolved the issue. Fingers crossed!