MyBB Community Forums

-----------
MyBB SQL Error

MyBB has experienced an internal SQL error and cannot continue.

SQL Error:
144 - Table './MyBB/mybb_users' is marked as crashed and last (automatic?) repair failed
Query:
SELECT s.sid, s.ip, s.uid, s.time, s.location, s.location1, u.username, u.invisible, u.usergroup, u.displaygroup FROM mybb_sessions s LEFT JOIN mybb_users u ON (s.uid=u.uid) WHERE s.time > '1515187582' ORDER BY u.username ASC, s.time DESC

Please contact the MyBB Group for technical support.
--------------

We had a mysql problem and had to restore from backups. Everything came back except the forum.

server: ubuntu 16.04.2
apache2
php7.0
phpinfo: http://www.matecraft.org/phpinfo.php

How can I fix this?

-Brian

You should try and repair the mybb_users table.

(2018-01-05, 10:04 PM)Ben Wrote: [ -> ]You should try and repair the mybb_users table.

mysqlcheck -r MyBB mybb_users
Failed to SHOW CREATE TABLE mybb_users
Error: Table './MyBB/mybb_users' is marked as crashed and last (automatic?) repair failed

any ideas?

-Brian