MyBB Community Forums

hi there my host crashed something to do with the router uplink or somehing like that

now my forum is back up but when i go to browser a use in admin cp

i get this sql error

MyBB has experienced an internal SQL error and cannot continue.
SQL Error:
1194 - Table 'u' is marked as crashed and should be repaired
Query:
SELECT u.* FROM myphpusers u WHERE 1=1 ORDER BY regdate desc LIMIT 0, 20

anyone know how to fix this ?

tia for any help with this

In phpMyAdmin, or something similar, select your database and then select all the tables. From the "with selected" dropdown box, select repair table.

hi m8 thanks for the reply

i tried that but when it got to one point it says this

myphp.myphpusers repair info Wrong bytesec: 0- 0- 0 at 452160; Skipped

Is that even a mybb table?

its on my sql database and got next to it how many users are on my forum

What happens if you instead try to repair the name of the crashed table with this query at the SQL tab instead?

REPAIR TABLE 'tablename';

and replace table name with your actual crashed table''s name.

i have tried to reapir it again and now seems to be working but still get the same error

myphp.myphpusers repair info Wrong bytesec: 0- 0- 0 at 452160; Skipped

but forum seems to be running ok now

Contact your host with the mySQL error message.

If it happens on a regular bassi then as Tomm M stated above, it would be best to contact your host and let them know about it.