Text only | Text with Images

Simple Machines Community Forum

SMF Support => SMF 2.0.x Support => Topic started by: GlennLever on January 07, 2020, 02:14:51 PM

Title: I have a data base error can cannot sign in to fix it
Post by: GlennLever on January 07, 2020, 02:14:51 PM
Note: It appears that your database may require an upgrade. Your forum's files are currently at version SMF 2.0.15, while your database is at version 2.0.3. The above error might possibly go away if you execute the latest version of upgrade.php.
Title: Re: I have a data base error can cannot sign in to fix it
Post by: vbgamer45 on January 07, 2020, 02:15:30 PM
Does it say anything else?
Do you get an email with the error information?
Title: Re: I have a data base error can cannot sign in to fix it
Post by: Illori on January 07, 2020, 02:15:51 PM
what is the error above that line? there are no database changes so an upgrade is not going to fix the issue.
Title: Re: I have a data base error can cannot sign in to fix it
Post by: GlennLever on January 07, 2020, 06:27:10 PM

Database Error
Incorrect key file for table './fronteng_smf/smf_log_online.MYI'; try to repair it
File: /home/fronteng/public_html/forum/Sources/Subs.php
Line: 2697

Note: It appears that your database may require an upgrade. Your forum's files are currently at version SMF 2.0.15, while your database is at version 2.0.3. The above error might possibly go away if you execute the latest version of upgrade.php.
Title: Re: I have a data base error can cannot sign in to fix it
Post by: vbgamer45 on January 07, 2020, 06:29:14 PM
Try to run this sql query on your database
REPAIR TABLE smf_log_online;

If not we might have to rebuild/recreate that table.
Title: Re: I have a data base error can cannot sign in to fix it
Post by: GlennLever on January 14, 2020, 04:11:29 PM
Restored to an earlier date and all seems well for the moment.
Text only | Text with Images