DB crash in OJS Version- 3.1.1.4

Software Support
1

Dear Team,
I am facing DB crash in my site. My OJS Version- 3.1.1.4

Day 1- Crash controlled_vocabs Table
Day 2- Crash sessions Table
Day 3- Crash controlled_vocab_entry_settings Table

Kindly help me

Regards
Surojit

2

Hi @Surojit_Bera

If you’re using MyISAM tables, you can fix crashed tables in MySQL by connecting to MySQL via the mysql command and running:

repair table sessions;

and likewise for the other tables.

You can also do this via PHPMyAdmin if you like. When the command is finished you can check the table to see if it is fixed:

mysql> check table sessions;
+---------------+-------+----------+----------+
| Table         | Op    | Msg_type | Msg_text |
+---------------+-------+----------+----------+
| database.sessions | check | status   | OK   |
+---------------+-------+----------+----------+
1 row in set (0.09 sec)

Cheers,
Jason