Simple Machines Community Forum

SMF Support => SMF 2.0.x Support => Aiheen aloitti: jmille44 - kesäkuu 18, 2019, 01:14:36 IP

Otsikko: appears that your database may require an upgrade
Kirjoitti: jmille44 - kesäkuu 18, 2019, 01:14:36 IP
I am receiving the error below when trying to delete accounts or ban users.
I don't want to mess up the forums, anyone know how to fix this?  Thank you in advance for any help!

Table './database948574/smf_log_errors' is marked as crashed and last (automatic?) repair failed
File: /Users/forumsite/Sources/Subs-Members.php
Line: 256

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. The above error might possibly go away if you execute the latest version of upgrade.php.
Otsikko: Re: appears that your database may require an upgrade
Kirjoitti: Kindred - kesäkuu 18, 2019, 01:18:23 IP
the database version message is a red herring and is not correct and not important. ignore it.

your real issue is the crashed table.
Go into your hosting CPanel/phpmyadmin and repair it.
Otsikko: Re: appears that your database may require an upgrade
Kirjoitti: jmille44 - kesäkuu 18, 2019, 01:20:01 IP
Once I am in phpmyadmin, how do I repair it?

Thanks!
Otsikko: Re: appears that your database may require an upgrade
Kirjoitti: Kindred - kesäkuu 18, 2019, 01:21:51 IP
select the table in the checkboxes and the choose repair from the options to act on the selected table(s)
Otsikko: Re: appears that your database may require an upgrade
Kirjoitti: jmille44 - kesäkuu 18, 2019, 01:36:46 IP
I can select the checkbox of the table but for the life of me can not find repair anywhere.

Is the repair option somewhere not obvious?

Thanks again for the help
Otsikko: Re: appears that your database may require an upgrade
Kirjoitti: Illori - kesäkuu 18, 2019, 01:38:31 IP
if you cant find it ask your host to look into it for you.
Otsikko: Re: appears that your database may require an upgrade
Kirjoitti: jmille44 - kesäkuu 18, 2019, 01:42:17 IP
So I found it and repaired the table smf_log_errors but the error continues.

Do I need to repair more tables?
Otsikko: Re: appears that your database may require an upgrade
Kirjoitti: Illori - kesäkuu 18, 2019, 01:44:53 IP
is another table listed as crashed? if so then repair that one as well.
Otsikko: Re: appears that your database may require an upgrade
Kirjoitti: jmille44 - kesäkuu 18, 2019, 01:45:35 IP
Worked!  thanks everyone.  I just had to Empty out unimportant logs and that seems to have worked along with the repair table.  Thanks again.