Advertisement:

Author Topic: Errors logging in - smf_admin_info_files corrupt  (Read 398 times)

Offline outdoors-stuff

  • Semi-Newbie
  • *
  • Posts: 83
Errors logging in - smf_admin_info_files corrupt
« 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
   
Quote
Table 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!

Offline Illori

  • Project Manager
  • SMF Master
  • *
  • Posts: 47,885
Re: Errors logging in - smf_admin_info_files corrupt
« Reply #1 on: November 14, 2017, 10:08:25 AM »
can you try to do a repair in phpmyadmin? that might work better for you.

Offline outdoors-stuff

  • Semi-Newbie
  • *
  • Posts: 83
Re: Errors logging in - smf_admin_info_files corrupt
« Reply #2 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?

Offline Illori

  • Project Manager
  • SMF Master
  • *
  • Posts: 47,885
Re: Errors logging in - smf_admin_info_files corrupt
« Reply #3 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.

Offline outdoors-stuff

  • Semi-Newbie
  • *
  • Posts: 83
Re: Errors logging in - smf_admin_info_files corrupt
« Reply #4 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?

Offline outdoors-stuff

  • Semi-Newbie
  • *
  • Posts: 83
Re: Errors logging in - smf_admin_info_files corrupt
« Reply #5 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!

Offline Illori

  • Project Manager
  • SMF Master
  • *
  • Posts: 47,885
Re: Errors logging in - smf_admin_info_files corrupt
« Reply #6 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.

Offline outdoors-stuff

  • Semi-Newbie
  • *
  • Posts: 83
Re: Errors logging in - smf_admin_info_files corrupt
« Reply #7 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...

Offline Illori

  • Project Manager
  • SMF Master
  • *
  • Posts: 47,885
Re: Errors logging in - smf_admin_info_files corrupt
« Reply #8 on: November 14, 2017, 10:30:00 AM »
then you need to go back to your host and ask them to fix this.

Offline outdoors-stuff

  • Semi-Newbie
  • *
  • Posts: 83
Re: Errors logging in - smf_admin_info_files corrupt
« Reply #9 on: November 14, 2017, 10:32:12 AM »
That crossed - but yes, does seem so.

Online aegersz

  • Sophist Member
  • *****
  • Posts: 1,110
  • Gender: Male
  • "mods" junkie
    • dopetalk
Re: Errors logging in - smf_admin_info_files corrupt
« Reply #10 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 !
SMF 2.0: 135+ mods installed (the full list can be seen at http://forum.drugs-and-users.org/index.php/topic,3301)

Offline Kindred

  • The Mean One
  • Support Specialist
  • SMF Legend
  • *
  • Posts: 54,997
  • Gender: Male
    • Kindred-999 on GitHub
Re: Errors logging in - smf_admin_info_files corrupt
« Reply #11 on: November 14, 2017, 08:27:46 PM »
Because there are trade offs
Please do not PM, IM or Email me with support questions.  You will get better and faster responses in the support boards.  Thank you.

Offline outdoors-stuff

  • Semi-Newbie
  • *
  • Posts: 83
Re: Errors logging in - smf_admin_info_files corrupt
« Reply #12 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!