Errors logging in - smf_admin_info_files corrupt

Started by outdoors-stuff, November 14, 2017, 10:07:03 AM

Previous topic - Next topic

outdoors-stuff

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!

Illori

can you try to do a repair in phpmyadmin? that might work better for you.

outdoors-stuff

Sorry I'm far from the most expert of folks at database stuff :( Not sure how to do this?

Illori

if you are not sure you might be better to ask your host to look into repairing the table for you.

outdoors-stuff

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?

outdoors-stuff

And apols, my first line of reply should also have been many thanks for such a quick response!

Illori


outdoors-stuff

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...

Illori

then you need to go back to your host and ask them to fix this.

outdoors-stuff


aegersz

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 !
The configuration of my Linux VPS (SMF 2.0 with 160+ mods & some assorted manual tweaks) can be found here and notes on my mods can be found here (warning: those links will take you to a drug related forum). My (House) music DJ dedication page is here

Kindred

Слaва
Украинi

Please do not PM, IM or Email me with support questions.  You will get better and faster responses in the support boards.  Thank you.

"Loki is not evil, although he is certainly not a force for good. Loki is... complicated."

outdoors-stuff

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!

Advertisement: